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?（） -题库考试答案搜索网

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?（）

单选题

2022-07-12 01:54

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)

查看答案

正确答案

试题解析

标签： 1Z0-007

感兴趣题目

You are the administrator of a new multiprocessor SQL Server 2000 computer. You are migrating data from other database management systems to this server. You need to load data from two data files into a new table on the server. The table is empty and has no indexes.

You modify an existing Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5. You add a theme to the ASP.NET application. You need to apply the theme to override any settings of individual controls. What should you do？（）

You have a customized image of Windows 7 Professional. You mount the image and modify the contents ofthe image. You need to restore the image to its original state. Which tool should you use?（）

The IT department is creating a human resources application that will require several new tables. You need to develop a standard alone executable that will defines these tables and their relationships. Which developer/2000 component could you use to create the executable?（）

You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows. Which statement is valid?（）

You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 1000 bytes. The column can currently hold 500 bytes per value. The table contains 20000 rows. Which statement is valid?（）

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?（）

You are the network administrator at TestKing. You need to perform password recovery on Router TK1. What must you modify in the password recovery process?（）

You use Microsof t Application Virtualization (App - V). You need to automate the process of sequencing applications . Which command should you run?（）

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?（）

Examine the structure of the STUDENTS table:

You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.Which SQL statement accomplishes this task?（）