Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 191:

  Your database instance is abnormally terminated because of a power outage. At the next startup, from which point in the redo log does the recovery start? (Choose the best answer.)

  A. from the most recent incremental checkpoint
  B. from the beginning of the current redo log file to the checkpoint position
  C. from the last committed transaction
  D. from the beginning of the current redo log file until the instance failure
  E. from the last complete checkpoint position
  E. from the last complete checkpoint position

  ---

  Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28318/startup.htm#CNCPT005

• Question 192:

  Examine the command and its output:

  SQL> DROP TABLE EMPLOYEE;

  SQL> SELECT object_name AS recycle_name, original_name, type FROM recyclebin;

  RECYCLE_NAMEORIGINAL_NAMETYPE

  binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE

  You then successfully execute the command:

  SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP;

  Which two statements are true?

  A. It flashes back the employee table and all the constraints associated with the table.
  B. It automatically flashes back all the indexes on the employes table.
  C. It automatically flashes back any triggers defined on the table.
  D. It flashes back only the structure of the table and not the data.
  E. It flashes back the data from the recycle bin and the existing data in the original table is permanently lost.
  B. It automatically flashes back all the indexes on the employes table.
  C. It automatically flashes back any triggers defined on the table.

  ---

  A table and all of its dependent objects (indexes, LOB segments, nested tables, triggers, constraints and so on) go into the recycle bin together, when you drop the table. Likewise, when you perform Flashback Drop, the objects are generally

  all retrieved together. Trigger automatically flashbacked.

  References:

  http://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr004.htm#i1020594

• Question 193:

  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
  C. Tablespace Point-in-Time Recovery
  D. Flashback Database

• Question 194:

  You restore and recover your database to a new host by using an existing RMAN open database backup.

  Which step must you perform next?

  A. Execute catproc.sqi to recompile invalid PL/SQL modules.
  B. Open the database with the resetlogs option.
  C. Set a new database identifier (DBID) for the newly restored database.
  D. Use the RMAN set newname and switch commands to switch to new files.
  B. Open the database with the resetlogs option.

  ---

  Reference: https://docs.oracle.com/cd/B10501_01/server.920/a96566/rcmrecov.htm#1007514

• Question 195:

  Your database is running in archivelog mode. Examine the parameters for your database instance:

  LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY' LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 ='LOCATIO=/disk3/arch' LOG_ARCHIVE_DEST _4 ='LOCATIONs/disk4/arch' LOG_ARCHIVE _MIN_SUCCEED_DEST = 2

  While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used.

  What happens at the next log switch?

  A. The database instance hangs and the redo log files are not overwritten.
  B. The archived redo log files are written to the fast recovery area until the mandatory destination is made available.
  C. The database instance is shutdown immediately.
  D. The destination set by the log_archive_dest parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.
  A. The database instance hangs and the redo log files are not overwritten.

  ---

  Explanation: Made more logfile switch until all redos groups are full. first log switch succeds, second also succeds then next will hang database.

• Question 196:

  user_data is a nonencryptedtablespace containing tables with data.

  You must encrypt ail data in this tablespace.

  Which three methods can do this?

  A. Use Data Pump.
  B. Use ALTERTABLE. . .MOVE
  C. Use CREATE TABLE AS SELECT
  D. Use alter tablespace to encrypt the tablespace after enabling row movement on all its
  E. Use altertablespace to encrypt the tablespace.
  A. Use Data Pump.
  B. Use ALTERTABLE. . .MOVE
  C. Use CREATE TABLE AS SELECT

  ---

  Finally, note that you can only create encrypted tablespaces; you cannot modify existing tablespaces to encrypt them. So, when you need existing data in encrypted tablespaces, the best solution is to first create encrypted tablespaces and then move the objects from the unencrypted tablespaces to them. Reference: http://www.oracle.com/technetwork/testcontent/o19tte-086996.html

• Question 197:

  You are performing regular backups of your production database by using a recovery catalog.

  You add two new tablespaces to your production database after performing a backup. They must be included in future backups. Which action should you perform?

  A. Synchronize the recovery catalog with the target database control file
  B. Add the tablespaces in the recovery catalog by using the CATALOG command
  C. Synchronize all the physical data files with the logical records in the recovery catalog by using the CROSSSCHECK command
  D. Create a new database incarnation record
  A. Synchronize the recovery catalog with the target database control file

• Question 198:

  Identify three benefits of unified auditing.

  A. It helps to reduce disk space used to store an audit trail in a database.
  B. It guarantees zero-loss auditing.
  C. It reduces overhead on a database caused by auditing, by having a single audit trail.
  D. An audit trail cannot be modified because it is read-only.
  E. It automatically audits Recovery Manager (RMAN) events.
  C. It reduces overhead on a database caused by auditing, by having a single audit trail.
  D. An audit trail cannot be modified because it is read-only.
  E. It automatically audits Recovery Manager (RMAN) events.

• Question 199:

  You want to move your existing recovery catalog to another database.

  Examine the steps:

  1) Export the catalog data by using the Data Pump Export utility in the source database.

  2) Create a recovery catalog user and grant the necessary privileges in the target database.

  3) Create a recovery catalog by using the create catalog command.

  4) Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database.

  5) Import the source recovery catalog schema by using the import catalog command.

  6) Connect to the destination database.

  7) Connect as catalog to the destination recovery catalog schema.

  Identify the option with the correct sequence for moving the recovery catalog.

  A. 1, 6, 4
  B. 2, 3, 7, 5
  C. 1, 2, 6, 4
  D. 1, 2, 3, 6, 5
  B. 2, 3, 7, 5

• Question 200:

  Consider the following scenario for your database:

  -Backup optimization is enabled in RMAN.

  -The recovery window is set to seven days in RMAN.

  -The most recent backup to disk for the tools tablespace was taken on March 1, 2015.

  -The tools tablespace is read-only since March 2, 2015.

  On March 15, 2015, you issue the RMAN command to back up the database via the Media Manager Interface.

  Which statement is true about the backup of the tools tablespace?

  A. The RMAN backup fails because the tools tablespace is read-only.
  B. RMAN skips the backup of the tools tablespace because backup optimization is enabled.
  C. RMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media.
  D. RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.
  D. RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.