A fully updated 2022 1z0-063 Exam Dumps exam guide from training expert 2Pass4sure
Provides complete coverage of every objective on exam and exam preparation 1z0-063
What Is 1Z0-063 Exam?
Also known as the Oracle Database 12c: Advanced Administration, 1Z0-063 is intended for the candidates with the working knowledge of Oracle Database 12c including Cloud computing strategies as well as how to backup, develop, and deploy them. Thus, this certification test is designed to validate that the student has the technical skills and expertise to manage and accomplish the implementation of enterprise databases. The test consists of questions that are multiple-choice. The total number of questions asked in this exam is 80, and the candidates are expected to answer all of them within the allocated time, which is 2 hours. The passing score for this exam is 60%. Any person who gets less than 60% doesn’t qualify for this Oracle certificate. According to the Oracle exam policy, such candidates may retake the test after 14 days starting from the day of failing the exam.
NEW QUESTION 54
Which two are prerequisites for setting up Flashback Data Archive?
- A. Fast Recovery Area should be defined.
- B. Supplemental logging should be enabled.
- C. Undo retention guarantee should be enabled.
- D. Automatic Undo Management should be enabled.
- E. The tablespace in which the Flashback Data Archive is created should have Automatic Segment Space Management (ASSM) enabled.
- F. All users using Flashback Data Archive should have unlimitedquota on the Flashback Data Archive tablespace.
Answer: D,E
Explanation:
Reference:http://www.oracle.com/technetwork/database/focus-areas/storage/total-recallwhitepaper-171749.pdf(page 8)
NEW QUESTION 55
You issue the RMAN command:
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;
Which statement is true about the execution of the command?
- A. RMAN always performs this type of backup in parallel.
- B. RMAN uses multiplexing to perform the backup.
- C. The resulting backupset has backup pieces that cannot exceed 300 MB.
- D. The backup succeeds only if the USERS tablespace is locally managed.
- E. The backup set size is limited to 300 MB.
Answer: C
NEW QUESTION 56
You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs).
You have already created a test system to support the consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.
What is the easiest way to perform capacity planning for consolidation?
- A. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Performance Analyzer on the test system
- B. capturing the workload on the production systemand using Consolidated Database Replay to replay the workload of all production systems simultaneously for all PDBs
- C. capturing the workload on the production system and replaying the workload for one PDB at a time on the test system
- D. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Tuning Advisor on thetest system
Answer: D
NEW QUESTION 57
Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.
SQL> SELECT name, active_sessions, queue_length,
consumed_cpu_time, cpu_waits, cpu_wait_time
FROM v$rsrc_consumer_group;
Which two statements are true? (Choose two.)
- A. A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.
- B. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
- C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
- D. An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.
- E. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.
Answer: A,C
NEW QUESTION 58
Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). (Choose three.)
- A. to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause
- B. to store backup information of multiple databases in one place
- C. to store RMAN scripts that are available to any RMAN client that can connect to target databasesregistered in the recovery catalog
- D. to automatically delete obsolete backups after a specified period of time
- E. to restrict the amount of space that is used by backups
Answer: A,B,C
NEW QUESTION 59
You execute the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2;
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/disk1/%U;
RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/disk2/%U;
RMAN>BACKUP DATABASE;
Which statement is true about the backup set created by the BACKUP command?
- A. Two channels are allocated and backup pieces for the backup set are created in both the specified destinations.
- B. Two channels are allocated and two copies of the backup set are taken in parallel in both locations.
- C. The default channel is allocated and the backup set is created in only one destination.
- D. Two channels are allocated and a copy of the backup set is taken in the location specified by CHANNEL 2.
Answer: D
NEW QUESTION 60
Which two can be backed up by using RMAN in a database that is in ARCHIVELOGmode? (Choose two.)
- A. data files while the database is in NOMOUNTstate
- B. data blocks in data files that have changed since the previous backup
- C. PFILE and password file in MOUNTstate
- D. online redo log files while the database is open
- E. data files while the database is open
Answer: B,E
NEW QUESTION 61
Your database is running in archivelog mode and Automatic Undo Management is enabled.
Which two tasks should you perform before enabling Flashback Database?
- A. Enable undo retention guarantee.
- B. Enable minimal supplemental logging.
- C. Enable the recyclebin.
- D. Enable Fast Recovery Area.
- E. Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.
Answer: B,C
NEW QUESTION 62
Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.
SQL> SELECT name, active_sessions, queue_length,
consumed_cpu_time, cpu_waits, cpu_wait_time
FROM v$rsrc_consumer_group;
Which two statements are true? (Choose two.)
- A. A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued.
- B. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error.
- C. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management.
- D. An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error.
- E. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.
Answer: A,C
NEW QUESTION 63
You issue commands in SQL*Plus as the Oracle owner, to enable multithreading for your UNIX-based Oracle 12c database:
CONNECT/AS SYSDBA
ALTER SYSTEMSETTHREADED__EXECUTION= TRUESCOPE=SPFILE;
SHUTDOWNIMMEDIATE
You then restart the instance and get an error:
STARTUP
ORA-01031:insufficientprivileges
Why does the startup command return the error shown?
- A. because the threaded architecture requires exiting from sql*pIus and reconnectingwith sql*PIus / as sysdba before issuing a startup command
- B. because the threaded architecture requires connecting to the instance via a listener before issuing a startup command
- C. because the threaded architecture requires restarting the listener before issuing astartup command
- D. because the threaded architecture requires authentication using a password file before issuing a startup command
- E. because the threaded architecture requires issuing a new connect / as sysdba from within sql*pIus before issuing a startup command
Answer: D
NEW QUESTION 64
LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory (OID).
SSL has been configured for the database and OID 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 password file
- C. authentication by using certificates over SSL
- D. authentication by using the Oracle Internet Directory
Answer: B
NEW QUESTION 65
Your database has a table CUSTOMERSthat contains the columns CUST_NAME, AMT_DUE, and OLD_STATUS.
Examine the commands executed and their output:
Why is it that only one update is listed by the Flashback Version Query?
- A. Undo retention guarantee is not enabled.
- B. The DB_FLASHBACK_RETENTION_TARGETparameter is set to a lower value and the undo data pertaining to the first transaction is flushed out.
- C. Supplemental logging is not enabled for the database.
- D. Flashback Data Archive is full after the first update statement.
- E. The undo data that existed for versions of rows before the change to the table structure is invalidated.
Answer: E
NEW QUESTION 66
Which three requirements must be met before a tablespace can be transported across different platforms?
- A. The platforms of both the source and target databases must have the same endian format.
- B. The minimum compatibility level for both the source and target databases must be
10.0.0. - C. The compatible parameter value must be the same in the source and target databases.
- D. The tablespace to be transported must be in read-only mode.
- E. Both the source and target databases must use the same character set.
Answer: A,B,C
NEW QUESTION 67
Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.)
- A. You can compress data but not metadata during export.
- B. You can rename tables during import.
- C. You cannot export data from a remote database.
- D. You can overwrite existing dump files during export.
Answer: B,D
NEW QUESTION 68
Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.
How would you achieve this?
- A. by using the RMAN SWITCHcommand to set the new location for the data files
- B. by using the RMAN DUPLICATEcommand with NOFILENAMECHECKto recover the database to the new host
- C. by using the RMAN DUPLICATEcommand with DBIDand SET NEWNAME FOR TABLESPACEto recover the database to the new host
- D. by creating a new database in the new host, and then using the RMAN RECOVERcommand
Answer: B
NEW QUESTION 69
You want to move your existing recovery catalog to another database.
Examine the steps:
1)Export the catalog data by using the Data Pump Export utility in the source database.
2) Create a recovery catalog user and grant the necessary privileges in the target
database.
3) Create a recovery catalog by using the create catalog command.
4)Import the catalog data into the new recovery catalog by using the Data Pump Import
utility in the target database.
5)Import the source recovery catalog schema by using the import catalog command.
6)Connect to the destination database.
7) Connect as catalog to the destination recovery catalog schema.
Identify the option with the correct sequence for moving the recovery catalog.
- A. 1, 2, 3, 6, 5
- B. 2, 3, 7, 5
- C. 1, 2, 6, 4
- D. 1, 6, 4
Answer: C
NEW QUESTION 70
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. RMAN must be connected to the target database instance and the auxiliary instance.
- B. The target database must be in MOUNTstate.
- C. Flashback must be enabled for the PRODdatabase.
- D. A most recent backup set of the PRODdatabase must exist.
Answer: A
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 71
Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):
Which statement is true about granting the SELECT privilege on the DBA_USERS view to the c##ROLE1 role?
- A. The command succeeds and the common user C##ADMIN can create a session in CDB$ROOT and all the PDBs, but can only query the DBA_USERS view in CDB$ROOT.
- B. The command succeeds and the common user C##ADMIN can create a session and query the DBA_USERS view in CDB$ROOT and all the PDBs.
- C. The command succeeds and the common user C##ADMIN can create a session and query the DBA_USERS view only in CDB$ROOT.
- D. The command fails and gives an error because object privileges cannot be granted to a common user.
- E. The command fails because CONTAINER is not set to CURRENT.
Answer: B
NEW QUESTION 72
Examine the command:
Which statement is true about the execution of the command?
- A. 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.
- B. It fails because no absolute path 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 fails because the log file parameter is not specified.
Answer: B
NEW QUESTION 73
Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB HR_PDB, the common user C##ADMINand the local user B_ADMINhave only the CONNECT privilege.
You create a common role C##ROLE1with the CREATE ANY TABLEand SELECT ANY TABLEprivileges.
You then execute the commands:
Which two statements are true? (Choose two.)
- A. C##ADMINcan create and select any table in the root container and all the PDBs.
- B. B_ADMINcan create and select any table in both the root container and HR_PDB.
- C. C##ADMINcan create and select any table, and grant the C##ROLE1role to users only in the root container.
- D. B_ADMINcan create and select any table only in HR_PDB.
- E. The GRANT c##role1 TO b_admincommand returns an error because CONTAINERshould be set to ALL.
Answer: A,D
NEW QUESTION 74
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
Examine the steps required to perform the migration:
1. Use Data Pump export to perform a full transportable export on the source database with the export parameter VERSION=12.
2. Place all tablespaces in read-only mode on the source database.
3. Upgrade the source database to Oracle Database 12c.
4. Copy the dump file and data files to the desired location in the target database.
5. Create a new PDB in the target CDB.
6. Synchronize the PDB on the target CDB.
7. Use Data Pump import on the new PDB by using the full transportable import options.
Identify the required steps in the correct order.
- A. 3, 2, 5, 1, 4, and 7
- B. 2, 5, 1, 4, 7, and 6
- C. 2, 1, 3, 5, 7, and 6
- D. 1, 5, 4, 7, and 6
Answer: B
Explanation:
Explanation
This example is a dumpfile-based full transportable export/import operation. In this case the metadata from the source database is exported to a dump file, and both the dump file and the tablespace data files are transferred to a new system. The steps would be as follows:
* (2) Set user tablespaces in the source database to READ ONLY.
* (5) Create a CDB on the destination system, including a PDB into which you will import the source database.
* (1) From the Oracle Database 11g Release 2 (11.2.0.3) environment, export the metadata and any data residing in administrative tablespaces from the source database using the FULL=Y and TRANSPORTABLE=ALWAYS parameters. Note that the VERSION=12 parameter is required only when exporting from an Oracle Database 11g Release 2 database.
* (4) Copy the tablespace data files from the source system to the destination system.
* (7) In the Oracle Database 12c environment, connect to the pre-created PDB and import the dump file.
http://www.oracle.com/technetwork/database/upgrade/upgrading-oracle-database-wp-12c-1896123.pdf, page 11
NEW QUESTION 75
RMAN is configured to create backupset backups for your database. You issue the command to back up the database:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which two statements are true about the backup performed by the command? (Choose two.)
- A. Only the used blocks in the data files are backed up.
- B. It backs up all the archived log files and deletes the ones that were just backed up.
- C. It backs up all archived redo log files and online log files and deletes the archived log files after the backup is complete.
- D. It backs up only those archived log files that are not backed up at least once.
- E. It backs up all the data files and deletes obsolete backups after the backup is complete.
Answer: B,E
Explanation:
Explanation/Reference:
Explanation:
You can use BACKUP ... DELETE to back up archived redo logs, data file copies, or backup sets and then delete the input files after successfully backing them up.
The BACKUP ARCHIVELOG ... DELETE INPUT command deletes archived log files after they are backed up. This command eliminates the separate step of manually deleting archived redo logs.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2017), page 9-
31
NEW QUESTION 76
You are administering a multitenant container database (CDB) cdb1 that is running in
archivelog mode and contains pluggable databases (PDBs), pdb_i and pdb_2.
While opening pdb_1, you get an error:
SQL> alter pluggable database pdb_1 open;
ORA-011S7:cannotidentify/lockdatafile11-seeDBWRtracefile
ORA-01110:data file 11:'/u01/app/oracle/oradata/cdb1/pcb_1/example01.dbf'
To repair the failure, you open an RMAN session for the target database CDBSROOT. You
execute the following as the first command:
RMAN>REPAIRFAILURE;
Which statement describes the consequence of the command?
- A. The command produces an errorbecause the advise failure command was not executed before the REPAIRFAILUER command.
- B. The command performs the recovery and closes the failure.
- C. The command produces an error because RMAN is not connected to the target database pdb_1.
- D. The command executes successfully, performs recovery, and opens PDB_1.
Answer: D
NEW QUESTION 77
Examine the command:
Which statement is true about the execution of the command?
- A. 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.
- B. It fails because no absolute path 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 fails because the log file parameter is not specified.
Answer: A
NEW QUESTION 78
You issue the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RKAN> 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?
- A. backing up all data files as image copies and archive log files, and deleting those archive log files
- B. backing up only the used blocks in the data files
- C. switching the online redo log file
- D. backing up allarchived log files and marking them as obsolete
- E. backing up all used and unused blocks in the data files
Answer: B,C,D
NEW QUESTION 79
......
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:
- 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.
- 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.
Tested Material Used To 1z0-063: https://www.2pass4sure.com/12c/1z0-063-actual-exam-braindumps.html