问题

You need to modify the STUDENTS table

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)

参考答案

参考解析：

分类：1Z0-007题库

You need to calculate the total of all salaries in the accounting department. Which group function should you use? （）A MAXB MINC SUMD COUNTE TOTALF LARGEST

2、You need to display the last names of

You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement di...

3、You need to dump the data from the ma

You need to dump the data from the master server and import it into a new slave server.Which mysqldump option can be used when dumping data...

4、You need to give the MANAGER role the

You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given...

5、You need to document the following co

You need to document the following configurations of a server that runs Windows Server 2008 R2:System servicesStartup programsHardware configuratio...

6、You need to create a table named ORDE

You need to create a table named ORDERS that contain four columns:1. an ORDER_ID column of number data type2. aCUSTOMER_ID column of number da...

编辑推荐

倒闸作业需（）作业，操作人员必须戴好绝缘手套，穿好绝缘鞋。..

运输布局是研究各种运输方式的()等工作总称。..

控制冷却的终冷温度一般是控制到相变结束。..

在课堂教学中，教师的非言语表达艺术是非常丰富的，它一般要.....

不属于新生儿败血症临床表现的是()..

用汉语拼音写出下列汉字所代表的音节，并从结构角度给韵母分.....