-
使用“CREATE DATABASE TEST”命令所建立的数据库TEST的数据文件的初始大小是（）字节。
A . 1M
B . 2M
C . 3M
D . 4M
-
Which are SRW package procedure or function could you use to create and then drop a temporary table in the sales report?（）
A . SRW.BREAK
B . SRW.SET_ALTER
C . SRW.REFERENCE
D . SRW.DO_SQL
E . SRW.RUN_REPORT
F . SRW.SET_FIELD
-
默认约束是在CREATE TABLE或ALTER TABLE语句中定义的，删除表的时候默认约束也随之删除了。
A . 正确
B . 错误
-
Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER（6）， oamt NUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command） （）
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.
-
由以下语句创建的表有种子字段，请正确组合插入语句，可不分先后。CREATE TABLE Customer（id int IDENTITY PRIMARY KEY，Customer varchar（40））（）
A . INSERT INTO Customer
B . SET IDENTITY_INSERT Customer ON
C . VALUES（3，’garden shovel’）
D . （id，Customer）
-
ForPro命令CREATE TABLE客户（客户号C（8），净水器编号C（18），类型C（8））的作用是（）。
A . 创建“客户”数据库
B . 创建“客户”表，表中有3个字段，1条空记录
C . 创建“客户”表，表中有3个字段，1条记录
D . 创建“客户”表，表中有3个字段，0条记录
-
Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully?（）
A . FORMS_DDL
B . DO_SQL
C . FORM_SUCCESS
D . FORM_NOT_SUCCESS
E . DBMS.ERROR_CODE
-
In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.（） Mysql＞ SELECT * INTO OUTFILE '/tmp/t1.sql' from t1; mysql＞ TRUNCATE t1;
A . $ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql
B . Mysql＞ INSERT INTO t1 VALUES FROM '/tmp/t1.sql'
C . $ mysql – u root – p – h localhost test ＜ /tmp/t1.sql
D . Mysql＞ LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1
E . $ mysqlinport – u root – p – h localhost test /tmp/t1.sql
-
A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）
A . REFERENCES
B . SELECT
C . UPDATE
D . ALTER
-
You want to create a temporary table while executing a procedure in a form. Which statement is true?（）
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.
-
CREATE TABLE dept (deptno NUMBER(2), dname VARCNAR2(14), 1oc VARCNAR2 (13)); ROLLBACK; DESCRIBE DEPT What is true about the set? （）
A . The DESCRIBE DEPT statement displays the structure of the DEPT table.
B . The ROLLBACK statement frees the storage space occupies by the DEPT table.
C . The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
D . The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
-
假设在数据库中创建了用户test，需要为其授予CREATE ANY TABLE系统权限，可以使用如下（）语句。
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
-
Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command（）
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.
-
管理员在执行create database benet usebenet create table benet01（column1int，column2int）语句时，发生了错误，如何修改（）
A . 分别执行每一句
B . 将各个语句使用go分开再执行
C . 不能将表格命名为benet01
D . 不能将数据库命名为benet
-
Evaluate the CREATE TABLE statement： CREATE TABLE products （product_id NUMBER （6） CONSTRAINT prod_id_pk PRIMARY KEY， product_name VARCHAR2 （15））； Which statement is true regarding the PROD_ID_PK constraint？（）
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.
-
Which is a valid CREATE TABLE statement? （）
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))
-
You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results? （）
A . CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;
B . CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;
C . GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
-
更改“成绩表”以添加新列“column_a” CREATE TABLE 成绩表 ADD column_a VARCHAR(20) NULL
-
从当前数据库中删除Test表及其数据和索引的语句为：DROP TABLE 教务管理.dbo.Test
-
CREATE TABLE是______功能的SQL语句。CREATE TABLE是______功能的SQL语句
-
使用SQL的CREATE TABLE语句建立数据库表时，为了说明主关键字应该使用关键词 KEY。使用SQL的CREATE TABLE语句建立数据库表时，为了说明主关键字应该使用关键词 KEY。
-
The following statements:CREATE TABLE t1 （col1 INT NOT NULL, PRIMARY KEY（col1)); CREATE TA
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.可以定义一个新的
在Visual FoxPro中，下列关于SQL表定义语句(CREATE TABLE)的说法错误的是（）。
A.可以定义一个新的基本表结构
B.可以定义数据库表中的主关键字
C.可以定义表的域完整性、字段有效性规则等
D.对自由表，同样可以实现其完整性、有效性规则等信息的设置
-
考虑如下数据表和查询，如何添加索引功能提高查询速度？（)Create table mytable（Id int,Name
考虑如下数据表和查询，如何添加索引功能提高查询速度？()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添加索引
