Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 121:

  In CDB$ROOT of your multitenant container database (CDB), you create a common user, C##A_ADMIN, and then execute the command:

  SQL> GRANT create tablespace to C##A_ADMIN;

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

  A. The command fails because the CONTAINER clause is not used.
  B. The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root database.
  C. The command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root database, as well as in the plugging databases (PDBs).
  D. The command fails because system privileges cannot be granted to a common user.
  B. The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root database.

• Question 122:

  Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time.

  Examine the steps to recover this table from an RMAN backup:

  1.Determine which backup contains the table that needs to be recovered.

  2.Issue the recover table RMAN command with an auxiliary destination defined and the point in time specified.

  3.Import the Data Pump export dump file into the auxiliary instance.

  4.Create a Data Pump export dump file that contains the recovered table on a target database.

  Identify the required steps in the correct order.

  A. 1, 4, 3
  B. 1, 2
  C. 1, 4, 3, 2
  D. 1, 2, 4
  D. 1, 2, 4

  ---

  Because according to oracle PDFs if you run restore table ... auxiliary a impede and rename can be included. So there is no reason to make the import manually if it can be already included in step 2. Reference: https://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV689

• Question 123:

  Examine the command:

  SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;

  In which two scenarios is this command required?

  A. The current online redo log file is missing.
  B. A data file belonging to a noncritical tablespace is missing.
  C. All the control files are missing.
  D. The database backup is older than the control file backup.
  E. All the data files are missing.
  A. The current online redo log file is missing.
  C. All the control files are missing.

  ---

  Reference: http://searchoracle.techtarget.com/answer/Recover-database-using-backup-controlfile-until-cancel

• Question 124:

  You set the following parameters in the parameter file and restart the database instance: MEMORY_MAX_TARGET=0 MEMORY__TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M

  Which two statements are true?

  A. The memory_max_target parameter is automatically set to 500 MB.
  B. The pga_aggregate_target and sga_target parameters are automatically set to zero.
  C. The value of the memory_max_target parameter remains zero for the database instance.
  D. The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.
  E. The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.
  A. The memory_max_target parameter is automatically set to 500 MB.
  D. The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.

  ---

  Reference:

  http://docs.oracle.com/cd/B28359_01/server.111/b28310/memory003.htm#ADMIN11200 (See the second note on the page)

• Question 125:

  You are required to migrate your 11.2.0.3 database to an Oracle 12c database.

  Examine the list of steps that might be used to accomplish this task:

  1.Place all user-defined tablespaces in read-only mode on the source database.

  2.Use the RMAN convert command to convert data files to the target platform's endian format, if required.

  3.Perform a full transportable export on the source database with the parameters

  VERSI0N=I2, TRANSPORTABLE=ALWAYS, and FULL=Y.

  4.

  Transport the data files for all the user-defined tablespaces.

  5.

  Transport the export dump file to the target database.

  6.

  Perform an import on the target database by using the full, network_link, and transportable_datafiles parameters.

  7.

  Perform an import on the target database by using the full and transportable_datafiles parameters. Identify the required steps in the correct order.

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

  ---

  Reference: http://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c-1896123.pdf

• Question 126:

  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.
  C. RMAN uses the pull method to restore files using backup sets.

• Question 127:

  You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs).

  You have already created a test system to support the consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.

  What is the easiest way to perform capacity planning for consolidation?

  A. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Performance Analyzer on the test system
  B. capturing the workload on the production system and replaying the workload for one PDB at a time on the test system
  C. capturing the workload on the production system and using Consolidated Database Replay to replay the workload of all production systems simultaneously for all PDBs
  D. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Tuning Advisor on the test system
  C. capturing the workload on the production system and using Consolidated Database Replay to replay the workload of all production systems simultaneously for all PDBs

  ---

  Reference: https://docs.oracle.com/database/121/RATUG/GUID-29988B63-F974-46EF-9AAD-3D04AF774337.htm#RATUG4122

• Question 128:

  Which three requirements must be met before a tablespace can be transported across different platforms?

  A. Both the source and target databases must use the same character set.
  B. The platforms of both the source and target databases must have the same endian format.
  C. The compatible parameter value must be the same in the source and target databases.
  D. The minimum compatibility level for both the source and target databases must be 10.0.0.
  E. The tablespace to be transported must be in read-only mode.
  A. Both the source and target databases must use the same character set.
  D. The minimum compatibility level for both the source and target databases must be 10.0.0.
  E. The tablespace to be transported must be in read-only mode.

  ---

  Reference: http://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces013.htm

• Question 129:

  Examine the RMAN commands executed in your database:

  RMAN>CONFIGURE DEFAULT DEVICE TYPE TO disk; RMAN>CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET; RKAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

  You issue the command: RMAN> BACKUP DATABASE;

  Which two statements are true about the command?

  A. It performs a log switch.
  B. It creates compressed backup sets by using binary compression by default.
  C. It backs up only the used blocks in data files.
  D. It backs up data files, the control file, and the server parameter file.
  E. It creates a backup of only the control file whenever the database undergoes a structural change.
  C. It backs up only the used blocks in data files.
  D. It backs up data files, the control file, and the server parameter file.

  ---

  C: RMAN backup sets automatically use unused block compression.

  D: If CONFIGURE CONTROLFILE AUTOBACKUP is ON (by default it is OFF), then RMAN automatically backs up the control file and server parameter file after every backup and after database structural changes.

  Not E: spfile is also backed up.

  References:

  http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta007.htm#i1015382

  http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup003.htm#i1009642

• Question 130:

  You execute the RMAN commands:

  RMAN> BACKUP VALIDATE DATABASE; RMAN> RECOVER CORRUPTION LIST;

  Which task is performed by these commands?

  A. Corrupted blocks, if any, are repaired in the backup created.
  B. Only those data files that have corrupted blocks are backed up.
  C. Corrupted blocks in the data files are checked and repaired before performing the database backup.
  D. The database is checked for physically corrupt blocks and any corrupted blocks are repaired.
  D. The database is checked for physically corrupt blocks and any corrupted blocks are repaired.

  ---

  Reference: http://www.dba-oracle.com/t_rman_36_validate_backup.htm