单选题A trigger can be created on which of the following objects?（）A ViewB Catalog TableC Stored ProcedureD Global Temporary Table

题目
单选题
A trigger can be created on which of the following objects?（）
A

View

B

Catalog Table

C

Stored Procedure

D

Global Temporary Table

相似考题

1.You issued the following command:An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command? ()A. It stores only the temporary table but not its indexes.B. It stores both the temporary table as well as its indexes.C. It must be a nondefault temporary tablespace for the database.D. It can be a default or nondefault temporary tablespace for the database.E. It must be the default temporary tablespace of the user who issues the command.

2.Which of the following database objects can be used to raise an error if a table is updated?()A.PackageB.TriggerC.Stored ProcedureD.Informational Constraint

3.Which of the following database objects is considered executable using SQL?()A.ViewB.TableC.RoutineD.Package

4.Which of the following are valid program types for a lightweight job?()A. PLSQL_BLOCK PLSQLB. EXECUTABLEC. JAVA_STORED_PROCEDURED. STORED_PROCEDUREE. EXTERNAL

参考答案和解析
正确答案： A
解析： 暂无解析
更多“单选题A trigger can be created on which of the following objects?（）A ViewB Catalog TableC Stored ProcedureD Global Temporary Table”相关问题

  • 第1题：

    A trigger can be created on which of the following objects?()

    A.View

    B.Catalog Table

    C.Stored Procedure

    D.Global Temporary Table


    参考答案：A

  • 第2题：

    A trigger can be created on which of the following objects?（）

    • A、View
    • B、Catalog Table
    • C、Stored Procedure
    • D、Global Temporary Table

    正确答案:A

  • 第3题：

    Which of the following are valid program types for a lightweight job？（）

    • A、 PLSQL_BLOCK
    • B、 EXECUTABLE
    • C、 JAVA_STORED_PROCEDURE
    • D、 STORED_PROCEDURE
    • E、 EXTERNAL

    正确答案:A,D

  • 第4题：

    Which of the following database objects is considered executable using SQL?（）

    • A、View
    • B、Table
    • C、Routine
    • D、Package

    正确答案:C

  • 第5题：

    An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement: CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT) Which of the following SQL statements will provide the table definition that meets the specified requirements?（）

    • A、DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE
    • B、DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS
    • C、CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS
    • D、CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE

    正确答案:B

  • 第6题：

    Which  statements are correct about temporary tables（）

    • A、Indexes and views can be created on temporary tables.
    • B、Both the data and the structure of temporary tables can be exported.
    • C、Temporary tables are always created in a user’s temporary tablespace.
    • D、The data inserted into a temporary table in a session is available to other sessions.
    • E、Data manipulation language （DML） locks are never acquired on the data of temporary tables

    正确答案:A,C,E

  • 第7题：

    Which of the following statements are true regarding the Recycle Bin？（）

    • A、 The Recycle Bin is a physical storage area for dropped objects.
    • B、 The Recycle Bin is a logical container for dropped objects.
    • C、 The Recycle Bin stores the results of a Flashback Drop operation.
    • D、 The objects in the Recycle Bin are stored in the tablespace in which they were created.

    正确答案:B,D

  • 第8题：

    Which three statements are correct about temporary tables？（）

    • A、Indexes and views can be created on temporary tables.
    • B、Both the data and the structure of temporary tables can be exported.
    • C、Temporary tables are always created in a user’s temporary tablespace.
    • D、The data inserted into a temporary table in a session is available to other sessions.
    • E、Data manipulation language （DML） locks are never acquired on the data of temporary tables.

    正确答案:A,C,E

  • 第9题：

    单选题
    A trigger can be created on which of the following objects?（）
    A

    View

    B

    Catalog Table

    C

    Stored Procedure

    D

    Global Temporary Table


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

  • 第10题：

    多选题
    Which three statements are correct about temporary tables？（）
    A

    Indexes and views can be created on temporary tables.

    B

    Both the data and the structure of temporary tables can be exported.

    C

    Temporary tables are always created in a user’s temporary tablespace.

    D

    The data inserted into a temporary table in a session is available to other sessions.

    E

    Data manipulation language （DML） locks are never acquired on the data of temporary tables.


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

  • 第11题：

    单选题
    Which statement is true regarding virtual private catalogs？（）
    A

     A virtual private catalog owner can create a local stored script， and have read/write access to a global stored script.

    B

     The virtual private catalog owner cannot create and modify the stored scripts.

    C

     The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.

    D

     To perform most of the RMAN operations， the virtual catalog owner must have the SYSDBA or  SYSOPER privilege on the target database.


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

  • 第12题：

    单选题
    Which of the following database objects can be used to raise an error if a table is updated?（）
    A

    Package

    B

    Trigger

    C

    Stored Procedure

    D

    Informational Constraint


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

  • 第13题：

    Which type of EIGRP route entry describes a feasible successor?（）

    • A、a primary route,stored in the routing table
    • B、a backup route,stored in the routing table
    • C、a backup route,stored in the topology table
    • D、a primary route,stored in the topology table

    正确答案:C

  • 第14题：

    Which of the following resources can be referenced in the LOCK statement?（）

    • A、Row
    • B、Table
    • C、Column
    • D、Table space

    正确答案:B

  • 第15题：

    Which of the following are valid program types for a lightweight job?（）

    • A、PLSQL_BLOCK PLSQL
    • B、EXECUTABLE
    • C、JAVA_STORED_PROCEDURE
    • D、STORED_PROCEDURE
    • E、EXTERNAL

    正确答案:A,D

  • 第16题：

    Which of the following database objects can be used to raise an error if a table is updated?（）

    • A、Package
    • B、Trigger
    • C、Stored Procedure
    • D、Informational Constraint

    正确答案:B

  • 第17题：

    Which statement is true regarding virtual private catalogs?（）

    • A、A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.
    • B、The virtual private catalog owner cannot create and modify the stored scripts.
    • C、The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
    • D、To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database

    正确答案:D

  • 第18题：

    Identify the logical structure that will never have more than one data segment created for it.（）

    • A、external table
    • B、partitioned table
    • C、partitioned index
    • D、nonclustered table
    • E、global temporary table

    正确答案:D

  • 第19题：

    You issued the following command：   CREATE GLOBAL TEMPORARY TABLE admin_work_area   （startdate DATE， enddate DATE， class CHAR（20）） ON COMMIT DELETE ROWS TABLESPACE tbs_t1；   An index is then created on the ADMIN_WORK_AREA temporary table.  Which two statements are true regarding the TBS_T1 tablespace in the above command？（） 

    • A、 It stores only the temporary table but not its indexes.
    • B、 It stores both the temporary table as well as its indexes.
    • C、 It must be a nondefault temporary tablespace for the database.
    • D、 It can be a default or nondefault temporary tablespace for the database.
    • E、 It must be the default temporary tablespace of the user who issues the command.

    正确答案:B,D

  • 第20题：

    多选题
    Which  statements are correct about temporary tables（）
    A

    Indexes and views can be created on temporary tables.

    B

    Both the data and the structure of temporary tables can be exported.

    C

    Temporary tables are always created in a user’s temporary tablespace.

    D

    The data inserted into a temporary table in a session is available to other sessions.

    E

    Data manipulation language （DML） locks are never acquired on the data of temporary tables


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

  • 第21题：

    多选题
    Which of the following statements are true regarding the Recycle Bin？（）
    A

    The Recycle Bin is a physical storage area for dropped objects.

    B

    The Recycle Bin is a logical container for dropped objects.

    C

    The Recycle Bin stores the results of a Flashback Drop operation.

    D

    The objects in the Recycle Bin are stored in the tablespace in which they were created.


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

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第23题：

    单选题
    Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?（）
    A

    Define the column MAINID as NOT UPDATABLE

    B

    Define the column MAINID as a PRIMARY KEY

    C

    Define the column MAINID as a FOREIGN KEY

    D

    Define an UPDATE trigger on table TABLEX


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

  • 第24题：

    单选题
    An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement: CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT) Which of the following SQL statements will provide the table definition that meets the specified requirements?（）
    A

    DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE

    B

    DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS

    C

    CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWS

    D

    CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE


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

相关内容