You Execute the following command to create a password file in the database server:
$ orapwd file=‘+DATA/PROD/orapwprod entries=5 ignorecase=N format=12’
Which two statements are true about the password file? (Choose two.)
Which three operations can be performed as multipartition operations in Oracle Database 12c? (Choose three.)
In your multitenant container database (CDB) that contains some pluggable databases (PDBs), you execute the following commands in the root container:
Which two statements are true? (Choose two.)
You are administering a database stored in Automatic Storage Management (ASM). One of the ASM disks is dropped because of hardware failure. You replace the failed disk and want the resulting rebalance operations to occur with minimal impact on database performance.
Which two settings will help to maintain consistent database performance during the rebalance?
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance.
What should you use to achieve this?
Which two statements are true about the installation modes in Oracle Database 12c?
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)? (Choose three.)
You want to upgrade your pre-12c database to an Oracle 12c database. You set up the test environment and replay the captured workload from the production database on the test machine twice with a time difference of four hours.
For which three reasons would you use the Compare Period ADDM report after the replay? (Choose three.)
Examine the following parameters for a database instance:
Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)
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;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?
You use the segment advisor to help determine objects for which space may be reclaimed.
Which three statements are true about the advice given by the segment advisor? (Choose three.)
You execute the following commands to audit database activities:
Which statement is true about the audit record that is generated when auditing starts after the instance restarts?
Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:
Which two statements are true? (Choose two.)
Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the PDB HR_PDB. You execute the following command:
What is the result?
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? (Choose two.)
Identify the prerequisite for configuring and accessing Enterprise Manager (EM) express for an Oracle 12c database.
You executed startup restrict foe a multitenant container database (CDB) containing several LUGGABLE databases (PDBs).
You then attempt an alter PLUGGABLE database PDBI open for a PDB called PDB1.
What is the result?
After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:
After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.
What must you do to activate the new default value for numeric full redaction?
Which five actions are prerequisites for using extended data types for VARCHAR2, NVARCHAR2, and RAW columns in Oracle Database 12c? (Choose five.)
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?
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? (Choose three.)
The current system change number (SCN) for a live database is 663571.
You decide to use the flashback table statement to flash back the customers table to SCN 662116.
After flashing back the customers table, you query It and decide to undo the effects of the flashback table command.
Which is the fastest way to do this?
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?
On your Oracle 12c database, you issue the following commands to create indexes:
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);
Which two statements are true? (Choose two.)
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 using Oracle Restart.
Examine the following command and its output:
What does this imply?
Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges? (Choose three.)
Your database is running an ARCHIVELOG mode.
The following parameters are set in your database instance:
Which statement is true about the archived redo log files?
Identify three benefits of Unified Auditing. (Choose three.)
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" clause? (Choose two.)
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? (Choose two.)
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 investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed.
Identify three possible reasons for this. (Choose three.)