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

题目
多选题
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题:

在oracle数据库中,执行下面的命令SQL>ALTER USER skd ACCOUNT LOCK;有关执行结果下面那两项描述正确?()

A.SKD用户的对象不能被任何用户访问

B.用户SKD密码过期,在下次登陆时强制用户修改密码

C.用户SKD不能登陆数据库实例

D.其它用户可以访问SKD用户的对象,当用户已经在访问对象的时候


参考答案:C, D

第2题:

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

第3题:

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 creation

B. The job is automatically dropped after the end date

C. The job executes with the privileges of the user SYS

D.


参考答案:B, C

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

第5题:

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

第6题:

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.

正确答案:B

第7题:

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

第8题:

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


参考答案:B, E

第9题:

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

第10题:

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

更多相关问题