单选题Which of the following are all valid DB2 data types?（）A LONG VARCHAR, SMALLINT, NUMBER, BLOBB DECIMAL, DATE, DBCLOB, INTERVALC NUMERIC, TIMESTAMP, BYTE, FLOATD NUM, TIME, XML, DOUBLE

第1题：

都是VB.NET中的数据类型的选项是（）

• A、Short、Integer、Long、Float、Double
• B、Short、Int、Long、Single、Double
• C、Integer、Long、Single、Double、Decimal
• D、Boolen、Byte、Bit、Decimal、Date

第2题：

which one of the following should maria do to display the release date in a text column?（）

• A、used the number and time format options 
• B、used the @date to text functions to convert time to text 
• C、concatenated the date types using mathematical operators 
• D、used the @text functions to convert time and number data to text in text columns 

第3题：

Which of the following DB2 data types has a fixed length?（）

• A、XML
• B、BLOB
• C、DOUBLE
• D、DBCLOB

第4题：

These are the details about V$FLASHBACK_DATABASE_STAT：  SQL> DESC V$FLASHBACK_DATABASE_STAT Name Null？ Type  ------------- -------- --------------  BEGIN_TIME DATE END_TIME DATE  FLASHBACK_DATA NUMBER  DB_DATA NUMBER REDO_DATA NUMBER  ESTIMATED_FLASHBACK_SIZE NUMBER  Which two statements regarding the V$FLASHBACK_DATABASE_STAT view are true？ （）

• A、BEGIN_TIME is the time at which Flashback logging is enabled.
• B、END_TIME is the time at which the query is executed on the view.
• C、REDO_DATA is the number of bytes of redo data written during the interval.
• D、This view contains information about flashback data pertaining to the last 24 hours.
• E、FLASHBACK_DATA is the amount of flashback data generated since the database was opened.

第5题：

Which three statements are true regarding the data types in Oracle Database 10g/11g?（）

• A、Only one LONG column can be used per table 
• B、A TIMESTAMP data type column stores only time values with fractional seconds 
• C、The BLOB data type column is used to store binary data in an operating system file 
• D、The minimum column width that can be specified for a VARCHAR2 data type column is one 
• E、The value for a CHAR data type column is blank-padded to the maximum defined column width

第6题：

You need to create a table named ORDERS that contain four columns: 1. an ORDER_ID column of number data type 2. aCUSTOMER_ID column of number data type 3. an ORDER_STATUS column that contains a character data type 4. aDATE_ORDERED column to contain the date the order was placed. When a row is inserted into the table, if no value is provided when the order was placed, today's date should be used instead. Which statement accomplishes this?（）

• A、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);
• B、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
• C、CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);
• D、CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);
• E、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);
• F、CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);

第7题：

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

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

A table was created using the following DDL: CREATE TABLE employee (id SMALLINT NOT NULL, name VARCHAR(9), dept SMALLINT CHECK (dept BETWEEN 10 AND 100), job CHAR(10) CHECK (job IN ('Sales','Mgr','Clerk')), hiredate DATE, salary DECIMAL(7,2), comm DECIMAL(7,2), PRIMARY KEY (id), CONSTRAINT yearsal CHECK (YEAR(hiredate) > 2004 OR salary > 80500) ); Which of the following INSERT statements will fail?（）

• A、INSERT INTO employee VALUES (2, 'Smith', 80, 'Mgr', '09/03/2006', 80000, NULL)
• B、INSERT INTO employee VALUES (4, 'Smith', 86, 'Mgr', '07/14/2003', 90000, NULL)
• C、INSERT INTO employee VALUES (1, 'Smith', 55, 'Sales', '07/14/2003', NULL, NULL)
• D、INSERT INTO employee VALUES (3, 'Smith', 33, 'Analyst', '11/26/2006', 90000, NULL)

第14题：

Which of the following are all valid DB2 data types?（）

• A、LONG VARCHAR, SMALLINT, NUMBER, BLOB
• B、DECIMAL, DATE, DBCLOB, INTERVAL
• C、NUMERIC, TIMESTAMP, BYTE, FLOAT
• D、NUM, TIME, XML, DOUBLE

第15题：

Which of the following datatypes store time-zone information in the database?（）

• A、TIMESTAMP
• B、DATE
• C、TIMESTAMP WITH TIME ZONE
• D、TIMESTAMP WITH LOCAL TIME ZONE
• E、DATETIME

第16题：

You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY-MM-DD. The default format of which two data types would be affected by this setting？ （）

• A、 DATE
• B、 TIMESTAMP
• C、 INTERVAL YEAR TO MONTH
• D、 INTERVAL DAY TO SECOND
• E、 TIMESTAMP WITH LOCAL TIME ZONE

第17题：

You need to create a table named ORDERS that contains four columns: 1.an ORDER_ID column of number data type 2.a CUSTOMER_ID column of number data type 3.an ORDER_STATUS column that contains a character data type 4.a DATE_ORDERED column to contain the date the order was placed When a row is inserted into the table, if no value is provided for the status of the order, the value PENDING should be used instead. Which statement accomplishes this?（）

• A、CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status NUMBER(10) DEFAULT 'PENDING', date_ordered DATE );
• B、CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );
• C、CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );
• D、CREATE OR REPLACE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) = 'PENDING', date_ordered DATE );
• E、CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered DATE );
• F、CREATE TABLE orders ( order_id NUMBER(10), customer_id NUMBER(8), order_status VARCHAR2(10) DEFAULT 'PENDING', date_ordered VARCHAR2 );

第18题：

The NLS_TERRITORY parameter specifies the default conventions to be used for which of the following globalization elements？（） 

• A、 Date format
• B、 Decimal character
• C、 Group separator
• D、 First day of the month
• E、 None of the above
• F、 All of the above

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：