You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this. 
Which data type would you use for the new column（）

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（）

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（）

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（）