Indexes and views can be created on temporary tables.
Both the data and the structure of temporary tables can be exported.
Temporary tables are always created in a user’s temporary tablespace.
The data inserted into a temporary table in a session is available to other sessions.
Data manipulation language (DML) locks are never acquired on the data of temporary tables
第1题:
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.None
B.Ⅰ and Ⅱ
C.Ⅱ and Ⅲ
D.All
第2题:
Which of the following statements about ORACLE is (are) correct?
Ⅰ.ORACLE follows SQL standard
Ⅱ.ORACLE database defines two logical types: table and view
A.Ⅰonly
B.Ⅱ only
C.Ⅰ and Ⅱ
D.none of the above
第3题:
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 only
B 1 and 3 only
C 1 and 2 only
D All three statements are correct
第4题:
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.
第5题:
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.
第6题:
In the following statements about graph operations,which one is NOT correct?
A.Finding critical path is an operation on directed graph
B.Finding critical path is an operation on undirected graph
C.Spanning tree of a graph may not be unique
D.Minimum spanning tree of a graph may not be unique
第7题:
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.
第8题:
19 Which of the following statements about intangible assets in company financial statements are correct according
to 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 only
B 1 and 2 only
C 2 and 3 only
D All three statements are correct
第9题:
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 tablespaces
D. It will detect and advise about chained rows.
E. It may advise the use of segment shrink for free list managed tables.
第10题:
In HDLC Protocol, when Supervisory Frame's type code is '00'.About the following statements, which is correct.
A.Receive Ready
B.Receive not Ready
C.Reject
D.Selective Reject