ExamQuestions.com

Register
Login
Oracle Datbase 12c SQL Exam Questions

Oracle

Oracle Datbase 12c SQL

103 / 120

Question 103:

View the exhibit and examine the structure and data in the INVOICE table. 
image
Which two SQL statements would execute successfully? (Choose two.) 

Answer options:

A. SELECT MAX(AVG(SYSDATE -inv_date)) FROM invoice
B. SELECT AVG(inv_date) FROM invoice
C. SELECT MAX(inv_date), MIN(cust_id) FROM invoice
D. SELECT AVG( inv_date -SYSDATE), AVG(inv_amt) FROM invoice