[单项选择] 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)

[单项选择]Which of the following technologies was created to reduce cost, increase cable length, and uses 3.3v across the line?（）
A. Wide-Ultra2 SCSI-3
B. High-Voltage Differential
C. Low-Voltage Differential
D. Fibre Channel

[单项选择]Given the following DDL for the PARTS table:CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever the table is queried. Which of the following create index statements will meet this criteria and require the least amount of storage for the index object?（）
A. CREATE UNIQUE INDEX idx_partno ON parts(part_no)
B. CREATE UNIQUE INDEX idx_partno ON parts(part_name ASC)
C. CREATE UNIQUE INDEX idx_partno ON parts(part_name, part_no ASC)
D. CREATE UNIQUE INDEX idx_partno ON parts(part_no, part_name ASC)

[单项选择]A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3, col4 FROM t1 WHERE col4 > 1000 WITH CHECK OPTIONWhat is the effect of the CHECK OPTION clause?（）
A. Any row inserted or updated through view V1 must meet the condition that col4 > 1000.
B. From now on, any row inserted or updated in table T1 must meet the condition that col4 > 1000, but existing rows in the table are not checked.
C. At view creation, DB2 will check the data in table T1, and if in any row doesn't meet the condition col4 > 1000, the view creation will be rejected.
D. Any row inserted or updated through view V1 must meet the condition that col4 > 1000 and no row in table T1 can be updated such that col4 <= 1000, but new rows in the table can be inserted with col4 <= 1000.

[单项选择]A trigger can be created on which of the following objects?（）
A. View
B. Catalog Table
C. Stored Procedure
D. Global Temporary Table

[单项选择] The INV_HISTORY table is created using the command：   SQL>CREATE TABLE INV_HISTORY （inv_no NUMBER（3）， inv_date DATE， inv_amt NUMBER（10，2）） partition by range （inv_date） interval （numtoyminterval（1，’month’）） （partition p0  values less than （to_date（’01-01-2005’，’dd-mm-yyyy’））， partition p1 values less than （to_date（’01-01-2006’，’dd-mm-yyyy’）））；   The following data has been inserted into the INV_HISTORY table ：   INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000 2 30-dec-2005 2000 3 1-feb-2006 3000 4 1-mar-2006 4000 5 1-apr-2006 5000   You would like to store the data belonging to the year 2006 in a single partition and issue the command：   SQL> ALTER TABLE inv_history MERGE PARTITIONS  FOR（TO_DATE（’15-feb-2006’，’dd-mon-yyyy’））， FOR（TO_DATE（’15-apr-2006’）） INTO PARTITION sys_py；  What would be the outcome of this command？（）
A.  It executes successfully，and the transition point is set to ’1-apr-2006’.
B.  It executes successfully，and the transition point is set to ’15-apr-2006’.
C.  It produces an error because the partitions specified for merging are not adjacent.
D.  It produces an error because the date values specified in the merge do not match the date values stored in the table.

[单项选择]Which of the following characteristics would create the least difficulty in estimating a bond's cash flows（）
A. Variable coupon rate.
B. Put-able bond.
C. Non-callable bond.

[单项选择]DDL是( )。
A. 操作数据语言
B. 定义数据的语言
C. 自含语言
D. 宿主语言

[单项选择] Examine the CREATE DISKGROUP command used to create a disk group: SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK 'ORCL: FRA3' NAME misc1, 'ORCL: FRA4' NAME misc2; In which situation would you use this method of disk group creation?（）
A. When two-way disk mirroring is required for the allocation units
B. When three-way disk mirroring is required for the allocation units
C. When using hardware mirroring or RAID
D. When disk mirroring is required for the Automatic Storage Management (ASM) disks

[单项选择]Which is NOT among the reasons that India is creating a secondary sanctuary for the Asiatic lions
A. Two many of them in the present sanctuary.
B. Possible outbreak of disease.
C. Clashing with people.
D. Food shortage.

[单项选择]We learn from the passage that an emotion is created by something that ______.
A. one thinks bad or good
B. one feels in danger
C. one faces in the outside world
D. one tries to escape from real life

[单项选择]数据库管理系统提供数据定义语言(DDL)及它的翻译程序，DDL定义数据库的模式、外模式和内模式，并通过翻译程序分别翻译成相应的目标模式，存放在( )。
A. 数据库
B. 数据字典
C. 数据库管理系统
D. 操作系统