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
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
相关考题：
Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:SQL PURGE TABLE sales_tab;What would be the outcome of this command?（）A. All three tables in the recycle bin are purgedB. Only the table with the oldest DROPSCN is purgedC. The command returns an error because multiple entries with the same name exist in the recycle binD. Only the table with the latest DROPSCN is purged
You opened the encryption wallet and then issued the following command:Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.What is the outcome?（）A. It creates the table and encrypts the data in it.B. It generates an error because the wallet is closed.C. It creates the table but does not encrypt the data in it.D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.
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
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 tableB、drop and recreate the mapping tableC、truncate the mapping table and reinsert the valuesD、use the ALTER TABLE .. REBUILD command to defragment the mapping table
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、MERGEB、SELECT …CROSS JOINC、INSERT ALL …SELECTD、CREATE VIEW …CONSTRAINT
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
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
Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space，you issued the following command： ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS； What would be the outcome of this command？（）A、 It produces an error because data already exists in the table.B、 It produces an error because compression can be enabled at table creation only.C、 It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.D、 It immediately compresses all existing data as well as new data， resulting from either fresh additions or modifications to existing data.
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.
In which scenario will you create a hash cluster？（）A、 when you want the data to be returned automatically in chronological orderB、 if the application uses queries joining tables only occasionallyC、 if the queries against the clustered table use the equality operator （=） to retrieve the desired rowD、 if the full table scan is executed often on only one of the clustered tables
You need to allow the user to toggle between automatic query and no automatic query using a pop-up menu. Which built-in would you use in the menu item command to obtain the relationship name? （）A、GET_RELATION_PROPERTY B、SET_RELATION_PROPERTY C、GET_BLOCK_PROPERTY D、GET_FORM_PROPERTY
You are developing a tax report for the payroll application. You created a before parameter form report trigger to create three temporary tables to store text that are need while the report is executed. Which report trigger would you use to delete these temporary tables?（）A、Before parameter form. B、After parameter form. C、Before report. D、After report.
You execute the following command toauditdatabase activities： SQLAUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）A、Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.B、Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.C、One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his 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 droptables owned by SCOTT.
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You plan to implement a test strategy for the application. You need to ensure that the test strategy meets the following requirements: Test data can be added to the test project without recompiling. Multiple variations of a test can be executed at run time. What should you do? （）A、Use IntelliTrace.B、Use data-driven tests.C、Create a single test class.D、Create a test method for each data variation.
单选题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（）AOne audit record is created for every successful DROP TABLE command executed in the session of SCOTT.BOne audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.COne audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.DOne audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.EOne audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT
单选题In your test database， you have created the ORDERS table as an index-organized 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？（）Aexport and import the mapping tableBdrop and re-create the mapping tableCtruncate the mapping table and reinsert the valuesDuse the ALTER TABLE···REBUILD command to defragment the mapping table
单选题You execute the following command toauditdatabase activities： SQLAUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）AOneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.BOneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.COne audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.DOne audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.EOne audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.
单选题You need to allow the user to toggle between automatic query and no automatic query using a pop-up menu. Which built-in would you use in the menu item command to obtain the relationship name? （）AGET_RELATION_PROPERTY BSET_RELATION_PROPERTY CGET_BLOCK_PROPERTY DGET_FORM_PROPERTY
单选题View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table： ALTER TABLE emp ADD CONSTRAINT emp_id_pk PRIMARY KEY （emp_id） USING INDEX emp_id_idx； Which statement is true regarding the effect of the command？（）A The PRIMARY KEY is created along with a new index.B The PRIMARY KEY is created and it would use an existing unique index.C The PRIMARY KEY would be created in a disabled state because it is using an existing index.D The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.
单选题You want to create a temporary table while executing a procedure in a form. Which statement is true?（）AYou cannot create a table form within Forms. BYou must use the FORMS_DDL built-in to create the table. CYou must use the DBMS_DYNAMIC_DDL package to create the table. DYou can write the CREATE TABLE statement directly into the trigger.
单选题Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully?（）AFORMS_DDL BDO_SQL CFORM_SUCCESS DFORM_NOT_SUCCESSEDBMS.ERROR_CODE
单选题In your test database， you have created the ORDERS table as an index-organized 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 degrees 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.
单选题You are developing a tax report for the payroll application. You created a before parameter form report trigger to create three temporary tables to store text that are need while the report is executed. Which report trigger would you use to delete these temporary tables?（）ABefore parameter form. BAfter parameter form. CBefore report. DAfter report.
单选题In which scenario will you create a hash cluster？（）A when you want the data to be returned automatically in chronological orderB if the application uses queries joining tables only occasionallyC if the queries against the clustered table use the equality operator （=） to retrieve the desired rowD if the full table scan is executed often on only one of the clustered tables
单选题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?（）AImmediately following statement execution BAfter the ALTER TABLE DROP UNUSED COLUMNS command is issued CAfter the ALTER TABLE SET UNUSED COLUMN command is issued DAfter the ALTER TABLE MODIFY command is issued
单选题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?（）ANEW_FORM BOPEN_FORM CCALL_FORM DCLOSE_FORM
单选题The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?（）ACREATE SYNONYM ord FOR orders; This command is issued by OE BCREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE CCREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator DCREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator