Free 12c 1z0-063 Ultimate Study Guide (Updated 278 Questions)
Get to the Top with 1z0-063 Practice Exam Questions
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.
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.
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.
NEW QUESTION 106
RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database:
Which two statements are true about the execution of the duplicate command? (Choose two.)
- A. All archive redo log files are automatically copied to the duplicate database.
- B. The duplicate database is created by using the backups created during the execution of the DUPLICATE command.
- C. The password file and SPFILE for the duplicate database DUP1are created in their respective default locations.
- D. The duplicate database is created without using RMAN backups and PROD1is allowed to remain open during duplication.
- E. The duplicate database has the same directory structure as the source database.
Answer: D,E
NEW QUESTION 107
You are connected to a pluggable database (PDB) as a common user with the SYSDBA privilege. The PDB is open and you issue the SHUTDOWN IMMEDIATE command.
What is the outcome?
- A. The command results in an error because the PDB can be shut down only by a local user.
- B. The command executes only if the common user is granted the SET CONTAINER privilege for the PDB.
- C. The PDB is closed and left in the unmount state.
- D. The PDB is closed and left in the mount state.
Answer: C
NEW QUESTION 108
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 109
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 all PDBs where the statistics_level parameter is not set.
- B. It is immediately set to all in the SPFILE and the CDB instance.
- C. It is immediately set to all in only those pluggable databases (PDBs) where the value is set to typical.
- D. It is set to all for all PDBs only in the SPFILE.
- E. It is immediately set to all only for cd3Sroot.
Answer: B,C
NEW QUESTION 110
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 111
Which two statements are true about unified auditing? (Choose two.)
- A. Unified auditing is enabled by executing make -f ins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME.
- B. Unified auditing is enabled by setting the audit_trail parameter to db, extended.
- C. A unified audit trail captures audit information from unified audit policies and audit settings.
- D. Audit records are created for all users except sys.
- E. Audit records are created only for the DML and DDL operations performed on database objects.
- F. A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.
Answer: A,C
NEW QUESTION 112
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 have been opened at least once after creation.
- D. A PDB must be in MOUNTstate or it must be unplugged.
- E. The data files associated with a PDB are automatically removed from disk.
- F. A PDB must be in closed state.
Answer: A,D
Explanation:
Explanation
Explanation:
Unplugging a PDB
The following prerequisites must be met:
The current user must have SYSDBA or SYSOPER administrative privilege, and the privilege must be either commonly granted or locally granted in the PDB. The user must exercise the privilege using AS SYSDBA or AS SYSOPER at connect time.
The PDB must have been opened at least once.
The PDB must be closed. In an Oracle Real Application Clusters (Oracle RAC) environment, the PDB must be closed on all instances.
Dropping a PDB
The DROP PLUGGABLE DATABASE statement drops a PDB. You can drop a PDB when you want to move the PDB from one CDB to another or when you no longer need the PDB. - THIS MAKES C CORRECT.
When you drop a PDB, the control file of the CDB is modified to eliminate all references to the dropped PDB.
Archived redo log files and backups associated with the PDB are not removed, but you can use Oracle Recovery Manager (RMAN) to remove them.
When dropping a PDB, you can either keep or delete the PDB's data files by using one of the following clauses:
KEEP DATAFILES, the default, retains the data files.
The PDB's temp file is removed even when KEEP DATAFILES is specified because the temp file is no longer needed.
INCLUDING DATAFILES removes the data files from disk.
If a PDB was created with the SNAPSHOT COPY clause, then you must specify INCLUDING DATAFILES when you drop the PDB.
The following prerequisites must be met:
The PDB must be in mounted mode, or it must be unplugged.
NEW QUESTION 113
Examine the output: SQL > ARCHIVE LOGLIST Database log modeArchive Mode
Automatic archivalEnabled Archive DestinationUSE_DB_RECOVERY_FILE_DEST
Oldest online log sequence376
Next log sequence to archive378
Current log sequence378
Which three types of files are automatically placed in the fast recovery area?
- A. Flashback data archives (FDA)
- B. Archived redo log files
- C. Server parameter file (SPFILE)
- D. Recovery Manager (RMAN) backup pieces
- E. Control file autobackups
Answer: B,D,E
Explanation:
Reference:http://docs.oracle.com/cd/E11882_01/backup.112/e10642/glossary.htm#BRADV 526
NEW QUESTION 114
You are administering a multitenant container database (CDB) cdb1 that has multiple pluggable databases (PDBs). As the sys user on cdb$root, you execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orc1123;
SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL;
SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;
Which two statements are true about the c##admin user that is created in all PDBs?
- A. It can create only local users in all the PDBs.
- B. It can create only local users in the CDB.
- C. It can create common users only when it is logged in to the CDB.
- D. It has a common schema for all the PDBs.
- E. It can be granted only common roles in the PDBs.
Answer: A,D
NEW QUESTION 115
Consider the following scenario for your database:
Backup optimization is enabled in RMAN.
The recovery window is set to seven days in RMAN.
The most recent backup to disk for the tools tablespace was taken on March 1, 2013.
The tools tablespace is read-only since March 2, 2013.
On March 15, 2013, you issue the RMAN command to back up the database to disk.
Which statement is true about the backup of the tools tablespace?
- A. RMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media.
- B. RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.
- C. The RMAN backup fails because the tools tablespace is read-only.
- D. RMAN skips the backup of the tools tablespace because backup optimization is enabled.
Answer: B
NEW QUESTION 116
Which two result in an inconsistent backup? (Choose two.)
- A. a user-managed backup taken for a closed database in NOARCHIVELOG mode
- B. an RMAN full backup taken for a database in NOARCHIVELOG mode
- C. a backup taken immediately after a SHUTDOWN ABORT command
- D. a differential incremental backup
- E. an RMAN backup taken for an open database in ARCHIVELOG mode
Answer: B,C
NEW QUESTION 117
RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database:
Which two statements are true about the execution of the duplicate command? (Choose two.)
- A. All archive redo log files are automatically copied to the duplicate database.
- B. The password file and SPFILE for the duplicate database DUP1are created in their respective default locations.
- C. The duplicate database is created without using RMAN backups and PROD1is allowed to remain open during duplication.
- D. The duplicate database has the same directory structure as the source database.
- E. The duplicate database is created by using the backups created during the execution of the DUPLICATEcommand.
Answer: C,D
NEW QUESTION 118
Which three statements are true about Oracle Restart? (Choose three.)
- A. It runs periodic check operations to monitor the health of Oracle components.
- B. It can be used to only start Oracle components.
- C. While starting any components, it automatically attempts to start all dependencies first and in proper order.
- D. It can be configured to automatically restart a database in case of normal shutdown of the database instance.
- E. It can be configured to automatically attempt to restart various components after a hardware or software failure.
Answer: A,C,E
Explanation:
Explanation/Reference:
Explanation:
Reference:
http://docs.oracle.com/cd/E18283_01/server.112/e17120/restart001.htm
NEW QUESTION 119
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. Set DB_FLASH_CACHE_SIZE=64G.
- D. db_flash_cache_SI2E is automatically configured by the instance at startup.
Answer: A
Explanation:
Explanation/Reference:
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 120
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 121
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:
$ . oraenv ORACLE_SID = [oracle] ? cdb1 The oraclebasefor ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is
/u01/app/oracle $ rman target / Recovery Manager : Release 12.1.0.0.2 - production on Fri Ju1 19 05:18:33: 2013
Coppyright (c) 1982, 2013, oracle and/or its affiliates. All rights reserved.
Connected to target database:CDB1 (DBID=782249327)
RMAN>SELECT name FROMv$tablespace;
Which statement is true about the execution of the last command?
- A. It succeeds and displays all the tablespaces that belong to the root database.
- B. It succeeds and displays all the tablespaces that belong to the root and pluggable databases.
- C. It fails and returns an error because a connection is not made by using the sysdba privilege.
- D. It fails and returns an error because SQL commands cannot be executed at the RMAN prompt.
Answer: A
NEW QUESTION 122
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;
Which two are required for the successful execution? (Choose two.)
- A. The database must be opened.
- B. The Fast Recovery Area must be configured.
- C. The database must be in ARCHIVELOG mode.
- D. The database must be mounted.
- E. Flashback Database must be enabled.
- F. Undo retention guarantee must be enabled.
Answer: B,C
Explanation:
Explanation/Reference: https://docs.oracle.com/cd/B19306_01/backup.102/b14192/rpfbdb002.htm
NEW QUESTION 123
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?
- A. By default, EM express is available for a database after database creation.
- B. You cannot start up or shut down a database instance by using create and configure pluggable
databases by using EM express. - C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
- D. You can use EM express to manage multiple databases running on the same server.
- E. You can create and configure pluggable databases by using EM express.
Answer: B
NEW QUESTION 124
......
Pass Oracle 1z0-063 exam - questions - convert Tets Engine to PDF: https://www.suretorrent.com/1z0-063-exam-guide-torrent.html