The SKD user cannot log in to the database instance.
The objects owned by the SKD user are not accessible to any user.
The other users can access the objects owned by the SKD user, on which they have access.
The password for the SKD user expires and the user is forced to change the password at the next log in
第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()
第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()
第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()
第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?()
第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()
第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()
第7题:
The SKD user cannot log in to the database instance.
The objects owned by the SKD user are not accessible to any user.
The other users can access the objects owned by the SKD user, on which they have access.
The password for the SKD user expires and the user is forced to change the password at the next log in
第8题:
The table created by SKD isnot accessibleand SKD cannot create new tables.
The tables created by SKD and HR remain, but both cannot create new tables.
The table created by HR remains and HR still has the CREATE TABLE system privilege.
The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
第9题:
The user SKD can grant only the MGR_ROLE role to other users, but not the privileges in it.
The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor.
The user SKD can grant the privileges in the MGR_ROLE role to other users, but not with ADMIN OPTION.
The user SKD can grant the privileges in the MGR_ROLE role to other users, but cannot revoke privilegesfrom them
第10题:
The table created by SKD is not accessible and SKD cannot create new tables.
The tables created by SKD and HR remain, but both cannot create new tables.
The table created by HR remains and HR still has the CREATE TABLE system privilege.
The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
第11题:
The SKD user cannot log in to the database instance.
The objects owned by the SKD user are not accessible to any user.
The other users can access the objects owned by the SKD user, on which they have access.
The password for the SKD user expires and the user is forced to change the password at the next log in.
第12题:
The database user OPS$SKD will be able to administer the database.
The authentication detail for the database user OPS$SKD is recorded in the password file.
The local operating system user SKD will be able to access the database instance without specifying the username and password.
The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.
第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()
第14题:
Examine the command: SQL> ALTER USER skd ACCOUNT LOCK; Which two statements are true after the command is executed()
第15题:
Examine the command: SQL> ALTER USER skd ACCOUNT LOCK; Which two statements are true after the command is executed()
第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()
第17题:
You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?()
第18题:
One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.
One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.
One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.
One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT
第19题:
Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.
Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.
One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.
One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.
第20题:
All the objects of scott are moved to the Recycle Bin.
Any objects in the Recycle Bin belonging to scott are purged.
All the objects owned by scott are permanently dropped from the database.
All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
第21题:
Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
The command will, create a common user whose description is contained in the root and each pdb.
The schema for the common user C # # A_ADMIN can be different in each container.
The command will create a user in the root container only because the container clause is not used
第22题:
Multiple users can enter configuration mode and have their own private configuration.
When a user commits, only the user's changes are committed.
A message indicates which other users are in configuration mode and what portion of the configuration they are editing.
Only a single user can edit the configuration.
第23题:
One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
One audit record is created for every session when any user successfully drops a table owned by SCOTT.
One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.
第24题:
It contains only the plan for the SQL statement executed by the user.
It contains the SQL text executed by the user and the bind variables used with it.
It contains the plan and statistics associated with the SQL statement executed by the user.
It contains the plan for the SQL statement executed by the user and the bind variables used with it