1z0-067 Oracle Exam Questions and Free Practice Test

Question 67

Examine the output:
SQL > ARCHIVE LOGLIST
Database log mode Archive Mode Automatic archival Enabled
Archive Destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 376
Next log sequence to archive 378 Current log sequence 378
Which three types of files are automatically placed in the fast recovery area?

A. Flashback data archives (FDA)

B. Archived redo log files

C. Control file autobackups

D. Server parameter file (SPFILE)

E. Recovery Manager (RMAN) backup pieces

Correct Answer:BCE
References: http://docs.oracle.com/cd/E11882_01/backup.112/e10642/glossary.htm#BRADV526

Question 68

You are administering a multitenant container database (CDB) cdb1 that has multiple pluggable databases (PDBs). As the sys user on cdb$root, you execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orc1123;
SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL; SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;
Which two statements are true about the c##admin user that is created in all PDBs?

A. It can create only local users in all the PDBs.

B. It has a common schema for all the PDBs.

C. It can create common users only when it is logged in to the CDB.

D. It can create only local users in the CDB.

E. It can be granted only common roles in the PDBs.

Correct Answer:BC