1Z0-060 Practice Questions

You notice that the performance of your production 24/7 Oracle database significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not w...

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

In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation. How does real-time Automatic database Diagnostic Mo...

The tnsnames.ora file has an entry for the service alias ORCL as follows: The TNSPING command executes successfully when tested with ORCL; however, from the same OS user session, y...

Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users: 1. Create a policy to capture the privilege used by a use...

You database is running an ARCHIVELOG mode. The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = `LOCATION = /disk1/a...

Your multitenant container database (CDB) is running in mode. You connect to the ARCHIVELOG CDB RMAN. Examine the following command and its output: You execute the following comman...

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: What is the result?

Which three functions are performed by the SQL Tuning Advisor?

Examine the following command: ALTER SYSTEM SET enable_ddl_logging=FALSE; Which statement is true?

Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. The...

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, to...

Identify two valid options for adding a pluggable database (PDB) to an existing 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 som...

The following parameter are set for your Oracle 12c database instance: You want to manage the SQL plan evolution task manually. Examine the following steps: 1. Set the evolve task...

In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with f...

Examine this command: SQL > exec DBMS_STATS.SET_TABLE_PREFS (`SH', `CUSTOMERS', `PUBLISH', `false'); Which three statements are true about the effect of this command?

Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source): Which three are prerequisites for successful execution of the com...

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

Examine the current value for the following parameters in your database instance: SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M You issue the fol...

Which three statements are true concerning unplugging a pluggable database (PDB)?

Examine the following command: Which three statements are true about using an invisible column in the PRODUCTS table?

You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT. You issue the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS; S...

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

After implementing full Oracle Data Redaction, you change the default value for the data NUMBER type as follows: After changing the value, you notice that FULL redaction continues...

You must track all transactions that modify certain tables in the sales schema for at least three years. Automatic undo management is enabled for the database with a retention of o...

Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table's indexes, to an...

To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following erro...

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

Identify two correct statements about multitenant architectures.

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?

Which statement is true concerning dropping a pluggable database (PDB)?

You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further...

Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges?

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?

You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema. Examine the following steps: 1. Iss...

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

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

An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the...

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/wri...

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

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB). The characteristics of the non-CDB are as follows: - Version: Oracle Database...

Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialize...

An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges. A multitenant container database (CDB) instant has the following parameter set: THREADED...

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

You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic...

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

Which three statements are true about adaptive SQL plan management?

You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in HR_PDB?

Which two statements are true about variable extent size support for large ASM files?