Oracle Oracle Database 1Z0-067 Questions & Answers

• Question 51:

  Examine the RMAN command:

  RMAN> RUN {

  ALLOCATE CHANNEL c1 DEVICE TYPE sbt;

  ALLOCATE CHANNEL c2 DEVICE TYPE sbt;

  ALLOCATE CHANNEL c3 DEVICE TYPE sbt;

  BACKUP

  INCREMENTAL LEVEL = 0

  (DATAFILE 1, 4, 5 CHANNEL c1)

  (DATAFILE 2, 3, 9 CHANNEL c2)

  (DATAFILE 6, 7, 8 CHANNEL c3)

  SQL `ALTER SYSTEM ARCHIVE LOG CURRENT';

  }

  Which statement is true about the command? (Choose the best answer.)

  A. It uses multisection backup.

  B. It uses parallelization for the backup set.

  C. It uses asynchronous I/O for the backup.

  D. It creates compressed backup sets.

  Correct Answer: B

• Question 52:

  Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidently truncates an important table at 10 AM after the last backup. After that, a few important transactions are performed on the database.

  Which two best methods are performed the truncated table data? (Choose two.)

  A. Table Point-in-Time Recovery.

  B. Database Point-in-Time Recovery

  C. Tablespace Point-in-Time Recovery

  D. Flashback Database

  E. Flashback Transaction Backout

  Correct Answer: CD

• Question 53:

  Your database is running in ARCHIVELOG mode. You backup your database regularly. If certain files are lost, an incomplete recovery is required.

  In which two cases is this true?

  A. flashback logs

  B. inactive online redo log

  C. current online redo log member

  D. all control files

  E. archived log files required to perform recovery

  Correct Answer: BD

  Reference: https://docs.oracle.com/cd/B10501_01/server.920/a96519/strategy.htm

• Question 54:

  Examine the probable steps involved in the basic backup process of RMAN and Oracle Secure Backup (OSB):

  1.

  RMAN initiates backup and passes the database backup storage selector to OSB.

  2.

  RMAN creates the backup job.

  3.

  OSB creates the backup job with an OSB user.

  4.

  RMAN updates its repository.

  5.

  RMAN executes the job and transfers data from a client to media.

  6.

  OSB executes the job and transfers data from a client to media.

  7.

  OSB updates its repository.

  Identify the required steps in the correct order.

  A. 1, 3, 6, 4, 7

  B. 2, 1, 6, 4, 7

  C. 1, 3, 6, 7, 4

  D. 1, 3, 5, 7, 4

  Correct Answer: C

• Question 55:

  ENCRYPT_TS an encrypted tablespace that contains tables with data.

  Which statement is true about queries and data manipulation language statements on these tables?

  A. Queries may be performed on columns that have the NO SALT option.

  B. Data remains encrypted when read into the buffer cache.

  C. Redo generated by DML remains encrypted.

  D. UNDO generated by DML remains encrypted if the UNDO tablespace is encrypted.

  E. Data remains encrypted when read into the PGA for direct path reads.

  Correct Answer: C

• Question 56:

  Examine the following impdp command to import a database over the network from a pre-12c Oracle

  database (source):

  $> impdp full=Y network_link=hrdb_test transportable=always

  transport_datafiles=

  `/u01/app/oracle/oradata/hrdb/sales01.dbf',

  `/u01/app/oracle/oradata/hrdb/cust01.dbf',

  `/u01/app/oracle/oradata/hrdb/emp01.dbf',

  version=12 logfile=import.log

  Which three are prerequisites for successful execution of the command?

  A. The impdp operation must be performed by the same user that performed the expdp operation.

  B. The path of data files on the target database must be the same as that on the source database.

  C. The export dump file must be created before starting the import on the target database.

  D. All the user defined tablespaces must be in read-only mode on the source database.

  E. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXP_FULL_DATABASE role.

  F. The source and target databases must be running on the same platform with the same endianness.

  Correct Answer: ACE

• Question 57:

  You are connected to a recovery catalog and target database. You execute the command:

  RMAN> CATALOG START WITH `/disk1/backups';

  Which statement is true?

  A. It lists and catalogs all valid data file copies, backup pieces, and archived logs that exist in all directory paths with the prefix /disk1/backups and their subdirectories.

  B. It lists all the data file copies, backup pieces, and archived logs cataloged in the recovery catalog in the /disk1/backups directory and its subdirectories.

  C. Only valid data file copies, existing in the /disk1/backups directory, are cataloged.

  D. Only valid backup pieces and archived logs, existing in the /disk1/backups directory, are cataloged.

  Correct Answer: A

• Question 58:

  Examine these parameter settings:

  SGA_TARGET = 700M SGA_MAX_SIZE = 1024M

  DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You attempt this:

  SQL> ALTER SYSTEM SER DB_8K_CACHE_SIZE=140M

  Which statement is true based on the information available?

  A. It will fail because DB_8K_CACHE_SIZE cannot be changed dynamically.

  B. It succeeds only if memory is available from the autotuned components of the SGA.

  C. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.

  D. It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

  Correct Answer: B

• Question 59:

  Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)? (Choose three.)

  A. Use Enterprise Manager Database Express to create a PDB in an existing CDB.

  B. Use the DBMS_PDB package to plug a non-CDB into an existing CDB.

  C. Use PDB$SEED for creating a PDB.

  D. To clone an existing PDB.

  E. Use the DBMS_PDB package to plug a pre-Oracle 12c database into an existing CDB.

  Correct Answer: BCD

• Question 60:

  Your database is running in ARCHIVELOG mode and flashback is enabled.

  In which scenario must you use RMAN backups for recovering tables and table partitions? (Choose the best answer.)

  A. when recovering data that was lost after a DDL operation modified the structure of a table

  B. when recovering dropped tables that are present in the recyclebin

  C. when recovering a table that has been logically corrupted

  D. when recovering a table to a point in time

  E. when recovering the data of a table to the desired point in time, which is more recent than the oldest available undo.

  Correct Answer: A