Which two are true about transactions, UNDO segments, and UNDO tablespaces? (Choose two.)

A. UNDO segments grow or shrink automatically

B. UNDO tablespaces are created and dropped automatically

C. UNDO segments are created and dropped automatically

D. UNDO tablespaces are brought ONLINE or OFFLINE as required

E. All transactions belonging to a single session use the same UNDO segment

You created a profile APP_USER and assigned it to the users. After a month, you decide to drop the

profile.

Some user sessions are currently connected to the database instance and are using the APP_USER

profile.

This command is used to drop the profile:

SQL> DROP PROFILE app_user;

Which statement describes the result?

A. The command produces an error.

B. The profile is dropped and current user sessions use the DEFAULT profile immediately.

C. The profile is dropped, the sessions are terminated, and the subsequent user sessions use the DEFAULT profile.

In which three situations does the Oracle Data Pump use external tables and not the direct path load while exporting a table? (Choose three.)

A. If a table is not in a cluster

B. If a table has an active trigger

C. If a table has an encrypted column

D. If a table has a VARCHAR2 column in it

E. If a table has a referential integrity constraint defined on it

Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener by using the command: LSNRCTL> STOP

What happens to the sessions that are presently connected to the database instance?

A. The sessions are able to perform only queries

B. The sessions are not affected and continue to function normally

C. The sessions are terminated and the active transactions are rolled back

D. The sessions are not allowed to perform any operations till the listener is started

In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?

A. When the data file of the undo tablespace is autoextensible

B. When there are more than one undo tablespace available in the database

C. When the undo tablespace is of a fixed size and retention guarantee is not enabled

D. When the undo tablespace is autoextensible and retention guarantee is not enabled

Which two operations can be performed on an external table? (Choose two.)

A. Create a view on the table

B. Create an index on the table

C. Create a synonym on the table

D. Add a virtual column to the table

E. Update the table using the UPDATE statement

F. Delete rows in the table using the DELETE command

In which of the scenario will the DBA perform recovery? (Choose all that apply.)

A. The alert log file is corrupted

B. A tablespace is accidentally dropped

C. One of the redo log members is corrupted

D. A database user terminates the session abnormally

E. The hard disk on which the data files is stored is corrupted

Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)

A. You can add SQL test cases to the incident package.

B. You can add or remove the trace files to the package.

C. You cannot create an incremental incident package when the physical files are purged from the ADR.

D. You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.

You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOG mode.

Which two statements are true in this scenario? (Choose two.)

A. You must shut down the database instance to perform the backups.

B. You must configure the Flash Recovery Area (FRA) for the database.

C. You can perform complete database backups without closing the database.

D. All the previous closed database backups including control files become invalid afteryou configure the database to ARCHIVELOG mode.

In a new installation of Oracle Database 11g, you perform these activities:

1.

Organize software and data on different subdirectories to avoid poor performance.

2.

Use consistent naming conventions for database files.

3.

Separate administrative information pertaining to the database in different directories. Which option corresponds to the type of activities you performed?

A. Oracle Managed Files

B. Oracle Grid Architecture

C. Optimal Flexible Architecture

D. Oracle database architecture

E. Automatic Storage Management