Pass Guaranteed Quiz 2022 Realistic Verified Free 1z0-063 Exam Dumps
Free 12c 1z0-063 Ultimate Study Guide (Updated 278 Questions)
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:
- 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.
- 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.
NEW QUESTION 128
In which three situations must you use a recovery catalog?
- A. when you want to store RMAN global scripts that can be used across multiple databases
- B. when you want to perform incremental backups by using a block change tracking file
- C. when you want to maintain backup metadata longer than the period specified by the CONTROL_FILE_RECORD_KEEP_TIMEparameter
- D. when you want to list data files that were in a target database at a given time by using the ATclause with the REPORT SCHEMAcommand
- E. when you want to restrict the amount of space used by backups
Answer: A,C,D
Explanation:
Explanation/Reference:
Explanation:
A: Some RMAN features function only when you use a recovery catalog. For example, you can store RMAN scripts in a recovery catalog. The chief advantage of a stored script is that it is available to any RMAN client that can connect to the target database and recovery catalog. Command files are only available if the RMAN client has access to the file system on which they are stored.
A local stored script is associated with the target database to which RMAN is connected when the script is created, and can only be executed when you are connected to this target database. A global stored script can be run against any database registered in the recovery catalog.
D: If you use a recovery catalog, then you can use the atClause to specify a past time, SCN, or log sequence number, as shown in these examples of the command:
RMAN> REPORT SCHEMA AT TIME 'SYSDATE-14'; # schema 14 days ago
RMAN> REPORT SCHEMA AT SCN 1000; # schema at scn 1000
RMAN> REPORT SCHEMA AT SEQUENCE 100 THREAD 1; # schema at sequence 100
RMAN> REPORT SCHEMA FOR DB_UNIQUE_NAME standby1;
E: The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter determines the minimum number of days that records are retained in the control file before they are candidates for being overwritten. Thus, you must ensure that you resynchronize the recovery catalog with the control file records before these records are erased.
References: https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmcatdb.htm
https://docs.oracle.com/database/121/BRADV/rcmreprt.htm#BRADV90911
NEW QUESTION 129
Your database has a table CUSTOMERSthat contains the columns CUST_NAME, AMT_DUE, and OLD_STATUS.
Examine the commands executed and their output:
Why is it that only one update is listed by the Flashback Version Query?
- A. Flashback Data Archive is full after the first update statement.
- B. Supplemental logging is not enabled for the database.
- C. The DB_FLASHBACK_RETENTION_TARGETparameter is set to a lower value and the undo data pertaining to the first transaction is flushed out.
- D. The undo data that existed for versions of rows before the change to the table structure is invalidated.
- E. Undo retention guarantee is not enabled.
Answer: D
NEW QUESTION 130
Which two statements are true regarding the Oracle Data Pump export and import operations?
- A. You cannot export data from a remote database.
- B. You can rename tables during import.
- C. You can overwrite existing dump files during export.
- D. You can compress data but not metadata during export.
Answer: A,B
Explanation:
Explanation/Reference:
Explanation:
Reference:
http://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_import.htm#BEHFFDCD
NEW QUESTION 131
The CATDB12cdatabase contains an Oracle Database version 12c catalog schema owned by the RC12C user.
The RCAT11database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both databases are open.
You execute the RMAN commands:
Which two tasks are performed as part of the import? (Choose two.)
- A. Local and global stored scripts that have the same name as existing scripts in the RC12Ccatalog are automatically renamed.
- B. Imported databases are unregistered from the RC11 catalog.
- C. Recovery catalog is resynchronized with the control files of the registered databases.
- D. Databases from the RC12C catalog are implicitly unregistered if the RC11catalog has registered databases with same name.
- E. All databases registered in the RC11catalog are registered in the RC12Ccatalog.
Answer: B,E
NEW QUESTION 132
Examine the RMAN command:
Which statement is true about the command?
- A. It uses multisection backup.
- B. It uses parallelization for the backup set.
- C. It uses asynchronous I/O for the backup.
- D. It creates compressed backup sets.
Answer: B
Explanation:
Explanation/Reference:
SBT stands for Serial Backup Tape.
Configuring Parallel Channels for Disk and SBT Devices
The number of channels available for a device type when you run a command determines whether RMAN reads or writes in parallel. As a rule, the number of channels used in executing a command should match the number of devices accessed.
For tape backups, allocate one channel for each tape drive.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2017), page 5-
6
NEW QUESTION 133
Which parameter must be set to which value to implement automatic PGA memory management?
- A. Set sgajtarget to zero.
- B. Set STATISTICS_LEVEL to BASIC.
- C. Set pga_aggregate_target to a nonzero value.
- D. Set pga_aggregate_target and sga_target to the same value.
- E. Set memory_target to zero.
Answer: C
Explanation:
Reference:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/memory004.htm#ADMIN11233
NEW QUESTION 134
Examine the following set of RMAN commands:
Which statement is true about the RMAN RUN block execution?
- A. The execution of the script fails because multiple channels cannot exist simultaneously.
- B. The script is executed and both DC1 and CH1 channels are used for script execution.
- C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.
- D. The new channel, CH1, is ignored because a channel has been configured already.
Answer: C
NEW QUESTION 135
Which two methods can be used toadd an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)?
- A. Use the d3MS_pdb package to plug the Oracle 11g database into the existing CDB as a PDB.
- B. Use the create database ... enable pluggable database statement to create a PDB by copying data files from pd3Sseed and use data pump to load data from the Oracle 11g database into the newly created PD
- C. Upgrade the Oracle 11g database to a 12c non-CDB and use the dbms_pdb.describe procedure to plug the database as a new PDB into the CDB.
- D. Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB.
- E. Pre-create a PDB in CDB and use the network_link and parallel parameters with data pump import to import data from the Oracle 11g database to the newly created PDB.
Answer: B,C
NEW QUESTION 136
In an Oracle 12c database, you attempt to load data into the HR.EMPLOYEES table in a pluggable database (PDB):
$> sqlldr hr/hr@pdb table=employees
Which three are true? (Choose three.)
- A. It succeeds if HR is a common user.
- B. It creates the HR.EMPLOYEES table in the PDB and loads data into it if the table does not exist in the PDB to which HR connects.
- C. It succeeds if HR is local user in the PDB to which HR connects.
- D. It loads data into HR.EMPLOYEES if the table exists in CDB$ROOT.
- E. It loads data into HR.EMPLOYEES if the table exists in the PDB to which HR connects.
Answer: B,C,E
NEW QUESTION 137
Your multitenant container database (CDB) cdb1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:
SQL>STARTUP
Which two statements are true about the successful execution of the command?
- A. All the PDBs are opened in read-write mode.
- B. The root, the seed, and all the PDBs are opened in read-write mode.
- C. All the PDBs are in closed state.
- D. Only the root database is opened in read-write mode.
- E. All redo log files are opened.
Answer: D,E
NEW QUESTION 138
Which two statements are true about the Automatic Diagnostic Repository (ADR)?
- A. The ADR base is shared across multiple instances.
- B. The ADR base keeps all diagnostic information in binary format.
- C. The ADR can be used for problem diagnosis even when the database instance is down.
- D. The ADR is used to store Automatic Workload Repository (AWR) snapshots.
- E. The ADR can be used to store statspack snapshots to diagnose database performance issues.
Answer: C,E
NEW QUESTION 139
Which two statements are true about setting the FAST_START_MTTR_TARGETparameter to a nonzero value?
(Choose two.)
- A. The time taken to recover an instance after a crash is always exactly the same as the value set for the FAST_START_MTTR_TARGETparameter.
- B. The value of the LOG_CHECKPOINT_INTERVALparameter overrides the value of the FAST_START_MTTR_TARGETparameter.
- C. The MTTR advisor is enabled only if the value is greater than the default value.
- D. Automatic checkpoint tuning is enabled.
Answer: B,C
Explanation:
The FAST_START_MTTR_TARGET initialization parameter lets you specify in seconds the expected "mean time to recover" (MTTR), which is the expected amount of time Oracle takes to perform crash or instance recovery for a single instance.
To enable MTTR advisory, set the initialization parameter FAST_START_MTTR_TARGET to a nonzero value.
If FAST_START_MTTR_TARGET is not specified, then MTTR advisory will be OFF.
When specified, FAST_START_MTTR_TARGET is overridden by LOG_CHECKPOINT_INTERVAL.
Note: The default value is 0. Range of values is 0 to 3600 seconds.
References: https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams079.htm#REFRN10058
https://docs.oracle.com/cd/A97630_01/server.920/a96533/instreco.htm
NEW QUESTION 140
You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter resumable_timeout to 3600.
Which two statements are true? (Choose two.)
- A. A resumable statement can be suspended and resumed only once during execution.
- B. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.
- C. Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.
- D. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
- E. A suspended statement will report an error if no corrective action has taken place during a timeout period.
Answer: C,E
Explanation:
Explanation/Reference:
NEW QUESTION 141
Which three statements are true about Oracle Restart?
- A. It can be configured to automatically attempt to restart various components after a hardware or software failure.
- B. While starting any components, it automatically attempts to start all dependencies first and in proper order.
- C. It can be used to only start Oracle components.
- D. It runs periodic check operations to monitor the health of Oracle components.
- E. It can be configured to automatically restart a database in case of normal shutdown of the database instance.
Answer: A,B,D
Explanation:
Explanation/Reference:
Explanation:
Reference:
http://docs.oracle.com/cd/E18283_01/server.112/e17120/restart001.htm
NEW QUESTION 142
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 scottorcll;
SQL> GRANT CREATE SESSION TO c##scott user?
Which statement is true about the c##scott user?
- A. It is created and has the CREATE SESSION privilege only in a PDB that is open.
- B. It is created in all the PDBs but has the CREATE SESSION privilege only in CDB$ROOT.
- C. It is created in all the PDBs with the CREATE SESSION privilege.
- D. It is created only in CDB$ROOT and has the CREATE SESSION privilege.
Answer: A
NEW QUESTION 143
Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. You notice that all online redo logs have been overwritten since the last backup.
Which method would you use to recover the data file?
- A. Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance.
- B. Shut down the instance if not already shut down, restore all data files belonging to the system tablespace from the last backup, and restart the instance.
- C. Shut down the instance if not already shut down, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the instance.
- D. Mount the database, restore all data files belonging to the system tablespace from the last backup, and open the database.
Answer: A
NEW QUESTION 144
Examine the command used to perform an incremental level-0 backup:
RMAN> BACKUP INCREMENTAL LEVEL0 DATABASE;
To enable block change tracking, after the incremental level 0 backup, you issue the command:
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING
FILE'/mydir/rman_change_track.f';
To perform an incremental level-1 cumulative backup, you issue the command:
RMAN> BACKUP INCREMENTAL LEVEL1 CUMULATIVE DATABASE;
Which two statements are true in the preceding situation? (Choose two.)
- A. The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.
- B. The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup.
- C. The block change tracking data is used only from the next incremental backup.
- D. The incremental level 1 backup does not use change tracking data for accomplishing the backup.
- E. The block change tracking data is used for the next incremental level 1 backup only after the next level
0 backup.
Answer: D,E
NEW QUESTION 145
You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command.
Which two statements are true about the dependent objects of the CUSTOMERS table? (Choose two.)
- A. LOB segments associated with the CUSTOMERS table are flashed back.
- B. All the constraints defined on the table, except the referential integrity constraints, are flashed back.
- C. Only the primary key constraint created for the table is flashed back, whereas all other indexes must be retrieved separately.
- D. Materialized views that use the CUSTOMERS table are flashed back.
- E. All the triggers associated with the table are flashed back but are disabled.
Answer: A,B
Explanation:
Explanation
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.
NEW QUESTION 146
Examine the commands:
SQL> ALTER SESSION SET RECYCLEBIN = ON;
Session altered.
SQL> DROP TABLE emp; --(First EMP table)
Table dropped.
SQL> CREATE TABLE emp(id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2)); Table created.
You then execute multiple INSERT statements to insert rows into the EMP table and drop the table again:
SQL> DROP TABLE emp; -- (Second EMP table)
Table dropped.
SQL> FLASHBACK TABLE emp TO BEFORE DROP;
Which statement is true about the FLASHBACK command?
- A. It recovers the structure, data, and indexes of the second EMP table.
- B. It recovers only the structure of the second EMP table.
- C. It recovers the structure, data, and indexes of the first EMP table.
- D. It returns an error because two tables with the same name exist in the recycle bin.
Answer: A
NEW QUESTION 147
......
Get to the Top with 1z0-063 Practice Exam Questions: https://www.actual4dump.com/Oracle/1z0-063-actualtests-dumps.html