1Z0-072 Online Practice Questions and Answers

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the MMON background process? (Choose three.)

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

B. ADDM can recommend shrinking the buffer cache.

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

D. ADDM can recommend extending the buffer cache.

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

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

Which two statements are true about VSTABLESPACE and DBA_ TABLESPACE?

A. VSTABLESPACE cab be queries by all users, but DBA_ TABLESPACEs cab be queries only by SYSDBA users.

B. VSTABLESPACE is a dynamic view that is populated with data from th DBA_ TABLESPACE dictionary view.

C. VSTABLESPACE is a dynamic view that is populated with data from the DBA_ TABLESPACES data queried only when a database is open.

D. VSTABLESPACE and DBA_ TABLESPACES are view based on base tables in the data dictionary.

E. VSTABLESPACE metadata is lost at shutdown, but DBA_ TABLESPACE metadata persists across shutdowns.

Which action helps in applying the principle of least privilege?

A. disabling audit for users with system privileges

B. revoking all system privileges from the SYSTEM user

C. setting the REMOTE_OS_AUTHENT parameter to true

D. setting the O7_DICTIONARY_ACCESSIBILITY parameter to true

E. restricting access to directory objects in the database

Your database instance is started by using an spfile. You want to modify the value of a static initialization parameter.

Examine these steps:

1.

Shut down the database instance.

2.

Modify the parameter in the spfile with scope = SPFILE.

3.

Modify the parameter in a pfile.

4.

Use the spfile to create a pfile.

5.

Use the pfile to create a spfile.

6.

Modify the parameter in the spfile with scope = BOTH.

7.

Start up the database instance.

Which are the minimum required steps in the correct order?

A. 2, 1, 7

B. 1, 7, 2

C. 1, 2, 7

D. 6, 1, 7

E. 1, 4, 3, 5, 7

What three are true about Oracle Flashback technology? (Choose three.)

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

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

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

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

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

Which two types of files are opened by a database instance in the NOMOUNT state?

A. control files

B. the alert log

C. the initialization parameter file

D. data files

E. online redo logs

For which three purposes is UNDO used? (Choose three.)

A. flashback queries

B. B. FLASHBACK TABLE TO BEFORE DROP operations

C. the roll forward phase of instance recovery

D. RESTORE DATABASE operations

E. ROLLBACK operations

F. read consistency

In the ORCL database, USER1 has unlimited quota on TBS1 and TBS2. The USER1.EMP table with primary key EMP_ENO_PK resides in TBS1. USER1.EMP_IDX residing in TBS2 is an index on U1.EMP.ENAME. TBS1 is exported from ORCL by using this command:

The TESTDB database has a TBS1 tablespace but no TBS2. The SYSTEM user in TESTDB executes this command:

What is the result and why?

A. It imports EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK and EMP_IDX.

B. It imports only EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK.

C. It fails because TESTDB has TBS1.

D. It imports only EMP.

E. It fails because TESTDB does not have TBS2 to create EMP_IDX.

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

A. The database must have FLASHBACK enabled in order to perform it.

B. It is possible only when the database is in MOUNT state

C. Uncommitted transactions will be rolled back after it completes.

D. Incremental backups can be used to roll forward the database while performing it.

E. Only RMAN backupsets can be used to restore a database as part of it.

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

A. The ALTER USER statement must be used to set specific default roles for a user.

B. A role must be disabled before it can be revoked from a user.

C. The SET ROLE statement can be used once per session.

D. The SET ROLE statement enables as well as disables roles in a session.

E. All privileges and roles granted to a user are enabled by default when the user logs in.