NEW QUESTION 1
You performed an incremental level 0 backup of a database:
RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;
To enable block change tracking after the incremental level 0 backup, you issued this command:
SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
‘ /mydir/rman_change_track.f’;
To perform an incremental level 1 cumulative backup, you issued this command: RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which three statements are true?

• A. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
• B. The change tracking file must always be backed up when you perform a full database backup.
• C. Block change tracking will always reduce I/O performed during cumulative incremental backups.
• D. More than one database block may be read by an incremental backup for a change made to a single block.
• E. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

Answer: ADE

NEW QUESTION 2
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:
SQL > ALTER DISKGROUP data ADD ALIAS ‘+data/prod/myfile.dbf’ FOR ‘
+data/prod/myfile.dbf’
What is the result?

• A. The file ‘+dat
• B. 231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.
• C. The file ‘+dat
• D. 231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.
• E. The file ‘+dat
• F. 231.54769’ remains in the same location and a synonym 'myfile.dbf' is create
• G. The file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+dat
• H. 231.54769’ in the data dictionary remove

Answer: C

NEW QUESTION 3
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?

• A. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
• B. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.
• C. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.
• D. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables use
• E. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and bind variables use

Answer: D

NEW QUESTION 4
Which three are true about the large pool for an Oracle database instance that supports
shared server connections?

• A. Allocates memory for RMAN backup and restore operations
• B. Allocates memory for shared and private SQL areas
• C. Contains a cursor area for storing runtime information about cursors
• D. Contains stack space
• E. Contains a hash area performing hash joins of tables

Answer: ABC

NEW QUESTION 5
Which three activities are supported by the Data Recovery Advisor?

• A. Advising on block checksum failures
• B. Advising on inaccessible control files
• C. Advising on inaccessible block change tracking files
• D. Advising on empty password files
• E. Advising on invalid block header field values

Answer: ABE

NEW QUESTION 6
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 which database users and for which executions is the audit policy now active? Select two.

• A. SYS, SYSTEM
• B. SCOTT
• C. Only for successful executions
• D. Only for failed executions
• E. Both successful and failed executions

Answer: AE

NEW QUESTION 7
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 execute the following command from the root container:
SQL > REVOKE create table FROM C # # A_ADMIN;
What is the result?

• A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
• B. It fails and reports an error because the CONTAINER=ALL clause is not use
• C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
• D. It fails and reports an error because the CONTAINER=CURRENT clause is not use
• E. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.

Answer: A

NEW QUESTION 8
Which three actions are possible during an Online Data file Move operation?

• A. Creating and dropping tables in the data file being moved
• B. Performing file shrink of the data file being moved
• C. Querying tables in the data file being moved
• D. Performing Block Media Recovery for a data block in the data file being moved
• E. Flashing back the database
• F. Executing DML statements on objects stored in the data file being moved

Answer: ACF

NEW QUESTION 9
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
TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y
Which statement is true?

• A. All database operations performed by the impdp command are logge
• B. Only CREATE INDEX and CREATE TABLE statements generated by the import are logge
• C. Only CREATE TABLE and ALTER TABLE statements generated by the import are logge
• D. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logge

Answer: C

NEW QUESTION 10
You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.
In which three ways can you re-create the lost disk group and restore the data?

• A. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the dat
• B. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
• C. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the dat
• D. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the dat
• E. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
• F. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the dat

Answer: CDF

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

• A. OMF cannot be used in a database that already has data files created with user- specified directions.
• B. The file system directions that are specified by OMF parameters are created automatically.
• C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.
• D. OMF automatically creates unique file names for table spaces and control files.
• E. OMF may affect the location of the redo log files and archived log files.

Answer: DE

NEW QUESTION 12
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?

• A. User session data
• B. Stack space
• C. Private SQL area
• D. Location of the runtime area for DML and DDL Statements
• E. Location of a part of the runtime area for SELECT statements

Answer: AC

NEW QUESTION 13
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?

• A. The size of the shared pool is too small.
• B. Cursors are not being share
• C. A large number COMMITS are being performe
• D. There are frequent logons and logoffs.
• E. The buffers are being read into the buffer cache, but some other session is changing the buffers.

Answer: ABE

NEW QUESTION 14
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_EXECUTION = FALSE
Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?

• A. You can conned as a common user by using the connect statement.
• B. You can connect as a local user by using the connect statement.
• C. You can connect by using easy connect.
• D. You can connect by using OS authentication.
• E. You can connect by using a Net Service name.
• F. You can connect as a local user by using the SET CONTAINER statement.

Answer: ACE

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

• A. It fails with the ORA-665610 Invalid DDL statement on history-tracked message
• B. The rows in the table are truncated without being archive
• C. The rows in the table are archived, and then truncate
• D. The rows in both the table and the archive are truncate

Answer: C

NEW QUESTION 16
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 the job's elapsed time?

• A. Increasing the priority of the job class to which the job belongs
• B. Increasing the job's relative priority within the Job class to which it belongs
• C. Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window
• D. Moving the job to an existing higher priority scheduler window with the same schedule and duration
• E. Increasing the value of the JOB_QUEUE_PROCESSES parameter
• F. Increasing the priority of the scheduler window to which the job belongs

Answer: CF

NEW QUESTION 17
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 three storage options support the use of HCC?

• A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.
• B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
• C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
• D. Database files stored in ZFS and accessed using conventional NFS mounts.
• E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
• F. Database files stored in any file system and accessed using the Oracle Direct NFS feature
• G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

Answer: AEG

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

• A. The root container can be flashed back without flashing back the pluggable databases (PDBs).
• B. To enable flashback database, the CDB must be mounte
• C. Individual PDBs can be flashed back without flashing back the entire CD
• D. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CD
• E. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

Answer: BDE

NEW QUESTION 19
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 ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapseD.
When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.
Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?

• A. Increase the value of the ASM_POWER_LIMIT parameter.
• B. Set the DISK_REPAIR_TIME disk attribute to a lower value.
• C. Specify the statement that adds the disk back to the disk group.
• D. Increase the number of ASMB processes.
• E. Increase the number of DBWR_IO_SLAVES in the ASM instance.

Answer: AC

NEW QUESTION 20
In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:

Which two statements are true?

• A. The C # # ROLE1 role is created in the root database and all the PDBs.
• B. The C # # ROLE1 role is created only in the root database because the container clause is not use
• C. Privileges are granted to the C##A_ADMIN user only in the root database.
• D. Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.
• E. The statement for granting a role to a user fails because the CONTAINER clause is not use

Answer: AC

NEW QUESTION 21
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, total database time, and the number of I/O requests.
For the database instance STATISTICS_LEVEL, the initialization parameter is set to
TYPICAL and the CONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.
What should you do to accomplish this task?

• A. Execute the query and view Active Session History (ASH) for information about the query.
• B. Enable SQL trace for the query.
• C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the report.
• D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.

Answer: C

NEW QUESTION 22
Which three functions are performed by the SQL Tuning Advisor?

• A. Building and implementing SQL profiles
• B. Recommending the optimization of materialized views
• C. Checking query objects for missing and stale statistics
• D. Recommending bitmap, function-based, and B-tree indexes
• E. Recommending the restructuring of SQL queries that are using bad plans

Answer: ACE

NEW QUESTION 23
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?

• A. The partitions can be moved online to new tablespaces.
• B. Global indexes must be rebuilt manually after moving the partitions.
• C. The partitions can be compressed in the same tablespaces.
• D. The partitions can be compressed in the new tablespaces.
• E. Local indexes must be rebuilt manually after moving the partitions.

Answer: ACD

NEW QUESTION 24
Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager?

• A. Maximum Undo per consumer group
• B. Maximum Idle time
• C. Parallel server limit
• D. CPU
• E. Exadata I/O
• F. Local file system I/O

Answer: CDE

NEW QUESTION 25
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 following command to increase the value of DB_8K_CACHE_SIZE:
SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
Which statement is true?

• A. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
• B. It succeeds only if memory is available from the autotuned components if SG
• C. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
• D. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

Answer: D

NEW QUESTION 26
......