Master the 1Z0-063 Oracle Database 12c: Advanced Administration content and be ready for exam day success quickly with this Actualtests 1Z0-063 exam fees. We guarantee it!We make it a reality and give you real 1Z0-063 questions in our Oracle 1Z0-063 braindumps.Latest 100% VALID Oracle 1Z0-063 Exam Questions Dumps at below page. You can use our Oracle 1Z0-063 braindumps and pass your exam.
♥♥ 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
Q61. Which two statements are true about tablespaces in multitenant container databases (CDBs)?
A. Default permanent tablespaces can be shared across pluggable databases (PDBs).
B. The current container must be set to root to create or modify the default temporary tablespace or tablespace group for a CDB.
C. Each PDB can have its own default temporary tablespace.
D. The default permanent tablespace for a PDB can be changed only by a local user with the required permissions.
E. The amount of space that each PDB can usein a shared temporary tablespace must be set at the CDB level.
Q62. Examine the backup requirement for your company:
1) Every Sunday, a backup of all used data file blocks is performed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is performed.
3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.
Which backup strategy satisfies the requirements?
A. level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
B. level 0 backup on Sunday, differential incrementalbackup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
C. full database backup on Sunday, level 0 backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
D. full database backup on Sunday, level 0 backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days
Q63. Examine the RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which prerequisitemust be met before accomplishing the backup?
A. The password for the encryption must be set up.
B. Oracle wallet for the encryption must be set up.
C. All the tablespaces in the database must be encrypted.
D. Oracle Database Vault must be enabled.
Reference:configuration encryption will use by Transparent encryption, For transparent encryption, you will need to create a wallet, and it must be open.
Transparent encryption will then occur automatically after you have issued the CONFIGURE ENCRYPTION FOR DATABASE ON or CONFIGURE ENCRYPTION FOR TABLESPACE ON command.
A database is running in archivelog mode. The database contains locally managed tablespaces. Examine the RMAN command:
AS COMPRESSED BACKUPSET
SECTION SIZE 1024M
Which statement is true about the execution of the command?
A.The backup succeeds only if all the tablespaces are locally managed.
B.The backup succeeds only if the RMAN default device for backup is set to disk.
C.The backup fails because you cannot specify section size for a compressed backup.
D.The backup succeeds and only the used blocks are backed up with a maximum backup
piece size of 1024 MB.
Q64. You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.
Which method or feature should you use?
A. Database Replay
B. Automatic Database Diagnostic Monitor (ADDM) Compare Period report
C. Active Session History (ASH) report
D. SQL Performance Analyzer
Q65. 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.
Q66. Which three RMAN persistent settings can be set for a database?
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
Q67. user_data is a nonencryptedtablespace containing tables with data.
You must encrypt ail data in this tablespace.
Which three methods can do this?
A. Use Data Pump.
B. Use ALTERTABLE. . .MOVE
C. Use CREATE TABLE AS SELECT
D. Use alter tablespace to encrypt the tablespace after enabling row movement on all its
E. Use altertablespace to encrypt thetablespace.
Q68. Examine the RMAN command:
RMAN> SET ENCRYPTION IDENTIFIEDBY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which type of encryption is used for the backup performed by using this command?
A. password-mode encryption
B. dual-mode encryption
C. transparent encryption
D. default encryption
Reference:http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#CEGE JABH(to make password –encrypted backups)
Q69. 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.
Q70. On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command:
Which two statements are true about the command?
A. It succeeds with default settings if the employees table exists in the hr schema.
B. It fails because no SQL*Loader data file location is specified.
C. It fails if the hr user does not have the create any directory privilege.
D. It fails because no SQL*Loader control file location is specified.
E. It succeeds and creates the employees table in the HR schema.