Oracle Database 12cR2 Administration - 1z1-072 Exam Practice Test

A. It can execute in parallel.

B. It can export data into sequential media, such as tapes.

C. It makes use of client system resources.

D. It represents database metadata information as DDL statements in the dump file.

E. It can restart failed export jobs.

A. ADDM performs its analysis only whenever a DBA requests it.

B. By default, MMON creates an AWR snapshot every 30 minutes.

C. By default, AWR snapshots are automatically purged after eight days.

D. ADDM can recommend shrinking the buffer cache.

E. AWR snapshots must be deleted when no longer required by ADDM.

F. ADDM can recommend extending the buffer cache.

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

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

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

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

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

A. when a dynamic listener is used

B. when multiple dynamic listeners are used

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

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

E. when a static listener is used

A. It listens on the default port 1521.

B. It must support at least one service on startup.

C. It must be defined in the LISTENER.ORA file.

D. It uses the settings of the INSTANCE_NAME and SERVICE_NAMES parameters from all databases using that listener.

E. It must be defined by using the Listener Control utility.

A. The Oracle background processes are started.

B. The control file is read.

C. The online data files are opened.

D. The initialization parameter file is read.

E. The online redo logs are opened.

F. The alert log records the execution details.

A. restricting access to directory objects in the database

B. setting the REMOTE_OS_AUTHENT parameter to true

C. setting the O7_DICTIONARY_ACCESSIBILITY parameter to true

D. revoking all system privileges from the SYSTEM user

E. disabling audit for users with system privileges

A. RMAN incremental backups in a seven-day cycle

B. automatic daily full database backups

C. encryption for all backups

D. on-demand backups that need to be scheduled

E. encryption of backups only for Enterprise Edition databases

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

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

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

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

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

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