单选题Which statement creates a new user? （）A CREATIVE USER susan;B CREATIVE OR REPLACE USER susan;C CREATE NEW USER susan DEFAULTD CREATE USER susan IDENTIFIED BY blue;E CREATE NEW USER susan IDENTIFIED BY blue;F CREATE OR REPLACE USER susan IDENTIFIED BY b

第1题：

第2题：

Your network contains one Exchange Server 2010 Service Pack 1 （SP1） Client Access server named Server1. You have a user named User1. You need to limit the size of the attachments that User1 can download by using Windows Mobile 6.5 devices. What should you do first？（）

• A、Create a new Exchange ActiveSync device access rule.
• B、Create new managed content settings.
• C、Modify the message size restrictions for User1.
• D、Create a new Exchange ActiveSync mailbox policy.

第3题：

第4题：

Which statement creates a new user?（）

• A、CREATIVE USER susan;
• B、CREATIVE OR REPLACE USER susan;
• C、CREATE NEW USER susan DEFAULT
• D、CREATE USER susan IDENTIFIED BY blue;
• E、CREATE NEW USER susan IDENTIFIED BY blue;
• F、CREATE OR REPLACE USER susan IDENTIFIED BY blue;

第5题：

When should you create a role? （）

• A、To simplify the process of creating new users using the CREATE USER xxx IDENTIFIED by yyy statement.
• B、To grant a group of related privileges to a user.
• C、When the number of people using the database is very high.
• D、To simplify the process of granting and revoking privileges.
• E、To simplify profile maintenance for a user who is constantly traveling.

第6题：

Which statement creates a new user?（）

• A、CREATE USER susan;
• B、CREATE OR REPLACE USER susan;
• C、CREATE NEW USER susan    DEFAULT;
• D、CREATE USER susan    IDENTIFIED BY blue;
• E、CREATE NEW USER susan   IDENTIFIED by blue;
• F、CREATE OR REPLACE USER susan   IDENTIFIED BY blue;

第7题：

Your network contains an Active Directory forest.   You set the Windows PowerShell execution policy to allow unsigned scripts on a domain   controller in the network. You create a Windows PowerShell script named new-users.ps1 that  contains the following lines：     new-aduser user1  new-aduser user2  new-aduser user3  new-aduser user4  new-aduser user5     On the domain controller， you double-click the script and the script runs. You discover that the  script fails to create the user accounts.     You need to ensure that the script creates the user accounts.     Which cmdlet should you add to the script（）

• A、Import-Module
• B、Register-ObjectEvent
• C、Set-ADDomain
• D、Set-ADUser

第8题：

第9题：

You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table.Which set of statements accomplishes this?（）

• A、CREATE ROLL registrar; GRANT MODIFY ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
• B、CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3
• C、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3
• D、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT registrar to user 1, user2, user3;
• E、CREATE registrar; GRANT CHANGE ON student_grant TO registrar; GRANT registrar;

第10题：

Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 isperformed（）

• A、The table created by SKD is not accessible and SKD cannot create new tables.
• B、The tables created by SKD and HR remain， but both cannot create new tables.
• C、The table created by HR remains and HR still has the CREATE TABLE system privilege.
• D、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.