itgle.com

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

相似考题

1.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

2.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

3. 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 re­create the mapping tableC、truncate the mapping table and reinsert the valuesD、use the ALTER TABLE .. REBUILD command to defragment the mapping table

4.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.

更多“单选题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 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

    正确答案:A

  • 第2题：

    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

    正确答案:C

  • 第3题：

    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

    正确答案:C

  • 第4题：

    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

    正确答案:C

  • 第5题：

    You execute the following command toauditdatabase activities：  SQL>AUDITDROP 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.

    正确答案:C

  • 第6题：

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


    正确答案： B
    解析： 暂无解析

  • 第7题：

    单选题
    You execute the following command toauditdatabase activities：  SQL>AUDITDROP 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.


    正确答案： A
    解析： 暂无解析

  • 第8题：

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


    正确答案： D
    解析： 暂无解析

  • 第9题：

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


    正确答案： C
    解析： 暂无解析

  • 第10题：

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


    正确答案： B
    解析： 暂无解析

  • 第11题：

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


    正确答案： A
    解析： 暂无解析

  • 第12题：

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


    正确答案： A
    解析： 暂无解析

  • 第13题：

    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

    正确答案:B

  • 第14题：

    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.

    正确答案:B

  • 第15题：

    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

    正确答案:C

  • 第16题：

    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.

    正确答案:D

  • 第17题：

    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.

    正确答案:B

  • 第18题：

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


    正确答案： B
    解析： 暂无解析

  • 第19题：

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


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    You want to create a temporary table while executing a procedure in a form. Which statement is true?（）
    A

    You cannot create a table form within Forms. 

    B

    You must use the FORMS_DDL built-in to create the table. 

    C

    You must use the DBMS_DYNAMIC_DDL package to create the table. 

    D

    You can write the CREATE TABLE statement directly into the trigger.


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    You need to base a data block on the EMP table, but you do not want to give the users of the application access privileges on the table. Which type of data source would you use to create the data block?（）
    A

    table 

    B

    transactional trigger 

    C

    stored procedure 

    D

    FROM clause query


    正确答案： D
    解析： 暂无解析

  • 第22题：

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


    正确答案： B
    解析： 暂无解析

  • 第23题：

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


    正确答案： A
    解析： 暂无解析

  • 第24题：

    单选题
    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?（）
    A

    CREATE SYNONYM ord FOR orders; This command is issued by OE 

    B

    CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE 

    C

    CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator 

    D

    CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator 


    正确答案： A
    解析： 暂无解析

相关内容