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

You execute the following command to audit the 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 the whole session if user SCOTT successfully drops one or more tables in his session.
B.One audit record is created for every session when any user successfully drops a table owned by SCOTT.
C.One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
D.One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
E.One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

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

单项选择题Your database is not configured for session failover. Your tnsnames.ora file contains the following details：  test.us.oracle.com= （DESCRIPTION=  （ADDRESS_LIST= （LOAD_BALANCE=off）   （FAILOVER=ON）   （ADDRESS= （PROTOCOL=tcp）（HOST=test1-server）（PORT=1521））   （ADDRESS= （PROTOCOL=tcp）（HOST=test2-server）（PORT=1521）））   （CONNECT_DATA= （SERVICE_NAME=test.us.oracle.com）））   Which feature is enabled in this case？（）

A.Load balancing
B.Instance failover
C.Database failover
D.Connect-time failover
E.Transparent Application Failover （TAF）

单项选择题YouwanttomovealltheobjectsoftheAPPSuserinthetestdatabasetotheDB_USERschemaoftheproductiondatabase.WhichoptionofIMPDPwouldyouusetoaccomplishthistask？（）

A.FULL
B.SCHEMAS
C.REMAP_SCHEMA
D.REMAP_DATAFILES
E.REMAP_TABLESPACE

多项选择题When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed：  TZ set to America New_york  OC4J Configuration issue.  u01 app oracle product 10.1.0 db_1 oc4j j2ee OC4J_DBConsole_orcl.us.oracle.com not found.  Which two environment variables do you need to set appropriately to avoid such errors and start the Database Control successfully？（）

A.NLS_LANG
B.ORACLE_SID
C.ORACLE_HOME
D.ORACLE_BASE
E.LD_LIBRARY_PATH

单项选择题TheSCOTTuserhasanindexontheITEM_DESCcolumnoftheITEMtable.Aspartoftheyear-endingtask，SCOTTupdatestheITEM_DESCcolumnformostoftherowsintheITEMtable.Howdoesthischangetothetableaffecttheindex？（）

A.An update in a leaf row takes place.
B.The index becomes invalid after the update.
C.The leaf block containing the row to be updated is marked as invalid.
D.A row in the leaf block of the index for the key value is deleted and inserted.

单项选择题Your tnsnames.ora file has the following entry for the service alias ORCL：  ORCL =  （DESCRIPTION =  （ADDRESS = （PROTOCOL = TCP） （HOST = 10.156.24.216） （PORT = 1521））   （CONNECT_DATA =  （SERVER = DEDICATED） （SERVICE_NAME = orcl.oracle.com）   ）   ）   The TNSPING command executes successfully when tested with ORCL but you are not able to connect to the database instance with the following command：  SQL> CONNECT scott tiger@orcl  What could be the reason for this？（）

A.The listener is not running at the server.
B.The TNS_ADMIN environmental variable is set to a wrong value.
C.The orcl.oracle.com database service is not registered with the listener.
D.The DEFAULT_DOMAIN parameter is set to a wrong value in the SQLNET.ORA file.