单选题Which statement creates a new user? （）ACREATIVE USER susan;BCREATIVE OR REPLACE USER susan;CCREATE NEW USER susan DEFAULTDCREATE USER susan IDENTIFIED BY blue;ECREATE NEW USER susan IDENTIFIED BY blue;FCREATE OR REPLACE USER susan IDENTIFIED BY blue;
单选题
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;
参考解析
解析：
暂无解析
相关考题：
The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?() A. no privilegesB. only the SELECT privilegeC. only the CONNECT privilegeD. all the privileges of a default user
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 blue;
假设在数据库中已经创建了某个用户test,需要将其口令修改为oracle,可以使用如下()语句。 A.ALTER USER test IDENTIFIED BY oracleB.ALTER USER test PASSWORD oracleC.CREATE USER test IDENTIFIED BY oracleD.UPDATE USER test IDENTIFIED BY oracle
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 susanIDENTIFIED by blue;F、CREATE OR REPLACE USER susan IDENTIFIED BY blue;
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.
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-ModuleB、Register-ObjectEventC、Set-ADDomainD、Set-ADUser
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.
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, user3B、CREATE NEW ROLE registrar; GRANT ALL ON student_grant TO registrar; GRANT registrar to user 1, user2, user3C、CREATE ROLL registrar; GRANT UPDATE ON student_grant TO registrar; GRANT ROLE to user1, user2, user3D、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;
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 blue;
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.
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 usercreates a table. 3：The SKD user grants theCREATETABLE 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 is performed（）A、The table created by SKD isnot accessibleand 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.
You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1 TEMPORARY TABLESPACE temp PROFILE default / SQL GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails. ERROR at line 1： ORA-01950： no privileges on tablespace What could be the possible reason for this error message？（）A、The tablespace TBS1 is full.B、The user is not the owner of the SYSTEM tablespace.C、The user does not have quota on the TBS1 tablespace.D、The user does not have sufficient system privileges to create table in the TBS1 tablespace.E、The user does not have sufficient privileges to create table on the default permanent tablespace.
The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?（）A、no privilegesB、only the SELECT privilegeC、only the CONNECT privilegeD、all the privileges of a default user
假设在数据库中已经创建了某个用户test，需要将其口令修改为oracle，可以使用如下（）语句。A、ALTER USER test IDENTIFIED BY oracleB、ALTER USER test PASSWORD oracleC、CREATE USER test IDENTIFIED BY oracleD、UPDATE USER test IDENTIFIED BY oracle
You are designing a migration strategy to create user IDs for all company users in the new environment. What should you do?（）A、Create a script that uses Active Directory Services Interfaces (ADSI) to import all user account into the new environment.B、Create new accounts for all users. Create a trust relationship between the existing environment and the new environment to enable access to resources in the existing environment.C、Import all user accounts into the new environment by using the Active Directory Migration Tool (ADMT).D、Import all user accounts into the new environment. Instruct users to no change their passwords during the migration phase so that they can access resources in the existing environment.
You need to design an access control strategy for resources that are located in the extranet for partners and for internal users. Your solution must meet business and security requirements. What should you do？（）A、Create a new child domain named extranet.corp.woodgrovebank.com in the existing forest. Create user accounts for users from partner companies in the new child domain. Create shortcut trusts in which the child domain trusts every domain in the forestB、Create a new forest and domain named extranet.woodgrovebank.com. Create user accounts for users from partner companies in the new domain. Create a one-way forest trust relationship in which the extranet forest trusts the company forestC、Create a new forest and domain named extranet.woodgrovebank.com. Create user accounts for users from partner companies in the new domain. Create an external trust relationship in which the extranet domain trusts the den.corp.woodgrovebank.com domainD、Create a child domain of the den.corp.woodgrovebank.com domain for the extranet. Create user accounts for users from partner companies in the new child domain. Create an external trust relationship in which the forest root domain trusts the extranet domain
You need to design a migration path for migrating user accounts and mailboxes to the new environment. Which two actions should you perform？（）A、Use the Migration Wizard to create and migrate mailboxes to Exchange Server 2003B、Use Active Directory Users and Computers to move user accounts and mailboxes to the new environmentC、Use Microsoft Identity Integration Server （MIIS） to synchronize user accounts with the new environmentD、Use the Active Directory Migration Tool （ADMT） to clone user accounts in Active DirectoryE、Use ClonePrincipal to migrate user accounts to the new environment
You are implementing an ASP.NET Web application. Users will authenticate to the application with an ID. The application will allow new users to register for an account. The application will generate an ID for the user based on the users full name. You need to implement this registration functionality. Which two actions should you perform？（）A、Configure the SqlMembershipProvider in the web.config file.B、Configure the SqlProfileProvider in the web.config file.C、Create an ASP.NET page that contains a default CreateUserWizard control to create a new user account.D、Create an ASP.NET page that contains a custom form that collects the user information and then uses the Membership.CreateUser method to create a new user account.
单选题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 usercreates a table. 3：The SKD user grants theCREATETABLE 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 is performed（）AThe table created by SKD isnot accessibleand SKD cannot create new tables.BThe tables created by SKD and HR remain， but both cannot create new tables.CThe table created by HR remains and HR still has the CREATE TABLE system privilege.DThe table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
单选题Which statement creates a new user?（）ACREATE USER susan;BCREATE OR REPLACE USER susan;CCREATE NEW USER susan DEFAULT;DCREATE USER susan IDENTIFIED BY blue;ECREATE NEW USER susanIDENTIFIED by blue;FCREATE OR REPLACE USER susan IDENTIFIED BY blue;
单选题Which statement creates a new user?（）ACREATIVE USER susan;BCREATIVE OR REPLACE USER susan;CCREATE NEW USER susan DEFAULTDCREATE USER susan IDENTIFIED BY blue;ECREATE NEW USER susan IDENTIFIED BY blue;FCREATE OR REPLACE USER susan IDENTIFIED BY blue;
单选题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（）AThe table created by SKD is not accessible and SKD cannot create new tables.BThe tables created by SKD and HR remain， but both cannot create new tables.CThe table created by HR remains and HR still has the CREATE TABLE system privilege.DThe table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
多选题You need to design a migration path for migrating user accounts and mailboxes to the new environment. Which two actions should you perform？（）AUse the Migration Wizard to create and migrate mailboxes to Exchange Server 2003BUse Active Directory Users and Computers to move user accounts and mailboxes to the new environmentCUse Microsoft Identity Integration Server （MIIS） to synchronize user accounts with the new environmentDUse the Active Directory Migration Tool （ADMT） to clone user accounts in Active DirectoryEUse ClonePrincipal to migrate user accounts to the new environment
多选题When should you create a role? （）ATo simplify the process of creating new users using the CREATE USER xxx IDENTIFIED by yyy statement.BTo grant a group of related privileges to a user.CWhen the number of people using the database is very high.DTo simplify the process of granting and revoking privileges.ETo simplify profile maintenance for a user who is constantly traveling.
单选题You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1 TEMPORARY TABLESPACE temp PROFILE default / SQL GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails. ERROR at line 1： ORA-01950： no privileges on tablespace What could be the possible reason for this error message？（）AThe tablespace TBS1 is full.BThe user is not the owner of the SYSTEM tablespace.CThe user does not have quota on the TBS1 tablespace.DThe user does not have sufficient system privileges to create table in the TBS1 tablespace.EThe user does not have sufficient privileges to create table on the default permanent tablespace.
单选题The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?（）Ano privilegesBonly the SELECT privilegeConly the CONNECT privilegeDall the privileges of a default user
单选题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（）AImport-ModuleBRegister-ObjectEventCSet-ADDomainDSet-ADUser
单选题You are the desktop administrator for your company's sales department. The IT manager for the sales department needs to distribute a custom application to the Windows XP Professional computers in the sales department. He deploys the software by using Group Policy. Susan is a user in the sales department. She reports that the custom application is not available. You examine her computer, and you verify that the application is not present on her computer. You want to ensure that the software is deployed the next time Susan logs on. Which command should you run?（）ASecedit /refreshpolicy user_policy /enforceBSecedit /refreshpolicy machine_policy /enforceCGpupdate /target:computer /syncDGpupdate /target:user /sync