Master the 1Z0-063 Oracle Database 12c: Advanced Administration content and be ready for exam day success quickly with this Actualtests 1Z0-063 actual exam. 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.
♥♥ 2017 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
Q91. You want to export the pluggable database (PDB) hr pdb1 from the multitenant container database (CDB)CDB1 and import it into the cdb2 CDB as the emp_pdb1 PDB.
Examine the list of possible steps required to perform the task:
1.Create a PDB named emp_pdb1.
2.Export the hr_pdb1 PDB by using the full clause.
3.Open the emp_pdb1 PDB.
4.Mount the emp_pdb1 PDB.
5.Synchronize the emp_pdb1 PDB in restricted mode.
6.Copy the dump file to the Data Pump directory.
7.Create a Data Pump directory in the emp_pdb1 PDB.
8.Import data into emp_pdb1 with the full and remap clauses.
9.Createthe same tablespaces in emp_pdb1 as in hr_pdb1 for new local user objects.
Identify the required steps in the correct order.
A. 2, 1, 3, 7, 6, and 8
B. 2, 1, 4, 5, 3, 7, 6, 9, and 8
C. 2, 1, 3, 7, 6, 9, and 8
D. 2, 1, 3, 5, 7, 6, and 8
Q92. A database is running in archivelog mode. You want to back up a 10 TB data file belonging to the users tablespace. The backup of the data file is too slow.
What type of backup do you recommend to improve the performance of the backup?
A. image copy backup by using RMAN
B. multisection image copy backup by using RMAN
C. multisection parallel backup by using RMAN
D. cold backup after taking the tablespace offline
E. cold backup after placing the tablespace in backup mode
Q93. You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges.
The statistics_level parameter isPDB modifiable.
As the user sys, execute the following command on pdb2:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;
Which statement is true about the result of this command?
A. The statistics_level parameter is set to all when anyof the PDBs is reopened.
B. The statistics_level parameter is set to all only for PDB2 when it is reopened.
C. The statistics_level parameter is set to all when the root database is restarted.
D. The statement is ignored because there is no SPFILE for a PDB.
73. Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)?
A. Database Resident Connection Pooling
B. Oracle Suggested Backup Strategy
C. Database Vault in ORACLE_HOME
E. Configure Label Security
Q94. Examine the RMAN commands executed in your database:
RMAN>CONFIGUREDEFAULT DEVICE TYPE TO disk;
RMAN>CONFIGURE DEVICETYPE DISK BACKUP TYPE TO BACKUPSET;
RKAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
You issue the command:
RMAN> BACKUP DATABASE;
Which two statements are true about the command?
A. It performs a log switch.
B. It creates compressed backup sets by using binary compression by default.
C. It backs up only the used blocks in data files.
D. It backs up data files, the control file, and the server parameter file.
E. It creates a backup of only the control file whenever the database undergoes a structural change.
Q95. Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and all the control files are lost.
Examine the steps to recover the database:
1.Restore the control filesby using the RMAN restore controlfile command.
2.Mount the database.
3.Restore the data files by using the RMAN restore database command.
4.Open the database with the resetlogs option.
5.Recover the data files by using the RMAN recover using backup controlfile command.
Start the database instance in nomount state.
Connect to the target database by using a recovery catalog.
8.Open the database.
9.Restore the data file.
10.Recover the data file.
Identify the required steps in the correct order.
A. 7,6, 1, 2, 3, 5, 4
B. 7, 2, 1, 3, 5, 8
C. 7, 6, 1, 2, 9, 10, 8
D. 7, 6, 1, 2, 9, 10, 4
140. You want RMAN to make duplicate copies of data files when using the backup command.
What must you set using the RMAN configure command to achieve this?
A. MAXSETSIZE TO 2;
B. DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
C. CHANNEL DEVICE TYPE DISK FORMAT '/disk1/%U' , '/disk2/%U'
D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
Q96. In a database supporting an OLTP workload, tables are frequently updated on both key and non-keycolumns.
Reports are also generated by joining multiple tables.
Which table organization or type would provide the best performance for this hybrid workload?
A. heap table with a primary key index
B. external table
C. hash clustered table
D. global temporary table
E. index clustered table
Q97. Automatic Shared Memory Management (ASMm) is enabled for your database instance,
but parameters for the managed components are not defined.
You execute this command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true?
A. The minimum size for the standard buffer cache is 100 MB.
B. The maximum size for the standard buffer cache is 100 MB.
C. The minimum space guaranteed in the buffer cache for any server process is 100 MB.
D. The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.
E. The minimum size for all buffer caches is 100 MB.
Q98. Which two statements are true about dropping a pluggable database (PDB)?
A. A PDB must be in mount state or it must be unplugged.
B. The data files associated with a PDB are automatically removed from disk.
C. A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs.
D. A PDB must be in closed state.
E. The backups associated with a PDB are removed.
F. A PDB must have been opened at least once after creation.
Q99. Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?
A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
B. In a PDB plan, subplans may be used with up to eight consumer groups.
C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.
D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
E. If a PDB plan is enabled for a pluggable database, then 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.
Explanation: A: Setting a PDB resource plan is optional. If not specified, all sessions within the PDB are treated equally. In a non-CDB database, workloads within a database are managed with resource plans. In a PDB, workloads are also managed with resource plans,also called PDB resource plans. The functionality is similar except for the following differences: Non-CDB Database Multi-level resource plans Up to 32 consumer groups Subplans PDB Database Single-level resource plans only Up to 8 consumer groups (Not B) No subplans
Q100. You wish to enable an audit policy for all database users, except sys, system, and scott. You issue the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?
A. all users exceptsys
B. all users except scott
C. all users except sys and scott
D. all users except sys, system, and scott