找考题网-背景图
单项选择题

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（）

A.One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.
B.One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.
C.One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.
D.One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
E.One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT

<上一题 目录 下一题>
热门试题

单项选择题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.

A.1 and 3
B.2， 3， and 5
C.1， 2， and 3
D.2， 3， 4， and 5

多项选择题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（）

A.CHECK
B.UNIQUE
C.NOT NULL
D.PRIMARY KEY
E.FOREIGN KEY

单项选择题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（）

A.1-c， 2-b， 3-d， 4-a
B.1-b， 2-c， 3-d， 4-a
C.1-a， 2-b， 3-c， 4-d
D.1-a， 2-b， 3-d， 4-c

单项选择题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

A.Large Pool
B.Redo Log Buffer
C.Database Buffer Cache
D.Program Global Area （PGA）

单项选择题Inyourdatabaseinstance，theusersessionsareconnectedtothedatabaseserverfromtheremotemachines.Youwanttoachievethefollowingfortheseusers： 1.Theuseraccountmustbelockedafterfourunsuccessfulloginattempts. 2.Theusermustbepromptedtochangethepasswordatregularintervals. 3.Theusermaynothavemorethanthreesimultaneoussessions. 4.Theusersessionmustautomaticallybeloggedoffifmorethan10minuteselapsedtimeused. Howwouldyouaccomplishtheabove（）

A.By assigning profiles for the users
B.By implementing Fine-Grained Auditing （FGA）
C.By granting a secure application role to the users
D.By implementing the Database Resource Manager plan