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 (stude

题目

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);
相似考题

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

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

3.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.

4.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 ”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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.

    正确答案:C

  • 第5题：

    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. 

    正确答案:B

  • 第6题：

    单选题
    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?（）
    A

    From the Automatic Approvals options, modify the Update Rules list.

    B

    From the Automatic Approvals options, modify the Advanced settings.

    C

    From the Products and Classifications options, modify the Products settings.

    D

    From the Products and Classifications options, modify the Classifications settings.


    正确答案： A
    解析： 暂无解析

  • 第7题：

    单选题
    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（）
    A

    Dsmod

    B

    Netdom

    C

    Redirusr

    D

    Active Directory Domains and Trusts


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    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?（）
    A

    Printing preferences

    B

    Priority

    C

    Security

    D

    Share


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    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
    解析： 暂无解析

  • 第10题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    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?（）
    A

    Run Del and specify the /p parameter.

    B

    Run Runas and specify the /noprofile parameter.

    C

    From Credential Manager， modify the Windows credentials.

    D

    From Authorization Manager， modify the Authorization Manager options.


    正确答案： A
    解析： 暂无解析

  • 第12题：

    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

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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 Reader
    • B、Modify the share permisisons for the Accounting Users group to Contributor
    • C、Modify the NTFS permisisons for the Managers group to Modify
    • D、Modify the NTFS permissions for the authenticated users group to modify and the share permissions to contributer.

    正确答案:A

  • 第16题：

    多选题
    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?（）
    A

    Configuration register

    B

    NVRAM

    C

    Boot flash

    D

    CMOS

    E

    Flash


    正确答案： E,D
    解析： 暂无解析

  • 第17题：

    单选题
    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?（）
    A

    From Personalization， modify the screen saver.

    B

    From Indexing Options， modify the Advanced options.

    C

    From Performance Options， modify the visual effects.

    D

    From Performance Options， modify the processor scheduling.


    正确答案： A
    解析： 暂无解析

  • 第18题：

    单选题
    You need to increase the size of a paging file. What should you do? （）
    A

    From Disk Management， shrink the boot partition.

    B

    From Disk Management， shrink the system partition.

    C

    From System， modify the Advanced system settings.

    D

    From System， modify the System protection settings.


    正确答案： A
    解析： 暂无解析

  • 第19题：

    单选题
    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?（）
    A

    Open Computer and modify the properties of the USB drive.

    B

    Open Performance Information and Tools and run disk cleanup.

    C

    Open Devices and Printers and modify the properties of the USB drive.

    D

    Open Device Manager and modify the properties of the USB device.


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    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?（）
    A

    Content

    B

    Encoding

    C

    Safety

    D

    Security


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    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？（）
    A

    From the Exchange Management Shell， modify the properties of the WEB Outlook Provider.

    B

    From the Exchange Management Shell， modify the properties of the EXPR Outlook Provider.

    C

    From the Internet Information Services （IIS） Manager， modify the properties of the RPC virtual directory.

    D

    From the Internet Information Services （IIS） Manager， modify the properties of the Autodiscover virtual directory.


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    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);


    正确答案： A
    解析： 暂无解析

相关内容