Which are three of the various resources that must be accessible to keep a database open?

• A. all members of a redo log group
• B. spfile
• C. SYSTEM tablespace
• D. control file
• E. SYSAUX tablespace

Which two affect the time taken for instance recovery? (Choose two.)

• A. size of archivelogs
• B. size of UNDO tablespace
• C. size of redo logs
• D. size of existing RMAN backupsets
• E. UNDO_RETENTION value
• F. FAST_START_MTTR_TARGET value

解説: (CertShiken メンバーにのみ表示されます)

You want to audit update statements that refer to USER1.DEPT.DNAME.
Which type of auditing must you use?

• A. standard auditing
• B. value-based auditing
• C. mandatory auditing
• D. fine-grained auditing

You created a profile APP_USER and assigned it to the users. After a month, you decide to drop the profile. Some user sessions are currently connected to the database instance and are using the APP_USER profile.
This command is used to drop the profile:
SQL> DROP PROFILE app_user;
Which statement describes the result?

• A. The command produces an error.
• B. The profile is dropped, the sessions are terminated, and the subsequent user sessions use the DEFAULT profile.
• C. The profile is dropped and current user sessions use the DEFAULT profile immediately.
• D. The profile is dropped and only the subsequent user sessions use the DEFAULT profile.

View the Exhibit and examine the output.

Which two statements are true regarding the LISTENER2 listener? (Choose two.)

• A. The ORCL instance is registered statically in the listener.ora file.
• B. The ORCL instance is registered dynamically with the listener.
• C. The total number of client connections handled so far by the service handler is two.
• D. The number of current client connections handled by the service handler is two.

解説: (CertShiken メンバーにのみ表示されます)