Oracle Oracle Database 1Z0-067 Questions & Answers

• Question 221:

  Identify two scenarios in which the RMAN crosscheck command can be used.

  A. when checking for backups that are not required as per the retention policy

  B. when updating the RMAN repository if any of the archived redo log files have been deleted without using RMAN to do the deletes

  C. when updating outdated information about backups that disappeared from disk or media or became corrupted and inaccessible

  D. when synchronizing backups, which were not performed by using RMAN, with the RMAN repository

  E. when listing backups that are required for recovery operations

  Correct Answer: BC

• Question 222:

  A database is running in archivelog mode. You want to back up a 10 TB data file belonging to the users tablespace. The backup of the data file is too slow.

  What type of backup do you recommend to improve the performance of the backup?

  A. image copy backup by using RMAN

  B. multisection image copy backup by using RMAN

  C. multisection parallel backup by using RMAN

  D. cold backup after taking the tablespace offline

  E. cold backup after placing the tablespace in backup mode

  Correct Answer: C

• Question 223:

  Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and historical data for a given transaction or for transactions in a given time interval.

  Which three are prerequisites to fulfill this requirement?

  A. Minimal supplemental logging must be enabled.

  B. The database must be running in archivelog mode.

  C. Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.

  D. The flashback any table privilege must be granted to the user.

  E. The select any transaction privilege must be granted to the user.

  F. The recycle bin parameter must be set to on.

  Correct Answer: ABE

  To configure your database for the Flashback Transaction feature, you or your database administrator must: With the database mounted but not open, enable ARCHIVELOG: ALTER DATABASE ARCHIVELOG; Open at least one archive log: ALTER SYSTEM ARCHIVE LOG CURRENT; If not done, enable minimal and primary key supplemental logging: ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS; Granting Necessary Privileges For Oracle Flashback Transaction Query Grant the SELECT ANY TRANSACTION privilege. For Oracle Flashback Query and Oracle Flashback Version Query To allow access to specific objects during queries, grant

  FLASHBACK and SELECT privileges on those objects. To allow queries on all tables, grant the

  FLASHBACK ANY TABLE privilege.

  Reference:

  http://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS612

• Question 224:

  On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command: S>sqlldrhr/hr@pdb table=employees

  Which two statements are true about the command?

  A. It succeeds with default settings if the employees table exists in the hr schema.

  B. It fails because no SQL*Loader data file location is specified.

  C. It fails if the hr user does not have the create any directory privilege.

  D. It fails because no SQL*Loader control file location is specified.

  E. It succeeds and creates the employees table in the HR schema.

  Correct Answer: AC

  sqlldr scott/tiger@pdb1 TABLE=EMP2 DATE_FORMAT=\"DD-MON-YYYY HH24:MI:SS\" Reference: https://oracle-base.com/articles/12c/sql-loader-enhancements-12cr1

• Question 225:

  Which three RMAN persistent settings can be set for a database?

  A. backup retention policy

  B. default backup device type

  C. default section size for backups

  D. default destinations for backups

  E. multiple backup device types for a single backup

  Correct Answer: ABD

  Explanation: To simplify ongoing use of RMAN, you can set several persistent configuration settings for each target database. These settings control many aspects of RMAN behavior. For example, you can configure the backup retention policy, default destinations for backups, default backup device type, and so on. You can use the SHOW and CONFIGURE commands to view and change RMAN configurations.

  Reference: http://docs.oracle.com/cd/B19306_01/backup.102/b14192/setup004.htm#i1019739

• Question 226:

  Which two statements are true about dropping a pluggable database (PDB)?

  A. A PDB must be in mount state or it must be unplugged.

  B. The data files associated with a PDB are automatically removed from disk.

  C. A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs.

  D. A PDB must be in closed state.

  E. The backups associated with a PDB are removed.

  F. A PDB must have been opened at least once after creation.

  Correct Answer: AC

  Reference: http://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13658

• Question 227:

  Your database has a table CUSTOMERS that contains the columns CUST_NAME, AMT_DUE, and

  OLD_STATUS.

  Examine the commands executed and their output:

  

  Why is it that only one update is listed by the Flashback Version Query?

  A. Supplemental logging is not enabled for the database.

  B. The undo data that existed for versions of rows before the change to the table structure is invalidated.

  C. The DB_FLASHBACK_RETENTION_TARGET parameter is set to a lower value and the undo data pertaining to the first transaction is flushed out.

  D. Undo retention guarantee is not enabled.

  E. Flashback Data Archive is full after the first update statement.

  Correct Answer: C

• Question 228:

  Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)?

  A. Use the DBMS_pdb package to plug the Oracle 11g database into the existing CDB as a PDB.

  B. Use the create database ... enable pluggable database statement to create a PDB by copying data files from pd3Sseed and use data pump to load data from the Oracle 11g database into the newly created PDB.

  C. Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB.

  D. Pre-create a PDB in CDB and use the network_link and parallel parameters with data pump import to import data from the Oracle 11g database to the newly created PDB.

  E. Upgrade the Oracle 11g database to a 12c non-CDB and use the dbms_pdb.describe procedure to plug the database as a new PDB into the CDB.

  Correct Answer: DE

• Question 229:

  In which three scenarios is media recovery required?

  A. when a tablespace is accidentally dropped from a database

  B. when archived redo log files are lost

  C. when data files are lost

  D. when one of the online redo log members is corrupted

  E. when all control files are lost

  Correct Answer: ABE

  References: https://docs.oracle.com/cd/A81042_01/DOC/server.816/a76993/recoscen.htm

• Question 230:

  In the SPFILE, UNDO TABLESPACE is Set to UNDO TBS.

  You rename the undotbs undo tablespace:

  ALTER TABLESPACE undotbs RENAME TO undotbs_old;

  Which statement is true?

  A. The tablespace will be renamed but the data file headers will not be updated.

  B. The statement will fail because you cannot rename an undo tablespace.

  C. The tablespace will be renamed and all the changes will be logged in the alert log.

  D. The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter.

  E. You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs.

  Correct Answer: C

  Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces008.htm