多选题Which statements are true regarding system-partitioned tables？（）AOnly a single partitioning key column can be specified.BAll DML statements must use partition-extended syntax.CThe same physical attributes must be specified for each partition.DUnique lo

第1题：

Which statements concerning the switch construct are true？（）  

• A、All switch statements must have a default label.
• B、There must be exactly one label for each code segment in a switch statement.
• C、The keyword continue can never occur within the body of a switch statement.
• D、No case label may follow a default label within a single switch statement.
• E、A character literal can be used as a value for a case label.

第2题：

Which statement is true regarding the INTERSECT operator?（）

• A、It ignores NULL values 
• B、Reversing the order of the intersected tables alters the result 
• C、The names of columns in all SELECT statements must be identical 
• D、The number of columns and data types must be identical for all SELECT statements in the query 

第3题：

第4题：

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.

第5题：

Which of the following statements is true regarding implementing Live Partition Mobility on two existing POWER6 based systems?（）

• A、The systems must use internal storage for boot purposes. 
• B、All virtualized ethernet adapters must be numbered below 10. 
• C、The mobile partition's network and disk access must be virtualized. 
• D、Each system must be controlled by a different Hardware Management Console (HMC). 

第6题：

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.

第7题：

Which three statements are true regarding subqueries?（）

• A、Subqueries can contain GROUP BY and ORDER BY clauses 
• B、Main query and subquery can get data from different tables 
• C、Main query and subquery must get data from the same tables 
• D、Subqueries can contain ORDER BY but not the GROUP BY clause 
• E、Only one column or expression can be compared between the main query and subquery
• F、 Multiple columns or expressions can be compared between the main query and subquery

第8题：

第9题：

Which three statements are true regarding the use of the Database Migration Assistant for Unicode(DMU)?（）

• A、A DBA can check specific tables with the DMU
• B、The database to be migrated must be opened read-only.
• C、The release of the database to be converted can be any release since 9.2.0.8.
• D、The DMU can report columns that are too long in the converted characterset.
• E、The DMU can report columns that are not represented in the converted characterset.

第10题：

Which three statements describe the functionality of the DO_KEY built-in?（）

• A、It accepts both a built-in and a key name as argument. 
• B、If no key trigger is defined, the specified built-in executes. 
• C、Its parameter must be specified in upper case, enclosed in single quotation marks. 
• D、It performs the same task as if you pressed the function key associated with the specified argument. 
• E、It executes the key trigger that corresponds to the built-in specified as its parameter.