1z0-067 Oracle Exam Questions and Free Practice Test

Question 37

Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIED BY ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which type of encryption is used for the backup performed by using this command?

A. password-mode encryption

B. dual-mode encryption

C. transparent encryption

D. default encryption

Correct Answer:B
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#CEGEJABH To make dualmode encrypted backups: Start RMAN and connect to a target database and recovery catalog (if
used). Execute the SET ENCRYPTION BY PASSWORD command, making sure to omit the ONLY keyword. The following example sets the encryption password for all tablespaces (where password is
a placeholder for the actual password that you enter) in the backup and omits ONLY to indicate dualmode encryption: SET ENCRYPTION IDENTIFIED BY password ON FOR ALL TABLESPACES;

Question 38

Which two statements are true about a common user?

A. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.

B. A common user with the create user privilege can create other common users, as well as local users.

C. A common user can be granted only a common role.

D. A common user can have a local schema in a PDB.

E. A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.

Correct Answer:BD

Question 39

Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests? (Choose three.)

A. assigned to a class with rights to browse all directories and catalogs

B. assigned to a class with rights to back up or restore Oracle database

C. OSB encryption for data in transport and on tape

D. RMAN preauthorization on the host

E. matching the OS user identity of the Oracle instance associated with the database username

F. scheduling of the RMAN backup to occur automatically at user-defined intervals

Correct Answer:BDE

Question 40

You issue the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RKAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY; RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which three tasks are performed by the BACKUP DATABASE command?

A. switching the online redo log file

B. backing up all data files as image copies and archive log files, and deleting those archive log files

C. backing up only the used blocks in the data files

D. backing up all used and unused blocks in the data files

E. backing up all archived log files and marking them as obsolete

Correct Answer:ABD

Question 41

Which three statements are true about the keystore storage framework for transparent data encryption?

A. It facilitates and helps to enforce keystore backup requirements.

B. It handles encrypted data without modifying applications.

C. It enables a keystore to be stored only in a file on a file system.

D. It enables separation of duties between the database administrator and the security administrator.

E. It transparently decrypts data for the database users and applications that access this data.

F. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.

Correct Answer:ADF
References: http://oradb-srv.wlv.ac.uk/E16655_01/network.121/e17729/asotrans.htm#CHDEABCA (benefits of the keystore storage framework)

Question 42

Examine these Data Pump commands to export and import objects from and to the same database. The dba has not yet created users hr1 and oe1.
$expdp system/manager schemas = hr.oe directory = EXP_DIR dumpfile = export.dat include = table
$ impdpsysten/manager schemas = hr1,oe1 directory = EXP_DIR dumpfile = export.dat
remap_schena=hr:hrl, oe:oe1
What will happen when running these commands?

A. expdp will fail because no path has been defined for the dumpfile.

B. expdp will succeed but impdp will fail because the users do not exist.

C. inpdp will create two users called hr1 and oe1 and import all objects to the new schemas.

D. impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively.

Correct Answer:B
ORA-39165: Schema not found error will be resulted

START 1z0-067 EXAM