网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
在数据库中，删除数据表student的命令是什么？ (1.0分) [单选.]
A. delete table student B. delete student C. drop student D. drop table student
参考答案
更多 “在数据库中，删除数据表student的命令是什么？ (1.0分) [单选.] A. delete table student B. delete student C. drop student D. drop table student ” 相关考题
考题
删除视图STUDENT的命令是( )。A．DELETE STUDENT VIEWB．DELETE STUDETNC．DROP STUDENT VIEWD．DROP VIEW STUDENT
考题
如果要删除Student数据库中的Information表，可以使用下列哪个命令?一——A．ALTER TABLE InformationB．TRUNCATE TABLE InformationC．DROP。TABLE InformationD．DELETE TABLE Information
考题
从student表删除年龄大于30的记录的正确SQL命令是（ ）。A.DELETE FOR年龄30B.DELETE FROM student WHERE年龄30C.DELETE student FOR年龄30D.DELETE student WHERE年龄30
考题
由于学号(SN)为00291的学生已毕业，欲在关系“Student”中删除该学生的所有信息，用元组关系演算语言实现应为(53)。A．GET W(Student): Student. SN = 00291' DELETE WB．GET W: Student. SN = 00291'in Student DELETE WC．HOLD W(student): Student. SN = 00291' DELETE WD．HOLD W: Student. SN = 00291'in Student DELETE W
考题
You need to design a student registration database that contains several tables storing academic information.The STUDENTS table stores information about a student. The STUDENT_GRADES table storesinformation about the student‘s grades. Both of the tables have a column named STUDENT_ID. The STUDENT_ID column in the STUDENTS table is a primary key.You need to create a foreign key on the STUDENT_ID column of the STUDENT_GRADES table thatpoints to the STUDENT_ID column of the STUDENTS table. Which statement creates the foreign key?（）A. CREATE TABLE student_grades (student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk REFERENCES (student_id) FOREIGN KEY student (student_id));B. CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));C. CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT FOREIGN KEY (student_id) REFERENCES student (student_id));D. CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));
考题
根据SQL标准，删除表student中对字段sno的唯一性约束，应该使用下面哪条语句? ()A drop sno from table studentB alter table student drop snoC alter table student drop unique(sno)D alter table student drop sno unique
考题
根据SQL标准，要删除表student中所有数据，但不将表student的定义一起删除，下面哪个语句可以适用?()A delete from studentB delete all from studentC delete * from studentD drop table student
考题
Which statement explicitly names a constraint? ()
A. ALTER TABLE student_grades ADD FOREIGN KEY (student_id) REFERENCES students (student_id);B. ALTER TABLE student_grades ADD CONSTRAINT NAME = student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);C. ALTER TABLE student_grades ADD CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);D. ALTER TABLE student grades ADD NAMED CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);E. ALTER TABLE student grades ADD NAME student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);
考题
Examine the statement:GRANT select, insert, updateON student_gradesTO managerWITH GRANT OPTION;Which two are true?()
A. MANAGER must be a role.B. It allows the MANAGER to pass the specified privileges on to other users.C. It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.D. It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.E. It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.F. It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
考题
从student表删除年龄大于30的记录的正确SQL命令是（ ）。A. DELETE FOR年龄30B. DELETE FROM student WHERE年龄30C. DELETE student FOR年龄30D. DELETE student WHERE年龄30
考题
删除student表中“平均成绩”字段的正确SQL命令是（ ）。A. DELETE TABLE student DELETE COLUMN平均成绩B. ALTER TABLE student DELETE COLUMN平均成绩C. ALTER TABLE student DROP COLUMN平均成绩D. DELETE TABLE student DROP COLUMN平均成绩
考题
删除student表的“平均成绩”字段的正确SQL命令是( )。A.DELETE TABLE student DELETE COLUMN平均成绩B.ALTER TABLE student DELETE COLUMN平均成绩C.ALTER TABLE student DROP COLUMN平均成绩D.DELETE TABLE student DROP COLUMN平均成绩
考题
一个信息表student，要求它由学号sno，姓名sname，性别sex，年龄age，4个属性组成。现在对这个现有的表增加一个入学时间cometime字段为日期型，下列语句正确的是______。A．AITER TABLE student ADD cometime DATE NOT NULL;B．ALTER TABLE student ADD cometime DATE;C．ALTER TABLE student DROP cometime DATE NOT NULL;D．ALTER TABLE student MODIPY cometime DATE;
考题
删除视图STUDENT的命令是（ ）。A.DELETE STUI)ENT VIEWB.DELETE STUI)ETNC.DROP STUDENT VIEWD.DROP VIEW STUDENT
考题
删除student表的“平均成绩”字段的正确SQL命令是A．DELETE TABLE student DELETE COLUMN平均成绩B．ALTER TABLE student DELETE C0LUMN平均成绩C．ALTER TABLE student DROP COLUMN平均成绩D．DELETE TABLE student DROP COLUMN平均成绩
考题
删除student表中“平均成绩”字段的正确SQL命令是（ ）。A.DELETE TABLE student DELETE COLUMN平均成绩B.ALTER TABLE student DELETE COLUMN平均成绩C.ALTER TABLE student DROP COLUMN平均成绩D.DELETE TABLE student DROP COLUMN平均成绩
考题
You need to design a student registration database that contains several tables storing academic information. The STUDENTS table stores information about a student. The STUDENT_GRADES table stores information about the student's grades. Both of the tables have a column named STUDENT_ID. The STUDENT_ID column in the STUDENTS table is a primary key. You need to create a foreign key on the STUDENT_ID column of the STUDENT_GRADES table that points to the STUDENT_ID column of the STUDENTS table. Which statement creates the foreign key?（）A、CREATE TABLE student_grades (student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk REFERENCES (student_id) FOREIGN KEY student (student_id));B、CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));C、CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT FOREIGN KEY (student_id) REFERENCES student (student_id));D、CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));
考题
Which statement explicitly names a constraint? （）A、ALTER TABLE student_grades ADD FOREIGN KEY (student_id) REFERENCES students (student_id);B、ALTER TABLE student_grades ADD CONSTRAINT NAME = student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);C、ALTER TABLE student_grades ADD CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);D、ALTER TABLE student grades ADD NAMED CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);E、ALTER TABLE student grades ADD NAME student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);
考题
Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?（）A、MANAGER must be a role.B、It allows the MANAGER to pass the specified privileges on to other users.C、It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.D、It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.E、It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.F、It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
考题
数据库中有一张表名称为Student，有列Number，Name，Age，IDCard，Sex。主键是Number，数据类型为Varchar（20）。要求写删除学号为“20140001”的学生，下列哪个SQL语句是正确的（）A、Delete Student‘20140001’B、Delete Student“20140001”C、Delete Student Where Number=‘20140001’"D、Delete From Student Where Number=”20140001”"
考题
在SQL Server数据库中，已有数据表student，可以删除该表数据的命令是（）。A、DROP FROM studentB、DELETE FROM studentC、REMOVE FROM studentD、KILL FROM student
考题
假设某数据表中有一个"生日"字段，删除80年出生的学生记录的语句是（）A、DELETE FROM Student WHERE生日Between #80-01-01#And#80-12-31#B、DELETE FROM Student WHERE生日Between（"80-01-01"And"80-12-31"）C、DELETE FROM Student WHERE生日Between（"80.01.01"And"80.12.31"）D、DELETE FROM Student WHERE生日Between #80.01.01#And#80.12.31#
考题
问答题已知数据表Student存储在SQL Server服务器的School数据库中，用户名为sa，密码为xyz123，创建student数据表的命令为： CREATE TABLE Student （ SName varchar（20） Primary Key Not NULL， SPwd Varchar（15） Not NULL ） 试根据下面的代码使用命令对象完成在student数据表中插入一条记录。
考题
单选题Which statement explicitly names a constraint?（）A
ALTER TABLE student_grades ADD FOREIGN KEY (student_id) REFERENCES students (student_id);B
ALTER TABLE student_grades ADD CONSTRAINT NAME = student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);C
ALTER TABLE student_grades ADD CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);D
ALTER TABLE student grades ADD NAMED CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);E
ALTER TABLE student grades ADD NAME student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id);
考题
单选题You need to design a student registration database that contains several tables storing academic information. The STUDENTS table stores information about a student. The STUDENT_GRADES table stores information about the student's grades. Both of the tables have a column named STUDENT_ID. The STUDENT_ID column in the STUDENTS table is a primary key. You need to create a foreign key on the STUDENT_ID column of the STUDENT_GRADES table that points to the STUDENT_ID column of the STUDENTS table. Which statement creates the foreign key?（）A
CREATE TABLE student_grades (student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk REFERENCES (student_id) FOREIGN KEY student (student_id));B
CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));C
CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT FOREIGN KEY (student_id) REFERENCES student (student_id));D
CREATE TABLE student_grades(student_id NUMBER(12),semester_end DATE, gpa NUMBER(4,3), CONSTRAINT student_id_fk FOREIGN KEY (student_id) REFERENCES students (student_id));
考题
单选题删除student表的“平均成绩”字段的正确SQL命令是（ ）。A
DELETE TABLE student DELETE COLUMN平均成绩B
ALTER TABLE student DELETE COLUMN平均成绩C
ALTER TABLE student DROP COLUMN平均成绩D
DELETE TABLE student DROP COLUMN平均成绩
热门标签
最新试卷
