Oracle Oracle Database 1Z0-067 Questions & Answers

• Question 41:

  Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)

  A. An ASM instance mounts an ASM control file

  B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group

  C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly

  D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

  Correct Answer: CD

• Question 42:

  Before a Flashback Table operation, you execute the following command:

  ALTER TABLE employees ENABLE ROW MOVEMENT;

  Why would you need this to be executed?

  A. Because row IDs may change during the flashback operation

  B. Because the object number changes after the flashback operation

  C. Because the rows are retrieved from the recycle bin during the flashback operation

  D. Because the table is moved forward and back to a temporary during the flashback operation

  Correct Answer: A

• Question 43:

  Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the

  users on the database use the default temporary tablespace.

  A user issues a query on the orders table and receives the following error:

  ERROR at line 1:

  ORA-01565: error in identifying file

  '/u01/app/oracle/oradata/TEST/temp01.tmp'

  ORA-27037: unable to obtain file status

  What would be the most efficient way to rectify this error?

  A. Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.

  B. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.

  C. Allow the database to continue running, drop the temp01.tmp temporary file, and then re-create it with new tempfiles.

  D. Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then bring the temporary tablespace online.

  Correct Answer: A

• Question 44:

  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 45:

  Examine the statements that use flashback technologies:

  1.

  FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP (`2013-02-04 09:30:00', `YYYYMM-DD HH:MI:SS');

  2.

  SELECT * FROM customers AS OF SCN 123456;

  3.

  FLASHBACK TABLE customers TO BEFORE DROP;

  4.

  FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP (`2013-02-04 09:30:00', `YYYY-MM-DD HH:MI:SS');

  5.

  SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;

  6.

  ALTER TABLE customers FLASHBACK ARCHIVE;

  Which set of statements depends on the availability of relevant undo data in the undo tablespace? (Choose the best answer.)

  A. 1, 2, 5

  B. 1, 3, 6

  C. 2, 3, 5, 6

  D. 3, 4, 5

  Correct Answer: A

• Question 46:

  Which three statements are true about Scheduler Windows? (Choose three.)

  A. Only one window can be open at one time.

  B. Consumer groups are associated with windows.

  C. Windows work with job classes to control resource allocation.

  D. A database service name must be provided during window creation.

  E. The Resource Manager can automatically start windowed jobs or change resource allocation among windowed jobs.

  Correct Answer: ACD

  Reference: https://docs.oracle.com/cd/E18283_01/server.112/e17120/schedover002.htm#insertedID9

• Question 47:

  You plan to migrate a production database to Real Application Clusters (RAC).

  You created a test RAC database by cloning the production database and plan to replay a workload,

  captured from the production database.

  Examine these steps:

  1) Preprocess the captured workload.

  2) Restart the database instance in RESTRICTED mode.

  3) Set up Replay Clients.

  4) Restore the test database to the point when the capture started on the production database.

  5) Remap connections.

  Which is the correct sequence of required steps?

  A. 1, 4, 3, 5

  B. 1, 4, 5, 3

  C. 2, 1, 5, 3, 4

  D. 1, 2, 4, 5, 3

  Correct Answer: A

• Question 48:

  Your database is running in ARCHIVELOG mode. You observe that the fast recovery area does not have enough free space and there is no scope to add more space to it.

  Identify two events that can occur at the time of a log switch. (Choose two.)

  A. All active transactions are rolled back and the database instance shuts down.

  B. The database instance status is automatically changed to RESTRICTED mode and file creation in the fast recovery area is prevented.

  C. The Oracle Database server deletes a file that is on the obsolete file list to create free space in the fast recovery area.

  D. An entry is written in the alert log and the database instance is automatically placed in MOUNT state.

  E. The log switch hangs until free space is available in the fast recovery area.

  Correct Answer: CE

• Question 49:

  RMAN is connected to a target database instance and an auxiliary instance. You execute the command:

  RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE SECTION SIZE 1G;

  What is the outcome?

  A. RMAN uses the push method to transfer image copies.

  B. RMAN uses the push method to transfer backup sets.

  C. RMAN uses the pull method to restore files using backup sets.

  D. RMAN uses the pull method to restore files using image copies.

  Correct Answer: C

• Question 50:

  As part of a manual update process, you install Oracle Database 12c software, prepare a new ORACLE_HOME, you shut down an existing single-instance database that runs from that ORACLE_HOME.

  What should you do next to start the upgrade of this database?

  A. Start up the database instance by using the STARTUP UPGRADE command by using the server parameter file.

  B. Start up the database instance by using the new location of the server parameter file and run the catupgrd.sql script from the new ORACLE_HOME to use parallel upgrade options that reduce down time.

  C. Start up the database instance by using the new location of the server parameter file and run the catctl.pl script from the new ORACLE_HOME to use parallel upgrade options that reduce down time.

  D. Start up the database instance by using the new location of the server parameter file and run the catuppst.sql script to generate informational messages and log files during the upgrade.

  Correct Answer: C