Oracle Database SQL Free Practice Exam Questions

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

  1. Question 94: Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database? (Choose three.)
  2. Question 97: Which two are true about the MERGE statement? (Choose two.)
  3. Question 98: Which two are true about virtual columns? (Choose two.)
  4. Question 99: Which three statements are true about inner and outer joins? (Choose three.)
  5. Question 101: Which two are true about scalar subquery expressions?
  6. Question 102: Which two statements cause changes to the data dictionary? (Choose two.)
  7. Question 103: Which two statements are true about selecting related rows from two tables based on an Entity Relationship Diagram (ERD)? (Choose two.)
  8. Question 106: Which statement is true about the INTERSECT operator used in compound queries?
  9. Question 108: Which two statements are true about views? (Choose two.)
  10. Question 109: The PRODUCT_INFORMATION table has a UNIT_PRICE column of data type NUMBER(8,2). Evaluate this SQL statement: SELECT TO_CHAR(unit_price, '$9,999') FROM product_…