-
Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?（）
A . ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;
B . ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL;
C . ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn NOT NULL;
D . ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL;
E . ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL;
F . ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL
-
For an HttpServlet Response response， which two create a custom header（）
A . response.set Header （“X-MyHeader”. “34”）：
B . response.addHeader （“X-MyHeader”. “34”）：
C . response. Set Header （new Http Header （“X-MyHeader”. “34”））：
D . response.addHeader（new Http Header （“X-MyHeader”. “34”））：
E . response. addHeader （new Servlet Header （“X-MyHeader”. “34”））：
F . response. setHeader （new Servlet Header （“X-MyHeader”， “34”））：
-
Which of the following WebSphere Commerce user roles can create new customer care queues？（）
A . Account Representative
B . Customer Service Representative
C . Logistics Manager
D . Customer Service Supervisor
-
默认约束是在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条记录
-
The CUSTOMERS table has these columns:
https://assets.asklib.com/images/image2/2018080116294948484.jpg
The CUSTOMER_ID column is the primary key for the table.Which two statements find the number of customers? （）
A . SELECT TOTAL(*) FROM customers;
B . SELECT COUNT(*) FROM customers;
C . SELECT TOTAL(customer_id) FROM customers;
D . SELECT COUNT(customer_id) FROM customers;
E . SELECT COUNT(customers) FROM customers;
F . SELECT TOTAL(customer_name) FROM customer
-
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
-
假设在数据库中创建了用户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))
-
The CUSTOMERS table has these columns:
https://assets.asklib.com/images/image2/2018080116181325145.jpg
Which statement finds the rows in the CUSTOMERS table that do not have a postal code?（）
A . SELECT customer_id, customer_name FROM customers WHERE postal_code CONTAINS NULL;
B . SELECT customer_id, customer_name FROM customers WHERE postal_code = '________';
C . SELECT customer_id, customer_name FROM customers WHERE postal_code IS NULL;
D . SELECT customer_id, customer_name FROM customers WHERE postal code IS NVL;
E . SELECT customer_id, customer_name FROM customers WHERE postal_code = NULL
-
更改“成绩表”以添加新列“column_a” CREATE TABLE 成绩表 ADD column_a VARCHAR(20) NULL
-
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添加索引
-
公司有一个客户的数据表，此表的建立语句如下：CREATE TABLE Customers（CustomerID int NOT NULL, CustomerName varchar（50) NOT NULL, ContactName varchar（30) NULL, Phone varchar（20) NULL, Country varchar（30) NOT NULL, CONSTRAINT
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
-
对于下面一段程序，当语句4执行出错后，应该执行哪条语句______。 exec sql whenever sqlerror continue； //语句1 exec sql whenever sqlerror goto s2； //语句2 exec sql whenever sqlerror goto handle_error； //语句3 … … Exec sql create table custs //语句4 （cids char（4) not null, cname varchar（13), … …)； if （strcmp（SQLSTATE, “82100”) == 0) //语句5 ＜处理82100错误的程序＞ … s2：… … //语句6 … handle_error：… … //语句7 …
A．执行语句2
B．执行语句3
C．执行语句5
D．执行语句6
-
Values of attribute Customer_ID in table BORROW（Customer_ID, Loan_no) must be the values o
Values of attribute Customer_ID in table BORROW(Customer_ID, Loan_no) must be the values of Customer_ID that have already existed in table CUSTOMER(Customer_ID, Customer_Name, Address), this constraint is called :
A、Entity integrity
B、Referential integrity
C、Check constraint
D、User defined constraint
