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

In your database instance， the user sessions are connected to the database server from the remote machines.You want to achieve the following for these users：
1. The user account must be locked after four unsuccessful login attempts.
2. The user must be prompted to change the password at regular intervals.
3. The user may not have more than three simultaneous sessions.
4. The user session must automatically be logged off if more than 10 minutes elapsed time used.
How would you accomplish the above（）

Note the following points describing various utilities in Oracle Database 1g：1. It enables the high-speed transfer of data from one database to another.
2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database.3. It enables the loading of data from an external file into an Oracle database.4. It provides a tape backup management for the Oracle ecosystem.
Which point describes Oracle Secure Backup（）

You executed the following command to perform a backup of the USERS tablespace：SQL> ALTER TABLESPACE users BEGIN BACKUP；ALTER TABLESPACE users BEGIN BACKUP*
ERROR at line 1：
ORA-01123： cannot start online backup； media recovery not enabled What could be the reason for this error（）

The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transactionin the system. Each row has cumulative transaction details of a single product and every product is identified bya product code， which is the primary key.As part of the archival process， the company wants to transfer therows in the TRANS_SUMMARY table to the TRANS_SUMMARY_DUP table at the end of every quarter of theyear. Along with existing products， the company deals with many new products during every quarter.
Whichmethod is best suited for this quarterly data transfer（）

To make audit information more productive， the DBA executes the following command before starting an auditoperation：
SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE；
Which statement is true regarding the audit record generated when auditing starts after restarting Thedatabase（）