View the Exhibit and examine the structure of the CUSTOMERS table:Using the CUSTOMERS table, you need to generate a report that shows the average credit limit for customers in WASHINGTON and NEW YORK.Which SQL statement would produce the required result?
Which two statements complete a transaction? (Choose two)
You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns:CUST_IDNUMBER(4)NOT NULL -CUST_NAMEVARCHAR2(100)NOT NULL -CUST_ADDRESSVARCHAR2(150)CUST_PHONEVARCHAR2(20)Which SELECT statement accomplishes this task?
Evaluate these two SQL statements:SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC;SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC;What is true about them?
Where can sub queries be used? (Choose all that apply)
Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? (Choose three.)
