Free Cram & Latest Exams Dumps

NO.43 On your Oracle 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.)

NO.44 Which two statements are true about Enterprise Manager (EM) express in Oracle Database 12c? (Choose two.)

NO.45 Which three statements are true about Oracle Data Pump export and import operations?

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

NO.47 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?

NO.48 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?

NO.49 In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?
Both local and global partitioned B-tree Indexes are defined on the table.
A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.
Minimal disrupt ion to availability is required.
Which three statements are true about this requirement?

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

NO.51 You must configure Oracle Data Redaction for the EMP table to satisfy the following requirements:
RANDOM redaction on the SALand COMMcolumns

PARTIAL redaction on the HIREDATEcolumn

FULL redaction on the MGRcolumn

What would you define to implement this?

NO.52 Examine these two statements:

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

NO.53 Which two statements are true about Enterprise Manager (EM) express in Oracle Database 12c?
(Choose two.)

NO.54 Your multitenant container database (CDB) containing two pluggable databases, PDB2_1 and PDB2_2, is running in ARCHIEVELOG mode. An RMAN backup exists for the databases.
You issue the following commands and get an error:

Examine the following commands:

Identify two correct sequences of commands to perform a recovery and make the data available. (Choose two.)

NO.55 Examine the commands executed to monitor database operations:
$> conn sys oracle/oracle@prod as sysdba
SQL > VAR eid NUMBER
SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING => ‘Y’);
Which two statements are true?

NO.56 You find this query being used in your Oracle 12c database:

Which method a used by the optimizer to limit the rows being returned?

NO.57 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 statements are true about the ASM disk group compatibility attributes that are set for a disk group?

NO.58 You execute the following commands to audit database activities:
SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;
SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?