View
Catalog Table
Stored Procedure
Global Temporary Table
多选题Which of the following statements are true regarding the Recycle Bin?()AThe Recycle Bin is a physical storage area for dropped objects.BThe Recycle Bin is a logical container for dropped objects.CThe Recycle Bin stores the results of a Flashback Drop operation.DThe objects in the Recycle Bin are stored in the tablespace in which they were created.
点击查看答案
多选题Which three statements are correct about temporary tables?()AIndexes and views can be created on temporary tables.BBoth the data and the structure of temporary tables can be exported.CTemporary tables are always created in a user’s temporary tablespace.DThe data inserted into a temporary table in a session is available to other sessions.EData manipulation language (DML) locks are never acquired on the data of temporary tables.
单选题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.
单选题Which statement is true regarding virtual private catalogs?()AA virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.BThe virtual private catalog owner cannot create and modify the stored scripts.CThe set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.DTo perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.
单选题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 UPDATABLEB Define the column MAINID as a PRIMARY KEYC Define the column MAINID as a FOREIGN KEYD Define an UPDATE trigger on table TABLEX
单选题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
单选题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