Oracle Oracle Certifications 1Z0-063 Questions & Answers

• Question 231:

  Which two statements are true about RMAN duplexed backups? (Choose two.)

  A. It is only supported for backups to tape via the media management interface.

  B. It is not supported for image copies.

  C. For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.

  D. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.

  E. Duplex backups can contain only data files and control files.

  Correct Answer: BD

• Question 232:

  Which three statements are true about automated maintenance tasks? (Choose three.)

  A. Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning Advisor.

  B. A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks.

  C. They run at predefined time intervals that are intended to occur during a period of low system loads.

  D. An Oracle Scheduler job is created for each maintenance tasks that is scheduled to run in a maintenance window.

  E. A maintenance window is automatically extended until all the maintenance tasks defined are completed.

  Correct Answer: ACD

• Question 233:

  Your database supports an online transaction processing (OLTP) workload and it needs to be up 24 x 7. You want to perform a complete database backup by using RMAN.

  Identify the minimum requirement for accomplishing the task.

  A. An RMAN channel must be configured to device-type disk.

  B. The database must be configured in ARCHIVELOG mode.

  C. Redo log groups must have at least two members each.

  D. All tablespaces in the database must be locally managed.

  Correct Answer: B

• Question 234:

  You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs), PDB1 and PDB2. You execute the following commands on CBD$ROOT as the SYS user:

  SQL> CREATE USER c##scott IDENTIFIED BY scottorcl1;

  SQL> GRANT CREATE SESSION TO c##scott;

  Which statement is true about the C##SCOTT user?

  A. It is created in all the PDBs with the CREATE SESSION privilege.

  B. It is created in all the PDBs but has the CREATE SESSION privilege only in CDB$ROOT.

  C. It is created and has the CREATE SESSION privilege only in a PDB that is open.

  D. It is created only in CDB$ROOT and has the CREATE SESSION privilege.

  Correct Answer: B

• Question 235:

  Which two statements are true about roles in multitenant container databases (CDBs)? (Choose two.)

  A. Local roles can be granted to local and common users.

  B. A common role can be granted only to a common user.

  C. A common user can create a local role by default in any pluggable database (PDB) that is plugged in to a CDB.

  D. A common role can be granted only system privileges.

  E. The root container can have both local and common roles.

  F. A local role can be assigned to a common role in a PDB.

  Correct Answer: AF

• Question 236:

  Which three conditions must be met before you Virtual Private Catalog (VPC) can be created and used by an Administrator? (Choose three.)

  A. A base recovery catalog must exist.

  B. The owner of the 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 must be granted to the virtual catalog owner.

  Correct Answer: ABE

• Question 237:

  Your database instance is abnormally terminated because of a power outage. At the next startup, from which point in the redo log does the recovery start?

  A. from the last complete checkpoint position

  B. from the beginning of the current redo log file until the instance failure

  C. from the last committed transaction

  D. from the beginning of the current redo log file to the checkpoint position

  E. from the most recent incremental checkpoint

  Correct Answer: E

• Question 238:

  Your database is running in ARCHIVELOG mode. You use RMAN to take image copies and you update these copies incrementally every six hours. After a regular maintenance task, when you attempt to restart the instance, it halts in MOUNT state with an error indicating that one of the data files belonging to the

  EXAMPLE tablespace is lost.

  You want to recover the data file as quickly as possible while maximizing availability for the database.

  Examine the possible steps involved in the recovery process:

  1.

  Mount the database.

  2.

  Take the data file offline.

  3.

  Bring the tablespace online.

  4.

  Use the RMAN SWITCH command to switch to the image copy.

  5.

  Recover the tablespace.

  6.

  Open the database.

  7.

  Use the RMAN RESTORE command to switch to the image copy.

  Identify the correct sequence of the required steps.

  A. 2, 6, 4, 5, 3

  B. 2, 4, 5, 3, 6

  C. 1, 2, 4, 6, 3

  D. 1, 2, 7, 5, 3, 6

  E. 2, 7, 5, 3

  Correct Answer: B

• Question 239:

  Examine the statements that use flashback technologies:

  1.

  FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP(`2013-02-04 09:30:00', `YYYY-MMDD 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 BETWEEM 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?

  A. 1, 2, 5

  B. 1, 3, 6

  C. 2, 3, 5, 6

  D. 3, 4, 5

  Correct Answer: A

• Question 240:

  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.

  Correct Answer: AE

  A: A CDB resource plan determines the amount of resources allocated to each PDB. A PDB resource plan determines how the resources allocated to a specific PDB are allocated to consumer groups within that PDB.

  Resource Manager allocates the resources in two steps:

  1.

  It allocates a portion of the system's resources to each PDB.

  2.

  In a specific PDB, it allocates a portion of system resources obtained in Step 1 to each session connected to the PDB.

  E: A PDB resource plan allocates resource among the consumer groups within a PDB.

  References: https://docs.oracle.com/database/121/ADMIN/cdb_dbrm.htm