Oracle Database SQL Free Practice Exam Questions

165 real Oracle Database SQL exam questions with answers and AI explanations. Oracle certification prep — page 2 of 17.

1. Question 19: Which three statements are true about indexes and their administration in an Oracle database? (Choose three.)
2. Question 21: In your session NLS_DATE_FORMAT is set to DD-MON-RR. Which two queries display the year as four digits? (Choose two.)
3. Question 22: Which statement is true about TRUNCATE and DELETE?
4. Question 23: Which two are true about using constraints? (Choose two.)
5. Question 25: Which two statements are true? (Choose two.)
6. Question 29: Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)
7. Question 30: Which two are true about global temporary tables? (Choose two.)
8. Question 32: Which three statements are true about sequences in a single instance Oracle database? (Choose three.)
9. Question 34: No user-defined locks are used in your database. Which three are true about Transaction Control Language (TCL)? (Choose three.)
10. Question 35: Examine this query: SELECT INTERVAL ‘100’ MONTH DURATION FROM DUAL; What will be the output?