搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

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;

查看正确答案
更多“Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value?（）”相关的问题
第1题
[单选题] A BGP router should use three export policies named add-communities, no-rfc1918-routes, andrejected-unwanted. Which export statement places the add-communities policy immediately before the default BGP policy?（）

A、export [add-communities no-rfc1918-routes rejected-unwanted];  B、export [no-rfc1918-routes add-communities rejected-unwanted];  C、export [add-communities rejected-unwanted no-rfc1918-routes];  D、export [no-rfc1918-routes rejected-unwanted add-communities];  

点击查看答案
第2题
[单选题] You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.Which statement accomplishes this task?（）

A、ALTER TABLE students ADD PRIMARY KEY student_id;  B、ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student _ id);  C、ALTER TABLE students ADD CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id);  D、ALTER TABLE students MODIFY CONSTRAINT stud _ id _pk PRIMARY KEY (student _ id);  

点击查看答案
第3题
[单选题] You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.Which statement accomplishes this task?（）

A、ALTER TABLE students ADD PRIMARY KEY _ id;  B、ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);  C、ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;  D、ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);  E、ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);  

点击查看答案
第4题
[单选题] You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?（）

A、ALTER TABLE students ADD PRIMARY KEY _ id;  B、ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);  C、ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;  D、ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);  E、ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);  

点击查看答案
第5题
[] Which two statements are true about TCP communication?（）

A、A. The receiver acknowledges the final packet in each communications stream.  B、B. The receiver adds sequencing numbers to the packets received.  C、C. The sender adds sequencing numbers to the packets it sends.  D、D. The receiver acknowledges each packet it receives from the sending device.  

点击查看答案
第6题
[单选题] You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?（）

A、ALTER TABLE students ADD PRIMARY KEY student_id;  B、ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);  C、ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;  D、ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);  E、ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);  

点击查看答案
第7题
[单选题] You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?（）

A、ALTER TABLE students ADD PRIMARY KEY student_id;  B、ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);  C、ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;  D、ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);  E、ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);  

点击查看答案
第8题
[单选题] You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.Which statement accomplishes this task?（）

A、ALTER TABLE students ADD PRIMARY KEY student_id;  B、ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);  C、ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;  D、ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);  E、ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);  

点击查看答案
第9题
[单选题] A BGP router should use three export policies named add-communities， no-rfc1918-routes， and rejected-unwanted. Which export statement places the add-communities policy immediately before the default BGP policy？（）

A、export [add-communities no-rfc1918-routes ejected-unwanted]；  B、export [no-rfc1918-routes add-communities rejected-unwanted]；  C、export [add-communities rejected-unwanted no-rfc1918-routes]；  D、export [no-rfc1918-routes rejected-unwanted add-communities]；  

点击查看答案
第10题
[] Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?（）

A、A.GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrp  B、B.GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1  C、C.GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrp  D、D.GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服