多选题Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）AThe SKD user cannot log in to the database instance.BThe objects owned by the SKD user are not accessible to any user.CThe other users 

题目
多选题
Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）
A

The SKD user cannot log in to the database instance.

B

The objects owned by the SKD user are not accessible to any user.

C

The other users can access the objects owned by the SKD user， on which they have access.

D

The password for the SKD user expires and the user is forced to change the password at the next log in

相似考题

1.The user SYS creates a job by using the following command:Which two statements are true about the job that was created by the preceding command?()A. The job is enabled by default after creationB. The job is automatically dropped after the end dateC. The job executes with the privileges of the user SYSD.

2.在oracle数据库中,执行下面的命令SQL>ALTER USER skd ACCOUNT LOCK;有关执行结果下面那两项描述正确?()A.SKD用户的对象不能被任何用户访问B.用户SKD密码过期，在下次登陆时强制用户修改密码C.用户SKD不能登陆数据库实例D.其它用户可以访问SKD用户的对象，当用户已经在访问对象的时候

3. To make audit information more productive， the DBA executes the following command before startingan audit operation：  SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE；  Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）A、It contains only the plan for the SQL statement executed by the user.B、It contains the SQL text executed by the user and the bind variables used with it.C、It contains the plan and statistics associated with the SQL statement executed by the user.D、It contains the plan for the SQL statement executed by the user and the bind variables used with it.

4.Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:Which two statements are true?()A. Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.B. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.C. The command will, create a common user whose description is contained in the root and each pdb.D. The schema for the common user C # # A_ADMIN can be different in each container.E. The command will create a user in the root container only because the container clause is not used

参考答案和解析
正确答案： D,C
解析： 暂无解析
更多“多选题Examine the command： SQL ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）AThe SKD user cannot log in to the database instance.BThe objects owned by the SKD user are not accessible to any user.CThe other users c”相关问题

  • 第1题：

    The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE  REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0  You have a local operating system user SKD. You create a database user OPS$SKD， and then  assignexternal authentication. The user OPS$SKD has the CREATE SESSION privilege.  What would youachieve by the above process（）

    • A、The database user OPS$SKD will be able to administer the database.
    • B、The authentication detail for the database user OPS$SKD is recorded in the password file.
    • C、The local operating system user SKD will be able to access the database instance without specifying the username and password.
    • D、The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.

    正确答案:C

  • 第2题：

    You execute the following command to audit database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）

    • A、One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.
    • B、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.
    • C、One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.
    • D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
    • E、One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT

    正确答案:C

  • 第3题：

    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

  • 第4题：

    You execute the following command to audit the database activities：   SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command？（）

    • A、One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
    • B、One audit record is created for every session when any user successfully drops a table owned by SCOTT.
    • C、One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
    • D、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
    • E、One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

    正确答案:A

  • 第5题：

    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

  • 第6题：

    You execute the following command toauditdatabase activities：  SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command（）

    • A、Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.
    • B、Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.
    • C、One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.
    • D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
    • E、One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.

    正确答案:C

  • 第7题：

    多选题
    Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）
    A

    The SKD user cannot log in to the database instance.

    B

    The objects owned by the SKD user are not accessible to any user.

    C

    The other users can access the objects owned by the SKD user， on which they have access.

    D

    The password for the SKD user expires and the user is forced to change the password at the next log in


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

  • 第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题：

    单选题
    View the Exhibit and examine the privileges granted to the MGR_ROLE role. The user SKD has been grantedthe CONNECT and RESOURCE roles only. The database administrator （DBA） grants MGR_ROLE to the userSKD by executing the command： SQL> GRANT MGR_ROLE TO SKD WITH ADMIN OPTION；  Which statement is true about the user SKD afterhe/she is granted this role（）
    A

    The user SKD can grant only the MGR_ROLE role to other users， but not the privileges in it.

    B

    The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor.

    C

    The user SKD can grant the privileges in the MGR_ROLE role to other users， but not with ADMIN OPTION.

    D

    The user SKD can grant the privileges in the MGR_ROLE role to other users， but cannot revoke privilegesfrom them


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

  • 第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题：

    多选题
    Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）
    A

    The SKD user cannot log in to the database instance.

    B

    The objects owned by the SKD user are not accessible to any user.

    C

    The other users can access the objects owned by the SKD user， on which they have access.

    D

    The password for the SKD user expires and the user is forced to change the password at the next log in.


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

  • 第12题：

    单选题
    The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE  REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0  You have a local operating system user SKD. You create a database user OPS$SKD， and then  assignexternal authentication. The user OPS$SKD has the CREATE SESSION privilege.  What would youachieve by the above process（）
    A

    The database user OPS$SKD will be able to administer the database.

    B

    The authentication detail for the database user OPS$SKD is recorded in the password file.

    C

    The local operating system user SKD will be able to access the database instance without specifying the username and password.

    D

    The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.


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

  • 第13题：

    All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions：SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.SQL> DELETE FROM persons WHERE exp=’Y’；3 rows deleted. The SYS user opens a new session after HR executed the above commands.  Which sessions can see theeffect of the UPDATE and DELETE commands（）

    • A、All sessions of the HR user only
    • B、All sessions of the HR user and the SYS user
    • C、The session of the HR user that executed the commands
    • D、All the sessions for which the database users have access privilege to the PERSONS table

    正确答案:C

  • 第14题：

    Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）

    • A、The SKD user cannot log in to the database instance.
    • B、The objects owned by the SKD user are not accessible to any user.
    • C、The other users can access the objects owned by the SKD user， on which they have access.
    • D、The password for the SKD user expires and the user is forced to change the password at the next log in

    正确答案:A,C

  • 第15题：

    Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）

    • A、The SKD user cannot log in to the database instance.
    • B、The objects owned by the SKD user are not accessible to any user.
    • C、The other users can access the objects owned by the SKD user， on which they have access.
    • D、The password for the SKD user expires and the user is forced to change the password at the next log in.

    正确答案:A,C

  • 第16题：

    The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege.  What would you achieve by the above process（）

    • A、The database user OPS$SKD will be able to administer the database.
    • B、The authentication detail for the database user OPS$SKD is recorded in the password file.
    • C、The local operating system user SKD will be able to access the database instance without specifying theusername and password.
    • D、The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.

    正确答案:C

  • 第17题：

    You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）

    • A、All the objects of scott are moved to the Recycle Bin.
    • B、Any objects in the Recycle Bin belonging to scott are purged.
    • C、All the objects owned by scott are permanently dropped from the database.
    • D、All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
    • E、Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

    正确答案:B,C

  • 第18题：

    单选题
    You execute the following command to audit database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）
    A

    One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.

    B

    One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.

    C

    One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.

    D

    One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.

    E

    One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT


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

  • 第19题：

    单选题
    You execute the following command toauditdatabase activities：  SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command（）
    A

    Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.

    B

    Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.

    C

    One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.

    D

    One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.

    E

    One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.


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

  • 第20题：

    多选题
    You executed the following command to drop a user：   DROP USER scott CASCADE；   Which two statements regarding the above command are correct？（）
    A

    All the objects of scott are moved to the Recycle Bin.

    B

    Any objects in the Recycle Bin belonging to scott are purged.

    C

    All the objects owned by scott are permanently dropped from the database.

    D

    All the objects of scott in the Recycle Bin must be purged before executing the DROP command.

    E

    Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.


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

  • 第21题：

    多选题
    Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container: Which two statements are true?（）
    A

    Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.

    B

    The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.

    C

    The command will, create a common user whose description is contained in the root and each pdb.

    D

    The schema for the common user C # # A_ADMIN can be different in each container.

    E

    The command will create a user in the root container only because the container clause is not used


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

  • 第22题：

    多选题
    Which two statements are true when using the configure exclusive CLI command?（）
    A

    Multiple users can enter configuration mode and have their own private configuration.

    B

    When a user commits, only the user's changes are committed.

    C

    A message indicates which other users are in configuration mode and what portion of the configuration they are editing.

    D

    Only a single user can edit the configuration.


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

  • 第23题：

    单选题
    You execute the following command to audit the database activities：  SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command？（）
    A

    One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.

    B

    One audit record is created for every session when any user successfully drops a table owned by SCOTT.

    C

    One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.

    D

    One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.

    E

    One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.


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

  • 第24题：

    单选题
    To make audit information more productive， the DBA executes the following command before starting an auditoperation： SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting Thedatabase（）
    A

    It contains only the plan for the SQL statement executed by the user.

    B

    It contains the SQL text executed by the user and the bind variables used with it.

    C

    It contains the plan and statistics associated with the SQL statement executed by the user.

    D

    It contains the plan for the SQL statement executed by the user and the bind variables used with it


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

相关内容