1Z0-060 Online Practice Questions and Answers

Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:

Which two statements are true about redefining the table? (Choose two.)

A. All the triggers for the table are disabled without changing any of the column names or column types in the table.

B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.

C. VPD policies are copied from the original table to the new table during online redefinition.

D. You must copy the VPD policies manually from the original table to the new table during online redefinition.

Which statement is true about Oracle Net Listener?

A. It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.

B. A single listener can service only one database instance and multiple remote client connections.

C. Service registration with the listener is performed by the listener registration process (LREG) process of each database instance.

D. The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.

E. The listener.ora configuration file must be located in the ORACLE_HOME/network/admin directory.

You plan to migrate your database from a File system to Automatic Storage Management (ASM) on same platform.

Which two methods or commands would you use to accomplish this task? (Choose two.)

A. RMAN CONVERT command

B. Data Pump Export and import

C. Conventional Export and Import

D. The BACKUP AS COPY DATABASE ... command of RMAN

E. DBMS_FILE_TRANSFER with transportable tablespace

Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command:

lsnrctl > STOP

What happens to the sessions that are presently connected to the database Instance?

A. They are able to perform only queries.

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

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

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

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)? (Choose three.)

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 in a table segment

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

Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX? (Choose three.)

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 thread.

D. Each multithreaded Oracle process has an SCMN thread.

E. The local listener may pass the request to an existing process which in turn will create a thread.

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.

You plan to drop the column of a table that has Flashback Archiving enabled.

You want to ensure minimal service disruption.

How would you do this in your Oracle 12c Database?

A. Disable Flashback Archiving, set the column unused, and re-enable Flashback Archiving.

B. Disable Flashback Archiving, drop the column unused, and re-enable Flashback Archiving.

C. Disassociate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure, drop the column, and re-associate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.RESASSOCIATE_FBA procedure.

D. Drop the column using the ALTER TABLE statement.

E. Disassociate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure, set the column unused, and re-associate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.RESASSOCIATE_FBA procedure.

Which statement is true concerning compression during an Online Datafile Move?

A. Only tables may be compressed during the Online Datafile Move.

B. The DBA may choose which objects in the datafile to be moved get compressed.

C. All objects in a data file to be moved will always to be compressed.

D. Uncompressed data files may be moved online to compress the entire file with Hybrid Columnar Compression.

E. If an object is already compressed in the source location, then the compression type for that object remains unchanged after the move.

The workload on your database remains the same between 9 AM and 6 PM on all days of the week.

However, you notice performance degradation between 3 PM and 5 PM on some days.

You want to identify regressed statements by comparing the workload between these two periods.

Examine these steps:

1.

Create a SQL Tuning Set (STS) for the statements cached in the library cache for both periods.

2.

Generate a Compare Period AWR report for both periods.

3.

Run the SQL Performance Analyzer (SPA) on the STS captured for both periods.

4.

Run the SQL Tuning Analyzer on the STS captured for both periods.

5.

Run the SQL Access Advisor on the STS captured for both periods.

6.

Run the Compare Period ADDM report for both periods. Identify the required steps to accomplish the task.

A. 1 and 3

B. 1 and 5

C. 1 and 2

D. only 6

E. 1 and 4

F. only 2