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 1 of 14.

1. Question 1: Which three statements are true about single-row functions? (Choose three.)
2. Question 2: Which two statements are true about space-saving features in an Oracle Database? (Choose two.)
3. Question 3: Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)
4. Question 4: Which two statements are true about the DUAL table? (Choose two.)
5. Question 5: Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)
6. Question 6: Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER. Examine these SQL statements: Statement 1: SELECT MAX(unit_price * q…
7. Question 7: Which three statements are true about views in an Oracle database? (Choose three.)
8. Question 8: Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)
9. Question 9: Which statement is true about aggregate functions?
10. Question 11: Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)