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);
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);
相关考题：
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);
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.
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);
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.
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 policyB、Create a mailboxC、Modify the properties of the Calendar managed default folderD、Modify the schedule for the Managed Folder Assistant
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.
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、DsmodB、NetdomC、RedirusrD、Active Directory Domains and Trusts
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.
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）.
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.
You have an Exchange Server 2010 Mailbox server. You need to ensure that deleted mailboxes are kept for 60 days. What should you do（）？ A、Create a Retention Policy.B、Create a managed folder mailbox policy.C、Modify the properties of the mailbox database.D、Modify the properties of the Mailbox server object.
Your company ahs an active direcotyr domain. The company also has a server named Server1 that runs Windows Server 2008. You install the file server role on Server1. you create a shared folder named AcctgShare on Server1 The permissions for the shared folder are configured as shown in the following table. （ missing again!） You need to ensure members of the Managers group can only view and open files in the shared folder. What should you do（）？ A、Modify the share permissions for the Managers group to ReaderB、Modify the share permisisons for the Accounting Users group to ContributorC、Modify the NTFS permisisons for the Managers group to ModifyD、Modify the NTFS permissions for the authenticated users group to modify and the share permissions to contributer.
You have a computer that runs Windows XP Professional. You need to ensure that the Administrative Tools menu appears on the Start menu. What should you do?（） A、Modify the Display Properties. B、Modify the Taskbar and Start Menu Properties.C、Switch to Classic View from Control Panel.D、Change the desktop theme to Windows Classic.
多选题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?（）AConfiguration registerBNVRAMCBoot flashDCMOSEFlash
单选题Your network contains a Windows Server Update Services (WSUS) server.You need to ensure that the WSUS server automatically downloads service packs. What should you do first?（）AFrom the Automatic Approvals options, modify the Update Rules list.BFrom the Automatic Approvals options, modify the Advanced settings.CFrom the Products and Classifications options, modify the Products settings.DFrom the Products and Classifications options, modify the Classifications settings.
单选题You have a computer that runs Windows 7. You generate a System Diagnostic Report and receive thefollowing warning message: The Graphics rating for the system is poor and may be the cause of performance problems. You need to increase the graphics performance of the computer without modifyingthe current hardware or drivers. What should you do?（）AFrom Personalization， modify the screen saver.BFrom Indexing Options， modify the Advanced options.CFrom Performance Options， modify the visual effects.DFrom Performance Options， modify the processor scheduling.
单选题You want users to log on to Active Directory by using a new Principal Name （UPN）. You need to modify the UPN suffix for all user accounts. Which tool should you use（）ADsmodBNetdomCRedirusrDActive Directory Domains and Trusts
单选题You need to increase the size of a paging file. What should you do? （）AFrom Disk Management， shrink the boot partition.BFrom Disk Management， shrink the system partition.CFrom System， modify the Advanced system settings.DFrom System， modify the System protection settings.
单选题You install a local printer on a computer. You share the printer. You need to ensure that only members of alocal group named Group1 can print documents on the printer. Which settings should you modify on theprinter?（）APrinting preferencesBPriorityCSecurityDShare
单选题You have a computer named Computer1 that runs Windows 7. Computer1 uses an NTFS-formatted USBdrive that has ReadyBoost enabled. You need to modify the amount of space that ReadyBoost reserves onthe USB drive. What should you do?（）AOpen Computer and modify the properties of the USB drive.BOpen Performance Information and Tools and run disk cleanup.COpen Devices and Printers and modify the properties of the USB drive.DOpen Device Manager and modify the properties of the USB device.
单选题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?（）AALTER TABLE students ADD PRIMARY KEY _ id;BALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);CALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;DALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);EALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
单选题You have a computer that runs Windows 7. You need to prevent ActiveX controls from running in WindowsInternet Explorer. Which Internet Explorer settings should you modify?（）AContentBEncodingCSafetyDSecurity
单选题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.
单选题You purchase a wildcard certificate.You plan to use the certificate for Outlook Anywhere. You need to configure an Exchange organization to use the certificate.What should you do first？（）AFrom the Exchange Management Shell， modify the properties of the WEB Outlook Provider.BFrom the Exchange Management Shell， modify the properties of the EXPR Outlook Provider.CFrom the Internet Information Services （IIS） Manager， modify the properties of the RPC virtual directory.DFrom the Internet Information Services （IIS） Manager， modify the properties of the Autodiscover virtual directory.
单选题You have a computer that runs Windows 7. You run Runas and specify the /savecred parameter to start anapplication. You need to delete the stored password. What should you do?（）ARun Del and specify the /p parameter.BRun Runas and specify the /noprofile parameter.CFrom Credential Manager， modify the Windows credentials.DFrom Authorization Manager， modify the Authorization Manager options.
单选题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?（）AALTER TABLE students ADD PRIMARY KEY student_id;BALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);CALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;DALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);EALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);