CMS专题
单选题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
题目
CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;
CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;
GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
参考答案和解析
相似问题和答案
第1题：
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
第2题：
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.
正确答案:A
第3题：
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***
第4题：
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.
正确答案:B,D
第5题：
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.
正确答案:A,B
第6题：
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 Enabled
- B、Create additional DNS A records for the servers， and use DNS round-robin
- C、In Remote Desktop Connection Broker， assign a lower weight to the servers that will undergo maintenance
- D、In Remote Desktop Connection Broker， assign a higher weight to the servers that will undergo maintenance
正确答案:C
第7题：
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.
正确答案:B,D
第8题：
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.
第9题：
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***
正确答案:A
第10题：
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.
正确答案:C