Oracle Database 11g: Administration I Free Practice Exam Questions

31 real Oracle Database 11g: Administration I exam questions with answers and AI explanations. Oracle certification prep — page 1 of 4.

1. Question 1: You have to create a table, STUDENTS, with the columns: STUDENT_ID, STUDENT_NAME, DATE_OF_BIRTH, and COURSE_ID. The following constraints have to be enforced o…
2. Question 2: Which three are true about auditing? (Choose three.)
3. Question 3: Which two are true about AWR snapshots? (Choose two.)
4. Question 5: Which two are true about transactions, UNDO segments, and UNDO tablespaces? (Choose two.)
5. Question 6: Which two are true about FAST_START_MTTR_TARGET? (Choose two.)
6. Question 7: You want to audit update statements that refer to USER1.DEPT.DNAME. Which type of auditing must you use?
7. Question 8: Your database is configured in archivelog mode. The USERS01 tablespace is currently online. You are required to take the tablespace offline. Which clause or cl…
8. Question 9: Examine these attributes for the profile assigned to USER1 whose password is oracle_4U. ✑ PASSWORD_REUSE_MAX IS 5 ✑ PASSWORD_REUSE_TIME IS 10 ✑ PASSWORD_GARCE_…
9. Question 10: Which two are true about server-generated alerts? (Choose two.)
10. Question 11: Which are three of the various resources that must be accessible to keep a database open? (Choose three.)