Oracle Database SQL Free Practice Exam Questions

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

1. Question 37: Which three are true about dropping columns from a table? (Choose three.)
2. Question 39: Which two are true about the NVL, NVL2, and COALESCE functions? (Choose two.)
3. Question 40: Which two are true about unused columns? (Choose two.)
4. Question 41: The SALES table has columns PROD_ID and QUANTITY_SOLD of data type NUMBER. Which two queries execute successfully? (Choose two.)
5. Question 46: Which two queries execute successfully? (Choose two.)
6. Question 48: Which statement executes successfully?
7. Question 51: The ORDERS table has a primary key constraint on the ORDER_ID column. The ORDER_ITEMS table has a foreign key constraint on the ORDER_ID column, referencing th…
8. Question 53: You and your colleague Andrew have these privileges on the EMPLOYEE_RECORDS table: 1. SELECT 2. INSERT 3. UPDATE 4. DELETE You connect to the database instance…
9. Question 55: Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)
10. Question 56: In the PROMOTIONS table, the PROMO_BEGIN_DATE column is of data type DATE and the default date format is DD-MON-RR. Which two statements are true about express…