最新的Oracle Database 12cR2 Administration - 1z1-072免費考試真題

A. RESTORE DATABASE operations

B. ROLLBACK operations

C. flashback queries

D. read consistency

E. the roll forward phase of instance recovery

F. FLASHBACK TABLE <tablename> TO BEFORE DROP operations

A. Grant the CREATE SESSION privilege without ADMIN OPTION to other users.

B. Grant the CREATE SESSION privilege with ADMIN OPTION to other users.

C. Log in to the database instance.

D. Execute DDL statements in the HR schema.

E. Revoke the CREATE SESSION privilege from other users.

F. Execute DML statements in the HR schema.

A. It returns an error because UNDOTBS2 is fixed size and has RETENTION GUARANTEE.

B. It suspends the transaction, which can be resumed by setting UNDOTBS1 as the active undo tablespace.

C. It suspends the transaction, which can be resumed by increasing USER1's quota on UNDOTBS2.

D. It returns an error because UNDOTBS2 is fixed size.

E. It returns an error because UNDOTBS2 has RETENTION GUARANTEE.

F. It suspends the transaction, which can be resumed by increasing the size of UNDOTBS2.

A. ensuring that critical components are protected by implementing redundancy

B. decreasing Mean Time to Recover (MTTR) by configuring FLASHBACK mode

C. implementing FLASHBACK DATA ARCHIVE to decrease MTTR

D. implementing FLASHBACK DATA ARCHIVE to decrease MTBF

E. decreasing Mean Time Between Failures (MTBF) by configuring FLASHBACK mode

A. encryption of backups only for High Performance and Extreme Performance database versions

B. encryption for all backups

C. encryption of backups only for Enterprise Edition databases

D. on-demand backups that need to be scheduled

E. RMAN incremental backups in a seven-day cycle

F. automatic daily full database backups

A. Users can revoke a role that is granted to them through other roles.

B. Users who are granted a role with ADMIN OPTION can revoke that role only from users to whom they have granted the role.

C. Users who have the GRANT ANY ROLE privilege can revoke any role.

D. Only users who are granted SYSDBA can revoke a role.

E. Only users who are granted the DBA role can revoke a role.

A. It will only generate SQL Plan Directives specific to a given SQL statement.

B. It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.

C. It can re-optimize execution plans after previous executions detect suboptimal plans.

D. It updates stale object statistics in the Data Dictionary.

E. It determines the optimal table join order and method.

F. It can optimize only SELECT statements.

A. Configure a nonstandard block size.

B. Enable flashback.

C. Register it with an available Enterprise Manager Management server.

D. Configure incremental backups.

E. Create user tablespaces.

A. when multiple dynamic listeners are used

B. when the listener uses multiple port numbers for different database instances

C. when the list of existing database services must be defined

D. when a static listener is used

E. when a dynamic listener is used