Oracle 1Z0-060 Exam Questions and Answers 2021

NEW QUESTION 1
Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.
Which two RMAN commands may be; used to back up only the PDB1 pluggable database?

• A. BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container
• B. BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container
• C. BACKUP DATABASE while connected to the PDB1 container
• D. BACKUP DATABASE while connected to the boot container
• E. BACKUP PLUGGABLE database PDB1 while connected to PDB2

Answer: AC

NEW QUESTION 2
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?

• A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.
• B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
• C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
• D. Database files stored in ZFS and accessed using conventional NFS mounts.
• E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
• F. Database files stored in any file system and accessed using the Oracle Direct NFS feature
• G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

Answer: AEG

NEW QUESTION 3
Which two statements are true when row archival management is enabled?

• A. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
• B. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
• C. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
• D. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
• E. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.

Answer: CD

NEW QUESTION 4
Examine the following command;
ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?

• A. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
• B. All DDL commands are logged in the alert log file.
• C. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
• D. Only DDL commands that resulted in the creation of new segments are logge
• E. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

Answer: C

NEW QUESTION 5
Which two are true concerning a multitenant container database with three pluggable database?

• A. All administration tasks must be done to a specific pluggable database.
• B. The pluggable databases increase patching time.
• C. The pluggable databases reduce administration effort.
• D. The pluggable databases are patched together.
• E. Pluggable databases are only used for database consolidation.

Answer: CE

NEW QUESTION 6
Which three statements are true about Automatic Workload Repository (AWR)?

• A. All AWR tables belong to the SYSTEM schem
• B. The AWR data is stored in memory and in the database.
• C. The snapshots collected by AWR are used by the self-tuning components in the database
• D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
• E. AWR contains system wide tracing and logging information.

Answer: CDE

NEW QUESTION 7
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 Linux 6 64-bit
The characteristics of the CDB are as follows:
✑ Version: Oracle Database 12c Release 1 64-bit
✑ Character set: AL32UTF8
✑ O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

• A. Transportable database
• B. Transportable tablespace
• C. Data Pump full export / import
• D. The DBMS_PDB package
• E. RMAN

Answer: D

NEW QUESTION 8
To enable the Database Smart Flash Cache, you configure the following parameters:
DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’
DB_FLASH_CACHE_SIZE=64G
What is the result when you start up the database instance?

• A. It results in an error because these parameter settings are invali
• B. One 64G flash cache file will be use
• C. Two 64G flash cache files will be use
• D. Two 32G flash cache files will be use

Answer: A

NEW QUESTION 9
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

NEW QUESTION 10
You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.
The CDB has several pluggable databases (PDBs) open in the read/write mode. There are ongoing transactions in both the CDB and PDBs.
What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?

• A. The shutdown proceeds immediately.The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack.
• B. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.
• C. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.
• D. The statement results in an error because there are open PDBs.

Answer: B

NEW QUESTION 11
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?

• A. Tracking the most recent read time for a table segment in a user tablespace
• B. Tracking the most recent write time for a table segment in a user tablespace
• C. Tracking insert time by row for table rows
• D. Tracking the most recent write time for a table block
• E. Tracking the most recent read time for a table segment in the SYSAUX tablespace
• F. Tracking the most recent write time for a table segment in the SYSAUX tablespace

Answer: ABD

NEW QUESTION 12
You performed an incremental level 0 backup of a database:
RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;
To enable block change tracking after the incremental level 0 backup, you issued this command:
SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
‘ /mydir/rman_change_track.f’;
To perform an incremental level 1 cumulative backup, you issued this command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which three statements are true?

• A. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
• B. The change tracking file must always be backed up when you perform a full database backup.
• C. Block change tracking will always reduce I/O performed during cumulative incremental backups.
• D. More than one database block may be read by an incremental backup for a change made to a single block.
• E. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

Answer: ADE

NEW QUESTION 13
Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:

Which two statements are true?

• A. Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
• B. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
• C. The command will, create a common user whose description is contained in the root and each PD
• D. The schema for the common user C # # A_ADMIN can be different in each container.
• E. The command will create a user in the root container only because the container clause is not use

Answer: CD

NEW QUESTION 14
Which two are prerequisites for performing a flashback transaction?

• A. Flashback Database must be enable
• B. Undo retention guarantee for the database must be configure
• C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
• D. Supplemental logging must be enable
• E. Recycle bin must be enabled for the database.
• F. Block change tracking must be enabled tor the database.

Answer: CD

NEW QUESTION 15
A new report process containing a complex query is written, with high impact on the database. You want to collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.
For the database instance STATISTICS_LEVEL, the initialization parameter is set to
TYPICAL and the CONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.
What should you do to accomplish this task?

• A. Execute the query and view Active Session History (ASH) for information about the query.
• B. Enable SQL trace for the query.
• C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the report.
• D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.

Answer: C

NEW QUESTION 16
The following parameter are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
1. Set the evolve task parameters.
2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.
3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function. Identify the correct sequence of steps:

• A. 2, 4, 5
• B. 2, 1, 4, 3, 5
• C. 1, 2, 3, 4, 5
• D. 1, 2, 4, 5

Answer: B

NEW QUESTION 17
You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12C.
Examine the table definition:

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

• A. The valid time columns employee_time_start and employee_time_end are automatically create
• B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
• C. The valid time columns are not populated by the Oracle Server automatically.
• D. The valid time columns are visible by default when the table is describe
• E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

Answer: ABE

NEW QUESTION 18
You are administering a database stored in Automatic Storage management (ASM). The files are stored in the DATA disk group. You execute the following command:
SQL > ALTER DISKGROUP data ADD ALIAS ‘+data/prod/myfile.dbf’ FOR ‘
+data/prod/myfile.dbf’
What is the result?

• A. The file ‘+dat
• B. 231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.
• C. The file ‘+dat
• D. 231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.
• E. The file ‘+dat
• F. 231.54769’ remains in the same location and a synonym 'myfile.dbf' is create
• G. The file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+dat
• H. 231.54769’ in the data dictionary remove

Answer: C

NEW QUESTION 19
You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements:

What is the result of the last SET CONTAINER statement and why is it so?

• A. It succeeds because the PDB_ADMIN user has the required privileges.
• B. It fails because common users are unable to use the SET CONTAINER statement.
• C. It fails because local users are unable to use the SET CONTAINER statement.
• D. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

Answer: C

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

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

Answer: BDE