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

第1题

Which of the following resources can be referenced in the LOCK statement?（）A、RowB、TableC、ColumnD、Table space

点击查看答案

第2题

Which of the following are valid program types for a lightweight job？（）A、 PLSQL_BLOCKB、 EXECUTABLEC、 JAVA_STORED_PROCEDURED、 STORED_PROCEDUREE、 EXTERNAL

点击查看答案

第3题

Which of the following are valid program types for a lightweight job?（）A、PLSQL_BLOCK PLSQLB、EXECUTABLEC、JAVA_STORED_PROCEDURED、STORED_PROCEDUREE、EXTERNAL

点击查看答案

第4题

Which of the following database objects is considered executable using SQL?（）A、ViewB、TableC、RoutineD、Package

点击查看答案

第5题

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

点击查看答案

第6题

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 TABLEB、DECLARE GLOBAL TEMPORARY TABLE tracker AS (SELECT item_no, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSC、CREATE TABLE systmp.tracker AS (SELECT item_num, item_name FROM items) WITH NO DATA ON COMMIT PRESERVE ROWSD、CREATE TABLE tracker AS (SELECT item_num, item_name FROM items) ON COMMIT PRESERVE ROWS ON DISCONNECT DROP TABLE

点击查看答案

第7题

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

点击查看答案