Oracle Database 12cR2 Administration - 1Z0-072 Free Exam Questions

A. It must be a smallfile tablespace.

B. It can be recovered while the instance is open in READ WRITE mode.

C. It contains undo only for uncommitted transactions.

D. It is a locally managed tablespace.

E. It is used for the FLASHBACK TABLE...TO BEFORE DROP operation.

A. Uncommitted transactions will be rolled back after complete recovery completes.

B. Only incremental backups can be used to roll forward the database while performing complete recovery.

C. The database must have FLASHBACK enabled in order to perform incomplete recovery.

D. Uncommitted transactions will be rolled back after incomplete recovery completes.

E. Incomplete recovery is possible only when the database is open.

A. Private database link creation requires the same user to exist in both the local and the remote database.

B. A database link created in a database allows a connection from that database instance to another, but not vice versa.

C. A public database link can be used by a user in the local database to connect to any schema in the remote database.

D. A public database link can be created only by SYS.

E. A database link can be created only between Oracle databases.

A. 50%

B. 90%

C. 10%

D. 25%

E. 75%

A. 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.

B. If only DB_CREATE_ONLINE_LOG_DEST_n is specified, only the redo logs and control files are OMF.

C. If only DB_CREATE_FILE_DEST is specified, only the data files and temp files are OMF.

D. If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.

E. 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.

F. 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.

A. FLASHBACK TRANSACTION can be used to undo the changes made by a committed transaction.

B. FLASHBACK QUERY can be used to view committed data at any given point in time.

C. FLASHBACK TABLE can be used to rewind a table back in time.

D. FLASHBACK TABLE can be used to undo dropping a column from a table.

E. FLASHBACK DATABASE can be used to rewind a database back and forth in time.

A. flashback queries

B. the roll forward phase of instance recovery

C. RESTORE DATABASE operations

D. ROLLBACK operations

E. FLASHBACK TABLE <tablename> TO BEFORE DROP operations

F. read consistency

A. view

B. table partition

C. sequence

D. stored procedure

E. materialized views on a prebuilt container

F. table

A. creating public synonyms

B. creating views

C. creating invisible indexes

D. creating partitions

E. executing UPDATE statements