Oracle 1Z0-060 Exam Questions 2021

NEW QUESTION 1
Examine the contents of SQL loader control file:

Which three statements are true regarding the SQL* Loader operation performed using the control file?

• A. An EMP table is created if a table does not exis
• B. Otherwise, if the EMP table is appended with the loaded dat
• C. The SQL* Loader data file myfile1.dat has the column names for the EMP table.
• D. The SQL* Loader operation fails because no record terminators are specifie
• E. Field names should be the first line in the both the SQL* Loader data files.
• F. The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

Answer: ABE

NEW QUESTION 2
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 3
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 PD
• 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 CD
• D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculate
• 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

NEW QUESTION 4
What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?

• A. Effectively implements role separation
• B. Enables you to take advantage of Oracle Managed Files.
• C. Automatically registers the database with Oracle Restart.
• D. Helps you to easily upgrade the database from a prior release.
• E. Enables the Installation of Grid Infrastructure files on block or raw devices.

Answer: CE

NEW QUESTION 5
In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation.
How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?

• A. It collects data from SGA and compares it with a preserved snapshot.
• B. It collects data from SGA, analyzes it, and provides a report.
• C. It collects data from SGA and compares it with the latest snapshot.
• D. It collects data from both SGA and PGA, analyzes it, and provides a report.

Answer: B

NEW QUESTION 6
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 7
A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:

There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?

• A. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
• B. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
• C. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiate
• D. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
• E. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succee

Answer: B

NEW QUESTION 8
You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform?

• A. Parallel compilation of only the stored PL/SQL code
• B. Sequential recompilation of only the stored PL/SQL code
• C. Parallel recompilation of any stored PL/SQL code
• D. Sequential recompilation of any stored PL/SQL code
• E. Parallel recompilation of Java code
• F. Sequential recompilation of Java code

Answer: CE

NEW QUESTION 9
Examine the following query output:

You issue the following command to import tables into the hr schema:
$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr
TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?

• A. All database operations performed by the impdp command are logge
• B. Only CREATE INDEX and CREATE TABLE statements generated by the import are logge
• C. Only CREATE TABLE and ALTER TABLE statements generated by the import are logge
• D. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logge

Answer: C

NEW QUESTION 10
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. User session data
• B. Stack space
• C. Private SQL area
• D. Location of the runtime area for DML and DDL Statements
• E. Location of a part of the runtime area for SELECT statements

Answer: AC

NEW QUESTION 11
Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX?

• A. Thread creation must be routed through a dispatcher process
• B. The local listener may spawn a now process and have that new process create a thread
• C. Each Oracle process runs an SCMN threa
• D. Each multithreaded Oracle process has an SCMN threa
• E. The local listener may pass the request to an existing process which in turn will create a threa

Answer: ADE

NEW QUESTION 12
You execute the following commands to audit database activities:
SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;
SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL;
Which statement is true about the audit record that generated when auditing after instance restarts?

• A. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
• B. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.
• C. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.
• D. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables use
• E. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and bind variables use

Answer: D

NEW QUESTION 13
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 14
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 15
Identify three benefits of Unified Auditing.

• A. Decreased use of storage to store audit trail rows in the database.
• B. It improves overall auditing performance.
• C. It guarantees zero-loss auditing.
• D. The audit trail cannot be easily modified because it is read-only.
• E. It automatically audits Recovery Manager (RMAN) events.

Answer: BDE

NEW QUESTION 16
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyze impact on the performance of SQL statements.

• A. Change in the Oracle Database version
• B. Change in your network infrastructure
• C. Change in the hardware configuration of the database server
• D. Migration of database storage from non-ASM to ASM storage
• E. Database and operating system upgrade

Answer: ACE

NEW QUESTION 17
Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called temp01.tmp.
A user issues a query on a table on one of the PDBs and receives the following error: ERROR at line 1:
ORA-01565: error in identifying file ‘/u01/app/oracle/oradata/CDB1/temp01.tmp’
ORA-27037: unable to obtain file status
Identify two ways to rectify the error.

• A. Add a new temp file to the temporary tablespace and drop the temp file that that produced the error.
• B. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
• C. Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and then bring the temporary tablespace online.
• D. Shutdown the database instance, restore and recover the temp file from the backup, and then open the database with RESETLOGS.
• E. Shut down the database instance and then restart the CDB and PDBs.

Answer: AE