View the Exhibit and examine the undo tablespace attributes. Your database instance is experiencing a largevolume of transactions from non-DBA users in the last one hour. The undo tablespace UNDOTBS1 is full withtransactions and no transaction was committed more than one hour ago. The database has two more undotablespaces. 
What happens to the new DML operations in this scenario（）

You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add anew column to the EMPLOYEE table to achieve this. 
Which data type would you use for the new column（）

Note the following functionalities of various background processes：
1. Record the checkpoint information in data file headers.
2. Perform recovery at instance startup.
3. Cleanup unused temporary segments.
4. Free the resources used by a user process when it fails.
5. Dynamically register database services with listeners.
6. Monitor sessions for idle session timeout.
Which option has the correct functionalities listed for a background process（）

You are using Enterprise Manager to schedule backups for your database. 
Which type of script would begenerated by the backup scheduler（）

in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. 
What is the impactof this setting（）

You execute the following command to audit database activities：
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；
What is the effect of this command（）

Which statements listed below describe the data dictionary views（）
1） These are stored in the SYSTEM tablespace.
2） These are the based on the virtual tables.
3） These are owned by the SYS user.
4） These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set to TRUE.
5） The V$FIXED_TABLE view can be queried to list the names of these views.

You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on it. 
Which constraints will remain enabled by default during this operation（）

Observe the information in the columns：
1. The SGA                 a. Text and parsed forms of all SQL statements
2. The cursor state       b. Run-time memory values for the SQL statement， such as rows retrieved
3. User-session data    c. Security and resource usage information
4. The stack space      d. Local variables for the process 
Which option has the correct match between the memory areas and their contents（）

Identify the memory component from which memory may be allocated for：（）
1. Session memory for the shared server
2. Buffers for I/O slaves
3. Oracle Database Recovery Manager （RMAN） backup and restore operations