Oracle Oracle Certifications 1Z0-067 Questions & Answers

• Question 111:

  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.

  Correct Answer: ADE

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

• Question 112:

  Examine the output:

  SQL > ARCHIVE LOGLIST

  Database log mode Archive Mode Automatic archival Enabled Archive Destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 376 Next log sequence to archive 378 Current log sequence 378

  Which three types of files are automatically placed in the fast recovery area?

  A. Flashback data archives (FDA)

  B. Archived redo log files

  C. Control file autobackups

  D. Server parameter file (SPFILE)

  E. Recovery Manager (RMAN) backup pieces

  Correct Answer: BCE

  References: http://docs.oracle.com/cd/E11882_01/backup.112/e10642/glossary.htm#BRADV526

• Question 113:

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

  A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

  B. In a PDB plan, subplans may be used with up to eight consumer groups.

  C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.

  D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.

  E. If a PDB plan is enabled for a pluggable database, then 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: Setting a PDB resource plan is optional. If not specified, all sessions within the PDB are treated equally. In a non-CDB database, workloads within a database are managed with resource plans. In a PDB, workloads are also managed with resource plans, also called PDB resource plans. The functionality is similar except for the following differences: Non-CDB Database Multi-level resource plans Up to 32 consumer groups Subplans PDB Database Single-level resource plans only Up to 8 consumer groups (Not B) No subplans

• Question 114:

  Which three statements are true about compression of backup sets?

  A. Compressed backups can only be written to media.

  B. Binary compression creates performance overhead during a backup operation.

  C. Unused blocks below the high-water mark are not backed up.

  D. Compressed backups cannot have section size defined during a backup operation

  E. It works only for locally managed tablespaces.

  Correct Answer: BCE

  "RMAN also skips other datafile blocks that do not currently contain data, if all of the following conditions apply: The COMPATIBLE initialization parameter is set to 10.2 There are currently no guaranteed restore points defined for the database The datafile is locally managed The datafile is being backed up to a backup set as part of a full backup or a level 0 incremental backup The backup set is being created on disk. References: https://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta009.htm#i1015382

• Question 115:

  Which three statements are true about the database instance startup after an instance failure?

  A. The RECO process recovers the uncommitted transactions at the next instance startup.

  B. Online redo log files and archived redo log files are required to complete the rollback stage of instance recovery.

  C. Uncommitted changes are rolled back to ensure transactional consistency.

  D. The SMON process automatically performs the database recovery.

  E. Media recovery is required to complete the database recovery.

  F. Changes committed before the failure, which were not written to the data files, are re-applied.

  Correct Answer: CDF

• Question 116:

  You are administering a multitenant container database (CDB) cdb1 that has multiple pluggable databases

  (PDBs). As the sys user on cdb$root, you execute the commands:

  SQL> CREATE USER C##ADMIN IDENTIFIED BY orc1123;

  SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL;

  SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;

  Which two statements are true about the c##admin user that is created in all PDBs?

  A. It can create only local users in all the PDBs.

  B. It has a common schema for all the PDBs.

  C. It can create common users only when it is logged in to the CDB.

  D. It can create only local users in the CDB.

  E. It can be granted only common roles in the PDBs.

  Correct Answer: BC

• Question 117:

  View the SPFILE parameter settings in the Exhibit.

  

  You issue this command and get errors: SQL> startup ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET dueto existing internalsettings,seealertlog for moreinformation

  Why did the instance fail to start?

  A. because pga_aggregate_target is not set

  B. because statistics_level is set to basic

  C. because memory_target and memory_max_target cannot be equal

  D. because sga_target and memory_target are both set

  Correct Answer: B

  SQL> startup nomount ORA-01078: failure in processing system parameters ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET SQL>

• Question 118:

  Examine the RMAN command:

  RMAN> BACKUP VALIDATE DATABASE;

  Which statement is true about the execution of the command?

  A. Block change tracking must be enabled before executing this command.

  B. The database must be running in archivelog mode for the successful execution of this command.

  C. A complete database backup must exist before executing this command.

  D. The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header.

  E. The command checks for blocks that contain a valid checksum and matching headers and footers, but that has logically inconsistent contents.

  Correct Answer: D

• Question 119:

  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 recovery_catalog_owner role should be granted to the virtual catalog owner.

  Correct Answer: ADE

  References: http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta013.htm

• Question 120:

  Which two statements are true regarding SecureFile lobs?

  A. The amount of undo retained is user controlled.

  B. They can be used only for nonpartitioned tables.

  C. Fragmentation is minimized by using variable-sized chunks.

  D. They support random reads and writes of encrypted LOB data.

  Correct Answer: CD

  References: http://docs.oracle.com/cd/E11882_01/appdev.112/e18294/adlob_smart.htm#ADLOB46