A new user, Smith, has just joined the organization. You need to create a User Account for him in the database. The points given below are to be kept in mind:
1. Create a user who is authenticated externally.
2. Make sure that the user has CONNECT and RESOURCE privileges.
3. Make sure the user does NOT have DROP TABLE and CREATE USER privileges.
4. Set a quota of 100 MB on the default tablespace and 500 K on the temporary tablespace.
5. Assign the user to the DATA_TS default tablespace
Which of the following statements would you use to create the User Account for Smith?
Correct Answer: CREATE USER smith IDENTIFIED EXTERNALLY DEFAULT TABLESPACE data_ts QUOTA 500K ON temp_ts QUOTA 100M ON data_ts TEMPORARY TABLESPACE temp_ts; GRANT connect, resource TO smith
Explanation:
Note: This Question is unanswered, help us to find answer for this one
More Oracle 9i Administration MCQ Questions