Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 41:

  Which two are prerequisites for creating a backup-based duplicate database?

  A. connecting to the target database and a recovery catalog to execute the duplicate command
  B. creating a password file for an auxiliary instance
  C. connecting to an auxiliary instance
  D. matching the database identifier (DBID) of the source database and the duplicate database
  E. creating an SPFILE for the target database
  B. creating a password file for an auxiliary instance
  C. connecting to an auxiliary instance

  ---

  References: http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#CHDEDFFH

• Question 42:

  You are administering a multitenant container database (CDB).

  Identify two ways to access a pluggable database (PDB) that is open in read-only mode.

  A. by using the connect statement as a local user having only the set container privilege
  B. by using easy connect
  C. by using external authentication
  D. as a common user with the set container privilege
  E. by executing the alter session set container command as a local user
  B. by using easy connect
  D. as a common user with the set container privilege

  ---

  Reference: https://docs.oracle.com/database/121/ADMIN/cdb_pdb_admin.htm#ADMIN13861

• Question 43:

  You wish to create jobs to satisfy these requirements:

  1.

  Automatically bulk load data from a flat file.

  2.

  Rebuild indexes on the SALES table after completion of the bulk load.

  How would you create these jobs?

  A. Create both jobs by using Scheduler raised events.
  B. Create both jobs using application raised events.
  C. Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.
  D. Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.
  C. Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.

  ---

  The bulk loader would be started in response to a file watcher scheduler event and the indexes would be rebuilt in response to an application event raised by the bulk loader. Your application can raise an event to notify the Scheduler to start a job. A job started in this way is referred to as an event-based job. The job can optionally retrieve the message content of the event. References: https://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse008.htm#CHDIAJEB https://docs.oracle.com/cd/E18283_01/server.112/e17120/scheduse005.htm#CIABIEJA

• Question 44:

  You are administering a database that supports data warehousing workload and Is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week.

  One of the data files is corrupted and the current online redo log file is lost because of a media failure.

  You want to recover the data file.

  Examine the steps involved in the recovery process:

  1.Shut down the database instance.

  2.Start up the database instance in nomount state.

  3.Mount the database.

  4.Take the data file offline.

  5.Put the data file online.

  6.Restore the control file.

  7.Restore the database.

  8.Restore the data file.

  9.Open the database with the resetlog option.

  10.Recover the database with the noredo option.

  11.Recover the data file with the noredo option.

  Identify the required steps in the correct order.

  A. 4, 8, 11, 5
  B. 1, 3, 8, 11, 9
  C. 1, 2, 6, 3, 7, 10, 9
  D. 1, 3, 7, 10, 9
  E. 1, 2, 6, 3, 8, 11, 9
  C. 1, 2, 6, 3, 7, 10, 9

• Question 45:

  You issue the RMAN commands:

  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;

  RMAN> 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
  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
  D. backing up all used and unused blocks in the data files

  ---

  Reference: https://docs.oracle.com/database/121/BRADV/rcmbckba.htm#BRADV89516

• Question 46:

  Users report this error message when inserting rows into the orders table:

  ERROR atline1:

  ORA-01654f:unable to extend index USERS.ORDERS_IND by 8in tablespace INDEXES

  You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database.

  Which two must you do to fix this problem without affecting currently executing queries?

  A. drop and re-create the index
  B. coalesce the orders,,ind index
  C. coalesce the indexes tablespace
  D. perform an on line table rebuild using dbns_redefir.ition.
  E. rebuild the index online moving it to another tablespace that has enough free space for the index
  B. coalesce the orders,,ind index
  E. rebuild the index online moving it to another tablespace that has enough free space for the index

  ---

  Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28310/indexes004.htm#i1006864

• Question 47:

  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.
  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.

• Question 48:

  Which statements are true regarding system-partitioned tables? (Choose all that apply.)

  A. Only a single partitioning key column can be specified.
  B. All DML statements must use partition-extended syntax.
  C. The same physical attributes must be specified for each partition.
  D. Unique local indexes cannot be created on a system-partitioned table.
  E. Traditional partition pruning and partitionwise joins are not supported on these tables.
  D. Unique local indexes cannot be created on a system-partitioned table.
  E. Traditional partition pruning and partitionwise joins are not supported on these tables.

• Question 49:

  Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2. RMAN is connected to the target database pdb2_1.

  Examine the command executed to back up pdb2_1:

  RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

  Which statement is true about the execution of this command?

  A. It fails because archive log files cannot be backed up using a connection to a PDB.
  B. It succeeds but only the data files belonging to the pdb2_i pluggable database are backed up.
  C. It succeeds and all data files belonging to PD2_i are backed up along with the archive log files.
  D. It fails because the pluggable clause is missing.
  B. It succeeds but only the data files belonging to the pdb2_i pluggable database are backed up.

  ---

  Reference: http://docs.oracle.com/database/121/BRADV/rcmcnctg.htm#CEGCCEIE

• Question 50:

  Which two statements are true about a multitenant architecture?

  A. Each pluggable database (PDB) has its own initialization parameter file.
  B. A PDB can have a private undo tablespace.
  C. Log switches occur only at the container database level.
  D. A PDB can have a private temporary tablespace.
  E. Each PDB has a private control file.
  C. Log switches occur only at the container database level.
  D. A PDB can have a private temporary tablespace.

  ---

  You are only able to switch the archived logs when you connect to the root of a CDB, but you cannot switch archived redo logs when connected to a PDB. You can able to create a PDB without temporary tablespace but not able to make it use the temporary tablespace of CDB.