Oracle Database SQL Free Practice Exam Questions

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

1. Question 79: The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type number. Which two queries execute successfully? (Choose two.)
2. Question 80: Which three actions can you perform by using the ORACLE_DATAPUMP access driver? (Choose three.)
3. Question 81: Which statement is true about aggregate functions?
4. Question 82: Which three are true about multitable INSERT statements? (Choose three.)
5. Question 83: Which two are true about savepoints? (Choose two.)
6. Question 84: The ORDERS table has a column ORDER_DATE of data type DATE. The default display format for a date is DD-MON-RR. Which two WHERE conditions demonstrate the corr…
7. Question 85: Which two object privileges can be restricted to a subset of columns in a table? (Choose two.)
8. Question 90: Which two statements are true about substitution variables?
9. Question 92: Which three statements are true about performing DML operations on a view with no INSTEAD OF triggers defined? (Choose three.)
10. Question 93: The SYSDATE function displays the current Oracle Server date as: 21-MAY-19 You wish to display the date as - MONDAY, 21 MAY, 2019 - Which statement will do thi…