单选题Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully?（）A FORMS_DDL B DO_SQL C FORM_SUCCESS D FORM_NOT_SUCCESSE DBMS.ERROR_CODE

第1题：

You create a multiple form application- Which built-in must you use to invoke the form modules to enable you to programmatically control navigation between the multiple forms in your application?（）

• A、NEW_FORM 
• B、OPEN_FORM 
• C、CALL_FORM 
• D、CLOSE_FORM

第2题：

You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）

• A、MERGE
• B、SELECT …CROSS JOIN
• C、INSERT ALL …SELECT
• D、CREATE VIEW …CONSTRAINT

第3题：

第4题：

In which scenario will you create a hash cluster？（）

• A、 when you want the data to be returned automatically in chronological order
• B、 if the application uses queries joining tables only occasionally
• C、 if the queries against the clustered table use the equality operator （=） to retrieve the desired row
• D、 if the full table scan is executed often on only one of the clustered tables

第5题：

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

第6题：

In your test database， you have created the ORDERS table as an index/x7forganized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions.  While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）

• A、export and import the mapping table
• B、drop and re­create the mapping table
• C、truncate the mapping table and reinsert the values
• D、use the ALTER TABLE .. REBUILD command to defragment the mapping table

第7题：

You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）

• A、Immediately following statement execution 
• B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued 
• C、After the ALTER TABLE SET UNUSED COLUMN command is issued 
• D、After the ALTER TABLE MODIFY command is issued

第8题：

第9题：

Examine the commands executed in the following sequence：  1：SQL> CREATE ROLE mgrrole；  2：SQL> GRANT create user，select any table，connect，resource TO mgrrole；  3：SQL> GRANT select，update ON sh.sales TO mgrrole；  4：SQL> CREATE ROLE ceo IDENTIFIED BY boss；  5：SQL> GRANT mgrrole，drop any table，create any directory TO ceo；  6：SQL> GRANT ceo TO mgrrole；  Which statement is true about the above commands（）

• A、The commands execute successfully.
• B、Command 6 produces an error because of circular role grant.
• C、Command 5 produces an error because a role cannot be granted to another role.
• D、Command 3 produces an error because the MGRROLE role already contains system privileges.
• E、The table created by HR remains and HR still has the CREATE TABLE system privilege.
• F、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

第10题：

Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully?（）

• A、FORMS_DDL 
• B、DO_SQL 
• C、FORM_SUCCESS 
• D、FORM_NOT_SUCCESS
• E、DBMS.ERROR_CODE