1Z0-067 Exam - Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP

NEW QUESTION 1
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 fre

Answer: ABD

Explanation: 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

NEW QUESTION 2
Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value? (Choose two.)

• A. The value of the LOG_CHECKPOINT_INTERVAL parameter overrides the value of the FAST_START_MTTR_TARGET parameter.
• B. The MTTR advisor is enabled only if the value is greater than the default value.
• C. Automatic checkpoint tuning is enabled.
• D. The time taken to recover an instance after a crash is always exactly the same as the value set for the FAST_START_MTTR_TARGET parameter.

Answer: AB

NEW QUESTION 3
Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.
How would you achieve this?

• A. by using the RMAN switch command to set the new location for the data files
• B. by using the RMAN duplicate command with no filename check to recover the database to the new host
• C. by using the RMAN duplicate command with dbid and set nekname for tablespace to recover the database to the new host
• D. by creating a new database in the new host, and then using the RMAN recover command

Answer: B

Explanation: Reference: https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmdupdb.htm#CHDGFABD

NEW QUESTION 4
Which two are prerequisites for creating a backup-based duplicate database?

• A. connecting to the target database and a recovery catalog to execute the duplicate command
• B. creating a password file for an auxiliary instance
• C. connecting to an auxiliary instance
• D. matching the database identifier (DBID) of the source database and the duplicate database
• E. creating an SPFILE for the target database

Answer: BC

Explanation: References:
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#CHDEDFFH

NEW QUESTION 5
You issue the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RKAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY; RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which three tasks are performed by the BACKUP DATABASE command?

• A. switching the online redo log file
• B. backing up all data files as image copies and archive log files, and deleting those archive log files
• C. backing up only the used blocks in the data files
• D. backing up all used and unused blocks in the data files
• E. backing up all archived log files and marking them as obsolete

Answer: ABD

NEW QUESTION 6
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 dat

Answer: CD

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

NEW QUESTION 7
Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)

• A. An unplugged PDB can be plugged into the same or another container database (CDB).
• B. PDB data files are automatically removed from disk.
• C. A PDB must have been opened at least once after creation.
• D. A PDB must be in closed state before it can be unplugged.
• E. A PDB must be in MOUNT state before it can be unplugge

Answer: ADE

NEW QUESTION 8
Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?

• A. The PDB is closed and the temp file is re-created automatically when the PDB is opened.
• B. The PDB is closed and requires media recovery at the PDB level.
• C. The PDB does not close and the temp file is re-created automatically whenever the containerdatabase (CDB) is opened.
• D. The PDB does not close and starts by using the default temporary tablespace defined for the CD

Answer: C

Explanation: If a temp file belonging to a PDB temporary tablespace is lost or damaged, and the user issuing the statement uses it, an error during the execution of SQL statements that require that temporary space for sorting occurs. ... The PDB can open with a missing temporary file. If any of the temporary files do not exist when the PDB is opened, they are automatically re-created. They are also automatically recreated at CDB startup.

NEW QUESTION 9
Identify three benefits of unified auditing.

• A. It helps to reduce disk space used to store an audit trail in a database.
• B. It guarantees zero-loss auditing.
• C. It reduces overhead on a database caused by auditing, by having a single audit trail.
• D. An audit trail cannot be modified because it is read-only.
• E. It automatically audits Recovery Manager (RMAN) event

Answer: CDE

NEW QUESTION 10
Your database instance is started using an SPFILE. You are connected to cdb$root, as a DB

• A. You issue:SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;Which two statements are true about the statistics level parameter?
• B. It is immediately set to all in the SPFILE and the CDB instance.
• C. It is immediately set to all in only those pluggable databases (PDBs) where the value is set to typical.
• D. It is immediately set to all only for cd3Sroot.
• E. It is immediately set to all in all PDBs where the statistics_level parameter is not set.
• F. It is set to all for all PDBs only in the SPFIL

Answer: AD

Explanation: When the STATISTICS_LEVEL parameter is modified by ALTER SYSTEM, all advisories or statistics are dynamically turned on or off, depending on the new value of STATISTICS_LEVEL. When modified by ALTER SESSION, the following advisories or statistics are turned on or off in the local session only.
Their system-wide state is not changed.

NEW QUESTION 11
LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory(OID).
SSL has been configure for the database and OLD and the password file has been configured for the database.
User scott with sysdba privilege tries to connect remotely using this command:
$sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name. Which authentication method will be attempted first?

• A. authentication by password file
• B. authentication by using certificates over SSL
• C. authentication by using the Oracle Internet Directory
• D. authentication by using the local OS of the database server

Answer: A

Explanation: If the database is configured to use a password file for remote authentication, Oracle Database checks the password file first. http://docs.oracle.com/cd/E25054_01/network.1111/e16543/authentication.htm

NEW QUESTION 12
Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests? (Choose three.)

• A. assigned to a class with rights to browse all directories and catalogs
• B. assigned to a class with rights to back up or restore Oracle database
• C. OSB encryption for data in transport and on tape
• D. RMAN preauthorization on the host
• E. matching the OS user identity of the Oracle instance associated with the database username
• F. scheduling of the RMAN backup to occur automatically at user-defined intervals

Answer: BDE

NEW QUESTION 13
You restore and recover your database to a new host by using an existing RMAN open database backup.
Which step must you perform next?

• A. Execute catproc.sqi to recompile invalid PL/SQL modules.
• B. Open the database with the resetlogs option.
• C. Set a new database identifier (DBID) for the newly restored database.
• D. Use the RMAN set newname and switch commands to switch to new file

Answer: B

NEW QUESTION 14
In which situation can you use Flashback Database?

• A. when undoing a shrink data file operation
• B. when retrieving a dropped tablespace
• C. when returning to a point in time before the restoration or re-creation of a control file
• D. when returning to a point in time before the most recent open resetlogs operation

Answer: D

Explanation: TO BEFORE RESETLOGS Returns the database to its state including all changes up to the SCN of the most recent OPEN RESETLOGS. Note: FLASHBACK DATABASE can only return the database to a point before the most recent OPEN RESETLOGS operation if your database has been upgraded to Oracle Database 10g Release 2 or later. http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm#RCMRF194

NEW QUESTION 15
Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined.
You execute this command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true?

• A. The minimum size for the standard buffer cache is 100 MB.
• B. The maximum size for the standard buffer cache is 100 MB.
• C. The minimum space guaranteed in the buffer cache for any server process is 100 MB.
• D. The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.
• E. The minimum size for all buffer caches is 100 M

Answer: A

Explanation: If SGA_TARGET is set: If the parameter is not specified, then the default is 0 (internally determined by the Oracle Database). If the parameter is specified, then the user-specified value indicates a minimum value for the memory pool.

NEW QUESTION 16
For which three pieces of information can you use the RMAN list command?

• A. stored scripts in the recovery catalog
• B. available archived redo log files
• C. backup sets and image copies that are obsolete
• D. backups of tablespaces
• E. backups that are marked obsolete according to the current retention policy

Answer: ABD

Explanation: About the LIST Command: The primary purpose of the LIST command is to list backup and copies. For example, you can list: -Backups and proxy copies of a database, tablespace, datafile, archived redo
log, or control file -Backups that have expired -Backups restricted by time, path name, device type, tag, or recoverability -Archived redo log files and disk copies http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmreprt.htm#BRADV89585

NEW QUESTION 17
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 owne

Answer: ADE

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