多项选择题
Examine the list of variables and their data types:
AME DATA Type
TS, TS1 TIMESTAMP
TSZ TIMESTAMP WITH TIME ZONE
TLZ TIMESTAMP WITH LOCAL TIME ZONE
IYM INTERVAL YEAR TO MONTH
IDS, IDSI INTERVAL YEAR To SECOND
Which three expressions using the new data and time data types are valid?()
A.IDS* 2
B.TS + IYM
C.TS –TSI
D.IDS – TS
E.IDS + IYM
相关考题
-
单项选择题
Whatistrueifyouwanttoswitchundotablespacesfromthecurrentone,calledUNDO1,toanewonecalledUNDO2?()
A.It is NOT possible to switch unless no active transaction exist in UNDO1.
B.It is possible to switch to UNDO2; but current active transactions will abort.
C.It is possible to switch to UNDO2; current active transactions will be automatically migrated to UNDO2.
D.It is possible to switch to UNDO2; only current active transactions will continue to execute inside UNDO1. -
单项选择题
WhichstatementcorrectlydescribesthefunctionofOracle9iCacheFusionfeature?()
A.It provides each session with its own view of the database at a different point in the past.
B.It enables you to execute scalable applications on a clustered database without having to partition the users or the database tables.
C.It lets you dynamically reassign memory in your database buffer cache to different block buffer sizes.
D.It allows you to add new sites to multimaster replication environment without quiescing the master definition site. -
多项选择题
Whatarethreebenefitsofperformingdatadefinitionlanguage(DDL)statementsagainstapartitionedtablewiththeUPDATEGLOBALINDEXESclause?()
A.Global indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with the UNUSABLE status.
B.You do not have to search for invalid global indexes after the DDL command completes and rebuild them individually.
C.Global indexes are maintained during the operation of the DDL command and therefore can be used by any concurrent query.
D.Global indexes remain intact and available for use by data manipulation language (DML) statements even for sessions that have not enabled the skipping of unusable indexes.
