Oracle 1z0-063 Dumps - The Sure Way To Pass Exam
1z0-063 Exam Questions (Updated 2021) 100% Real Question Answers
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.
Skills Gaged by 1Z0-063 and Other Key Details
The Oracle 1Z0-063 test measures various skills like the ones detailed below:
- Database failure diagnosis and the use of the automatic diagnostic repository;
- Transporting databases and tablespaces;
- Configuration and management of RMAN;
- Encrypting, monitoring, and securing RMAN backups;
- Performing recovery and restore operations.
- Performing recovery and basic backup;
- Configuring and using the flashback technologies;
- Operating the RMAN Recovery catalog;
The candidates who have taken the Oracle 1Z0-063 exam don’t have to do it again. This is because the Oracle Database 12c Administrator Certified Professional certificate does not have an expiration. So, once you get this designation, you can have confidence in the validation of your qualifications. To take this test, one has to register online at the Pearson VUE website. The exam is taken at Pearson VUE centers. The candidates are supposed to browse through the website to find out the nearest test center where they will take their exams.
Conclusion
Now that you are clearly familiar with all the intricacies of the Oracle Database 12c: Advanced Administration 1Z0-063 exam, namely its objectives, process, and revision materials, you can see how having this certification can affect your future and career development. Even if you are already an Oracle Database 12c Administrator Certified Professional, don't be satisfied with what has been achieved. Set a new goal for yourself in the form of another prestigious certificate, start preparing for the related test with only credible sources, and continue on your career ladder, which will help you see new opportunities and/or stand out from other applicants for your desired position. Take the first step. After all, it is up to you!
NEW QUESTION 108
Examine the statements that use flashback technologies:
1. FLASHBACK TABLEcustomers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00',
'YYYY-MM-DD HH:MI:SS');
2. SELECT * FROM customers AS OF SCN 123456;
3. FLASHBACK TABLE customers TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');
5. SELECT * FROM customers VERSIONS BETWEEM SCN 123456 AND 123999;
6. ALTER TABLE customers FLASHBACK ARCHIVE;
Which set of statements depends on the availability of relevant undo data in the undo tablespace?
- A. 3, 4, 5
- B. 1, 2, 5
- C. 1, 3, 6
- D. 2, 3, 5, 6
Answer: B
NEW QUESTION 109
One of your database runs in ARCHIVELOG mode?
Examine these initialization parameter settings:
Which statement is true based on these settings?
- A. An online redo log will not be overwritten only if an archived log cannot be created in LOG_ARCHIVE_DEST_4.
- B. An online redo log will not be overwritten only if an archived log cannot be created in at least two of the non-mandatory destinations.
- C. An online redo log will not be overwritten only if an archived log cannot be created in at least one of the non-mandatory destinations and LOG_ARCHIVE_DEST_4.
- D. An online redo log will not be overwritten only if an archived log cannot be created in at least two of the non-mandatory destinations and LOG_ARCHIVE_DEST_4.
Answer: A
NEW QUESTION 110
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:
Explanation/Reference:
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 111
Which three statements are true about common roles? (Choose three.)
- A. Object privileges can be granted to a common role in a pluggable database (PDB).
- B. A common role can be granted only to a common user.
- C. Only system privileges can be granted to a common role in a container database (CDB).
- D. A common user that is granted a common role can grant the role to other common and local users in a PDB.
- E. A common role cannot be created by a local user.
Answer: A,D,E
Explanation:
C: Commonly granted privileges that have been made to the common role apply in the root and all PDBs to which the grantor can connect, including PDBs that may be added later on.
D: Common users can both create and grant common roles to other common and local users.
E: Local users cannot create common roles.
Note: A common role is a role that is created in the root; a local role is created in a PDB.
Incorrect Answers:
A: Local users can grant common roles to common and other local users.
References: https://docs.oracle.com/database/121/DBSEG/authorization.htm
NEW QUESTION 112
You want to create a guaranteed restore point for one of your databases by executing the command:
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command.
- A. A database backup must be taken.
- B. Fast Recovery Area must be enabled.
- C. The recyclebin must be enabled for the database.
- D. Undo retention guarantee must be enabled
- E. Flashback Database must be enabled.
- F. The database must be running in ARCHIVELOG mode.
Answer: B,F
NEW QUESTION 113
Which two statements describe the relationship between a window, a resource plan, and a job class? (Choose two.)
- A. A job class specifies a window that will be open when that job class becomes active.
- B. A window in association with a resource plan controls a job class allocation.
- C. A window specifies a job class that will be activated when that window becomes active.
- D. A window specifies a resource plan that will be activated when that window becomes active.
- E. A window in association with a job class controls a resource allocation.
Answer: D,E
NEW QUESTION 114
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?
- 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 withan 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 115
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 116
Which two statements are true about scheduling operations in a pluggable database (PDB)? (Choose two.)
- A. Scheduler objects created by users can be exported or imported using Data Pump.
- B. A job defined in a PDB runs only if that PDB is open.
- C. Scheduler attribute setting is performed only at the CDB level.
- D. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.
- E. Scheduler jobs for a PDB can be created only by common users.
Answer: A,B
NEW QUESTION 117
View the Exhibit showing steps to create a database resource manager plan.
SQL>execute dbms_resource_manager.create_pendingarea();
PL/SQL procedure successfully completed.
SQL>exec dbms_resource_manager, create_consumergroup
(consumer_group=>'OLTP,,comment=>,onlineuser')
PL/SQL procedure successfully completed.
SQL>exec bras resource_manager.create plan(plan=>'PRIU3ER3',comment=>'dssprio'); SQL>exec Dbms_resource_manager.create_plan_directive (plan=>'PRIU3ER3',group_or_subplan=>'OLTP',comment=>'onlinegrp'CPU_Pl=>60); PL/3QLproceduresuccessfullycompleted.
After executing the steps in the exhibit you execute this procedure, which results in an error:
SQL> EXECUTE dbms_resource_manager. validate_pending_area ();
What is the reason for the error?
- A. The sys_group group is not included in the resource plan.
- B. The other_groups group is not included in the resource plan.
- C. The procedure must be executed before creating any plan directive.
- D. The pending area is automatically submitted when creating plan directives.
- E. Pending areas can not be validated until submitted.
Answer: B
NEW QUESTION 118
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)? (Choose three.)
- A. tracking the most recent write time for a table segment in a user tablespace
- B. tracking the most recent read time for a table segment in the sysaux tablespace
- C. tracking the most recent read time for a table segment in a user tablespace
- D. tracking the most recent write time for each block in a table segment
- E. tracking insert time by row for table rows
- F. tracking the most recent write time for a table segment in the sysaux tablespace
Answer: A,C,D
NEW QUESTION 119
Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup? (Choose two.)
- A. Tables or table partitions from the system and sysaux tablespaces cannot be recovered.
- B. Tables or table partitions can be recovered by using an auxiliary instance only.
- C. Tables with not null constraints cannot be recovered.
- D. Tables or table partitions with a foreign key cannot be recovered.
- E. Tables or table partitions can be recovered only when the database is in mount state.
Answer: A,B
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 120
You execute the command to recover your database:
Which statement is true?
- A. It restores all data files from the specified time, and then applies the redo logs.
- B. It restores all data files and control files from the most recent backup taken before the "until time", and then recovers up to the "until time" using any restored archive logs that are needed to complete the task.
- C. It restores the control file and all data files from the most recent backups, and then applies the redo logs up to the "until time".
- D. It restores all data files, redo log files, and control files, and then applies the redo logs up to the specified time.
Answer: B
Explanation:
Explanation
UNTIL TIME = 'date_string' specifies a time as an upper limit. RMAN selects only files that can be used to restore and recover up to but not including the specified time.
RMAN can perform recovery of the whole database to a specified past time, SCN, or log sequence number.
This type of recovery is sometimes called incomplete recovery because it does not completely use all of the available redo. Incomplete recovery of the whole database is also called database point-in-time recovery (DBPITR).
DBPITR requires restoring your database from an older backup, then performing media recovery until your specified target time, SCN or log sequence number. Note that because you need your archived redo log files to perform this process, you cannot perform database point-in-time recovery if you have been running your database in NOARCHIVELOG mode.
References: https://docs.oracle.com/cd/B13789_01/server.101/b10734/rcmrecov.htm
NEW QUESTION 121
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the db_smart_flash_file parameter:
DB_FLASH_CACHE_FILE= ' /dev/f lash_device_1',' /dev/f lash_device_2'
How should the D3_flash_cache_size be configured to use both devices?
- A. Set D3_FLASH_CACHE_SIZE=64G, 64G.
- B. Set D3_FLASK_CACKE_SI2E=i28G.
- C. db_flash_cache_SI2E is automatically configuredby the instance at startup.
- D. Set DB_FLASH_CACHE_SIZE=64G.
Answer: A
Explanation:
* Smart Flash Cache concept is not new in Oracle 12C - DB Smart Flash
Cache in Oracle 11g.
In this release Oracle has made changes related to both initialization parameters used by
DB Smart Flash cache. Now you can define many files|devices and its sizes for "Database
Smart Flash Cache" area. In previous releases only one file|device could be defined.
DB_FLASH_CACHE_FILE = /dev/sda, /dev/sdb, /dev/sdc
DB_FLASH_CACHE_SIZE = 32G, 32G, 64G
So above settings defines 3 devices which will be in use by "DB Smart Flash Cache"
/dev/sda - size 32G
/dev/sdb - size 32G
/dev/sdc - size 64G
New view V$FLASHFILESTAT - it's used to determine the cumulative latency and read
counts of each file|device and compute the average latency
NEW QUESTION 122
Which two statements are true about dropping a pluggable database (PDB)? (Choose two.)
- A. A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs.
- B. The backups associated with a PDB are removed.
- C. A PDB must be in closed state.
- D. A PDB must have been opened at least once after creation.
- E. A PDB must be in mount state or it must be unplugged.
- F. The data files associated with a PDB are automatically removed from disk.
Answer: C,E
NEW QUESTION 123
Your database is running in archivelog mode. Examine the parameters for your database instance:
LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY'
LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch'
LOG_ARCHIVE_DEST_3 ='LOCATIO=/disk3/arch'
LOG_ARCHIVE_DEST _4 ='LOCATIONs/disk4/arch'
LOG_ARCHIVE _MIN_SUCCEED_DEST = 2
While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used.
What happens at the next log switch?
- A. The database instance hangs and the redo log files are not overwritten.
- B. The archived redo log files are written to the fast recovery area until the mandatory destination is made available.
- C. The database instance is shutdown immediately.
- D. The destination set by the log_archive_dest parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.
Answer: D
NEW QUESTION 124
Examine the command to create a pluggable database (PDB):
SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1
FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/') PATH_PREFIX
'/disk2/oracle/pdb2';
Which two statements are true? (Choose two.)
- A. The pluggable database pdb2 is created by cloning pdb1 and is in mount state.
- B. All database objects belonging to common users in PDB1 are cloned in PDB2.
- C. The tablespace specifications of pdb2 are the same as pdb1.
- D. pdb2 is created with its own private undo and temp tablespaces.
- E. Details about the metadata describing pdb2 are stored in an XML file in the '/disk2/oracle/pdb2/' directory.
Answer: A,C
NEW QUESTION 125
A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance? (Choose three.)
- A. Configure large pool if not already done.
- B. Always use synchronous I/O for the database.
- C. Always use RMAN compression for tape backups rather than the compression provided by media manager.
- D. Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.
- E. Set the backup_tape_io_slaves parameter to true.
- F. Remove the rate parameter, if specified, in the allocate channel command.
Answer: A,D,F
Explanation:
Reference:
http://docs.oracle.com/cd/B19306_01/backup.102/b14191/rcmtunin.htm
NEW QUESTION 126
Examine the RMAN command:
RMAN> BACKUP VALIDATE DATABASE;
Which statement is true about the execution of the command?
- A. The database must be running in archivelog mode for the successful execution of this command.
- B. Block change tracking must be enabled before executing this command.
- C. A complete database backup must exist before executing this command.
- D. The command checks for blocks that contain a valid checksum and matching headers and footers, but
that has logically inconsistent contents. - E. The command checks for blocks containing all zeros, an invalid checksum, or a corrupt block header.
Answer: E
NEW QUESTION 127
Examine the statements that use flashback technologies:
1. FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP ('2013-02-04 09:30:00',
'YYYY-MM-DD HH:MI:SS');
2. SELECT * FROM customers AS OF SCN 123456;
3. FLASHBACK TABLE customers TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP ('2013-02-04 09:30:00',
'YYYY-MM-DD HH:MI:SS');
5. SELECT * FROM customers VERSIONS BETWEEM SCN 123456 AND 123999;
6. ALTER TABLE customer FLASHBACK ARCHIVE;
Which set of statements depends on the availability of relevant undo data in the undo tablespace?
- A. 3, 4, 5
- B. 1, 2, 5
- C. 1, 3, 6
- D. 2, 3, 5, 6
Answer: B
NEW QUESTION 128
One of your database runs in ARCHIVELOG mode.
Examine these initialization parameter settings:
Which statement is true based on these settings?
- A. An online redo log will not be overwritten only if an archived log cannot be created in LOG_ARCHIVE_DEST_4.
- B. An online redo log will not be overwritten only if an archived log cannot be created in at least two of the non- mandatory destinations and LOG_ARCHIVE_DEST_4.
- C. An online redo log will not be overwritten only if an archived log cannot be created in at least one of the non-mandatory destinations and LOG_ARCHIVE_DEST_4.
- D. An online redo log will not be overwritten only if an archived log cannot be created in at least two of the non- mandatory destinations.
Answer: A
Explanation:
Explanation/Reference:
NEW QUESTION 129
Users report this error message when inserting rows into the orders table:
ERROR atline1:
ORA-01654f:unable to extend index USERS.ORDERS_IND by 8in tablespace INDEXES
You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database.
Which two must you do to fix this problem without affecting currently executing queries?
- A. coalesce the indexes tablespace
- B. perform an on line table rebuild using dbns_redefir.ition.
- C. coalesce the orders index
- D. rebuild the index online moving it to anothertablespace that has enough free space for the index
- E. drop and re-create the index
Answer: A,E
NEW QUESTION 130
......
Pass Oracle 1z0-063 Exam Quickly With ExamsReviews: https://www.examsreviews.com/1z0-063-pass4sure-exam-review.html