Oracle 1Z0-060 Actual Free Exam Questions & Community Discussion

Identify two valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB).

Examine the parameter for your database instance:

You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:

Identify the reason why the optimizer chose different execution plans.

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command?

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 senior DBA asked you to execute the following command to improve performance:

You checked the data in the SUBSCRIBE_LOGtable and found that it is a large table containing one million rows.
What could be a reason for this recommendation?

What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled?

What are two of the benefits of installing Oracle Grid Infrastructure for a stand-alone server before installing and creating an Oracle database on the same server? (Choose two.)

You create a table with the PERIOD FORclause 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 EMPLOYEEStable?

You are administering a database and you receive a requirement to apply the following restrictions:
1. A connection must be terminated after four unsuccessful login
attempts by user.
2. A user should not be able to create more than four simultaneous
sessions.
3. User session must be terminated after 15 minutes of inactivity.
4. Users must be prompted to change their passwords every 15 days.
How would you accomplish these requirements?

Examine these two statements:

Which three are true about the MRKTtablespace? (Choose three.)

Which three SQL statements would display the value 1890.55 as $1, 890.55?

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

Your database supports a DSS workload that involves the execution of complex queries:
Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.
What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?

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?