Oracle Database Administration I Free Practice Exam Questions

136 real Oracle Database Administration I exam questions with answers and AI explanations. Oracle certification prep — page 9 of 14.

1. Question 104: Which three statements are true about connection strings and service names used to connect to an Oracle database instance? (Choose three.)
2. Question 106: Which two statements are true regarding indexes? (Choose two.)
3. Question 107: Which three statements are true about the naming methods and their features supported by Oracle database used to resolve connection information? (Choose three.)
4. Question 108: Which two statements are true about UNDO and UNDO tablespaces? (Choose two.)
5. Question 110: Examine this command: SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT Which two statements are true? (Choose two.)
6. Question 111: Which three statements are true about Deferred Segment Creation in Oracle databases? (Choose three.)
7. Question 112: Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement?
8. Question 113: Which two statements are true about the PMON background process? (Choose two.)
9. Question 114: Which two statements are true about single row functions? (Choose two.)
10. Question 117: Which three statements are true about the Automatic Diagnostic Repository (ADR)? (Choose three.)