Pass 1z0-063 Exam in First Attempt Guaranteed 2021 Dumps!
1z0-063 Dumps Full Questions - Exam Study Guide
The Oracle 1Z0-063 exam is a globally recognized qualifying test for the Oracle Database 12c Administrator Certified Professional certificate for the most highly skilled and experienced database specialists who already have the Oracle Database 12c Administrator Certified Associate certification.
Oracle 1z0-063 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
| Topic 10 |
|
| Topic 11 |
|
| Topic 12 |
|
Preparation Resources
Indeed, Oracle is focused on supporting each candidate and fostering his or her growth and quality training. This is why the official vendor recommends two optional courses to help the students prepare for the Oracle 1Z0-063 test:
- At the same time, Oracle Database 12c: Managing Multitenant Architecture course will equip candidates with the relevant expertise to successfully pass 1Z0-063 exam by utilizing multitenant architecture. During this class, administrators and architects will discover why and how to create and manage a container database that is multitenant and how to deal with databases that are commonly pluggable, how to manage storage and security, and moreover, how to execute certain operations such as the transportation of Oracle Data Pump including encryption, loading, and auditing. These and other topics regarding managing Multitenant Architecture will be available when you sign up for the Live Virtual Class, which will ultimately aid in passing the Oracle 1Z0-063 test on the first try.
- Oracle Database 12c: Backup and Recovery Workshop designed both for administrators and for everyone who wants to evaluate their own recovery skills. During virtual classes, you will get to know how to use Oracle Database recovery procedures and Flashback Technologies along with ways of diagnosing and fixing data failures. Moreover, through this real-time training, each candidate will gain a clear understanding of Oracle Database Cloud Service and learn how to optimize database workloads using backup and recovery procedures. In the end, the knowledge gained in this workshop will guarantee you a fast, reliable, secure, and easy increase in your Oracle database administration performance.
NEW QUESTION 165
A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance? (Choose three.)
- A. Always use synchronous I/O for the database.
- B. Always use RMAN compression for tape backups rather than the compression provided by media manager.
- C. Configure large pool if not already done.
- D. Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.
- E. Set the backup_tape_io_slaves parameter to true.
- F. Remove the rate parameter, if specified, in the allocate channel command.
Answer: C,D,F
Explanation:
Reference:
http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmtunin.htm
NEW QUESTION 166
Your multitenant container database (CDB) CDB1 has two pluggable databases, PDB1 and PDB2. The local net service name CDB1 connects to the root database, and the service names PDB1 and PDB2 connect to the pluggable databases (PDBs), PDB1 and PDB2, respectively.
Examine the commands to change the value of the PDB modifiable initialization parameter:
Which statement is true about the OPTIMIZER_USE_SQL_PLAN_BASELINES parameter?
- A. It gives an error because it cannot be set for the root database.
- B. It is set to TRUE for the root database and all the PDBS, but is effective only when the CDB is restarted and the PDBs are reopened.
- C. It is set to TRUE for the root database and the pluggable database PDBs, because values can be set for this parameter at the PDB level in a PDB.
- D. It is set to TRUE for the root database and all the PDBs, because the value set at the root level has higher precedence.
Answer: C
NEW QUESTION 167
Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler? (Choose three.)
- A. A job is specified as part of a program definition.
- B. A program and window can be specified as part of a job definition.
- C. A program and job can be specified as part of a schedule definition.
- D. A program can be used in the definition of multiple jobs.
- E. A program and schedule can be specified as part of a job definition.
Answer: B,D,E
NEW QUESTION 168
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. A maintenance window is automatically extended until all the maintenance tasks defined are
completed. - E. An Oracle Scheduler job is created for each maintenance tasks that is scheduled to run in a
maintenance window.
Answer: A,C,E
NEW QUESTION 169
You plan to duplicate the multitenant container database (CDB) cdb1that contains the pluggable database (PDB) SALES:
Which two statements are true? (Choose two.)
- A. A backup of the SALES PDB must exist before the execution of the command.
- B. The root and seed databases are included in the duplication.
- C. Only the SALESPDB is duplicated as the non-CDB CDBDUP.
- D. RMAN must be connected to a recovery catalog for the execution of the command.
- E. An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASEset to TRUE.
Answer: B,E
Explanation:
D: When duplicating a whole CDB or one more PDBs:
You must create the auxiliary instance as a CDB. To do so, start the instance with the following declaration in the initialization parameter file:
enable_pluggable_database=TRUE
A: To duplicate PDBs, you must create the auxiliary instance as a CDB. To do so, start the instance with the declaration enable_pluggable_database=TRUE in the initialization parameter file. When you duplicate one or more PDBs, RMAN also duplicates the root (CDB$ROOT) and the seed database (PDB$SEED). The resulting duplicate database is a fully functional CDB that contains the root, the seed database, and the duplicated PDBs.
References: https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm
NEW QUESTION 170
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
NEW QUESTION 171
Which statement is true aboutthe loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?
- A. The PDB does not close and starts by using the default temporary tablespace defined
for the CD - B. The PDB is closed and requires media recovery at the PDBlevel.
- C. The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.
- D. The PDB is closed and the temp file is re-created automatically when the PDB is opened.
Answer: D
NEW QUESTION 172
Which two statements are true about dropping a pluggable database (PDB)? (Choose two.)
- A. A PDB must have been opened at least once after creation.
- B. A PDB must be in mount state or it must be unplugged.
- C. The data files associated with a PDB are automatically removed from disk.
- D. A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs.
- E. A PDB must be in closed state.
- F. The backups associated with a PDB are removed.
Answer: B,D
Explanation:
Unplugging a PDB
The following prerequisites must be met:
The current user must have SYSDBA or SYSOPER administrative privilege, and the privilege must be either commonly granted or locally granted in the PDB. The user must exercise the privilege using AS SYSDBA or AS SYSOPER at connect time.
The PDB must have been opened at least once.
The PDB must be closed. In an Oracle Real Application Clusters (Oracle RAC) environment, the PDB must be closed on all instances.
Dropping a PDB
The DROP PLUGGABLE DATABASE statement drops a PDB. You can drop a PDB when you want to move the PDB from one CDB to another or when you no longer need the PDB. - THIS MAKES C CORRECT.
When you drop a PDB, the control file of the CDB is modified to eliminate all references to the dropped PDB.
Archived redo log files and backups associated with the PDB are not removed, but you can use Oracle Recovery Manager (RMAN) to remove them.
When dropping a PDB, you can either keep or delete the PDB's data files by using one of the following clauses:
KEEP DATAFILES, the default, retains the data files.
The PDB's temp file is removed even when KEEP DATAFILES is specified because the temp file is no longer needed.
INCLUDING DATAFILES removes the data files from disk.
If a PDB was created with the SNAPSHOT COPY clause, then you must specify INCLUDING DATAFILES when you drop the PDB.
The following prerequisites must be met:
The PDB must be in mounted mode, or it must be unplugged.
NEW QUESTION 173
Your database instance is started using an SPFILE. You are connected to cdb$root, as a DBA. You issue:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;
Which two statements are true about the statistics level parameter? (Choose two.)
- A. It is immediately set to all in only those pluggable databases (PDBs) where the value is set to typical.
- B. It is immediately set to all only for cd3Sroot.
- C. It is immediately set to all in all PDBs where the statistics_level parameter is not set.
- D. It is immediately set to all in the SPFILE and the CDB instance.
- E. It is set to all for all PDBs only in the SPFILE.
Answer: A,D
NEW QUESTION 174
Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler? (Choose three.)
- A. A job is specified as part of a program definition.
- B. A program and window can be specified as part of a job definition.
- C. A program and job can be specified as part of a schedule definition.
- D. A program can be used in the definition of multiple jobs.
- E. A program and schedule can be specified as part of a job definition.
Answer: B,D,E
Explanation:
Explanation/Reference:
NEW QUESTION 175
Which two statements are true about service creation for pluggable databases (PDBs)? (Choose two.)
- A. When a PDB is created, a service is automatically started in the instance with the same name as the
PDB. - B. When a PDB is created, a service with the same name as the PDB is created in the PDB.
- C. The default service that is automatically created by a database at the time of PDB creation can be
dropped, provided a new additional service is created. - D. Only a common user can create additional services for a PDB.
- E. A database managed by Oracle Restart can have additional services created or existing services
modified by using the srvctl utility for each PDB.
Answer: A,E
NEW QUESTION 176
You execute the commands to configure settings in RMAN:
Then, you issue the following command to take a backup:
Which statement is true about the execution of these commands?
- A. It backs up two copies each of the data files to disk and media, and two copies of archived logs to media.
- B. It backs up the data files and archived logs to media, making two copies of each data file and archived logs.
- C. The backup terminates because the backup destination for disk is not specified in the BACKUP command.
- D. It backup up the data files and archived logs, making one copy of each data file and archived log on disk and media.
Answer: B
NEW QUESTION 177
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?
- A. You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.
- B. By default, EM express is available for a database after database creation.
- C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
- D. You can use EM express to manage multiple databases running on the same server.
- E. You can create and configure pluggable databases by using EM express.
Answer: A
NEW QUESTION 178
RMAN is configured to create backupset backups for your database. You issue the command to back up the database:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which two statements are true about the backup performed by the command?
- A. Only the used blocks in the data files are backed up.
- B. It backs up all the data files and deletes obsolete backups after the backup is complete.
- C. It backs up all the archived log files and deletes the ones that were just backed up.
- D. It backs up all archived redo log files and online log files and deletes the archived log files after the backup is complete.
- E. It backs up only those archived log files that are not backed up at least once.
Answer: B,C
Explanation:
Explanation/Reference:
Explanation:
You can use BACKUP ... DELETE to back up archived redo logs, data file copies, or backup sets and then delete the input files after successfully backing them up.
The BACKUP ARCHIVELOG ... DELETE INPUT command deletes archived log files after they are backed up. This command eliminates the separate step of manually deleting archived redo logs.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2017), page 9-
31
NEW QUESTION 179
Examine the list of possible steps to transport a tablespace across platforms that have the same
compatibility level, character sets, and endian format:
1. Make the tablespace read-only at the source database.
2. Export metadata from the source database.
3. Import metadata into the target database.
4. Transfer the dump file and data files to the target machine.
5. Convert data files by using Recovery Manager (RMAN).
6. Make the tablespace read-write at the target database.
Identify the required steps in the correct order.
- A. 1, 5, 2, 4, 3, and 6
- B. 1, 2, 4, 3, and 6
- C. 2, 4, and 3
- D. 2, 4, 3, and 5
Answer: B
Explanation:
Explanation/Reference:
Explanation:
Step 1 (1) : To copy tablespaces from one database to another using transportable tablespace, the source
tablespaces are first kept in READ-ONLY mode (to ensure data consistency). Once the tablespaces are in
READ-ONLY mode, the actual datafiles belonging to the source tablespaces are copied from source
database to target database (using any available methods like scp, sftp, rcp, etc).
Step 2 (2): Once the tablespace is kept in READ-ONLY mode, we need to generate the metadata export of
the tablespaces that needs to transported using the DataPump export utility.
Step 3 (4): Once the metadata export is generated on the source database for all the tablespaces that
needs to be transported, we need to copy the Export Dump file as well as all the datafiles belonging to the
tablespaces to be transported to the target database server.
References: http://www.oraclebuffer.com/oracle/migrate-oracle-database-using-transportable-tablespace/
NEW QUESTION 180
You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to
pluggable databases (PDBs).
You have already created a test system to support the consolidation of databases in a multitenant
container database (CDB) that has multiple PDBs.
What is the easiest way to perform capacity planning for consolidation?
- A. capturing the workload on the production system and replaying the workload for one PDB at a time on
the test system - B. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system
and using the SQL Tuning Advisor on the test system - C. capturing the workload on the production system and using Consolidated Database Replay to replay
the workload of all production systems simultaneously for all PDBs - D. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system
and using the SQL Performance Analyzer on the test system
Answer: C
NEW QUESTION 181
Which three statements are true about Flashback Data Archive? (Choose three.)
- A. A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first.
- B. To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database.
- C. While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive.
- D. Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error.
- E. To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.
Answer: A,B,C
NEW QUESTION 182
Examine this command:
SQL> CREATE DATABASE cdb1
DEFAULT TABLESPACE users
DEFAULT TEMPORARY TABLESPACE temp
UNDO TABLESPACE undotbs1
ENABLE PLUGGABLE DATABASE
SEED
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
SYSAUX DATAFILES SIZE 100M;
Which two requirements must be met to ensure that CDB1 is created? (Choose two.)
- A. The DB_CREATE_FILE_DEST parameter must be configured.
- B. The USER_DATA TABLESPACE clause must be added to the command.
- C. The ENABLE_PLUGGABLE_DATABASE parameter must be set to TRUE.
- D. The PDB_FILE_NAME_CONVERT parameter must be configured.
- E. The FILE_NAME_CONVERT clause must be added to the command.
Answer: C,E
NEW QUESTION 183
Which three statements are true about Consolidated Database Replay?
- A. The workload capture and replay systems must have the same operating system (OS).
- B. Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB).
- C. A subset of the captured workload can be replayed.
- D. Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.
- E. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.
Answer: B,C,D
NEW QUESTION 184
In which situation can you use Flashback Database?
- A. when retrieving a dropped tablespace
- B. when undoing a shrink data file operation
- C. when returning to a point in time before the most recent open resetlogs operation
- D. when returning to a point in time before the restoration or re-creation of a control file
Answer: A
Explanation:
Reference:
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm (prerequisites, third para)
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm#RCMRF194
NEW QUESTION 185
Which three statements are true about automated maintenance tasks?
- A. An Oracle Scheduler job is created for each maintenance tasks that is scheduled to run in a maintenance window.
- B. A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks.
- C. Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning Advisor.
- D. They run at predefined time intervals that are intended to occur during a period of low system loads.
- E. A maintenance window is automatically extended until all the maintenance tasks defined are completed.
Answer: A,C,D
NEW QUESTION 186
......
12c Free Certification Exam Material from BootcampPDF with 278 Questions: https://www.bootcamppdf.com/1z0-063_exam-dumps.html