1Z0-063 | Replace Oracle 1Z0-063 practice test

Q61. You create a default Flashback Data Archive FLA1and 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 gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive. 

B. It executes successfully and all metadata related to the EMPLOYEES table before altering the table definition is purged from Flashback Data Archive. 

C. It executes successfully and continues to store metadata related to the EMPLOYEES table. 

D. It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table. 

Answer: C 

Q62. Which three statements are true about a job chain? 

A. It can contain a nested chain of jobs. 

B. It can be used to implement dependency-based scheduling. 

C. It cannot invoke the same program or nested chain in multiple steps in the chain. 

D. It cannot have more than one dependency. 

E. It can be executed using event-based or time-based schedules. 

Answer: A,B,E 

Reference:http://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse009.htm#AD 

MIN12459 

Q63. You are administering a multitenant container database (CDB) cdb1. 

Examine the command and itsoutput: 

SQL>show parameterfile 

NAMETYPEVALUE 

db_create_file_deststring db_file_name_convertstring db_filesinteger200 

You verify that sufficient disk space is available and that nofile currently exists in the ‘/u0l/app/oracle/oradata/cdb1/salesdb' location. 

You plan to create a new pluggable database (PDB) by using the command: 

SQL>CREATEPLUGGABLEDATABASESALESPDB 

ADMINUSERsalesadmIDENTIFIED 3Y password 

ROLES=(dba) 

DEFAULTTABLESPACEsales 

DATAFILE' /u01/app/oracle/oradata/cdb1/salesdb/sales01 .dbf’SIZE 250M AUTOEXTEND 

ON 

FILE_NAME_CONVERT=(‘/u01/app/oracle/oradata/cdb1/pdbseed/', 

'/u01/app/oracle/oradata/cdb1/salesdb/') 

STORAGE(MAXSIZE2G) 

PATK_PREFIX='/u01/app/oracle/oradata/cdb1/SALESPDB' 

Which statement is true? 

A. SALESPDB is created and is in mount state. 

B. PDB creation fails because the D3_file_name_convert parameter is not set in the CDB. 

C. SALESPDB is created and is in read/write mode. 

D. PDB creation fails because a defaulttemporary tablespace is not defined for SALESPDB. 

Answer: B 

Q64. Examine the command to create a pluggable database (PDB): 

SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1 

FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/’) PATH_PREFIX= '/disk2/oracle/pdb2' 

Which two statements are true? 

A. The pluggable database pdb2 is created by cloning pdb1 and is in mount state. 

B. Details about the metadata describing pdb2 are stored in an XML file in the '/disk2/oracle/pdb2/' directory. 

C. The tablespace specifications of pdb2 are the same as pdb1. 

D. All database objects belonging to common users in PD3I are cloned in PD32. 

E. pdb2 is created with its own private undo and temp tablespaces. 

Answer: A,C 

Reference:http://oracle-info.com/2013/07/27/12c-database-create-pdbs-plug-unplug/(see the table, 4throw) 

Q65. Examinethe commands: 

SQL> ALTER SESSION SET RECYCLBIN = 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: A 

Q66. Identify three scenarios in which RMAN will use backup sets to perform active database duplication. 

A. whenthe duplicate ... from active database command contains the section size clause 

B. when you perform active database duplication on a database with flashback disabled 

C. when you specify set encryption before the duplicate ... from active database command 

D. when the number of auxiliary channels allocated is equal to or greater than the number of target channels 

E. when you perform active database duplication on a database that has read-onlytablespaces 

Answer: A,C,D 

Reference:http://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV298 

Q67. 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: A,B,D 

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

http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmreprt.htm#BRADV89585 

The primary purpose of the LIST command is to list backup andcopies. 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 redolog files and disk copies 

Q68. In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20. 

Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement? 

A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used 

B. Setting the target tablespace to read-only after the segments are moved 

C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds T3Spercent used 

D. Taking the target tablespace offline after the segments are moved 

E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used 

Answer: B,C 

Q69. 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. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB. 

E. Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules. 

Answer: B,C,E 

Q70. You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able toconnect to the database instance because it hangs. 

How can you detect the cause of the degraded performance? 

A. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis 

B. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots 

C. by using Active Session History (ASH) data and performing hang analysis 

D. by running ADDM in diagnostic mode 

Answer: B