1Z1-060 Exam Training Practice Tests (Oracle Upgrade to Oracle Database 12c)]

Question 1

Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.
You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:
SQL > SHUTDOWN IMMEDIATE
SQL > STARTUP MOUNT
SQL > FLASHBACK DATABASE to TIME "TO_DATE (`08/20/12' , `MM/DD/YY')";
Examine following commands:
1. ALTER PLUGGABLE DATABASE ALL OPEN;
2. ALTER DATABASE OPEN;
3. ALTER DATABASE OPEN RESETLOGS;
Which command or commands should you execute next to allow updates to the flashback back schema?

A. Only 1 B. 1 and 2 C. 3 and 1 D. Only 3 E. Only 2

Correct Answer: C

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 2

Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the PDB HR_PDB. You execute the following command:

What is the result?

A. It executes successfully but neither tablespace nor the data file is created. B. It falls and reports an error because there can be only one undo tablespace in a CDB. C. It executes successfully and creates an UNDO tablespace in HR_PDB. D. It fails and reportsan error because the CONTAINER=ALL clause is not specified in the command. E. It fails and reportsan error because the CONTAINER=CURRENT clause is not specified in the command.

Correct Answer: A

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 3

Which two statements are true regarding single row functions?

A. TRIM: can be used to remove all the occurrences of a character from a string B. TRUNC: can be used with number and date values C. INSTR: can be used to find only the first occurrence of a character in a string D. SYSDATE: returns the database server current date and time E. CONCAT: can be used to combine any number of values F. MOD: returns the quotient of a division

Correct Answer: B,D

Question 4

Examine the current value for the following parameters in your database instance:
SGA_MAX_SIZE = 1024M
SGA_TARGET = 700M
DB_8K_CACHE_SIZE = 124M
LOG_BUFFER = 200M
You issue the following command to increase the value of DB_8K_CACHE_SIZE:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
Which statement is true?

A. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET. B. It succeeds only if memory is available from the autotuned components if SGA. C. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically. D. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

Correct Answer: B

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 5

Identify two valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB).

A. Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED. B. Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEED. C. Use the DBMS_PDB package to plug an Oracle 11 g Release 2 (11.2.0.3.0) non-CDB database into an existing CDB. D. Use the DBMS_PDB package to clone an existing PDB. E. Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB.

Correct Answer: A,D,E

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 6

An application accesses a small lookup table frequently.
You notice that the required data blocks are getting aged out of the default buffer cache.
How would you guarantee that the blocks for the table never age out?

A. Increase the database buffer cache size. B. Configure the RECYCLE bufferpool and alter the table with the corresponding storage clause. C. Configure Automatic Memory Management- D. Configure the KEEP buffer pool and alter the table with the corresponding storage clause. E. Configure Automata Shared Memory Management.

Correct Answer: D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 7

You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy.
One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed.
When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.
Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?

A. Increase the number of ASMB processes. B. Specify the statement that adds the disk back to the disk group. C. Set the DISK_REPAIR_TIME disk attribute to a lower value. D. Increase the value of the ASM_POWER_LIMIT parameter. E. Increase the number of DBWR_IO_SLAVES in the ASM instance.

Correct Answer: B,D

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 8

What are three purposes of the RMAN "FROM SERVICE" clause?

A. to support PUSH-based active database duplication B. to support synchronization of a standby database with the primary database in a Data Guard environment C. to support file restoration over the network in a Data Guard environment D. to support file recovery over the network in a Data Guard environment E. to support active database duplication by taking image copies of the source database

Correct Answer: B,D,E

Question 9

Examine the commands executed to monitor database operations:
$> conn sys oracle/oracle@prod as sysdba
SQL > VAR eid NUMBER
SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (`batch_job' ,
FORCED_TRACKING => `Y');
Which two statements are true?

A. Only DML and DDL statements will be monitored for the session. B. Database operations will be monitored only when they consume a significant amount of resource. C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING. D. Database operations for all sessions will be monitored. E. All subsequent statements in the session will be treated as one database operation and will be monitored.

Correct Answer: C,E

Explanation: Only visible for TrainingDump members. You can sign-up / login (it's free).

Question 10

Which three statements are true about using flashback database in a multitenant container database (CDB)?

A. To enable flashback database, the CDB must be mounted. B. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point. C. The root container can be flashed back without flashing back the pluggable databases (PDBs). D. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB. E. Individual PDBs can be flashed back without flashing back the entire CDB.

Correct Answer: A,B,D

Oracle Upgrade to Oracle Database 12c - 1Z1-060 Exam Practice Test