Oracle Database SQL Free Practice Exam Questions

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

1. Question 177: Which two statements are true about Oracle synonyms? (Choose two.)
2. Question 179: Which two are true about self joins? (Choose two.)
3. Question 180: Which two statements are true about the data dictionary?
4. Question 182: You execute this query: SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "Monday for" fmMonth rrrr') FROM DUAL; What is the result?
5. Question 183: Which three statements are true about a self join? (Choose three.)
6. Question 184: Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.)
7. Question 185: Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION?
8. Question 186: You need to calculate the number of days from 1st January 2019 until today. Dates are stored in the default format of DD-MON-RR. Which two queries give the req…
9. Question 189: Which three actions can you perform only with system privileges? (Choose three.)
10. Question 190: Which two statements will convert the string Hello World to ello world? (Choose two.)