1Z0-060 Practice Questions

You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema. The RECYCLE_BIN...

In your multitenant container database (CDB) that contains pluggable databases (PDBs), the HR user executes the following commands to create and grant privileges on a procedure: Ho...

You created a new database using the "create database" statement without specifying the "ENABLE PLUGGABLE" clause. What are two effects of not using the "ENABLE PLUGGABLE database"...

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux. You have set the DB_SMART_FLASH_...

Examine the following parameters for a database instance: Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)

Examine the contents of SQL loader control file: Which three statements are true regarding the SQL* Loader operation performed using the control file?

In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You...

Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

You use a recovery catalog for maintaining your database backups. You execute the following command: Which two statements are true? (Choose two.)

Which three statements are true concerning the multitenant architecture?

You notice that the elapsed time for an important database scheduler Job is unacceptably long. The job belongs to a scheduler job class and window. Which two actions would reduce t...

You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform. Which two methods or commands would you use to accomplish this task?

You run a script that completes successfully using SQL*Plus that performs these actions: 1. Creates a multitenant container database (CDB) 2. Plugs in three pluggable databases (PD...

You execute the following piece of code with appropriate privileges: User SCOTT has been granted the CREATE SESSION privilege and the MGR role. Which two statements are true when a...

Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command: 1snrctl > STOP What happens to the sessions that...

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

You execute the following PL/SQL: Which two statements are true?

You execute the following commands to audit database activities: Which statement is true about the audit record that generated when auditing after instance restarts?

You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three s...

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

You executed this command to create a password file: $ orapwd file = orapworcl entries = 10 ignorecase = N Which two statements are true about the password file?

Identify three valid methods of opening, pluggable databases (PDBs).

You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy. One of the...

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

A senior DBA asked you to execute the following command to improve performance: You checked the data in the table and found that it is a large table containing SUBSCRIBE_LOG one mi...

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

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c?

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?

Which two statements are true about Oracle Managed Files (OMF)?

Which four actions are possible during an Online Data file Move operation?

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and yo...

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

Which two statements are true about the RMAN validate database command?

You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an ope...

You are required to migrate your 11.2.0.3 database as a pluggable database (PDB) to a multitenant container database (CDB). The following are the possible steps to accomplish this...

In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?

Which two statements are true about the Oracle Direct Network File system (DNFS)?

Examine the parameters for your database instance: Which three statements are true about the process of automatic optimization by using cardinality feedback?

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

Which three operations can be performed as multipartition operations in Oracle?

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

Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report: What are three possible causes for the latch-related wait events?

You enabled an audit policy by issuing the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM; For whi...

A redaction policy was added to the SAL column of the SCOTT.EMP table: All users have their default set of system privileges. For which three situations will data not be redacted?...

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

Which three activities are supported by the Data Recovery Advisor?

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

Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?

Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by u...