There are two listeners, LISTENER1 and LISTENER2, and one service name ORCL available for your database.The database is running and currently only LISTENERI has been started. You issue the following command:
$lsnrctl start listener2
What would be the outcome?
Answer : A
Listed below are the database resident program units and their descriptions in random order.
1. Package a. stored subprogram that is associated with a database table, view or event
2. Procedure b. stand alone program that must return a value
3. Functionc. structure that contains program definitions and PL/SQL code
4. Trigged. stand-alone program that may or may not return a value
Which option specifies the correct definition for each program unit?
Answer : A
Which two statements are true regarding the Undo Retention Settings? (Choose two.)
Answer : B,C
You have to create a table, STUDENTS, with the columns: STUDENT_ID,
STUDENT_NAME, DATE_OF_BIRTH, and COURSE_ID.
The following constraints have to be enforced on this table:
-> Each student must be uniquely identifiable by the STUDENT_ID.
-> The STUDENT_ID columns should not be left blank.
-> The student should not be less than 15 years of age.
-> The student can only take a course that is specified in the COURSE table in the database.
Which three constraints must be explicitly enforced on the table? (Choose three)
Answer : B,C,F
Which statement is true regarding the OracleUniversal Installer (OUI)?
Answer : A
Which two statements ate true regarding the sever parameter file? (Choose two)
Answer : B,C
Your database instance is running. You are not able to access Oracle Enterprise Manager
Database Control because the listener is not started.
Which tool or utility would you use to start the listener?
Answer : B
Which statement describes the function of the Segment Advisor?
Answer : C
View the exhibit above.
Which two statements ore true regarding the status of data file backups after31 days?
(Choose two)
Answer : C
A customer recently had a security audit, when they were told that their test and developmentenvironment contained test data, which was the copy of production data, yet was not properly protected. What technology should be used to quickly bring these environments into compliance?
Answer : C
Which three statements are true regarding database recovery operations? (Choose three.)
Answer : B,E,F
Which two statements we true regarding the index creation recommendations given by
SQL Tuning Advisor and SQLAccess Advisor? (Choose two.)
Answer : B,C
Which two options describe the features of simple views? (Choose two.)
Answer : A,C
The RECYCLEBIN parameter is set to onfor your database. You drop a table,
PRODUCTS, from the SCOTTschema.
Which two statements are true regarding the outcome of this action? (Choose two.)
Answer : C,D
Evaluate the following command:
$sqlplus / noblog
In which scenario would the above command execute successfully?
Answer : B