网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
多选题
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” 相关考题
考题 15 Which of the following statements about intangible assets are correct?1 If certain criteria are met, research expenditure must be recognised as an intangible asset.2 Goodwill may not be revalued upwards.3 Internally generated goodwill should not be capitalised.A 2 and 3 onlyB 1 and 3 onlyC 1 and 2 onlyD All three statements are correct

考题 19 Which of the following statements about intangible assets in company financial statements are correct accordingto international accounting standards?1 Internally generated goodwill should not be capitalised.2 Purchased goodwill should normally be amortised through the income statement.3 Development expenditure must be capitalised if certain conditions are met.A 1 and 3 onlyB 1 and 2 onlyC 2 and 3 onlyD All three statements are correct

考题 Which of the following statements about internet is (are) correct?Ⅰ.Each host in internet only has a IP address.Ⅱ.It is possible to have multiple names corresponding to the same IP address.Ⅲ.In users' points, Internet means a virtual network.A.NoneB.Ⅰ and ⅡC.Ⅱ and ⅢD.All

考题 In the following statements about graph operations,which one is NOT correct?A.Finding critical path is an operation on directed graphB.Finding critical path is an operation on undirected graphC.Spanning tree of a graph may not be uniqueD.Minimum spanning tree of a graph may not be unique

考题 Which of the following statements about ORACLE is (are) correct?Ⅰ.ORACLE follows SQL standardⅡ.ORACLE database defines two logical types: table and viewA.ⅠonlyB.Ⅱ onlyC.Ⅰ and ⅡD.none of the above

考题 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.

考题 Which two statements are true about a Work Item with "Open" Notification? ()(Choose two.) A. The Work Item is not eligible for Purge.B. The Work Item is eligible for a Permanent purge.C. The Work Item is eligible for a Temporary purge.D. The Work Item is not complete because it still has Open Notification.E. The Work Item is eligible for both Temporary and Permanent purge.

考题 You use the segment advisor to help determine objects for which space may be reclaimed.Which three statements are true about the advisor given by the segment advisor?() A. It may advise the use of online table redefinition for tables in dictionary managed tablespace.B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.C. It may advise the use of online table redefinition for tables in locally managed tablespacesD. It will detect and advise about chained rows.E. It may advise the use of segment shrink for free list managed tables.

考题 Which statement is correct about a Routing Policy term?() A.A term must contain a from statement.B.A term acts like if and then statements.C.The most specific term has precedence.D.Terms can be written in any order to achieve the same behavior.

考题 In HDLC Protocol, when Supervisory Frame's type code is '00'.About the following statements, which is correct.A.Receive ReadyB.Receive not ReadyC.RejectD.Selective Reject

考题 Which of the following statements is true regarding the VERSIONS BETWEEN clause?()  A、 The VERSIONS BETWEEN clause may be used in DML statements.B、 The VERSIONS BETWEEN clause may be used in DDL statements.C、 The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.D、 The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.

考题 Which two statements about layer 3 access designs are correct?()A、 IP address space is difficult to manage.B、 Broadcast and fault domains arc increasedC、 Convergence time is fractionally slower than STPD、 Limits on clustering and NIC teaming are removedE、 Fast uplink convergence is supported tor failover and fallback

考题 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 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 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.

考题 多选题Which two statements about layer 3 access designs are correct?()AIP address space is difficult to manage.BBroadcast and fault domains arc increasedCConvergence time is fractionally slower than STPDLimits on clustering and NIC teaming are removedEFast uplink convergence is supported tor failover and fallback

考题 多选题You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?()AIt may advise the use of online table redefinition for tables in dictionary managed tablespace.BIt may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.CIt may advise the use of online table redefinition for tables in locally managed tablespacesDIt will detect and advise about chained rows.EIt may advise the use of segment shrink for free list managed tables.

考题 多选题Which two statements are correct about routing tables in JUNOS?()AThere are separate tables for IPv4 and IPv6 called inet.0 and inet6.0 respectively.BThey only contain the best possible route to each destination.CAll running protocols can populate the routing tables at the same time.DRoutes with the highest preference value are placed as active routes in the routing table.

考题 多选题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  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 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 statements regarding the Flashback Table feature are correct?()AFlashback Table can be performed on system tables.BFlashback Table operation does not shrink the segments.CFlashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.DFlashback Table operation acquires exclusive data manipulation language (DML) locks.

考题 单选题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.

考题 多选题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 of the following statements about general cargoes is not correct?()A General cargoes are neither liquid nor solid bulk cargoB General cargoes are packaged hazardous cargoesC General cargoes are also called breakbulk cargoesD General cargoes are mostly carried on container ships now

考题 单选题Which of the following statements is true regarding the VERSIONS BETWEEN clause?()A  The VERSIONS BETWEEN clause may be used in DML statements.B  The VERSIONS BETWEEN clause may be used in DDL statements.C  The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.D  The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.

考题 多选题Which two statements are true about a Work Item with "Open" Notification? ()(Choose two.)AThe Work Item is not eligible for Purge.BThe Work Item is eligible for a Permanent purge.CThe Work Item is eligible for a Temporary purge.DThe Work Item is not complete because it still has Open Notification.EThe Work Item is eligible for both Temporary and Permanent purge.