ForPro命令CREATE TABLE客户（客户号C（8），净水器编号C（18），类型C（8））的作用是（）。

A . ALTER TABLE test ADD t_sex CHAR（2） B . ALTER TABLE test ADD t_sex C . ALTER TABLE test ALTER t_sex CHAR（2） D . ALTER TABLE test DROP（t_sex CHAR（2））

A . 正确 B . 错误

A . A CHECK constraint is created on the OID column. B . A NOT NULL constraint is created on the OID column. C . The ORDERS table is the only object created in the USERS tablespace. D . The ORDERS table and a unique index are created in the USERS tablespace. E . The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.

A . A、潜在 B . B、特殊 C . C、非正式

A . REFERENCES B . SELECT C . UPDATE D . ALTER

A . You cannot create a table form within Forms.  B . You must use the FORMS_DDL built-in to create the table.  C . You must use the DBMS_DYNAMIC_DDL package to create the table.  D . You can write the CREATE TABLE statement directly into the trigger.

A . GRANT CREATE ANY TABLE test B . GRANT CREATE ANY TABLE TO test C . TAKE CREATE ANY TABLE TO test D . ALTER CREATE ANY TABLE TO test

A . A CHECK constraint is created on the OID column. B . A NOT NULL constraint is created on the OID column. C . The ORDERS table is the only object created in the USERS tablespace. D . The ORDERS table and a unique index are created in the USERS tablespace. E . The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.

A . 管理 B . 分析 C . 服务

A . 分别执行每一句 B . 将各个语句使用go分开再执行 C . 不能将表格命名为benet01 D . 不能将数据库命名为benet

A .  It would be created only if a unique index is manually created first. B .  It would be created and would use an automatically created unique index. C .  It would be created and would use an automatically created nonunique index. D .  It would be created and remains in a disabled state because no index is specified in the command.

A . CREATE TABLE EMP9$# AS (empid number(2)); B . CREATE TABLE EMP*123 AS (empid number(2)); C . CREATE TABLE PACKAGE AS (packid number(2)); D . CREATE TABLE 1EMP_TEST AS (empid number(2))

A . DELETE TABLE order WHERE签订日期<{^2002-1-1} B . DELETE TABLE order WHILE签订日期<{^2002-1-1} C . DELETE FROM order WHERE签订日期<{^2002-1.1} D . DELETE FROM order WHILE签订日期<{^2002一1—1}

The following statements:CREATE TABLE t1 (col1 INT NOT NULL, PRIMARY KEY(col1)); CREATE TABLE t2 (col1 INT NOT NULL, col2 CHAR(1) NOT NULL, PRIMARY KEY (col1, col2), FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE CASCADE ON UPDATE RESTRICT); CREATE TABLE t3 (col1 INT NOT NULL, col2 INT NOT NULL, PRIMARY KEY (col1, col2),FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE NO ACTION ON UPDATE RESTRICT);INSERT INTO t1 VALUES (1), (2); INSERT INTO t2 VALUES (1, ‘a‘), (1, ‘b‘), (2,‘c‘); INSERT INTO t3 VALUES (1, 100), (2, 200), (2,300);How many rows will be deleted by the following DELETE statement？ DELETE FROM t1 WHERE col1= 1;（） A.4 B.3 C.1 D.0

在Visual FoxPro中，下列关于SQL表定义语句(CREATE TABLE)的说法错误的是（）。 A.可以定义一个新的基本表结构 B.可以定义数据库表中的主关键字 C.可以定义表的域完整性、字段有效性规则等 D.对自由表，同样可以实现其完整性、有效性规则等信息的设置

考虑如下数据表和查询，如何添加索引功能提高查询速度？()Create table mytable(Id int,Name char(100),Address1 varchar(100),Address2 varchar(100),Zipcode varshar(10),Sity varchar(50),Province varchar(2))Select id, varcharFrom mytableWhe A.给Zipcode添加全文的索引 B.给Name添加索引 C.给Id添加索引，然后给Name和Zipcode分别添加索引 D.给id添加索引

A．住院号 B． 姓名 C． 病房 D． 家庭住址

A．（电话）REFERENCES（职工电话） B．（部门号）REFERENCES部门（部门号） C．（部门号）REFERENCES职工（部门号） D．（负责人代码）REFERENCES 职工（职工号）

A、SELECT Country FROM CustomersGROUP BY Country HAVING COUNT (Country)>=10 B、SELECT TOP 10 Country FROM Customers C、SELECT TOP 10 Country FROM Customers FROM (SELECT DISTINCT Country FROM Customers) AS XGROUP BY Country HAVING COUNT(*)>= 10 D、SET ROWCOUNT 10SELECT Country, COUNT (*) as “NumCountries”FROM CustomersGROUP BY Country ORDER BY NumCountries, Desc

A．SELECT*FROM客户FOR名称LIKE"%网络%" B．SELECT*FROM客户FOR名称="%网络%" C．SELECT*FROM客户WHERE名称="%网络%" D．SELECT*FROM客户WHERE名称LIKE"%网络%"