Get New 2021 Valid Practice 12c 1z0-063 Q&A - Testing Engine
1z0-063 Dumps PDF - 100% Passing Guarantee
The Oracle 1Z0-063 exam is a globally recognized qualifying test for the Oracle Database 12c Administrator Certified Professional certificate for the most highly skilled and experienced database specialists who already have the Oracle Database 12c Administrator Certified Associate certification.
NEW QUESTION 82
You want to create a duplicate database DUP_DB from your production database PRODon the same host. The PRODdatabase uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog.
You create an auxiliary instance and want to execute the command:
What is a prerequisite for the successful execution of this command?
- A. Flashback must be enabled for the PRODdatabase.
- B. A most recent backup set of the PRODdatabase must exist.
- C. RMAN must be connected to the target database instance and the auxiliary instance.
- D. The target database must be in MOUNTstate.
Answer: C
Explanation:
Assume that the source database prod is on host1 and stores its data files in a non-ASM file system. The control files for prod are located in /oracle/oradata/prod/.
You want to duplicate the source database to database dupdb on remote host host2.
You want to store the duplicate database files in ASM disk group +DISK1.
After connecting RMAN to the target, duplicate, and recovery catalog databases, run the following RMAN script to duplicate the database.
DUPLICATE TARGET DATABASE TO dupdb
FROM ACTIVE DATABASE
SPFILE
PARAMETER_VALUE_CONVERT '/oracle/oradata/prod/', '+DISK1'
SET DB_CREATE_FILE_DEST +DISK1;
When the DUPLICATE command completes, the duplicate database is created, with data files, online redo log files, and control files in ASM disk group +DISK1.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2017), page 26-7
NEW QUESTION 83
Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2. RMAN is connected to the target database pdb2_1.
Examine the command executed to back up pdb2_1:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of this command?
- A. It fails because the pluggable clause is missing.
- B. It fails because archive log files cannot be backed up using a connection to a PDB.
- C. It succeeds but only the data files belonging to the pdb2_i pluggable database are backed up.
- D. It succeeds and all data files belonging to PD32_i are backed up along with the archive log files.
Answer: D
NEW QUESTION 84
Your database supports an OLTP workload. Examine the output of the query:
SQL> SSLECT target_mttr, estimated_mttr
FROM v$instance_recovery
Target_mttrestimated_mttr
- --------------------- ---------------------------
0 76
To ensure faster instance recovery, you set the fast_start_mttrjtargh:t initialization parameter to 30.
What is the effect of this setting on the database?
- A. The frequency of log switches is increased.
- B. The MTTR advisor is disabled.
- C. Automatic checkpoint tuning is disabled.
- D. The overhead on database performance is increased because of frequent writes to disk.
Answer: C
NEW QUESTION 85
The CATDB12Cdatabase contains an Oracle Database 12c catalog schema owned by the RC12Cuser.
The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user.
A database with DBID=1423241is registered in the CATDB11catalog. Both the recovery catalog databases are open.
In the CATDB12cdatabase, you execute the commands:
What is the outcome of the import?
- A. It fails because RMAN is not connected to the target database with DBID=1423241.
- B. It succeeds but the database is not automatically registered in the RC12ccatalog.
- C. It succeeds and all global scripts in the RC11catalog that have the same name as existing global scripts in the RC12Ccatalog are automatically renamed.
- D. It fails because the target database and recovery catalog database are of different versions.
Answer: D
NEW QUESTION 86
You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs), PDB1 and PDB2. You execute the following commands on CBD$ROOT as the SYS user:
SQL> CREATE USER c##scott IDENTIFIED BY scottorcll;
SQL> GRANT CREATE SESSION TO c##scott user?
Which statement is true about the C##SCOTT user?
- A. It is created in all the PDBs but has the CREATE SESSION privilege only in CDB$ROOT.
- B. It is created and has the CREATE SESSION privilege only in a PDB that is open.
- C. It is created in all the PDBs with the CREATE SESSION privilege.
- D. It is created only in CDB$ROOT and has the CREATE SESSION privilege.
Answer: A
NEW QUESTION 87
View the SPFILE parameter settings in the Exhibit.
You issue this command and get errors:
SQL> startup
ORA-00824:cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information Why did the instance fail to start?
- A. because memory_target and memory_max_target cannot be equal
- B. because statistics_level is set to basic
- C. because pga_aggregate_target is not set
- D. because sga_target and memory_target are both set
Answer: B
NEW QUESTION 88
Which two statements are true about tablespaces in multitenant container databases (CDBs)? (Choose
two.)
- A. Each PDB can have its own default temporary tablespace.
- B. The default permanent tablespace for a PDB can be changed only by a local user with the required
permissions. - C. The amount of space that each PDB can use in a shared temporary tablespace must be set at the CDB
level. - D. The current container must be set to root to create or modify the default temporary tablespace or
tablespace group for a CDB. - E. Default permanent tablespaces can be shared across pluggable databases (PDBs).
Answer: A,D
NEW QUESTION 89
Which two statements are true about a common user? (Choose two.)
- A. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.
- B. A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.
- C. A common user can be granted only a common role.
- D. A common user with the create user privilege can create other common users, as well as local users.
- E. A common user can have a local schema in a PDB.
Answer: D,E
NEW QUESTION 90
You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:
create table employees
(empno number, salary number,
deptid number, name varchar2(100),
period for employee_time);
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)
- A. The valid time columns are not populated by the Oracle Server automatically.
- B. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.
- C. The valid time columns employee_time_start and employee_time_end are automatically created.
- D. The valid time columns are visible by default when the table is described.
- E. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
Answer: A,C,E
Explanation:
Explanation
A: To implement Temporal Validity(TV), 12c offers the option to have two date columns in that table which is having TV enabled using the new clause Period For in the Create Table for the newly created tables or in the Alter Table for the existing ones. The columns that are used can be defined while creating the table itself and will be used in the Period For clause or you can skip having them in the table's definition in the case of which, the Period For clause would be creating them internally.
NEW QUESTION 91
You issue the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which three tasks are performed by the BACKUP DATABASE command? (Choose three.)
- A. backing up only the used blocks in the data files
- B. backing up all used and unused blocks in the data files
- C. switching the online redo log
- D. backing up all data files as image copies and archive logs, and deleting those archive logs
- E. backing up all archived logs and marking them as obsolete
Answer: B,C,D
NEW QUESTION 92
Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)?
- A. Use the DBMS_PDBpackage to plug a pre-Oracle 12c database into an existing CDB.
- B. Use the DBMS_PDBpackage to plug a non-CDB into an existing CDB.
- C. Clone the existing PDB.
- D. Use PDB$SEEDfor creating a PDB.
- E. Use Enterprise Manager Database Express to create a PDB in an existing CDB.
Answer: B,C,D
Explanation:
Explanation/Reference:
Explanation:
Use the CREATE PLUGGABLE DATABASE statement to create a pluggable database (PDB).
This statement enables you to perform the following tasks:
* Create a PDB by using the seed as a template
Use the create_pdb_from_seed clause to create a PDB by using the seed in the multitenant container database (CDB) as a template.
* Create a PDB by plugging an unplugged PDB or a non-CDB into a CDB
Use the create_pdb_from_xml clause to plug an unplugged PDB or a non-CDB into a CDB, using an XML metadata file.
* Create a PDB by cloning an existing PDB or non-CDB
Use the create_pdb_clone clause to create a PDB by copying an existing PDB or non-CDB and then plugging the copy into the CDB.
References: https://docs.oracle.com/database/121/SQLRF/statements_6010.htm
NEW QUESTION 93
Which two statements are true about encrypted backups performed by using RMAN? (Choose two.)
- A. Encrypted backups can only be written to disk.
- B. Transparent encryption of backups uses an encryption wallet.
- C. Image copy backups can be created by using password encryption.
- D. A database uses the same encryption key for every encrypted backup.
- E. A password encryption of backups uses the password while creating and restoring backups.
Answer: B,E
Explanation:
Explanation/Reference:
NEW QUESTION 94
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. full database backup on Sunday, level 0 backup 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 differential incremental level 1 backup on all the other days
- D. level 0 backup on Sunday, differential incrementalbackup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days
Answer: D
NEW QUESTION 95
Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). (Choose three.)
- A. to store backups that would cause the controlfile to become too large
- B. to allow database duplication without a connection to the auxiliary instance
- C. to allow database duplication without a connection to the target instance
- D. to store backup metadata that would cause the controlfile to become too large
- E. to report on the database schema at an earlier point in time
Answer: A,C,E
Explanation:
Explanation
NEW QUESTION 96
The CATDBI2c database contains an Oracle Database 12c catalog schema owned by the rc12c user.
The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RCII user.
A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases are open.
In the CATDB12c database, you execute the commands:
What is the outcome of the import?
- A. It fails because RMAN is not connected to the target database with DBID=1423241.
- B. It succeeds but the database is not automatically registered in the RC12c catalog.
- C. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RC12C catalog are automatically renamed.
- D. It fails because the target database and recovery catalog database are of different versions.
Answer: C
NEW QUESTION 97
Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?
- A. Tables or table partitions with a foreign key cannot be recovered.
- B. Tables with not null constraints cannot be recovered.
- C. Tables or table partitions can be recovered by using an auxiliary instance only.
- D. Tables or table partitions from the system and sysaux tablespaces cannot be recovered.
- E. Tables or table partitions can be recovered only when the database is in mount state.
Answer: C,D
Explanation:
Explanation/Reference:
Explanation:
Reference:
http://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV695 (Limitations of Recovering Tables and Table Partitions from RMAN Backups)
NEW QUESTION 98
Your database instance is started using an SPFILE. You are connected to CDB$ROOT, as a DBA.
You issue:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;
Which two statements are true about the STATISTICS_LEVEL parameter? (Choose two.)
- A. It is immediately set to ALL in the SPFILE and the CDB instance.
- B. It is immediately set to ALL in only those pluggable databases (PDBs) where the value is set to TYPICAL.
- C. It is immediately set to ALL only for CDB$ROOT.
- D. It is set to ALL for all PDBs only in the SPFILE.
- E. It is immediately set to ALL in all PDBs where the STATISTICS_LEVEL parameter is not set.
Answer: A,B
NEW QUESTION 99
LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterpriserole in Oracle Internet Directory(OID). SSL has been configure for the database and OLD and the password file has been
configured for the database.
User scott with sysdba privilege tries to connect remotely using this command:
$sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name.
Which authentication method will be attempted first?
- A. authentication by using the local OS of the database server
- B. authentication by using certificates over SSL
- C. authentication by password file
- D. authentication by using the Oracle Internet Directory
Answer: C
NEW QUESTION 100
You execute the commands to configure settings in RMAN:
Then, you issue the following command to take a backup:
Which statement is true about the execution of these commands?
- A. The backup terminates because the backup destination for disk is not specified in the BACKUPcommand.
- B. It backs up the data files and archived logs to media, making two copies of each data file and archived logs.
- C. It backs up two copies each of the data files to disk and media, and two copies of archived logs to media.
- D. It backup up the data files and archived logs, making one copy of each data file and archived log on disk and media.
Answer: B
Explanation:
Explanation/Reference:
NEW QUESTION 101
Which two statements describe the relationship between a window, a resource plan, and a job class?
(Choose two.)
- A. A window specifies a job class that will be activated when that window becomes active.
- B. A window specifies a resource plan that will be activated when that window becomes active.
- C. A job class specifies a window that will be open when that job class becomes active.
- D. A window in association with a resource plan controls a job class allocation.
- E. A window in association with a job class controls a resource allocation.
Answer: B,E
NEW QUESTION 102
Your database is running in archivelog mode and a nightly backup of the database, along with an
autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the
control files are lost.
Examine the steps to restore the SPFILE and the control file to mount the database:
1. Set DBID of the target database in RMAN.
2. Start the database instance by using the startup force nomount command in RMAN.
3. Restore the control files from the backup.
4. Mount the database.
5. Restore the SPFILE from the autobackup.
6. Create a PFILE from the recovered SPFILE.
7. Restart the instance in nomount state.
Identify the required steps in the correct order.
- A. 1, 2, 3, 5, 6, 4
- B. 2, 1, 5, 7, 3, 4
- C. 2, 1, 5, 6, 7, 4, 3
- D. 1, 2, 5, 3, 6, 4
Answer: B
NEW QUESTION 103
Your multitenant container database (CDB) CDB1that is running in ARCHIVELOGmode contains two
pluggable databases (PDBs), PDB2_1and PDB2_2, both of which are open. RMAN is connected to the
target pluggable database PDB2_1.
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which statement is true about the execution of this command to back up the database?
- A. All data files belonging to PDB2_1are backed up and all archive log files are deleted.
- B. All data files belonging to PDB2_1are backed up along with the archive log files.
- C. This command gives an error because archive log files can be backed up only when RMAN is
connected to the root database. - D. Only the data files belonging to pdb2_1are backed up.
Answer: B
NEW QUESTION 104
......
Preparation Resources
Indeed, Oracle is focused on supporting each candidate and fostering his or her growth and quality training. This is why the official vendor recommends two optional courses to help the students prepare for the Oracle 1Z0-063 test:
- Oracle Database 12c: Backup and Recovery Workshop designed both for administrators and for everyone who wants to evaluate their own recovery skills. During virtual classes, you will get to know how to use Oracle Database recovery procedures and Flashback Technologies along with ways of diagnosing and fixing data failures. Moreover, through this real-time training, each candidate will gain a clear understanding of Oracle Database Cloud Service and learn how to optimize database workloads using backup and recovery procedures. In the end, the knowledge gained in this workshop will guarantee you a fast, reliable, secure, and easy increase in your Oracle database administration performance.
- At the same time, Oracle Database 12c: Managing Multitenant Architecture course will equip candidates with the relevant expertise to successfully pass 1Z0-063 exam by utilizing multitenant architecture. During this class, administrators and architects will discover why and how to create and manage a container database that is multitenant and how to deal with databases that are commonly pluggable, how to manage storage and security, and moreover, how to execute certain operations such as the transportation of Oracle Data Pump including encryption, loading, and auditing. These and other topics regarding managing Multitenant Architecture will be available when you sign up for the Live Virtual Class, which will ultimately aid in passing the Oracle 1Z0-063 test on the first try.
1z0-063 Braindumps Real Exam Updated on Dec 27, 2021 with 278 Questions: https://surepass.actualtests4sure.com/1z0-063-practice-quiz.html
