多項選擇題

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.

你可能感興趣的試題

單項選擇題

The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct？（）

A.Undo data becomes obsolete after 1，000 seconds.
B.Undo data gets refreshed after every 1，000 seconds.
C.Undo data will be stored permanently after 1，000 seconds.
D.Committed undo data would be retained for 1，000 seconds if free undo space is available.
E.Undo data will be retained in the UNDO tablespace for 1，000 seconds，then it gets moved to the TEMPORARY tablespace to provide read consistency.

單項選擇題

You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）

A.run Segment Advisor
B.run SQL Tuning Advisor on top SQL statements
C.run the Automatic Workload Repository （AWR） report
D.run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements

Which three statements are correct about temporary tables？（）

你可能感興趣的試題

The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct？（）

You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）

Which three statements are correct about temporary tables？（）

The UNDO_RETENTION parameter in your database is set to 1000 and undo retention is not guaranteed. Which statement regarding retention of undo data is correct？（）

You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）