多选题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 st

第1题：

第2题：

You executed the following code：   SQL> CREATE TABLE COUNTRY   （COUNTRY_ID CHAR（2） CONSTRAINT COUNTRY_ID_nn NOT NULL，   COUNTRY_NAME VARCHAR2（20），   CURRENCY_NAME VARCHAR2（20），   CONSTRAINT COUNTRY_ID_PK PRIMARY KEY （COUNTRY_ID））   ORGANIZATION INDEX；   In which tablespace will the mapping table be created？（）

• A、 SYSTEM tablespace
• B、 SYSAUX tablespace
• C、 Undo tablespace
• D、 The tablespace of the Index Organized Table （IOT）

第3题：

第4题：

As a result of performance analysis， you created an index on the prod_name column of the prod_det table， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）

• A、A leaf will be marked as invalid.
• B、An update in a leaf row takes place.
• C、The index will be updated automatically at commit.
• D、A leaf row in the index will be deleted and inserted.
• E、The index becomes invalid when you make any updates.

第5题：

You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？ （）

• A、flash back the database
• B、import the temporary tablespace from the last export
• C、restore all the data files and temporary files from the last full database backup and perform a recovery
• D、not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace

第6题：

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

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

第7题：

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

第8题：

第9题：

You issued the following command on the temporary tablespace LMTEMP in your database：   SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M；   Which requirement must be fulfilled for this command to succeed？（）  

• A、 The tablespace must be locally managed.
• B、 The tablespace must have only one temp file.
• C、 The tablespace must be made nondefault and offline.
• D、 The tablespace can remain as the default but must have no active sort operations.

第10题：

Which two operations can be performed on an external table（）

• A、Create a view on the table.
• B、Create an index on the table.
• C、Create a synonym on the table.
• D、Add a virtual column to the table.
• E、Update the table using the UPDATE statement.
• F、Delete rows in the table using the DELETE command.