Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 241:

  Which three conditions must be true for unused block compression to be used automatically while performing backups by using RMAN?

  A. The compatible initialization parameter is set to 10.2 or higher.
  B. There are no guaranteed restore points defined for the database.
  C. The default device for the backup must be set to disk.
  D. The tablespaces are locally managed.
  E. The fast recovery area is less than 50 percent free.
  A. The compatible initialization parameter is set to 10.2 or higher.
  B. There are no guaranteed restore points defined for the database.
  D. The tablespaces are locally managed.

  ---

  About Unused Block Compression When employing unused block compression, RMAN skips reading, and backing up, any database blocks that are not currently allocated to some database object. This is regardless of whether those blocks had previously been allocated. So if a database table is dropped, RMAN will not back up the space that was occupied by that table until new objects are created in that space. Unused block compression is used automatically when the following conditions are true: -The COMPATIBLE initialization parameter is set to 10.2 or higher. -There are currently no guaranteed restore points defined for the database. -The data file is locally managed. -The data file is being backed up to a backup set as part of a full backup or a level 0 incremental backup. -The backup set is created on disk, or Oracle Secure Backup is the media manager. References: http://docs.oracle.com/database/121/BRADV/rcmcncpt.htm#BRADV89481

• Question 242:

  Your database is running in archivelog mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost.

  Examine the steps to restore the SPFILE and the control file to mount the database:

  1.

  Set DBID of the target database in RMAN.

  2.

  Start the database instance by using the STARTUP FORCE NOMOUNT command in RMAN.

  3.

  Restore the control files from the backup.

  4.

  Mount the database.

  5.

  Restore the SPFILE from the autobackup.

  6.

  Create a PFILE from the recovered SPFILE.

  7.

  Restart the instance in NOMOUNT state.

  Identify the required steps in the correct order.

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

• Question 243:

  You are administering a multitenant container database (CDB) that has no startup triggers and contains three pluggable databases (PDBs). You execute the command to start up the CDB: SQL>STARTUP

  Which statement is true?

  A. CDB$ROOT, PDB$SEED, and the PDBs are opened in read/write mode
  B. CDB$ROOT is opened in read/write mode, PDB$SEED in read-only mode, and the PDBs in MOUNT state
  C. CDB$ROOT and PDB$SEED are opened in read-only mode, but the PDBs are in closed mode
  D. CDB$ROOT, PDB$SEED, and the PDBs are opened in read-only mode
  E. CDB$ROOT is opened in read/write mode, but PDB$SEED and the PDBs are in closed mode
  B. CDB$ROOT is opened in read/write mode, PDB$SEED in read-only mode, and the PDBs in MOUNT state

• Question 244:

  Which two statements describe the relationship between a window, a resource plan, and a job class?

  A. A window specifies a resource plan that will be activated when that window becomes active.
  B. A window specifies a job class that will be activated when that window becomes active.
  C. A job class specifies a window that will be open when that job class becomes active.
  D. A window in association with a resource plan controls a job class allocation.
  E. A window in association with a job class controls a resource allocation.
  A. A window specifies a resource plan that will be activated when that window becomes active.
  E. A window in association with a job class controls a resource allocation.

  ---

  Windows work with job classes to control resource allocation. Each window specifies the resource plan to activate when the window opens (becomes active), and each job class specifies a resource consumer group or specifies a database service, which can map to a consumer group. A job that runs within a window, therefore, has resources allocated to it according to the consumer group of its job class and the resource plan of the window. Reference: http://docs.oracle.com/database/121/ADMIN/schedover.htm#ADMIN12366

• Question 245:

  Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)

  A. It can be used to allow the access privilege settings for users but not roles.
  B. It can be used to allow the access privilege settings for users as well as roles.
  C. It can be used to control the time interval for which the access privilege is available to a user.
  D. It can be used to selectively restrict the access for each user in a database to different host computers.
  E. It can be used to selectively restrict a user's access to different applications in a specific host computer.
  B. It can be used to allow the access privilege settings for users as well as roles.
  C. It can be used to control the time interval for which the access privilege is available to a user.
  D. It can be used to selectively restrict the access for each user in a database to different host computers.

• Question 246:

  A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance?

  A. Set the backup_tape_io_slaves parameter to true.
  B. Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.
  C. Configure large pool if not already done.
  D. Remove the rate parameter, if specified, in the allocate channel command.
  E. Always use RMAN compression for tape backups rather than the compression provided by media manager.
  F. Always use synchronous I/O for the database.
  B. Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.
  C. Configure large pool if not already done.
  D. Remove the rate parameter, if specified, in the allocate channel command.

  ---

  Tuning RMAN Backup Performance: Procedure Many factors can affect backup performance. Often, finding the solution to a slow backup is a process of trial and error. To get the best performance for a backup, follow the suggested steps in this section: Step 1: Remove RATE Parameters from Configured and Allocated Channels Step 2: If You Use Synchronous Disk I/O, Set DBWR_IO_SLAVES Step 3: If You Fail to Allocate Shared Memory, Set LARGE_POOL_SIZE Step 4: Tune RMAN Tape Streaming Performance Bottlenecks Step 5: Query V$ Views to Identify Bottlenecks Reference:https://docs.oracle.com/database/121/BRADV/rcmtunin.htm#BRADV172

• Question 247:

  Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

  A. A base recovery catalog should exist.
  B. The owner of VPC cannot own recovery catalog.
  C. At least one target database should be registered in the recovery catalog.
  D. The register database privilege should be granted to the virtual catalog owner.
  E. The DBA role should be granted to the virtual catalog owner.
  A. A base recovery catalog should exist.
  D. The register database privilege should be granted to the virtual catalog owner.
  E. The DBA role should be granted to the virtual catalog owner.

• Question 248:

  After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:

  SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE

  SQL> EXEC DBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)

  PL/SQL procedure successfully completed.

  SQL> select number_value from redaction_values_for_type_full;

  NUMBER VALUE

  After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.

  What must you do to activate the new default value for numeric full redaction?

  A. Re-enable redaction policies that use FULL data redaction.
  B. Re-create redaction policies that use FULL data redaction.
  C. Re-connect the sessions that access objects with redaction policies defined on them.
  D. Flush the shared pool.
  E. Restart the database instance.
  E. Restart the database instance.

  ---

  About Altering the Default Full Data Redaction Value You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value. The modification applies to all of the Data Redaction policies in the current database instance. After you modify a value, you must restart the database for it to take effect.

• Question 249:

  Which three types of failures are detected by the Data Recovery Advisor (DRA)?

  A. loss of a non-critical data file
  B. loss of a control file
  C. physical data block corruption
  D. logical data block corruption
  E. loss of an archived redo log file
  B. loss of a control file
  C. physical data block corruption
  D. logical data block corruption

  ---

  Reference: https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmrepai.htm#BRADV89716

• Question 250:

  Which three statements are true about Consolidated Database Replay?

  A. The workload capture and replay systems must have the same operating system (OS).
  B. Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB).
  C. A subset of the captured workload can be replayed.
  D. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.
  E. Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.
  B. Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB).
  C. A subset of the captured workload can be replayed.
  E. Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.

  ---

  These capture files are platform independent and can be transported to another system. You can use Consolidated Database Replay to combine the captured workloads from the three applications and replay them concurrently on PDBs. References: https://docs.oracle.com/database/121/RATUG/GUID-36DE5567-5A64-493B-A154-6581C678FC8A.htm#RATUG105 https://docs.oracle.com/database/121/RATUG/GUID-42958859-005D-4B93-9DD3-79807968EA9E.htm#RATUG4199 https://docs.oracle.com/database/121/RATUG/GUID-C4DC0795-74B2-456D-AA0A-B4F7F45C81F8.htm https://docs.oracle.com/database/121/RATUG/GUID-B1AEA82F-60E5-43CE-BB12-C6D72232886A.htm