单选题You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results?（）ACREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;BCREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;CGRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
单选题
You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results?（）
A
CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;
B
CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;
C
GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
参考解析
解析：
暂无解析
相关考题：
You need to perform these tasks:1. Create and assign a MANAGER role to Blake and Clark2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and ClarkWhich set of SQL statements achieves the desired results? （）A. CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;B. CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;C. GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
All network servers run Windows Server 2003, and all client computers run Windows XP Professional.Sandra, the manager of the human resources department, asks you to create a shared folder named HRDrop.You create a HRDrop folder on a member server. You assign the Allow - Full Control share permission to the Everyone group.Now you need to configure the NTFS permissions on HRDrop to fulfil the following requirements:1. Sandra must be able to read, modify, change permissions on, and delete all files and subfolders in HRDrop.2. All other domain users must only be able to add new files to HRDrop.What should you do?（）A. Assign the Allow - Modify permission to Sandra. Assign the Allow - Read permission to the Users group.B. Assign the Allow - Full Control permission to Sandra. Assign the Allow - Write permission and the Deny - Read and Execute permission to the Users group.C. Assign the Allow - Modify permission to Sandra. Assign the Allow - List Folder permission to the Users group.D. Assign the Allow - Full Control permission to Sandra. Assign the Allow - Read permission to the Users group.E. Assign the Allow - Full Control permission to Sandra. Assign the Allow - Write permission to the Users group and remove the Read and Execute permissions to the Users group.
You are the network administrator for All network servers run Windows Server 2003. All client computers run Windows XP Professional.You create a folder on thet network and share it as TestKingDocs. You want users to be able to read, create, and modify documents that are stored in the shared folder. You also want users to be able to delete the folders and the files that they create.A user reports that another used deleted a folder that she created. You discover that the Everyone group ias assigned the Allow - Full Control NTFS permission for the folder. You remove all assigned permissions for the Everyone group.You need to configure permission for the TestKingDocs shared folder to meet your requirements. You also need to ensure that users cannot delete the folders and files that other users create.Which two actions should you perform （）(Each correct answer presents part of the solution. Choose two.)A. Assign the Authenticated Users group the Allow - Read Execute permission.B. Assign the Anonymous group the Allow - Modify permission.C. Assign the Creator Owner group the Allow - Modify permission.D. Assign the Creator Owner group the Allow - Full Control permission
Your company uses Windows Server 2008 R2 Hyper-V servers to provide a Microsoft Virtual Desktop Infrastructure （VDI） environment. Maintenance tasks result in reduced capacity on several servers. You need to prevent servers from experiencing performance problems during maintenance. What should you do？（）A、Set the user logon mode on every server to EnabledB、Create additional DNS A records for the servers， and use DNS round-robinC、In Remote Desktop Connection Broker， assign a lower weight to the servers that will undergo maintenanceD、In Remote Desktop Connection Broker， assign a higher weight to the servers that will undergo maintenance
You are responsible for implementing maintenance jobs on a SQL Server 2005 database server. Certain jobs run every Sunday and other jobs run at the beginning of every month. You need to schedule the jobs in the way that uses the least amount of administrative effort. What should you do? （）A、 Create a job schedule that runs every Sunday. Assign weekly tasks to this schedule. Create a second schedule that runs on the first day of every month. Assign monthly tasks to this schedule. B、 Create a job for each task that runs once a day. Use a Transact-SQL statement to check the date and day of the week. If the day is either a Sunday or the first day of the month, execute the code. C、 Create a job schedule that runs once a day. Assign jobs to this job schedule. If the day is either a Sunday or the first day of the month, execute the jobs. D、 Create a job for each task that runs once a week on Sunday. Add a second job schedule that runs the job on the first of the month.
You create Web sites for your company. You apply a consistent design to the pages and controls of the Web sites. You need to make style changes to all of the Web sites on the Web server. You want to achieve this goal without having to edit the individual pages on each Web site. Which two actions should you perform?（）A、Place a theme in the App_Themes directory under the application root directory.B、Place a theme under an ASP.NETClientFiles folder under the ASP.NET installation directory.C、Assign a theme by setting the %@ Page Theme="..." % directive to the name of the application theme.D、Assign a theme by specifying the pages theme="..."/ section in the Web.config file.
You are the network administrator for All network servers run Windows Server 2003. Recently, another network administrator create a scheduled task to perform a normal backup of Microsoft Exchange Server 2003 compuer every Saturday night. You need to perform maintenance tasks on the Exchange server on this Saturday night only. If the backup starts while you are performing the maintenance tasks,data might be corrupted. You need to ensure that the backup task does not start while you perform the maintenance tasks. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution.（）Choose two.)A、In the Backup utility, clear the Enabled (scheduled tasks runs at specified time) check box.B、In Control Panel, use Scheduled Tasks to pause Task Scheduler.C、Run the Schtasks command with the /end /p parameters.D、Use the Services snap-in to change the startup type of the Task Scheduler service from Automatic to Manual.
You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results?（）A、CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;B、CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;C、GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?（）A、Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.B、Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.C、Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.D、Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.E、Re-create the password file in the Oracle Database 12c format.
You have a computer that runs Windows 7. The computer is a member of a domain. You share D:/data asData. You assign Everyone Full control share permissions to the folder. No other share permissions areassigned to the folder. From another computer, you attempt to create a file in the Data share by using a domain account named User1. You receive the following error message: Destination Folder Access Denied.You need to ensure that you can create files in the Data share by using the User1 account. What should you do?（）A、Create a local user named User1.B、Add User1 to the local Power Users group.C、Assign User1 Write NTFS permission on the D:///data folder.D、Assign User1 Full control share permissions to the Data share.
You are responsible for managing the database schema for an order entry application in a SQL Server 2005 database. After a design review, a member of the development staff asks you to add a new column named CommissionRate to the Product table. Because the actual commission rates for all products are not known at this time, each product has a default commission rate of 12 percent. The rate can be modified as necessary. You add the new column. You need to configure the table to assign the default value as efficiently as possible. What should you do?（）A、 Create an INSERT trigger to assign the default value to each item in the table. B、 Create a CHECK constraint to validate the data and to assign the default value to each item in the table. C、 Create an UPDATE trigger to update the default value for each new item in the table. D、 Create a DEFAULT constraint to assign the default value specifying the WITH VALUES argument.
.Your companys virtual environment includes Windows Server 2008 R2 Hyper-V servers. You manage the environment by using Microsoft System Center Virtual Machine Manager （VMM） 2008 R2. You need to provide a user with the ability to perform only the Create， Delete， Start， Stop， Pause， Resume， and Shut Down virtual machine （VM） management tasks on your host servers . What should you do？（）A、In VMM，create a Self-Service user role.B、In VMM，create a Delegated Administrator user role.C、In VMM，assign the Local Administrator permission for the host servers to the user.D、In Authorization Manager， create a role on the users client computer and add the user to this role.
You need to design a method for junior IT administrators to perform more IT support tasks. Your solution must meet business and security requirements. What should you do？（）A、Delegate appropriate Active Directory permissions to the junior IT administratorsB、Add the junior IT administrators’ user accounts to the Domain Admins user groupC、Create a custom Microsoft Management Console （MMC） that uses taskpad views to enable the appropriate tasks for the junior IT administratorsD、Make the junior IT administrators’ domain user accounts member of the local Administrators group on all client computersE、Create new domain user accounts for each junior IT administrator. Make the new accounts members of the Domain Admins group and instruct junior IT administrators to use the new accounts only for appropriate administrative tasks
You install two Exchange Server 2010 Edge Transport servers named Server1 and Server2.You need to ensure that e-mail sent from the Internet is sent to Server2 if Server1 fails.What should you do？（）A、Create two SRV records.Assign the SRV record for Server1 a priority of 20.Assign the SRV record Server2 a priority of 10.B、Create two SRV records.Assign the SRV record for Server1 a priority of 10.Assign the SRV record for Server2 a priority of 20.C、Create two MX records.Assign the MX record for Server1 a priority of 20.Assign the MX record for Server2 a priority of 10.D、Create two MX records.Assign the MX record for Server1 a priority of 10.Assign the MX record for Server2 a priority of 20.
You design a Business Intelligence （BI） solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services （SSRS） solution that contains five sales dashboard reports. Users must be able to manipulate the reports’ parameters to analyze data. You need to ensure that the following requirements are met： Users can manipulate the parameters for data analysis in a single trip to the data source. Reports are automatically rendered as soon as they are accessed for the first time. Which two tasks should you perform？（）A、 Filter data by using expressions.B、 Specify the default values for each parameter.C、 Create an available values list for each parameter.D、 Create report parameters by using query parameters to filter data at the data source.
You have Active Directory Certificate Services （AD CS） deployed. You create a custom certificate template. You need to ensure that all of the users in the domain automatically enroll for a certificate based on the custom certificate template. Which two actions should you perform（）A、In a Group Policy object （GPO）， configure the autoenrollment settingsB、In a Group Policy object （GPO）， configure the Automatic Certificate Request Settings.C、On the certificate template， assign the Read and Autoenroll permission to the Authenticated Users group.D、On the certificate template， assign the Read， Enroll， and Autoenroll permission to the Domain Users group.
You need to create an administrative design that will enable the organization to centralize the management of the Exchange Server 2003 computers. Which two actions should you perform？（）A、Create a new domain named Exchange.Corp.cpandl.com and locate all the Exchange servers in the domainB、Create a new organizational unit （OU） named Exchange OU and move all the Exchange servers into the OUC、Locate all the Exchange servers in the Domain Controller OU.（Modified NEW answer）D、Assign Full Exchange Administrator rights to the Domain Admins group and to the Exchange Admins Group.（Modified NEW answer）E、Assign Full Exchange Administrator rights to the Domain Admins group. Assign Exchange Administrator rights to the Exchange Admins group.（Modified NEW answer）F、Assign Full Exchange Administrator rights to the Domain Admins group. Add the Exchange Admins group to the Administrators group on each Exchange server.（Modified NEW answer）
You install two Exchange Server 2010 Service Pack 1 （SP1） Edge Transport servers named Edge1 and Edge2.You need to ensure that e-mail is sent only to Edge2 if Edge1 fails. What should you do？（）A、Create two CNAME records that have the same name.Create one MX record that uses the FQDN of the CNAME records.Assign a priority of 0 to the MX record.B、Create two MX records.Assign the MX record for Edge1 a priority of 5.Assign the MX record for Edge2 a priority of 1.C、Create two A records that use the same name.Create one MX record that uses the FQDN of the A record.Assign a priority of 0 to the MX record.D、Create two MX records.Assign the MX record for Edge1 a priority of 1.Assign the MX record for Edge2 a priority of 5.
You have an Exchange 2010 organization.You have an administrative user named Admin1.You need to ensure that Admin1 can move mailboxes in the organization.The solution must assign the minimum amount of permissions to Admin1. What should you do？（）A、Create a local move request.B、Create a custom Management role.Assign the role to Admin1.C、Add Admin1 to the Organization Management role group.D、Add Admin1 to the Recipient Management security group.
You need to ensure that you can recover system configuration and data if your computer hard disk fails. What should you do？ （）A、Create a system restore point.B、Create a backup of all file categories.C、Create a Complete PC Backup and Restore image.D、Perform an Automated System Recovery （ASR） backup.
You are the network administrator for TestKing. The network consists of a single Active Directory domain named testking.com. All domain controller run Windows Server 2003. employes three database administrators who administer seven databases servers that run Windows Server 2003. The database administrators occasionally restore a database server after a disaster. To restore a server, database administrators need the rights required to perform the following tasks: 1. Back up files and folders 2. Restore files and folders. 3. Restore the System State data. You need to assign the database administrators the rights that they require to perform the specified tasks. For security reasons, you must not assign the administrators more rights than they require to perform the tasks. What should you do?（）A、Add the database administrators' user accounts to the Administrators group on each of the database servers.B、Add the database administrators' user accounts to the Power Users group on each of the database servers.C、Add the database administrators' user accounts to the Backup Operators group on each of the database servers.D、Add the database administrators' user accounts to the Backup Operators group on one of the domain controllers.E、Add the database administrators' user accounts to the Server Operators group on one of the domain controllers.
单选题You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results? （）ACREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;BCREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;CGRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
多选题You are the network administrator for All network servers run Windows Server 2003. Recently, another network administrator create a scheduled task to perform a normal backup of Microsoft Exchange Server 2003 compuer every Saturday night. You need to perform maintenance tasks on the Exchange server on this Saturday night only. If the backup starts while you are performing the maintenance tasks,data might be corrupted. You need to ensure that the backup task does not start while you perform the maintenance tasks. What are two possible ways to achieve this goal? (Each correct answer presents a complete solution.（）Choose two.)AIn the Backup utility, clear the Enabled (scheduled tasks runs at specified time) check box.BIn Control Panel, use Scheduled Tasks to pause Task Scheduler.CRun the Schtasks command with the /end /p parameters.DUse the Services snap-in to change the startup type of the Task Scheduler service from Automatic to Manual.
单选题You are responsible for implementing maintenance jobs on a SQL Server 2005 database server. Certain jobs run every Sunday and other jobs run at the beginning of every month. You need to schedule the jobs in the way that uses the least amount of administrative effort. What should you do? （）A Create a job schedule that runs every Sunday. Assign weekly tasks to this schedule. Create a second schedule that runs on the first day of every month. Assign monthly tasks to this schedule. B Create a job for each task that runs once a day. Use a Transact-SQL statement to check the date and day of the week. If the day is either a Sunday or the first day of the month, execute the code. C Create a job schedule that runs once a day. Assign jobs to this job schedule. If the day is either a Sunday or the first day of the month, execute the jobs. D Create a job for each task that runs once a week on Sunday. Add a second job schedule that runs the job on the first of the month.
多选题You have Active Directory Certificate Services （AD CS） deployed. You create a custom certificate template. You need to ensure that all of the users in the domain automatically enroll for a certificate based on the custom certificate template. Which two actions should you perform（）AIn a Group Policy object （GPO）， configure the autoenrollment settingsBIn a Group Policy object （GPO）， configure the Automatic Certificate Request Settings.COn the certificate template， assign the Read and Autoenroll permission to the Authenticated Users group.DOn the certificate template， assign the Read， Enroll， and Autoenroll permission to the Domain Users group.
单选题You need to identify which tool the help desk users must use to perform administrative tasks. Which tool should you identify？（）ARemoteAppBRemote AssistanceCRemote DesktopDRemote Server Administration Tools （RSAT）
单选题You have three computers that run Windows 7. You use Windows PowerShell to perform remote administration tasks on all three computers. You need to remotely administer all three computers by usingPowerShell. Which PowerShell cmdlet should you use?（）AEnable-PSRemotingBEnable-PSSessionConfigurationCNew-PSDriveDNew-PSSession