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

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

相似考题

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

2.You are the administrator of Ezonexam's network.An employee named Mark has a local user account on a Windows 2000 Professional computer. Mark has rights and permissions to multiple files and folders on the computer. All of Mark's permissions are being granted through group membership. Mark recently hired a new employee named Eric as his assistant.You want Eric to have the same rights and permissions that Mark has on the Windows 2000 Professional computer. You want to accomplish this with the least amount of administrative effort.What should you do?A．Create a new local group. Create Eric's user account. Add Mark's user account and Eric's user account to the new group.B．Create Eric's user account. Copy Mark's profile to Eric's user account.C．Create Eric's user account. Make Eric's user account a member of all the same groups as Mark's user account.D．Create Eric's user account. Copy the registry entries in the subkey that correspond to Mark under HKEY_USERS to the subkey that corresponds to Eric.

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

4.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;

更多“单选题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;”相关问题

  • 第1题：

    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.

    正确答案:D

  • 第2题：

    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.

    正确答案:C,D

  • 第3题：

    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;

    正确答案:D

  • 第4题：

    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.

    正确答案:C

  • 第5题：

    The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?（）

    • A、no privileges
    • B、only the SELECT privilege
    • C、only the CONNECT privilege
    • D、all the privileges of a default user

    正确答案:A

  • 第6题：

    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.

    正确答案:A

  • 第7题：

    You are the administrator of your company’s network. You purchase 75 new Windows 2000 Professional computers that will be shared by the users in Graphic organizational unit (OU). All the computers are configured identically. You want the users to be able to maintain their individual desktop settings regardless of which computer they use. You want to accomplish this with the least amount of administrative effort. What should you do? （）

    • A、Configure each computer to join a workgroup.      Create a user account and a local profile for each user. 
    • B、Configure each computer to join a workgroup.      Create a domain user account that uses roaming user profiles. 
    • C、Configure each computer to join the domain.      Create a user account for each user on a domain controller. 
    • D、Configure each computer to join the domain.      Create domain user accounts that use roaming user profiles.

    正确答案:D

  • 第8题：

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


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

  • 第9题：

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

    B

    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 forest

    C

    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 domain

    D

    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


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

  • 第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.


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

  • 第11题：

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


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

  • 第12题：

    单选题
    The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?（）
    A

    no privileges

    B

    only the SELECT privilege

    C

    only the CONNECT privilege

    D

    all the privileges of a default user


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

  • 第13题：

    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

    正确答案:A

  • 第14题：

    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;

    正确答案:D

  • 第15题：

    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.

    正确答案:C

  • 第16题：

    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.

    正确答案:C

  • 第17题：

    假设在数据库中已经创建了某个用户test，需要将其口令修改为oracle，可以使用如下（）语句。

    • A、ALTER USER test IDENTIFIED BY oracle
    • B、ALTER USER test PASSWORD oracle
    • C、CREATE USER test IDENTIFIED BY oracle
    • D、UPDATE USER test IDENTIFIED BY oracle

    正确答案:A

  • 第18题：

    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 forest
    • B、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 forest
    • C、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 domain
    • D、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

    正确答案:B

  • 第19题：

    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.

    正确答案:A,D

  • 第20题：

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


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

  • 第21题：

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


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

  • 第22题：

    单选题
    You are the administrator of your company’s network. You purchase 75 new Windows 2000 Professional computers that will be shared by the users in Graphic organizational unit (OU). All the computers are configured identically. You want the users to be able to maintain their individual desktop settings regardless of which computer they use. You want to accomplish this with the least amount of administrative effort. What should you do? （）
    A

    Configure each computer to join a workgroup.      Create a user account and a local profile for each user. 

    B

    Configure each computer to join a workgroup.      Create a domain user account that uses roaming user profiles. 

    C

    Configure each computer to join the domain.      Create a user account for each user on a domain controller. 

    D

    Configure each computer to join the domain.      Create domain user accounts that use roaming user profiles.


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

  • 第23题：

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


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

  • 第24题：

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


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

相关内容