Q1. View the Exhibit and examine the privileges granted to the MGR_ROLE role.
The user SKD has been granted the CONNECT and RESOURCE roles only. The database administrator (DBA) grants MGR_ROLE to the user SKD by executing the command:
SQL> GRANT MGR_ROLE TO SKD WITH ADMIN OPTION;
Which statement is true about the user SKD after he/she is granted this role?
Exhibit:
A. The user SKD can grant only the MGR_ROLE role to other users, but not the privileges in it
B. The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor
C. The user SKD can grant the privileges in the MGR_ROLE role to other users but not with ADMIN OPTION
D. The user SKD can grant the privileges in the MGR_ROLE role to other users, but cannot revoke privileges from them
Answer: A
Q2. Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine?
A. Host naming method
B. Local naming method
C. External naming method
D. Directory naming method
Answer: B
Q3. You are managing an Oracle Database 11g database with the following backup strategy:
1. On Sunday, an incremental level 0 tape backup is performed
2. Monday through Saturday, a cumulative incremental level 1 tape backup is performed
Which two statements are true regarding the backups performed? (Choose two.)
A. The backup performed in step 1 backs up all blocks that have ever been in use in the database
B. The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup
C. The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup
D. The backup performed in step 2 backs up all blocks that have changed since the most recent incremental backup at level 1
Answer: AB
Q4. Examine the commands executed in the following sequence:
Which statement is true about the above commands?
A. The commands execute successfully.
B. Command 6 produces an error because of circular role grant.
C. Command 5 produces an error because a role cannot be granted to another role.
D. Command 3 produces an error because the MGRROLE role already contains system privileges. The table created by HR remains and HR still has the CREATE TABLE system privilege.
E. The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
Answer: B
Q5. Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)
A. Shared SQL Area will be allocated in the shared pool
B. Shared SQL Area will be allocated when a session starts
C. Shared SQL Area will be allocated in the large pool always
D. The whole of Private SQL Area will be allocated in the Program Global Area (PGA) always
E. Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool
F. The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter
Answer: AF
Q6. You executed the following commands to find the location of the alert log file:
Where is the alert log file stored? (Choose all that apply.)
A. in the BACKGROUND_DUMP_DEST location; in text format
B. in the BACKGROUND_DUMP_DEST location; in XML format
C. in the BACKGROUND_DUMP_DEST location; in both text and XML format
D. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in text format
E. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in XML format
F. in the DIAGNOSTIC_DEST/diag/rdbms/orcl/orcl/alert directory; in both text and XML format
Answer: A,E
Q7. Identify the two situations in which the alert log file is updated with details. (Choose two.)
A. Running a query on a table returns "ORA-600: Internal Error"
B. Inserting a value in a table returns "ORA-01722: Invalid Number"
C. Creating a table returns "ORA-00955: name is already used by an existing object'
D. Inserting a value in a table returns "ORA-00001: unique constraint (SYS.PK_TECHP) violated."
E. Rebuilding an index using ALTER INDEX ... REBUILD fails with an error "ORA-01578: ORACLE data block corrupted (file # 14, block @ 50)."
F. Rebuilding an index using ALTER INDEX .... REBUILD fails with an error "ORA-01578: ORACLE data block corrupted (file #14, block #50)."
Answer: AE
Q8. View the Exhibit and examine the output of the query.
What do you infer from this?
A. The SGA_TARGET is a static parameter.
B. The instance is started, but the database is not yet open.
C. The server parameter file (SPFILE) was used to start the instance.
D. The SGA_TARGET parameter does not have any effect on the database instance until the SGA_MAX_SIZE parameter is specified.
Answer: C
Q9. You executed the following command to create a password file in the database server:
$ orapwd file = orapworcl entries = 5 ignorecase=N
Which statement describes the purpose of the above password file?
A. It records usernames and passwords of users when granted the DBA role
B. It contains usernames and passwords of users for whom auditing is enabled
C. It is used by Oracle to authenticate users for remote database administrator
D. It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups
Answer: C
Q10. Which task would you perform before you run Oracle Universal Installer (OUI) in silent or suppressed mode for an installation?
A. Run the root.sh script.
B. Create the oraInst.loc file.
C. Create the tnsnames.ora file.
D. Run the oraInstRoot.sh script.
Answer: B