网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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
参考答案
参考解析
解析：
暂无解析
更多 “多选题Which 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” 相关考题
考题
On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()
A. fixed tablesB. heap tablesC. external tablesD. temporary tablesE. Index-Organized Tables (IOTs)
考题
You issued the following command: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.
考题
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.
考题
A trigger can be created on which of the following objects?()
A.ViewB.Catalog TableC.Stored ProcedureD.Global Temporary Table
考题
A trigger can be created on which of the following objects?（）A、ViewB、Catalog TableC、Stored ProcedureD、Global Temporary Table
考题
On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）A、fixed tablesB、heap tablesC、external tablesD、temporary tablesE、Index-Organized Tables (IOTs)
考题
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.
考题
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
考题
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
考题
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.
考题
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.
考题
For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）(Choose two.)A、viewsB、fixed tablesC、heap tablesD、external tablesE、temporary tablesF、index-organized tables (IOT)
考题
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.
考题
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 .. commandB、sorting of the SYSTEM tablespace’s dataC、sorting of data required by recursive SQL statementsD、the CREATE TABLE .. ORGANIZATION EXTERNAL .. commandE、sorting of data if the users have not been allocated temporary tablespace explicitlyF、sorting of data if the users have been allocated temporary tablespace explicitly
考题
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.
考题
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.
考题
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.
考题
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 GBC、Increase the size of the data files in the Tracking database.D、Decrease the file growth increment for tempdb to 25 MBE、Use more local temporary tables and fewer global temporary tables in the Tracking database.
考题
多选题Which 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
考题
单选题To determine the space allocated for temporary segments, the DBA can access which of the following views? （）A
DBA_TABLESPACES B
DBA_TABLES C
DBA_SEGMENTS D
DBA_FREE_SPACE
考题
多选题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？（）AIt stores only the temporary table but not its indexes.BIt stores both the temporary table as well as its indexes.CIt must be a nondefault temporary tablespace for the database.DIt can be a default or nondefault temporary tablespace for the database.EIt must be the default temporary tablespace of the user who issues the command.
考题
多选题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.
考题
多选题Which two statements about views are true?（）AA view can be created as read only.BA view can be created as a join on two or more tables.CA view cannot have an ORDER BY clause in the SELECT statement.DA view cannot be created with a GROUP BY clause in the SELECT statement.EA view must have aliases defined for the column names in the SELECT statement.
考题
多选题Which two statements are true about simple views？（）AViews can be created as read only.BViews are data segments like tables.CViews can be created on the basis of more than one table.DData manipulation language （DML） operations cannot be performed on views.
考题
多选题Which statements are true regarding the Query Result Cache？（）AIt can be set at the system， session， or table level.BIt is used only across statements in the same session.CIt can store the results from normal as well as flashback queries.DIt can store the results of queries based on normal，temporary，and dictionary tables.
考题
多选题Which two are true regarding external tables？ （）AExternal tables can be updated.BExternal tables are read-only tables.CIndexes can be created on external tables.DIndexes cannot be created on external tables.
考题
单选题In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance？（）A
heap tableB
object tableC
external tableD
clustered tableE
global temporary tableF
indexorganized table （IOT）
考题
多选题You need to improve the performance of the tempdb database on SQL1.Which two actions should you perform？（）AMove tempdb onto a faster disk volume.BIncrease the initial size of tempdb to 1.5 GBCIncrease the size of the data files in the Tracking database.DDecrease the file growth increment for tempdb to 25 MBEUse more local temporary tables and fewer global temporary tables in the Tracking database.
热门标签
最新试卷
