Oracle 1Z0-063 Online Practice Questions and Exam Preparation

Oracle 1Z0-063 Online Questions & Answers

• Question 111:

  Your multitenant container database (CDB) cdb1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:

  SQL> STARTUP

  Which two statements are true about the successful execution of the command? (Choose two.)

  A. All redo log files are opened.
  B. The root, the seed, and all the PDBs are opened in read-write mode.
  C. All the PDBs are opened in read-write mode.
  D. All the PDBs are in closed state.
  E. Only the root database is opened in read-write mode.
  A. All redo log files are opened.
  E. Only the root database is opened in read-write mode.

• Question 112:

  You wish to enable an audit policy for all database users, except sys, system, and scott. You issue the following statements:

  SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;

  For which database users is the audit policy now active?

  A. all users except sys
  B. all users except scott
  C. all users except sys and scott
  D. all users except sys, system, and scott
  B. all users except scott

• Question 113:

  You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both have their instances running. Which two statements are true? (Choose two.)

  A. Both orcl1 and orcl2 are automatically added to the Oracle Restart configuration.
  B. All database listeners running from the database home are automatically added to the Oracle Restart configuration.
  C. The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restart configuration.
  D. The crsct1 start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete.
  E. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.
  C. The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restart configuration.
  E. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.

• Question 114:

  You need to perform a block media recovery on the tools01.dbf data file in your database by using Recovery Manager (RMAN). Which two are prerequisites for performing this operation? (Choose two.)

  A. You must configure a block change tracking file.
  B. You must use an incremental level-1 backup to restore blocks.
  C. You must ensure that the database is mounted or open.
  D. You must have full or level-0 backups to restore blocks.
  E. You must take the tools01.dbf data file offline.
  C. You must ensure that the database is mounted or open.
  D. You must have full or level-0 backups to restore blocks.

• Question 115:

  You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively.

  From the tablespace space usage metrics, you find that the space usage has reached the specified warning threshold value, but no alerts have been generated.

  What could be the reason for this?

  A. The event parameter was not set.
  B. The sql_trace parameter is set to false.
  C. Enterprise Manager was not used.
  D. The statistics_level parameter is set to basic.
  E. The timed_statistics parameter is set to false.
  D. The statistics_level parameter is set to basic.

• Question 116:

  You execute the RMAN commands:

  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk; RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 2; RMAN> BACKUP DATABASE;

  Which two statements are true? (Choose two.)

  A. One channel is allocated.
  B. Two channels are allocated.
  C. The backup set is created in parallel in two locations.
  D. The backup set is created in parallel only in one location.
  E. The backup set is created serially in only one location.
  B. Two channels are allocated.
  C. The backup set is created in parallel in two locations.

• Question 117:

  Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? (Choose two.)

  A. Reduced logical I/O
  B. Reduced virtual memory utilization
  C. Improved Serial Execution performance
  D. Reduced physical I/O
  E. Reduced CPU utilization
  B. Reduced virtual memory utilization
  E. Reduced CPU utilization

• Question 118:

  Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.)

  A. If no PDB plan is enabled for a pluggable database, all sessions for that PDB are treated to an equal share of resources.
  B. To enable a resource plan for a PDB, a CDB resource plan must be created and enabled.
  C. If a PDB plan is enabled for a pluggable database, Resource Manager uses the resource allocation at the PDB level and ignores the limits set at the CDB level.
  D. If no PDB plan is enabled for a pluggable database, the PDB uses the CDB plan.
  E. If a PDB plan is enabled for a pluggable database, resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
  A. If no PDB plan is enabled for a pluggable database, all sessions for that PDB are treated to an equal share of resources.
  E. If a PDB plan is enabled for a pluggable database, resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

• Question 119:

  Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?

  A. configuration of unified auditing mode
  B. execution of SQL statements by users connected with the SYSDBA privilege
  C. usage of the AUDIT statement
  D. creation of a fine grained audit policy
  C. usage of the AUDIT statement

• Question 120:

  One of your databases supports a data warehousing workload and is in NOARCHIVELOG mode. You perform RMAN level 0 backup on Sundays and level 1 incremental backups on other days.

  One data file is corrupt and the current online redo log is missing due to media failure.

  Which four actions must you take for recovery? (Choose four.)

  A. Restore the missing data file.
  B. Recover the database by using RECOVER DATABASE NOREDO;
  C. Recover the database by using RECOVER DATABASE;
  D. Restore the control file.
  E. Open the database by using the RESETLOGS option.
  F. Recover the corrupt file by using RECOVER DATAFILE.
  G. Restore all data files.
  B. Recover the database by using RECOVER DATABASE NOREDO;
  D. Restore the control file.
  E. Open the database by using the RESETLOGS option.
  G. Restore all data files.