11.
By default, how much tablespace can any account use for a new table?
- A.None
- B.Up to the current free space in the tablespace
- C.Unlimited space, including autoextends
- D.Up to the default quota established at tablespace creation time
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| By default, user accounts have no quota in any tablespace. Before a user can create a table or an index, you need to either give the user a quota in one or more specific tablespaces, or grant the UNLIMITED TABLESPACE system privilege to give unlimited quota (including autoextends) in all tablespaces. |
12.
Which of the following SQL statements results in a disconnection after a session is idle for
30 minutes?
- A.alter session set idle_timeout=30;
- B.alter session set idle_timeout=1800;
- C.alter profile limit idle_time 30;
- D.alter profile set idle_timout 30;
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| Profiles limit the amount of idle time, CPU time, logical reads, or other resource-oriented session limits. Option C uses the correct syntax to limit idle time for a session to 30 minutes. |
13.
Which of the following prevents a user from reusing a password when they change their password?
- A.Setting the initialization parameter NO_PASSWORD_REUSE to TRUE
- B.Altering that user's profile to UNLIMITED for PASSWORD_REUSE_TIME and 1 for PASSWORD_ REUSE_MAX
- C.Altering that user's profile to UNLIMITED for both PASSWORD_REUSE_TIME and PASSWORD_ REUSE_MAX
- D.Using a password verify function to record the new password and compare the new passwords to those recorded previously
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| Although option D could also work, it involves storing the passwords in a table in the database, which could be a security concern. It also takes a lot more effort to configure and maintain. The better technique is to use the standard database profile features PASSWORD_RESUSE_TIME and PASSWORD_REUSE_MAX. Setting one of these profile parameters to UNLIMITED and the other to a specific value prevents passwords from being reused. If both of these profile parameters are set to UNLIMITED, these parameters are essentially disabled. There is no initialization parameter called NO_PASSWORD_REUSE. |
14.
How can you prevent someone from using an all-numeric password?
- A.Set the initialization parameter PASSWORD_COMPLEXITY to ALPHANUM.
- B.Alter that user's profile setting PASSWORD_COMPLEXITY to ALPHNANUM.
- C.Alter the user's profile to use a password verify function that performs REGEX comparisons to validate the password.
- D.There is no mechanism that lets you prevent an all-numeric password.
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| There are no standard password complexity settings in either the initialization parameters or profiles. A password verify function can validate new passwords against any rules that you can code in PL/SQL, including regular expression comparisons. |
15.
Which of the following is not an object privilege on a table?
- A.SELECT
- B.DEBUG
- C.REFERENCES
- D.READ
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| The object privileges on a table include SELECT, INSERT, UPDATE, DELETE, ALTER, INDEX, REFERENCES, and DEBUG, but not READ. READ is a valid object privilege, but only on a directory— a database object that is outside the scope of the OCA exam. |
|
|
||||||||||||||||||||||||||||
