Upgrade to Oracle Database 12c (1Z0-060) Free Practice Test

Question 1

Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database.
You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted.
What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?

A. Take the USERDATA tablespace offlineinACCOUNTS_PDB.

B. Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDB.

C. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.

D. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.

Correct Answer: A

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

Question 2

In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.
Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?

A. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

B. The movement of all segments to a target tablespace with a higher degree of compression,on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

C. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

D. Setting the target tablespace offline

E. Setting the target tablespace to read-only

Correct Answer: A,E

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

Question 3

Examine the following parameters for a database instance:

Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)

A. JAVA_POOL_SIZE

B. SORT_AREA_SIZE

C. STREAMS_POOL_SIZE

D. DB_16K_CACHE_SZIE

E. DB_KEEP_CACHE_SIZE

F. LOG_BUFFER

Correct Answer: D,E,F

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

Question 4

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB).
The characteristics of the non-CDB are as follows:
- Version:Oracle Database 12c Releases 1 64-bit
- Character set: WE8ISO8859P15
- National character set: AL16UTF16
- O/S: Oracle Linux6 64-bit
The characteristics of the CDB are as follows:
- Version: Oracle Database 12c Release 1 64-bit
- Character set: AL32UTF8
- O/S:OracleLinux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

A. Data Pump full export / import

B. Transportable tablespace

C. Transportable database

D. The DBMS_PDB package

E. RMAN

Correct Answer: B

Question 5

The persistent configuration settings for RMAN have default for all parameters.
Identify four RMAN commands that produce a multi-section backup.

A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;

B. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

C. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;

D. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;

E. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;

F. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;

G. BACKUP SPFILE SECTION SIZE 1M;

Correct Answer: A,B,D,F

Question 6

Which three statements are true about adaptive SQL plan management?

A. It adds new; bettor plans automatically as fixed plans to the baseline.

B. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.

C. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.

D. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.

Correct Answer: B,C,D

Question 7

Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command:
1snrctl > STOP
What happens to the sessions that are presently connected to the database Instance?

A. They are not allowed to perform any operations until the listener LISTENER is started.

B. They are terminated and the active transactions are rolled back.

C. They are able to perform only queries.

D. They are not affected and continue to function normally.

Correct Answer: D

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

Question 8

You must track all transactions that modify certain tables in the sales schema for at least three years.
Automatic undo management is enabled for the database with a retention of one day.
Which two must you do to track the transactions?

A. Create a Flashback Data Archive in any suitable tablespace.

B. Enable supplemental logging for the database.

C. Enable Flashback Data Archiving for the tables that require tracking.

D. Create a Flashback Data Archive in the tablespace where the tables are stored.

E. Specify undo retention guarantee for the database.

Correct Answer: A,C

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

Question 9

Examine this command:
SQL > exec DBMS_STATS.SET_TABLE_PREFS (`SH', `CUSTOMERS', `PUBLISH',
`false');
Which three statements are true about the effect of this command?

A. Statistics collection is not done for the CUSTOMERS table when database stats are gathered.

B. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.

C. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

D. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.

E. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.

Correct Answer: C,D,E

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

Question 10

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 2

B. 3 and 1

C. 1 and 2

D. Only 3

E. Only 1

Correct Answer: B

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

Question 11

You configure your database Instance to support shared server connections.
Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?

A. Location of a part of the runtime area for SELECT statements

B. Stack space

C. Private SQL area

D. User session data

E. Location of the runtime area for DML and DDL Statements

Correct Answer: C,D

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

Question 12

You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.
You issue the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?

A. All users except SYS

B. All users except sys, system, and SCOTT

C. All users except SCOTT

D. All users except sys and SCOTT

Correct Answer: C

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

Welcome to TestSimulate

Oracle Upgrade to Oracle Database 12c (1Z0-060) Free Practice Test