You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.

Which two are possible if table updates are performed which affect the invisible index columns? (Choose two.)

A. The index remains invisible.

B. The index is not updated by the DML statements on the indexed table.

C. The index automatically becomes visible in order to have it updated by DML on the table.

D. The index becomes unusable but the table is updated by the DML.

E. The index is updated by the DML on the table.

Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?

A. execution of SQL statements by users connected with the SYSDBA privilege

B. creation of a fine-grained audit policy

C. configuration of unified auditing mode

D. usage of the AUDIT statement

Identify two prerequisites for configuring Enterprise Manager Database Express (EM Express).

A. Grant the APEX_PUBLIC_USER role to the SYSMAN user.

B. Use the DBMS_XDB_CONFIG.SETHTTPPORT procedure to configure a port number for Oracle HTTP Server.

C. Install Oracle HTTP Server.

D. Configure at least one dispatcher for the TCP/IP protocol.

E. Create a SYSMAN user with the SYSDBA privilege as an administrator for EM Express.

You are managing an Oracle Database 12c database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.

Which three statements are true about these backups? (Choose three.)

A. The backups would be consistent.

B. The backups would be possible only if the database is running in ARCHIVELOG mode.

C. The backups need to be restored and the database has to be recovered in case of a media failure.

D. The backups would be inconsistent.

E. The backups by default consist of all the data blocks within the chosen files or the full database.

Examine the following command: SQL> DBMS_STATS. SET_TABLE_PREFS ('SH', 'CUSTOMERS', 'PUBLISH', 'false');

What is the effect of executing this command?

A. Existing statistics for the CUSTOMERS table become unusable for the query optimizer.

B. Automatic statistics collection is stopped for the CUSTOMERS table.

C. Statistics for the CUSTOMERS table are locked and cannot be overwritten.

D. Statistics subsequently gathered on the CUSTOMERS table are stored as pending statistics.

Which two statements are true about resumable space allocation? (Choose two.)

A. A database-level LOGON trigger can be used to automatically configure resumable statement settings for individual sessions.

B. SELECT statements that run out of temporary space for sort areas are candidates for resumable execution.

C. A resumable statement can be suspended and resumed only once during a session.

D. Resumable space allocation does not apply when a database instance uses asynchronous commit.

E. Resumable space allocation does not apply when users exceed their assigned space quota in a tablespace.

F. Free space in a segment is automatically reclaimed when a resumable statement is suspended because of an out-of-space condition.

Examine the parameters:

Users complain that their sessions for certain transactions hang. You investigate and discover that some users fail to complete their transactions, causing other transactions to wait on row-level locks.

Which two actions would you take to prevent this problem? (Choose two.)

A. Increase the maximum number of ITL slots for segments on which a blocking user performs a transaction.

B. Decrease the SESSIONS_PER_USER limit in the profiles assigned to blocking users.

C. Set a limit in the profiles of blocking users to control the number of data blocks that can be accessed in a session.

D. Use Database Resource Manager to automatically kill the sessions that are idle and are blocking other sessions.

E. Decrease the IDLE_TIME resource limit in the profiles assigned to blocking users.

Examine this command executed on a client that is remote from the database server.

SQL> CONNECT hr/hr@orcl

Which two are required for this command to connect the SQLPLUS client to a database instance? (Choose two.)

A. An orcl TNS entry must be defined in the client-side and server-side tnsnames.ora files

B. An orcl TNS entry must be defined in the client-side tnsnames.ora file

C. A service name must be defined to the listener that matches the service name in the orcl TNS entry

D. An orcl TNS entry must be defined in the server-side tnsnames.ora file

E. The service name orcl must be defined to the listener

Examine these statements: DESC emp

INSERT INTO emp VALUES ( 101, 'John', 12000);

1 row created.

SAVEPOINT after_insert;

Savepoint created.

UPDATE emp SET salary=16000 WHERE empno=101;

1 row updated.

SAVEPOINT after_update;

Savepoint created.

DELETE FROM emp WHERE empno=101;

1 row deleted.

SAVEPOINT after_delete;

Savepoint created.

ROLLBACK TO SAVEPOINT after_update;

Rollback complete.

INSERT INTO emp VALUES ( 102, 'Emma', 12000);

ROLLBACK TO SAVEPOINT after_delete;

Which is the result and effect of this ROLLBACK?

A. The ROLLBACK backs out all DMLS before after_delete.

B. The ROLLBACK backs out all DMLS until after_delete.

C. The ROLLBACK throws an error.

D. The ROLLBACK executes successfully but does not back out any DMLS.

Examine these commands:

Now examine these steps:

1) STARTUP NOMOUNT 2) STARTUP MOUNT 3) STARTUP FORCE 4) ALTER DATABASE ARCHIVELOG; 5) SHUTDOWN TRANSACTIONAL 6) ALTER DATABASE OPEN; 7) SHUTDOWN ABORT 8) ALTER DATABASE MOUNT

Identify the required steps in the correct order to change the database to run in ARCHIVELOG mode.

A. 5, 2, 4, 6

B. 5, 1, 4, 8, 6

C. 5, 1, 4, 6

D. 7, 1, 4, 8, 6

E. 5, 3, 4, 6

F. 5, 2, 6, 4