You have already completed the Test before. Hence you can not start it again.
Test is loading...
You must sign in or sign up to start the Test.
You have to finish following quiz, to start this Test:
Your results are here!! for" Oracle Database 12c Advanced Administration (1Z0-063) Practice Test 2 "
0 of 65 questions answered correctly
Your time:
Time has elapsed
Your Final Score is : 0
You have attempted : 0
Number of Correct Questions : 0 and scored 0
Number of Incorrect Questions : 0 and Negative marks 0
Average score
Your score
Oracle Database 12c Advanced Administration (1Z0-063)
You have attempted: 0
Number of Correct Questions: 0 and scored 0
Number of Incorrect Questions: 0 and Negative marks 0
You can review your answers by clicking on “View Answers” option.
Important Note : Open Reference Documentation Links in New Tab (Right Click and Open in New Tab).
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
Answered
Review
Question 1 of 65
1. Question
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.
You are administering a database that supports a data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 incremental backups on all the other days of the week. One of the data files is corrupted and the current online redo log file is lost because of a media failure. Which action must you take for recovery?
Examine the parameters for your database instance: NAMEĀ Ā TYPEĀ Ā VALUE āāāāĀ Ā āāāāĀ Ā āāāā āāāāāāāāāāāā optimizer_adaptive_reporting_onlyĀ Ā booleanĀ Ā FALSE optimizer_capture_sql_plan_baselinesĀ Ā booleanĀ Ā FALSE optimizer_dynamic_samplingĀ Ā integerĀ Ā 2 optimizer_features_enableĀ Ā stringĀ Ā 12.1.0.1 Which three statements are true about the process of automatic optimization by using statistics feedback?
RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database: RMAN> DUPLICATE TARGET DATABASE TO dup1 FROM ACTIVE DATABASE NOFILENAMECHECK PASSWORD FILE SPFILE; Which two statements are true about the execution of the duplicate command?
A user issues a query on the sales table and receives the following error: ERROR at line 1: ORA-01565: error in identifying file ā/u0l/app/oracle/oradata/ORCL/temp01.dbfā ORA-27037: unable to obtain file status Which two actions would you take to recover the temporary tablespace?
Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and is affecting undo retention. Which two actions would you take to solve this problem?
Tablespace user_data is a non encrypted tablespace containing tables with data. You must encrypt all data in this tablespace. Which three methods can do this?
Examine the command and its output: SQL> DROP TABLE EMPLOYEE; SQL> SELECT object_name AS recycle_name, original_name, type FROM recyclebin; RECYCLE_NAMEĀ Ā ORIGINAL_NAMEĀ Ā TYPE āāāāāāāĀ Ā āāāāāāāāĀ āāāāāāā binsgk31sj/3akk5hg3j21kl5j3d==$0Ā Ā EMPLOYEEĀ Ā TABLE You then successfully execute the command: SQL> FLASHBACK TABLE āBINSgk31sj/3akk5hg3j21kl5j3d==$0ā TO BEFORE DROP; Which two statements are true?
Correct
Reference:Ā http://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr004.htm#i1020594 Another poorly written question made by Oracle
Incorrect
Reference:Ā http://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr004.htm#i1020594 Another poorly written question made by Oracle
Unattempted
Reference:Ā http://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr004.htm#i1020594 Another poorly written question made by Oracle
Question 12 of 65
12. Question
You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures. You set the value of the initialization parameter resumable_timeout to 3600. Which two statements are true?
Your database is running in archivelog mode and Automatic Undo Management is enabled. Which two tasks should you perform before enabling Flashback Database?
Consider the following scenario for your database: Backup optimization is enabled in RMAN. The recovery window is set to 7 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?
You set the following parameters in the parameter file and restart the database instance: MEMORY_MAX_TARGET=0 MEMORY__TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M Which two statements are true?
Your database supports an OLTP workload. Examine the output of the query: SQL> SELECT target_mttr, estimated_mttr FROM v$instance_recovery; Target_mttrĀ Ā Ā Ā Ā estimated_mttr āāāāāāā- āāāāāāāāā 76 To ensure faster instance recovery, you set the fast_start_mttr_target initialization parameter to 30. What is the effect of this setting on the database?
Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user: SQL> CREATE USER c##a_admin Ā Ā IDENTIFIED BY password Ā Ā DEFAULT TABLESPACE users Ā Ā QUOTA 100M ON users Ā Ā TEMPORARY TABLESPACE temp; Which statement is true about the execution of the command?
You have a production Oracle 12c database running on a host. You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database. The steps in random order: 1. Create directory structures similar to the production database on all new machines. 2. Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database. 3. Create a database clone template for the database. 4. Run the Database Configuration Assistant (DBCA) to create the database. 5. Run OUI in graphical mode on each machine. 6. Run OUI in silent mode using the OUI response file. Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.
You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want to ensure the following: 1. Long-running queries are not affected. 2. No extra space is used. 3. Data manipulation language (DML) operations on the table succeed at all times throughout the process. 4. Unused space is reclaimed both above and below the high water mark. Which alter TABLE option would you recommend?
Examine the commands: SQL> ALTER SESSION SET RECYCLBIN = ON; Session altered. SQL> DROP TABLE emp; — (First EMP table) Total dropped. SQL> CREATE TABLE emp (id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2) ); Table created. You then execute multiple INSERT statements to insert rows into EMP table and drop the table again: SQL> DROP TABLE emp; — (Second EMP table) Table dropped. SQL> FLASHBACK TABLE emp TO BEFORE DROP; Which statement is true about the FLASHBACK command?
You are administering a database that supports data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week. One of the data files is corrupted and the current online redo log file is lost because of a media failure. You want to recover the data file. Examine the steps involved in the recovery process: 1. Shut down the database instance. 2. Start up the database instance in nomount state. 3. Mount the database. 4. Take the data file offline. 5. Put the data file online. 6. Restore the control file. 7. Restore the database. 8. Restore the data file. 9. Open the database with the resetlogs option. 10. Recover the database with the noredo option. 11. Recover the data file with the noredo option. Identify the required steps in the correct order.
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 is PDB 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?
Your database is running in archivelog mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted. Examine the steps to recover the online redo log group and move it to a new location. 1. Restore the corrupted redo log group. 2. Restore the database from the most recent database backup. 3. Perform an incomplete recovery. 4. Relocate the member of the damaged online redo log group to a new location. 5. Open the database with the resetlogs option. 6. Issue a checkpoint and clear the log. Identify the required steps in the correct order.
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 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: $ sqlplus scott/tiger@DB01 as sysdba where DB01 is the net service name. Which authentication method will be attempted first?
RMAN is connected to a target database instance and an auxiliary instance. You execute the command: RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE SECTION SIZE 1G; What is the outcome?
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 dumpfile and datafiles 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.
You accidentally drop the CUSTOMERS table, and then recover it by using the FLASHBACK TABLE command. Which two statements are true about the dependent objects of the CUSTOMERS table?
You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases: $ . oraenv ORACLE-_SID = [oracle] ? cdb1 The oracle base for 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 Copy right (c) 1982, 2013, oracle and/or its affiliates. All rights reserved. Connected to target database: CDB1 (DBID=782249327) RMAN>SELECT name FROM v$tablespace; Which statement is true about the execution of the last command?
Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?
Correct
Incorrect
Unattempted
Question 42 of 65
42. Question
Examine the RMAN commands executed in your database: RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk; RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET; RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; You issue the command: RMAN> BACKUP DATABASE; Which two statements are true about the command?
Correct
Reference: C is Wrong but it is more reasonable than the other answers. https://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta007.htm#i1015382 Attention: RMAN backup sets automatically useĀ unused block compression. Skipping unused data blocks WHEREĀ POSSIBLE enables RMAN to back up datafiles using less space, and can make I/O more efficient. When backing up datafiles into backup sets, RMAN does not include data blocks that have never been allocated. RMAN also skips datafile blocks that do not currently contain data, BUTĀ ONLY IFĀ ALLĀ OFĀ THE FOLLOWINGĀ CONDITIONSĀ APPLY: List of conditions. D is Correct https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup003.htm#i1009642 E: could be right if the question were referring to the first commands only. A: is not correct. You can not say if the database is in archivelog mode or not. B: is no correct. https://docs.oracle.com/database/121/BRADV/rcmconfb.htm#BRADV89400 “… The default backup type for disk is an uncompressed backup set. …” There is no evidence that compression is enabled or not.
Incorrect
Reference: C is Wrong but it is more reasonable than the other answers. https://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta007.htm#i1015382 Attention: RMAN backup sets automatically useĀ unused block compression. Skipping unused data blocks WHEREĀ POSSIBLE enables RMAN to back up datafiles using less space, and can make I/O more efficient. When backing up datafiles into backup sets, RMAN does not include data blocks that have never been allocated. RMAN also skips datafile blocks that do not currently contain data, BUTĀ ONLY IFĀ ALLĀ OFĀ THE FOLLOWINGĀ CONDITIONSĀ APPLY: List of conditions. D is Correct https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup003.htm#i1009642 E: could be right if the question were referring to the first commands only. A: is not correct. You can not say if the database is in archivelog mode or not. B: is no correct. https://docs.oracle.com/database/121/BRADV/rcmconfb.htm#BRADV89400 “… The default backup type for disk is an uncompressed backup set. …” There is no evidence that compression is enabled or not.
Unattempted
Reference: C is Wrong but it is more reasonable than the other answers. https://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta007.htm#i1015382 Attention: RMAN backup sets automatically useĀ unused block compression. Skipping unused data blocks WHEREĀ POSSIBLE enables RMAN to back up datafiles using less space, and can make I/O more efficient. When backing up datafiles into backup sets, RMAN does not include data blocks that have never been allocated. RMAN also skips datafile blocks that do not currently contain data, BUTĀ ONLY IFĀ ALLĀ OFĀ THE FOLLOWINGĀ CONDITIONSĀ APPLY: List of conditions. D is Correct https://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup003.htm#i1009642 E: could be right if the question were referring to the first commands only. A: is not correct. You can not say if the database is in archivelog mode or not. B: is no correct. https://docs.oracle.com/database/121/BRADV/rcmconfb.htm#BRADV89400 “… The default backup type for disk is an uncompressed backup set. …” There is no evidence that compression is enabled or not.
Question 43 of 65
43. Question
In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file. What precaution must you take for the read-only tablespaces before performing an incomplete recovery?
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?
Examine the output: SQL > ARCHIVE LOG LIST Database log mode Archive Mode Automatic archival Enabled Archive Destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 376 Next log sequence to archive 378 Current log sequence 378 Which three types of files are automatically placed in the fast recovery area?
Which three requirements must be met before a tablespace can be transported across different platforms?
Correct
Reference:Ā https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces013.htm#ADMIN10140 SQL> COLUMN PLATFORM_NAME FORMAT A32 SQL> SELECT * FROM V$TRANSPORTABLE_PLATFORM; PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT ———– ——————————– ————– 1 Solaris[tm] OE (32-bit) Big 2 Solaris[tm] OE (64-bit) Big 7 Microsoft Windows IA (32-bit) Little 10 Linux IA (32-bit) Little 6 AIX-Based Systems (64-bit) Big 3 HP-UX (64-bit) Big 5 HP Tru64 UNIX Little 4 HP-UX IA (64-bit) Big 11 Linux IA (64-bit) Little 15 HP Open VMS Little 8 Microsoft Windows IA (64-bit) Little 9 IBM zSeries Based Linux Big 13 Linux 64-bit for AMD Little 16 Apple Mac OS Big 12 Microsoft Windows 64-bit for AMD Little 17 Solaris Operating System (x86) Little 16 rows selected.
Incorrect
Reference:Ā https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces013.htm#ADMIN10140 SQL> COLUMN PLATFORM_NAME FORMAT A32 SQL> SELECT * FROM V$TRANSPORTABLE_PLATFORM; PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT ———– ——————————– ————– 1 Solaris[tm] OE (32-bit) Big 2 Solaris[tm] OE (64-bit) Big 7 Microsoft Windows IA (32-bit) Little 10 Linux IA (32-bit) Little 6 AIX-Based Systems (64-bit) Big 3 HP-UX (64-bit) Big 5 HP Tru64 UNIX Little 4 HP-UX IA (64-bit) Big 11 Linux IA (64-bit) Little 15 HP Open VMS Little 8 Microsoft Windows IA (64-bit) Little 9 IBM zSeries Based Linux Big 13 Linux 64-bit for AMD Little 16 Apple Mac OS Big 12 Microsoft Windows 64-bit for AMD Little 17 Solaris Operating System (x86) Little 16 rows selected.
Unattempted
Reference:Ā https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces013.htm#ADMIN10140 SQL> COLUMN PLATFORM_NAME FORMAT A32 SQL> SELECT * FROM V$TRANSPORTABLE_PLATFORM; PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT ———– ——————————– ————– 1 Solaris[tm] OE (32-bit) Big 2 Solaris[tm] OE (64-bit) Big 7 Microsoft Windows IA (32-bit) Little 10 Linux IA (32-bit) Little 6 AIX-Based Systems (64-bit) Big 3 HP-UX (64-bit) Big 5 HP Tru64 UNIX Little 4 HP-UX IA (64-bit) Big 11 Linux IA (64-bit) Little 15 HP Open VMS Little 8 Microsoft Windows IA (64-bit) Little 9 IBM zSeries Based Linux Big 13 Linux 64-bit for AMD Little 16 Apple Mac OS Big 12 Microsoft Windows 64-bit for AMD Little 17 Solaris Operating System (x86) Little 16 rows selected.
Question 48 of 65
48. Question
View the SPFILE parameter settings in the Exhibit.
You issue this command and get errors:
SQL> startup
ORA-00824: cannot set sga_target due to existing internal settings, see alert log for more information
Why did the instance fail to start?
Correct
Reference:Ā https://docs.oracle.com/database/121/ADMIN/memory.htm#ADMIN11237
TheĀ STATISTICS_LEVELĀ initialization parameter must be set toĀ TYPICALĀ (the default) orĀ ALLĀ for automatic shared memory management to function.
Incorrect
Reference:Ā https://docs.oracle.com/database/121/ADMIN/memory.htm#ADMIN11237
TheĀ STATISTICS_LEVELĀ initialization parameter must be set toĀ TYPICALĀ (the default) orĀ ALLĀ for automatic shared memory management to function.
Unattempted
Reference:Ā https://docs.oracle.com/database/121/ADMIN/memory.htm#ADMIN11237
TheĀ STATISTICS_LEVELĀ initialization parameter must be set toĀ TYPICALĀ (the default) orĀ ALLĀ for automatic shared memory management to function.
Question 49 of 65
49. Question
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?
You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user. You execute the commands: SQL> CREATE USER C##ADMIN IDENTIFIED BY orcll23; SQL> CREATE ROLE C##CONNECT; SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT; SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL; Which statement is true about the c##connect role?
Examine the following set of RMAN commands: RMAN> CONFIGURE CHANNEL c1 DEVICE TYPE DISK FORMAT ā/u02/backup/%Uā; RMAN> RUN { Ā Ā ALLOCATE CHANNEL c2 DEVICE TYPE DISK; Ā Ā EXECUTE SCRIPT arc_backup; } Which statement is true about the RMAN run block execution?
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?
Correct
Reference:Ā https://docs.oracle.com/database/121/TDPPT/tdppt_degrade.htm#TDPPT525 Seems like A or B are correct. Poorly written question made by Oracle. Further investigation shows that B is more appropriate. https://docs.oracle.com/database/121/TDPPT/tdppt_degrade.htm#TDPPT089
Incorrect
Reference:Ā https://docs.oracle.com/database/121/TDPPT/tdppt_degrade.htm#TDPPT525 Seems like A or B are correct. Poorly written question made by Oracle. Further investigation shows that B is more appropriate. https://docs.oracle.com/database/121/TDPPT/tdppt_degrade.htm#TDPPT089
Unattempted
Reference:Ā https://docs.oracle.com/database/121/TDPPT/tdppt_degrade.htm#TDPPT525 Seems like A or B are correct. Poorly written question made by Oracle. Further investigation shows that B is more appropriate. https://docs.oracle.com/database/121/TDPPT/tdppt_degrade.htm#TDPPT089
Question 63 of 65
63. Question
You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format. Which three storage options support the use of HCC?
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 files by 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 datafiles using RMAN recover using backup controlfile command. 6. Start the database instance in nomount state. 7. 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