Evaluate the following SQL statement: Which statement is true regarding the outcome of the above query? A. It produces an error because the ORDER BY clause should appear only at the end of a compound query-that is, with the last…

Which three SQL statements would display the value 1890.55 as $1,890.55? (Choose three.) A. SELECT TO_CHAR(1890.55,’$99G999D00′)FROM DUAL; B. SELECT TO_CHAR(1890.55,’$9,999V99′)FROM DUAL; C. SELECT TO_CHAR(1890.55,’$0G000D00′)FROM DUAL; D. SELECT TO_CHAR(1890.55,’$99G999D99′)FROM DUAL; E. SELECT TO_CHAR(1890.55,’$9,999D99′)FROM DUAL;

Where can sub queries be used? (Choose all that apply) A. field names in the SELECT statement B. the FROM clause in the SELECT statement C. the HAVING clause in the SELECT statement D. the GROUP BY clause in the…

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? A. The two statements produce identical results. B. The second…

See 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…

Which three statements are true regarding sub queries? (Choose three.) A. Multiple columns or expressions can be compared between the main query and sub query B. Main query and sub query can get data from different tables C. Sub queries…

See the Exhibit and examine the structure and data in the INVOICE table: Exhibit: Which two SQL statements would executes successfully? (Choose two.) A. SELECT MAX(inv_date),MIN(cust_id) FROM invoice; B. SELECT MAX(AVG(SYSDATE - inv_date)) FROM invoice; C. SELECT (AVG(inv_date) FROM invoice;…

You need to design a student registration database that contains several tables storing academic information. The STUDENTS table stores information about a student. The STUDENT_GRADES table stores information about the student’s grades. Both of the tables have a column named…

Here is the structure and data of the CUST_TRANS table: Exhibit: Dates are stored in the default date format dd-mm-rr in the CUST_TRANS table. Which three SQL statements would execute successfully? (Choose three.) A. SELECT transdate + ’10’ FROM cust_trans;…

Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? (Choose three.) A. It releases the storage space used by the table. B. It does not release the storage space used by the table. C.…