100% Guarantee 1Z0-063 Dumps Questions 2021

NEW QUESTION 1
Which two statements are true regarding SecureFile lobs? (Choose two.)

• 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.

Answer: CD

NEW QUESTION 2
You want to move your existing recovery catalog to another database. Examine the steps:
1) Export the catalog data by using the Data Pump Export utility in the source database.
2) Create a recovery catalog user and grant the necessary privileges in the target database.
3) Create a recovery catalog by using the CREATE CATALOG command.
4) Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database.
5) Import the source recovery catalog schema by using the IMPORT CATALOG command.
6) Connect to the destination database.
7) Connect as CATALOG to the destination recovery catalog schema. Identify the option with the correct sequence for moving the recovery catalog.

• A. 1, 6, 4
• B. 2, 3, 7, 5
• C. 1, 2, 6, 4
• D. 1, 2, 3, 6, 5

Answer: C

NEW QUESTION 3
Examine the command:
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required? (Choose two.)

• A. The current online redo log file is missing.
• B. A data file belonging to a noncritical tablespace is missing.
• C. All the control files are missing.
• D. The control file backup is older than the database backup.
• E. All the data files are missing.

Answer: CD

NEW QUESTION 4
Examine the initialization parameter that is set in the PFILE:
DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/'
You execute the following command to create CDB1 container database (CDB): SQL>CREATE DATABASE CDB1
DEFAULT TABLESPACE users DEFAULT TEMPORARY TABLESPACE
temp
UNDO TABLESPACE
Undotbsl ENABLE
PLUGGABLE DATABASE SEED
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED SYSAUX DATAFILES SIZE 100M;
Which three statements are true? (Choose three.)

• A. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.
• B. The files created for both the root and seed databases use Oracle Managed Files (OMF).
• C. It creates a multitenant container database with the root and seed databases opened and one PDB mounted.
• D. It sets the users tablespace as the default for both the root and seed databases.
• E. undotbs1 is used as the undo tablespace for both the root and seed databases.
• F. It creates a multitenant container database with the root database opened and the seed database mounted.

Answer: ABE

NEW QUESTION 5
Which two statements are true about scheduling operations in a pluggable database (PDB)? (Choose two.)

• A. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.
• B. A job defined in a PDB runs only if that PDB is open.
• C. Scheduler attribute setting is performed only at the CDB level.
• D. Scheduler objects created by users can be exported or imported using Data Pump.
• E. Scheduler jobs for a PDB can be created only by common users.

Answer: BD

NEW QUESTION 6
In which three situations must you use a recovery catalog? (Choose three.)

• A. when you want to store RMAN global scripts that can be used across multiple databases
• B. when you want to restrict the amount of space used by backups
• C. when you want to perform incremental backups by using a block change tracking file
• D. when you want to list data files that were in a target database at a given time by using the AT clause with the REPORT SCHEMA command
• E. when you want to maintain backup metadata longer than the period specified by the CONTROL_FILE_RECORD_KEEP_TIME parameter

Answer: ADE

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 7
You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.
Examine the steps required to recover the database:
1. Restore an autobackup of the server parameter file.
2. Restore the control file.
3. Start up the database instance in NOMOUNT state.
4. Mount the database.
5. Restore the data files.
6. Open the database with the RESETLOGS option.
7. Recover the data files.
8. Set DBID for the database.
Identify the required steps in the correct order.

• A. 1, 8, 3, 2, 4, 5, 7, 6
• B. 8, 1, 3, 2, 4, 5, 7, 6
• C. 1, 3, 2, 4, 8, 5, 6, 7
• D. 8, 3, 2, 4, 5, 7, 6
• E. 8, 1, 3, 2, 4, 5, 6

Answer: B

NEW QUESTION 8
Evaluate these statements: CREATE TABLE purchase_orders (po_idNUMBER(4),
po_dateTIMESTAMP, supplier_idNUM8ER(6),
po_totalNUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(po_id)) PARTITION BY RANGE(po_date)
(PARTITIONQ1 VALUES LESS THAN (TO_DATE('01-apr-2007','dd-mm-yyyy')), PARTITIONQ2VALUESLESSTHAN(TO_DATE('01-jul-2007','dd-mm-yyyy')), PARTITIONQ3VALUESLESSTHAN (TO~DATE('01-oct-2007','dd-mm-yyyy')), PARTITIONQ4VALUESLESSTHAN (TO_DATE('Ol-jan-2008','dd-mm-yyyy')));
CREATE TABLE purchase_order_items (po_idNUM3ER(4)NOT NULL,
product_idNUMBER(6)NOT NULL, unit_price NUMBER(8,2),
quantity NUMBER(8), CONSTRAINT po_items_f k
FOREIGN KEY(po_id)REFERENCES purchase_orders(po_id)) PARTITION BY REFERENCE(po_items_fk);
Which two statements are true? (Choose two.)

• A. Partitions of purchase_order_items are assigned unique names based on a sequence.
• B. The purchase_orders and purchase_order_items tables are created with four partition each.
• C. purchase_order_items table partitions exist in the same tablespaces as the purchase_orders table partitions.
• D. The purckase_order_:teks table inherits the partitioning key by duplicating the key columns from the parent table.
• E. Partition maintenance operations on the purchase_order_items table require disabling the foreign key constraint.

Answer: BC

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

Answer: AE

Explanation: A: ACDB 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. References: https://docs.oracle.com/database/121/ADMIN/cdb_dbrm.htm

NEW QUESTION 10
Which three statements are true about the database instance startup after an instance failure? (Choose three.)

• 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 coordinates 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.

Answer: ACD

Explanation: A: Occasionally a database closes abnormally with one or more distributed transactions in doubt (neither committed nor rolled back). When you reopen the database and recovery is complete, the RECO background process automatically, immediately, and consistently resolves any in-doubt distributed transactions.
C: Crash and instance recovery involve two distinct operations: rolling forward the current, online datafiles by applying both committed and uncommitted transactions contained in online redo records, and then rolling back changes made in uncommitted transactions to their original state.
D: The SMON background process performs instance recovery, applying online redo automatically. No user intervention is required.
References: https://docs.oracle.com/cd/B28359_01/server.111/b28318/startup.htm https://docs.oracle.com/database/121/CNCPT/startup.htm

NEW QUESTION 11
Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (CDB) plan using Oracle Database Resource Manager? (Choose two.)

• A. maximum undo per consumer group
• B. maximum idle time for a session in a PDB
• C. parallel server limit
• D. CPU
• E. maximum number of sessions for a PDB

Answer: CD

NEW QUESTION 12
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 can be used in the definition of multiple jobs.
• C. A program and job can be specified as part of a schedule definition.
• D. A program and schedule can be specified as part of a job definition.
• E. A program and window can be specified as part of a job definition.

Answer: BDE

NEW QUESTION 13
Which three RMAN persistent settings can be set for a database? (Choose three.)

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

Answer: ABD

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

Answer: CE

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 15
While performing database backup to tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive.
Which two actions would you take for tape streaming to happen during the backup? (Choose two.)

• A. Configure backup optimization.
• B. Configure the channel to increase maxopenfiles.
• C. Configure a backup policy by using incremental backups.
• D. Configure the channel to increase capacity with the rate parameter.
• E. Configure the channel to adjust the tape buffer size by using the 3LKSIZE option.
• F. Configure large_pool, if not done alread
• G. Alternatively, you can increase the size of large_pool.

Answer: BE

NEW QUESTION 16
You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). RMAN is connected to CDB$ROOT.
Examine the command:
RMAN> LIST FAILURE;
Which statement is true about this command?

• A. It lists failures only for the CDB root database.
• B. It lists failures for a PDB only when RMAN is connected to a recovery catalog.
• C. It lists failures for the CDB and all the PDBs in this CDB.
• D. It lists failures only if RMAN is connected to a PDB.

Answer: A

Explanation: In the current release, Data Recovery Advisor can only be used to diagnose and repair data corruptions in non-CDBs and the root of a multitenant container database (CDB). Data Recovery Advisor is not supported for pluggable databases (PDBs).
Note: You can run the LIST FAILURE command to show all known failures. References: https://docs.oracle.com/database/121/BRADV/rcmrepai.htm

NEW QUESTION 17
Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB HR_PDB, the common user C##ADMIN and the local user B_ADMIN have only the CONNECT privilege.
You create a common role C##ROLE1 with the CREATE ANY TABLE and SELECT ANY TABLE privileges.
You then execute the commands:

Which two statements are true? (Choose two.)

• A. C##ADMIN can create and select any table, and grant the C##ROLE1 role to users only in the root container.
• B. B_ADMIN can create and select any table in both the root container and HR_PDB.
• C. C##ADMIN can create and select any table in the root container and all the PDBs.
• D. B_ADMIN can create and select any table only in HR_PDB.
• E. The GRANT c##role1 TO b_admin command returns an error because CONTAINER should be set to ALL.

Answer: CD

NEW QUESTION 18
Examine the commands:
SQL> ALTER SESSION SET RECYCLEBIN = ON;
Session altered.
SQL> DROP TABLE emp; --(First EMP table) Total 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 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 first EMP table.
• B. It recovers only the structure of the second EMP table.
• C. It returns an error because two tables with the same name exist in the recycle bin.
• D. It recovers the structure, data, and indexes of the second EMP table.

Answer: D