47.Which tow statements accurately describe a role?(Choose two)
A. A role can be given to a maximum of 1000 users.
B. A user can have access to a maximum of 10 roles.
C. A role can have a maximum of 100 privileges contained in it.
D. Privileges are given to a role by using the CREATE ROLE statement.
E. A role is a named group of privileges that can be granted to the user.
F. A user can have access to serveral roles,and sereral users can be assigned the same role.
Answer: D,F
68.Which tow are attributes of SQL*Plus(Choose tow)
A.SQL*Plus commands cannot be abbreviated.
B.SQL*Plus commands are accesses from browser.
C.SQL*Plus commands are used to manipulate data in tables.
D.SQL*Plus manipulate table definitions in the database.
E.SQL*Plus is the Oracle proprietary interface for executing SQL statements.
Answer:C,D
43.Which two statements about subqueries are true? (Choose two.)
A. A single row subquery can retrieve data from only one table.
B. A SQL query statement cannot display data from table B that is referred to in its