1Z0-072 試験問題を無料オンラインアクセス

In your database, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)

• A.Log in to the database instance.
• B.Execute DDL statements in the HR schema.
• C.Grant the CREATE SESSION privilege with ADMIN OPTION to other users.
• D.Revoke the CREATE SESSION privilege from other users.
• E.Execute DML statements in the HR schema.
• F.Grant the CREATE SESSION privilege without ADMIN OPTION to other users.

Which two are true about instance recovery? (Choose two.)

• A.It is guaranteed to complete within fast_start_mttr_target number of seconds.
• B.It is performed when mounting a database.
• C.It occurs after a SHUTDOWN IMMEDIATE.
• D.Archived REDO log files are never required to perform instance recovery.
• E.The database opens after the roll forward phase of instance recovery.
• F.Archived REDO log files are required to perform instance recovery.

Which two are true about the roles? (Choose two.)

• A.The SET ROLE statement enables as well as disables roles in a session.
• B.A role must be disabled before it can be revoked from a user.
• C.The ALTER USER statement must be used to set specific default roles for a user.
• D.All privileges and roles granted to a user are enabled by default when the user logs in.
• E.The SET ROLE statement can be used once per session.

Which three are true about Oracle Managed Files (OMF)? (Choose three.)

• A.If only DB_CREATE_ONLINE_LOG_DEST_n is specified, only the redo logs and control files are OMF.
• B.If DB_RECOVERY_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_RECOVERY_FILE_DEST by default.
• C.If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.
• D.If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_CREATE_FILE_DEST by default.
• E.If DB_CREATE_ONLINE_LOG_DEST_1 is specified but DB_CREATE_FILE_DEST is not, the data files and temp files are placed in DB_CREATE_ONLINE_LOG_DEST_1 by default.
• F.If only DB_CREATE_FILE_DEST is specified, only the data files and temp files are OMF.

Which three failures do not require intervention for recovery? (Choose three.)

• A.statement failure
• B.user process failure
• C.media failure
• D.network interface card (NIC) failure
• E.transaction failure