Oct 2021 updated: Pass4sure Oracle 1Z0-063 practice exam 21-30

Want to know Examcollection 1Z0-063 Exam practice test features? Want to lear more about Oracle Oracle Database 12c: Advanced Administration certification experience? Study High value Oracle 1Z0-063 answers to Improved 1Z0-063 questions at Examcollection. Gat a success with an absolute guarantee to pass Oracle 1Z0-063 (Oracle Database 12c: Advanced Administration) test on your first attempt.

♥♥ 2021 NEW RECOMMEND ♥♥

Free VCE & PDF File for Oracle 1Z0-063 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW 1Z0-063 Exam Dumps (PDF & VCE):
Available on: http://www.surepassexam.com/1Z0-063-exam-dumps.html

Q21. Examine the command: 

$expdp SYSTEM FULL=YES DUMPFILE=dpump_dir1:fulll%U.dmp, dpump_dir2:full2% U.dmp, dpump_dir3:full3%U.djnp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull 

Which statement is true about the execution of the command? 

A. It fails because the log file parameter is not specified. 

B. It fails because no absolutepath is specified for the log file and dump file. 

C. It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations. 

D. It succeeds and exports the full database, simultaneously creating three dump files at three different locations, but the total number of dump files can exceed three. 

Answer: B 

Q22. You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB). 

The following are the possible steps to accomplish this task: 

1. 

Place all the user-defined tablespace in read-only mode on the source database. 

2. 

Upgrade the source database to a 12c version. 

3. 

Create a new PDB in the target container database. 

4. 

Perform a full transportable export on the source database withthe VERSION parameter set to 12 using the expdp utility. 

5. 

Copy the associated data files and export the dump file to the desired location in the target database. 

6. 

Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options. 

7. 

Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function. 

Identify the correct order of the required steps. 

A. 2, 1, 3, 4, 5, 6 

B. 1, 3, 4, 5, 6, 7 

C. 1, 4, 3, 5, 6, 7 

D. 2, 1, 3, 4, 5, 6, 7 

E. 1, 5, 6, 4, 3, 2 

Answer: C 

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

Q24. In which situation can you use Flashback Database? 

A. whenundoing a shrink data file operation 

B. when retrieving a dropped tablespace 

C. when returning to a point in time before the restoration or re-creation of a control file 

D. when returning to a point in time before the most recent open resetlogs operation 

Answer: B 

Reference:http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm(pre requisites, thirdpara) 

http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta023.htm#RCMRF194 

Q25. Which three conditions must be met before you create a Virtual Private Catalog (VPC)? 

A. A base recovery catalog should exist. 

B. The owner of VPC cannot own recovery catalog. 

C. At least one target database should beregistered in the recovery catalog. 

D. The register database privilege should be granted to the virtual catalog owner. 

E. The recovery_catalog_owner role should be granted to the virtual catalog owner. 

Answer: C,D,E 

Reference:http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta013.htm 

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

Q27. In your database, there are tablespaces that were read-only when thelast backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file. 

What precaution must you take for the read-only tablespaces before performing anincomplete recovery? 

A. All the read-only tablespaces should be taken offline. 

B. All the read-only tablespaces should be restored separately. 

C. All the read-only tablespaces should be renamed to have the MISSINGnnnn format. 

D. All the read-only tablespacesshould be made online with logging disabled. 

Answer: B 

Q28. Which two statements are true regarding SecureFile lobs? 

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: C,D 

Reference:http://docs.oracle.com/cd/E11882_01/appdev.112/e18294/adlob_smart.htm#AD LOB46113 

Q29. You restore and recover your database to anew host by using an existing RMAN open database backup. 

Which step must you perform next? 

A. Execute catproc.sqi to recompile invalid PL/SQL modules. 

B. Open the database with the resetlogs option. 

C. Set a new database identifier (DBID) for the newly restored database. 

D. Use the RMAN set newname and switch commands to switch to new files. 

Answer: A 

Q30. Which three requirements must be met before a tablespace can be transported across different platforms? 

A. Both the source and target databases must use the same character set. 

B. The platforms of both the source and target databases must have the same endian format. 

C. The compatible parameter value must be the same in the source and target databases. 

D. The minimum compatibility level for both the source and target databases must be 

10.0.0. 

E. The tablespace to be transported must be in read-only mode. 

Answer: B,C,D