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

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

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

[单项选择]子模式DDL用来描述( )。
A. 数据库的总体逻辑结构
B. 数据库的局部逻辑结构
C. 数据库的物理存储结构
D. 数据库的概念结构

[单项选择]A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_sequence CACHE 10 ORDER The following statements are successfully executed in sequence through separate database connections: CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO :con1hvar CONNECTION2 - VALUES NEXT VALUE FOR my_sequence INTO :con2hvar CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO:con1hvarWhat is the current value of the :con1hvar host variable?（）
A. 2
B. 3
C. 11
D. 30

[单项选择] Given the following DDL and INSERT statements: CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 > 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 < 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100); How many of these INSERT statements will be successful?（）
A. 0
B. 1
C. 2
D. 3

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

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

[单项选择]子模式DDL用来描述数据库的( )。
A. 总体逻辑结构
B. 局部逻辑结构
C. 物理存储结构
D. 概念结构

[单项选择]数据库管理系统提供的DDL语言的功能是( )。
A. 实现对数据库的检索、插入、修改与删除
B. 描述数据库的结构和为用户建立数据库提供手段
C. 用于数据的安全性控制、完善性控制和并发控制
D. 提供数据初始装入、数据转储、数据库恢复和数据库重新组织等手段

[单项选择]下述哪个不是sql中的数据定义语言（ddl）？（）
A. drop
B. commit
C. create
D. alert

[多项选择]下列SQL语句中属于数据定义语句（DDL）的是（）
A. DELETE
B. ALTER
C. RENAME
D. TRUNCATE