Oracle Database SQL Free Practice Exam Questions

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

1. Question 1: The STORES table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE…
2. Question 2: Which two are true about granting object privileges on tables, views, and sequences? (Choose two.)
3. Question 3: You own table DEPARTMENTS, referenced by views, indexes, and synonyms. Examine this command which executes successfully: DROP TABLE departments PURGE; Which th…
4. Question 5: You need to allow user ANDREW to: 1. Modify the TITLE and ADDRESS columns of your CUSTOMERS table. 2. GRANT that permission to other users. Which statement wil…
5. Question 6: Which two actions can you perform with object privileges? (Choose two.)
6. Question 8: Which two statements are true about the COUNT function? (Choose two.)
7. Question 12: Which two are true about queries using set operators such as UNION? (Choose two.)
8. Question 14: Which two will execute successfully? (Choose two.)
9. Question 15: Examine this command: TRUNCATE TABLE test; Table truncated. Which two are true? (Choose two.)
10. Question 17: Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement?