Oracle Database SQL Free Practice Exam Questions

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

1. Question 158: You issued this command: DROP TABLE hr.employees; Which three statements are true? (Choose three.)
2. Question 159: Which two statements are true about an Oracle database? (Choose two.)
3. Question 160: Which three statements are true about views in an Oracle Database? (Choose three.)
4. Question 161: Which two are true about external tables that use the ORACLE_DATAPUMP access driver? (Choose two.)
5. Question 163: Which two statements about INVISIBLE indexes are true? (Choose two.)
6. Question 164: A session's NLS_DATE_FORMAT is set to DD Mon YYYY. Which two queries return the value 1 Jan 2019? (Choose two.)
7. Question 165: You create a table named 123. Which statement runs successfully?
8. Question 169: The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2. The table has two rows whose CUST_LAST_NAME values are Anderson and Ausson. Which query…
9. Question 171: Which two are true about creating tables in an Oracle database? (Choose two.)
10. Question 173: Which two are true about granting privileges on objects? (Choose two.)