Q 1. Which term describes the process of confirming the identity of a user?
a. Verification
b. Repudiation
c. Authentication
d. Authorization
Q 2. When using local authentication, a user is authenticated using what?
a. An LDAP server
b. An external authentication service
c. KERBEROS
d. A password
Q 3. Which of the following lines in the CREATE USER
statement will cause an error?
a. CREATE USER janders identified by password
b. default tablespace example
c. quota 600M on example
d. profile limit set PASSWORD_REUSE_MAX = 10;
Q 4. Which of the following is incorrect regarding the CREATE ANY TABLE
privilege?
a. It allows a user to create a table in their own schema.
b. It allows a user to drop a table in any other schema.
c. It allows a user to create a table in any other schema.
d. It is a system privilege.
Q 5. Given that a new user is created and is granted the following privileges as shown, which of these statements is true?
create user janders identified by password; grant create table...