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

题目

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);

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

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);

正确答案:C

第2题：

You have an Exchange Server 2010 organization.You need to ensure that all users in the organization can automatically schedule the use of a projector.What should you do？（）

A、Create a new sharing policy
B、Create a mailbox
C、Modify the properties of the Calendar managed default folder
D、Modify the schedule for the Managed Folder Assistant

正确答案:B

第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);

参考答案：D

第4题：

You create a Password Settings object （PSO）. You need to apply the PSO to a domain user named User1. What should you do（）

A、Modify the properties of the PSO.
B、Modify the account options of the User1 account.
C、Modify the security settings of the User1 account.
D、Modify the password policy of the Default Domain Policy Group Policy object （GPO）.

正确答案:A

第5题：

You want users to log on to Active Directory by using a new User Principal Name （UPN）. You need to modify the UPN suffix for all user accounts. Which tool should you use（）

A、Dsmod
B、Netdom
C、Redirusr
D、Active Directory Domains and Trusts

正确答案:A

第6题：

You have an Exchange Server 2010 organization.You create a distribution group for all users in your company.You need to ensure that new users can add their mailboxes to the distribution group.What should you do？（）

A、Modify the group scope of the distribution group.
B、Modify the approval mode of the distribution group.
C、Modify the security settings of the distribution group.
D、Modify the authentication settings of the ECP virtual directory.

正确答案:B

第7题：

You have an Exchange Server 2010 server named Server1.Server1 hosts a mailbox database named DB1 that contains 25 user mailboxes.You create a new public folder database named PUB2.You need to configure PUB2 as the default public folder database for each mailbox on DB1. Which properties should you modify？（）

A、Modify the properties of each mailbox.
B、Modify the properties of DB1.
C、Modify the properties of Server1.
D、Modify the properties of PUB2.

正确答案:B

第8题：

You install three servers that run Windows Server 2003 Service Pack 2 (SP2). The servers are on the same subnet.You get the IP configuration for the servers as shown in the following table. You need to ensure that you can establish communication between the three servers. What should you do?（）

A、Modify the IP address on Server3.
B、Modify the IP address on Server1.
C、Configure the hosts file on each server.
D、Modify the default gateway for each server.

正确答案:A

第9题：

You need to configure the security settings for the new app servers. Which two actions should you perform?（）

A、Create a Group policy object (GPO) for the web servers.
B、Create a Group policy object (GPO) for the database servers.
C、Modify the Default Domain Policy.
D、Modify the Default Domain Controllers Policy.

正确答案:A,B

第10题：

You develop a Web application. Your application contains two settings in the Web.config file. You deploy your application to production. You need to modify the application settings in the production environment without manually editing the XML markup in the Web.config file. What should you do? （）

A、Modify the application settings by using the Web Site Administration Tool.
B、Modify the application settings by using the Visual Studio property page editor for the project.
C、Modify the application settings by using the resource editor.
D、Modify the application settings by using the Visual Studio start options editor.

正确答案:A

You need to modify the STUDENTS

题目

相似问题和答案

更多相关问题

相关内容