Updated Free Oracle 1z0-063 Test Engine Questions with 278 Q&As [Q116-Q141]

Updated Free Oracle 1z0-063 Test Engine Questions with 278 Q&As

The Best 12c 1z0-063 Professional Exam Questions

More Info

For more info visit: Oracle 12c Official 1Z0-063 Exam Reference

What Is 1Z0-063 Exam?

Also known as the Oracle Database 12c: Advanced Administration, 1Z0-063 is intended for the candidates with the working knowledge of Oracle Database 12c including Cloud computing strategies as well as how to backup, develop, and deploy them. Thus, this certification test is designed to validate that the student has the technical skills and expertise to manage and accomplish the implementation of enterprise databases. The test consists of questions that are multiple-choice. The total number of questions asked in this exam is 80, and the candidates are expected to answer all of them within the allocated time, which is 2 hours. The passing score for this exam is 60%. Any person who gets less than 60% doesn’t qualify for this Oracle certificate. According to the Oracle exam policy, such candidates may retake the test after 14 days starting from the day of failing the exam.

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

• A. The unplugged PDB becomes a non-CDB.
• B. The unplugged PDB can be plugged into another CDB.
• C. The unplugged PDB can be plugged into the same multitenant container database (CDB)
• D. The PDB must be dosed.
• E. The PDB must be open in read only mode.
• F. The PDB data files are automatically removed from disk.

Answer: B,C,D

Explanation:
B (not A): The PDB must be closed before unplugging it.
D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode information in an endianness-sensitive way. There is no supported way to handle the conversion of such columns automatically. This means, quite simply, that an unplugged PDB cannot be moved across an endianness difference.
E (not F): To exploit the new unplug/plug paradigm for patching the Oracle version most effectively, the source and destination CDBs should share a filesystem so that the PDB's datafiles can remain in place.
Reference:
Oracle White Paper, Oracle Multitenant

 

NEW QUESTION 117
You are administering a multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode and contains pluggable databases (PDBs), PDB_1 and PDB_2.
While opening PDB_1, you get an error:
SQL> alter pluggable database pdb_1 open;
ORA-01157: cannot identify/lock data file 11 - see DBWR trace file
ORA-01110: data file 11: '/u01/app/oracle/oradata/cdb1/pdb_1/example01.dbf' To repair the failure, you open an RMAN session for the target database CDB$ROOT. You execute the following as the first command:
RMAN> REPAIR FAILURE;
Which statement describes the consequence of the command?

• A. The command performs the recovery and closes the failure.
• B. The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command.
• C. The command executes successfully, performs recovery, and opens PDB_1.
• D. The command produces an error because RMAN is not connected to the target database PDB_1.

Answer: B

 

NEW QUESTION 118
Which two options can be configured for an existing database by using the Database Configuration
Assistant (DBCA)? (Choose two.)

• A. Database Vault in ORACLE_HOME
• B. Oracle Suggested Backup Strategy
• C. Database Resident Connection Pooling
• D. Configure Label Security
• E. Non default block size tablespaces

Answer: A,D

 

NEW QUESTION 119
Which two statements are true about making RMAN image copies of a database? (Choose two.)

• A. They can be made only when the database is running in ARCHIVELOGmode.
• B. They can be made only when the database is running in NOARCHIVELOGmode.
• C. They consist of all used and unused blocks in the data files.
• D. They can be made only when the database is in MOUNTstate.
• E. They can only be written to disk.

Answer: C,E

Explanation:
An image copy can be written only to disk.
An image copy is the same as datafiles. The disadvantage of image copy backup mode is that it occupies much space and does not skip unused data blocks.
References: http://www.dba-oracle.com/t_rman_10_image_copies.htm

 

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

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

Answer: A,C,E

Explanation:
A: To unplug a PDB, you first close it.
E: You can disassociate or unplug a PDB from a CDB and reassociate or plug the PDB into the same CDB or into another CDB.
Incorrect Answers:
C: The PDB must be in a closed stated, not in a mounted state when unplugging it.
D: The unplugging operation makes changes in the PDB data files to record that the PDB was properly and successfully unplugged. Because the PDB is still part of the CDB, you can back it up in Oracle Recovery Manager (Oracle RMAN).
References: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/pdb/pdb_unplug_plug/ pdb_unplug_plug.html

 

NEW QUESTION 121
Which two statements are true regarding Oracle Data Pump? (Choose two.)

• A. EXPDP and IMPDP are the client components of Oracle Data Pump.
• B. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
• C. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.
• D. Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.
• E. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

Answer: A,B

Explanation:
Reference:
http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm

 

NEW QUESTION 122
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. 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.
• C. If no PDB plan is enabled for a pluggable database, the PDB uses the CDB plan.
• D. 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.
• E. To enable a resource plan for a PDB, a CDB resource plan must be created and enabled.

Answer: A,D

Explanation:
Explanation
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:
E: A PDB resource plan allocates resource among the consumer groups within a PDB.
https://docs.oracle.com/database/121/ADMIN/cdb_dbrm.htm

 

NEW QUESTION 123
Which three RMAN persistent settings can be set for a database?

• A. backup retention policy
• B. default backup device type
• C. default destinations for backups
• D. multiple backup device types for a single backup
• E. default section size for backups

Answer: A,B,C

Explanation:
Explanation/Reference:
Explanation:
Reference:
http://docs.oracle.com/cd/B19306_01/backup.102/b14192/setup004.htm#i1019739

 

NEW QUESTION 124
You take your database backups by using the RMAN media management interface (MMI).
Which two are true about the use of the RMAN MMI? (Choose two.)

• A. You can use it to create image copies for entire file systems.
• B. You can use it to create backup sets for database files.
• C. You can use it to create proxy copies for entire file systems.
• D. You can use it to create proxy copies for database files.
• E. You can use it to create image copies for database files.

Answer: B,E

 

NEW QUESTION 125
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

• A. SQL profile recommendations
• B. SQL statement restructure recommendations
• C. creation of materialized views to improve query performance
• D. statistics recommendations

Answer: A

Explanation:
Explanation/Reference:

 

NEW QUESTION 126
Which Oracle Database component is audited by default if the Unified Auditing option is enabled?

• A. Oracle Recovery Manager (RMAN)
• B. Oracle Label Security
• C. Oracle Database Vault
• D. Oracle Data Pump
• E. Oracle Real Application Security

Answer: A

 

NEW QUESTION 127
Which two components are contained only in CDB$ROOT? (Choose two.)

• A. database links between PDBs in the CDB
• B. resource manager plans for each PDB in the CDB
• C. the unified audit trail
• D. the default TEMPtablespace for the entire CDB
• E. PDB service names

Answer: D,E

Explanation:
Explanation/Reference:
Reference https://docs.oracle.com/database/121/CNCPT/cdblogic.htm#CNCPT89268

 

NEW QUESTION 128
Examine the following set of RMAN commands:

Which statement is true about the RMAN run block execution?

• A. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the
  RMAN RUNblock.
• B. The new channel, CH1, is ignored because a channel has been configured already.
• C. The execution of the script fails because multiple channels cannot exist simultaneously.
• D. The script is executed and both DC1and CH1channels are used for script execution.

Answer: A

 

NEW QUESTION 129
You want to create a duplicate database DUP_DB from your production database PRODon the same host.
The PRODdatabase uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog.
You create an auxiliary instance and want to execute the command:

What is a prerequisite for the successful execution of this command?

• A. Flashback must be enabled for the PRODdatabase.
• B. A most recent backup set of the PRODdatabase must exist.
• C. The target database must be in MOUNTstate.
• D. RMAN must be connected to the target database instance and the auxiliary instance.

Answer: D

Explanation:
Explanation/Reference:
Explanation:
Assume that the source database prod is on host1 and stores its data files in a non-ASM file system. The control files for prod are located in /oracle/oradata/prod/.
You want to duplicate the source database to database dupdb on remote host host2.
You want to store the duplicate database files in ASM disk group +DISK1.
After connecting RMAN to the target, duplicate, and recovery catalog databases, run the following RMAN script to duplicate the database.
DUPLICATE TARGET DATABASE TO dupdb
FROM ACTIVE DATABASE
SPFILE
PARAMETER_VALUE_CONVERT '/oracle/oradata/prod/', '+DISK1'
SET DB_CREATE_FILE_DEST +DISK1;
When the DUPLICATE command completes, the duplicate database is created, with data files, online redo log files, and control files in ASM disk group +DISK1.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2017), page
26-7

 

NEW QUESTION 130
You accidentally drop the CUSTOMERStable, and then recover it by using the FLASHBACK TABLE command.
Which two statements are true about the dependent objects of the CUSTOMERS table?

• A. All the constraints defined on the table, except the referential integrity constraints, are flashed back.
• B. Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.
• C. All the triggers associated with the table are flashed back but are disabled.
• D. Materialized views that use the CUSTOMERS table are flashed back.
• E. LOB segments associated with the CUSTOMERStable are flashed back.

Answer: A,E

Explanation:
Explanation/Reference:
B: Oracle Database retrieves all indexes defined on the table except for bitmap join indexes, and all triggers and constraints defined on the table except for referential integrity constraints that reference other tables.
Incorrect Answers:
A: Flashback Table restores tables while automatically maintaining associated attributes such as current indexes, triggers, and constraints, and in this way enabling you to avoid finding and restoring database- specific properties.
Furthermore. indexes on table that exist currently are reverted and reflect the state of the table at the Flashback point.
C: By default, the database disables triggers on the affected table before performing a FLASHBACK TABLE operation. After the operation, the database returns the triggers to the state they were in before the operation (enabled or disabled). To keep triggers enabled during the flashback of the table, add an ENABLE TRIGGERS clause to the FLASHBACK TABLE
D: Flashback Table operations are not valid for the following type objects: tables that are part of a cluster, materialized views, Advanced Queuing (AQ) tables, static data dictionary tables, system tables, remote tables, object tables, nested tables, or individual table partitions or subpartitions.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2017), page
18-11

 

NEW QUESTION 131
You create a default Flashback Data Archive FLA1 and enable it for the EMPLOYEES table in the HR schema.
After a few days, you want to alter the EMPLOYEES table by executing the command:
SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);
Which statement is true about the execution of the command?

• A. It executes successfully and continues to store metadata related to the EMPLOYEES table.
• B. It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive.
• C. It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table.
• D. It executes successfully and all metadata related to the EMPLOYEES table before altering the table definition is purged from Flashback Data Archive.

Answer: A

 

NEW QUESTION 132
You want to create a guaranteed restore point for your database by executing the command:
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command.

• A. Flashback Database must be enabled.
• B. A database backup must be taken.
• C. The database must be running in archivelog mode.
• D. Undo retention guarantee must be enabled.
• E. Fast Recovery Area must be enabled.
• F. The recyclebin must be enabled for the database.

Answer: C,E

Explanation:
Reference:http://docs.oracle.com/cd/B19306_01/backup.102/b14192/rpfbdb002.htm

 

NEW QUESTION 133
You want to create a guaranteed restore point for your database by executing the command:
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command. (Choose two.)

• A. Flashback Database must be enabled.
• B. A database backup must be taken.
• C. Undo retention guarantee must be enabled.
• D. Fast Recovery Area must be enabled.
• E. The recyclebin must be enabled for the database.
• F. The database must be running in ARCHIVELOG mode.

Answer: D,F

 

NEW QUESTION 134
Examine the command to duplicate a database:
RMAN> DUPLICATE TARGET DATABASE TO cdb
PLUGGABLE DATABASE pdb1, pdb5;
Which two statements are true about the DUPLICATEcommand? (Choose two.)

• A. A backup of pdb1and pdb5must exist before executing the command.
• B. The DUPLICATEcommand first creates a backup, and then duplicates the PDBs by using the backup.
• C. The SPFILE is copied along with the data files of the pluggable databases (PDBs).
• D. The root and the seed database in the container database (CDB) are also duplicated.
• E. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE
  set to TRUE.

Answer: A,E

 

NEW QUESTION 135
You execute the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2;
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/disk1/%U;
RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/disk2/%U;
RMAN> BACKUP DATABASE;
Which statement is true about the backup set created by the BACKUPcommand?

• A. Two channels are allocated and backup pieces for the backup set are created in both the specified destinations.
• B. The default channel is allocated and the backup set is created in only one destination.
• C. Two channels are allocated and two copies of the backup set are taken in parallel in both locations.
• D. Two channels are allocated and a copy of the backup set is taken in the location specified by CHANNEL 2.

Answer: A

 

NEW QUESTION 136
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. All database listeners running from the database home are automatically added to the Oracle Restart configuration.
• B. 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.
• C. Both orcl1 and orcl2 are automatically added to the Oracle Restart configuration.
• D. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.
• E. The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restart configuration.

Answer: D,E

Explanation:
Explanation
https://docs.oracle.com/cd/E18283_01/server.112/e17120/restart001.htm

 

NEW QUESTION 137
user_data is a nonencryptedtablespace containing tables with data.
You must encrypt ail data in this tablespace.
Which three methods can do this?

• A. Use altertablespace to encrypt thetablespace.
• B. Use CREATE TABLE AS SELECT
• C. Use ALTERTABLE. . .MOVE
• D. Use Data Pump.
• E. Use alter tablespace to encrypt the tablespace after enabling row movement on all its

Answer: B,C,D

 

NEW QUESTION 138
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?
(Choose three.)

• A. A DBA can check specific tables with the DMU
• B. The DMU can report columns that are not represented in the converted characterset
• C. The DMU can report columns that are too long in the converted characterset
• D. The database to be migrated must be opened read-only.
• E. The release of the database to be converted can be any release since 9.2.0.8.

Answer: A,B,C

Explanation:
Explanation
A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps of the migration process.
D: Exceed column limit
The cell data will not fit into a column after conversion.
E: Need conversion
The cell data needs to be converted, because its binary representation in the target character set is different than the representation in the current character set, but neither length limit issues nor invalid representation issues have been found.

 

NEW QUESTION 139
Examine the command and its output:
SQL> DROP TABLE EMPLOYEE;
SQL> SELECT object_name AS recycle_name, original_name, type
FROM recyclebin; RECYCLE_NAMEORIGINAL_NAMETYPE
binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE
You then successfully execute the command:
SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP; Which two statements are true? (Choose two.)

• A. It automatically flashes back any triggers defined on the table.
• B. It flashes back only the structure of the table and not the data.
• C. It automatically flashes back all the indexes on the employees table.
• D. It flashes back the data from the recycle bin and the existing data in the original table is permanently lost.
• E. It flashes back the employee table and all the constraints associated with the table.

Answer: A,E

 

NEW QUESTION 140
Examine the commands executed to monitor database operations:
$> conn sys/oracle@prod as sysdba
SQL> VAR eid NUMBER
SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION
('batch_job',FORCED_TRACKING=>'Y');
Which two statements are true? (Choose two.)

• A. Only DML and DDL statements will be monitored for the session.
• B. Database operations will be monitored only when they consume a significant amount of resource.
• C. All subsequent statements in the session will be treated as one database operation and will be monitored.
• D. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
• E. Database operations for all sessions will be monitored.

Answer: C,D

Explanation:
C: Setting the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter to DIAGNOSTIC
+TUNING (default) enables monitoring of database operations. Real-Time SQL Monitoring is a feature of the Oracle Database Tuning Pack.
Note:
* The DBMS_SQL_MONITOR package provides information about Real-time SQL Monitoring and Real-time Database Operation Monitoring.
*(not B) BEGIN_OPERATION Function starts a composite database operation in the current session.
/ (E) FORCE_TRACKING - forces the composite database operation to be tracked when the operation starts.
You can also use the string variable 'Y'.
/ (not A) NO_FORCE_TRACKING - the operation will be tracked only when it has consumed at least 5 seconds of CPU or I/O time. You can also use the string variable 'N'.

 

NEW QUESTION 141
......

Try 100% Updated 1z0-063 Exam Questions [2022]: https://www.itexamsimulator.com/1z0-063-brain-dumps.html