单项选择题
You created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL> DROP PROFILE app_user；
Which statement describes the result（）
A.The command produces an error.
B.The profile is dropped and current user sessions use the DEFAULT profile immediately.
C.The profile is dropped and only the subsequent user sessions use the DEFAULT profile.
D.The profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.
相关考题
-
单项选择题
In your database instance， the user sessions are connected to the database server from the remotemachines. You want to achieve the following for these users： 1：The user account must be locked after four unsuccessful login attempts.PASSWORD_LOCK_TIME 2：The user must be prompted to change the password at regular intervals.PASSWORD_LIFE_TIME 3：The user may not have more than three simultaneous sessions.SESSIONS_PER_USER 4：The user session must automatically be logged off if more than 10 minutes elapsed time used.CONNECT_TIME How would you accomplish the above（）
A.by assigning profiles for the users
B.by implementing Fine-Grained Auditing （FGA）
C.by granting a secure application role to the users
D.by implementing the Database Resource Manager plan -
单项选择题
View the Exhibit to observe the roles assigned to the SLP_REP user. Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SLP_REPuser（）
A.The user must enable the role explicitly.
B.The user can grant the role to other users.
C.The user cannot use the role until the DBA enables it explicitly.
D.The user can start using the role immediately without any changes. -
单项选择题
View the Exhibit and examine the user information. The user has been granted CONNECT and RESOURCE roles and no individual system privileges. TheSL_REP user executes this command to create a table： SQL> CREATE TABLE orders（oid number（6）， odate date， ccode number（4）， oamt number（10，2）） TABLESPACE purchase_space； The PURCHASE_SPACE tablespace already exists in the database. Which statement describes theeffect of the command（）
A.The command executes successfully and creates the table in the USERS tablespace.
B.The command executes successfully and creates the table in the PURCHASE_SPACE tablespace.
C.The command produces an error because the user does not have the privilege to create the table.
D.The command produces an error because the user does not have quota in the PURCHASE_SPACE tablespace.
