Oracle Database SQL Free Practice Exam Questions

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

  1. Question 61: Which two are true about constraints? (Choose two.)
  2. Question 63: Which two statements are true about CURRENT_TIMESTAMP? (Choose two.)
  3. Question 64: Examine this incomplete query: SELECT DATE '2019-01-01' + FROM DUAL; Which three clauses can replaceto add 12 hours to the date? (Choose three.)
  4. Question 65: Which set of commands will prompt only once for the name of the table to use in the query?
  5. Question 68: Which three statements are true about external tables? (Choose three.)
  6. Question 71: Examine this query: SELECT SUBSTR(SYSDATE, 1, 5) "Result" FROM DUAL; Which statement is true?
  7. Question 72: Which three statements are true about the DESCRIBE command? (Choose three.)
  8. Question 73: Which statement is true about TRUNCATE and DELETE?
  9. Question 74: Which two queries return the string Hello! We're ready? (Choose two.)
  10. Question 75: Examine this query: SELECT TRUNC(ROUND(156.00,-2),-1) FROM DUAL; What is the result?