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

第1题：

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

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

第2题：

On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）

• A、fixed tables
• B、heap tables
• C、external tables
• D、temporary tables
• E、Index-Organized Tables (IOTs)

第3题：

The rows inside three Oracle tables supporting a customer order entry system are frequently accessed together by means of a table join. Because data is always being added to the tables, you leave a lot of extra space inside each block to accommodate growth. Which of the following types of tables would be useful for storing the data in this context?（）

• A、Temporary tables 
• B、Index-organized tables 
• C、Cluster tables 
• D、Standard Oracle tables 

第4题：

Which two statements about views are true?（）

• A、A view can be created as read only.
• B、A view can be created as a join on two or more tables.
• C、A view cannot have an ORDER BY clause in the SELECT statement.
• D、A view cannot be created with a GROUP BY clause in the SELECT statement.
• E、A view must have aliases defined for the column names in the SELECT statement.

第5题：

For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）(Choose two.)

• A、views
• B、fixed tables
• C、heap tables
• D、external tables
• E、temporary tables
• F、index-organized tables (IOT)

第6题：

While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）

• A、the CREATE TABLE .. command
• B、sorting of the SYSTEM tablespace’s data
• C、sorting of data required by recursive SQL statements
• D、the CREATE TABLE .. ORGANIZATION EXTERNAL .. command
• E、sorting of data if the users have not been allocated temporary tablespace explicitly
• F、sorting of data if the users have been allocated temporary tablespace explicitly

第7题：

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.

第8题：

You need to improve the performance of the tempdb database on SQL1.Which two actions should you perform？（）

• A、Move tempdb onto a faster disk volume.
• B、Increase the initial size of tempdb to 1.5 GB
• C、Increase the size of the data files in the Tracking database.
• D、Decrease the file growth increment for tempdb to 25 MB
• E、Use more local temporary tables and fewer global temporary tables in the Tracking database.

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

Which statements are true regarding the Query Result Cache？（） 

• A、 It can be set at the system， session， or table level.
• B、 It is used only across statements in the same session.
• C、 It can store the results from normal as well as flashback queries.
• D、 It can store the results of queries based on normal，temporary，and dictionary tables.

第15题：

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

第16题：

Which two statements are true about simple views？（）

• A、Views can be created as read only.
• B、Views are data segments like tables.
• C、Views can be created on the basis of more than one table.
• D、Data manipulation language （DML） operations cannot be performed on views.

第17题：

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.

第18题：

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.

第19题：

Which two are true regarding external tables？ （）

• A、External tables can be updated. 
• B、External tables are read-only tables. 
• C、Indexes can be created on external tables. 
• D、Indexes cannot be created on external tables.

第20题：

第21题：

第22题：

第23题：