Master the 1z0-060 Upgrade to Oracle Database 12c content and be ready for exam day success quickly with this Exambible 1z0-060 testing engine. We guarantee it!We make it a reality and give you real 1z0-060 questions in our Oracle 1z0-060 braindumps.Latest 100% VALID Oracle 1z0-060 Exam Questions Dumps at below page. You can use our Oracle 1z0-060 braindumps and pass your exam.

Q41. 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?

A. Compare Period ADDM report

B. AWR Compare Period report

C. Active Session History (ASH) report

D. Taking a new snapshot and comparing it with a preserved snapshot

Answer: B


Q42. You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.

You plan to create the database using SQL statements. 

Which three techniques can you use to achieve this?

A. Use Oracle Managed Files (OMF).

B. Specify the SEED FILE_NAME_CONVERT clause.

C. Specify the PDB_FILE_NAME_CONVERT initialization parameter.

D. Specify the DB_FILE_NAMECONVERT initialization parameter.

E. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF).

Answer: ABC


Q43. In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.

How would you accomplish this?

A. Setting a metric threshold

B. Implementing Database Resource Manager

C. Enabling resumable timeout for user sessions

D. Decreasing the value of the IDLE_TIME resource limit in the default profile

Answer: D


Q44. 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. Only 2

C. Only 3

D. 3 and 1

E. 1 and 2

Answer: D


Q45. Your multitenant container database (CDB) contains a pluggable database, HR_PDB.  The default permanent tablespace in HR_PDB is USERDATA.  The container database (CDB) is open and you connect RMAN.

You want to issue the following RMAN command: 

RMAN > BACKUP TABLESPACE hr_pdb:userdata;

Which task should you perform before issuing the command?

A. Place the root container in ARHCHIVELOG mode.

B. Take the user data tablespace offline.

C. Place the root container in the nomount stage.

D. Ensure that HR_PDB is open.

Answer: A


Q46. Identify two situations in which the alert log file is updated. 

A. Running a query on a table returns ORA-600: Internal Error.

B. Inserting a value into a table returns ORA-01722: invalid number.

C. Creating a table returns ORA-00955: name us already in used by an existing objects.

D. Inserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated. 

E. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.

Answer: AE


Q47. Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB. 

B. In a PDB plan, subplans may be used with up to eight consumer groups.

C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB. 

D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated. 

E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Answer: AE


Q48. Which two statements are true about Oracle Managed Files (OMF)?

A. OMF cannot be used in a database that already has data files created with user- specified directions.

B. The file system directions that are specified by OMF parameters are created automatically.

C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.

D. OMF automatically creates unique file names for table spaces and control files.

E. OMF may affect the location of the redo log files and archived log files.

Answer: DE


Q49. You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.

Which statement is true?

A. The ORACLE_BASE base parameter is not set.

B. The installation is being performed by the root user.

C. The operating system group that is specified should have the root user as its member.

D. The operating system group that is specified must have permission to write to the inventory directory.

Answer: D


Q50. You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).

Examine the query and its output:

Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?

A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.

B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.

D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

E. Re-create the password file in the Oracle Database 12c format.

Answer: BD