Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about theSQL statement? (Choose three.)
You need to design a student registration database that contains several tables storingacademic information. The STUDENTS table stores information about a student. TheSTUDENT_GRADES table stores information about the student’s grades. Both of the tableshave a column named STUDENT_ID. The […]
Here is the structure and data of the CUST_TRANS table: Exhibit: Dates are stored in thedefault date format dd-mm-rr in the CUST_TRANS table. Which three SQL statementswould execute successfully? (Choose three.)
See the Exhibit and examine the structure and data in the INVOICE table: Exhibit: Whichtwo SQL statements would executes successfully? (Choose two.)
Which three statements are true regarding sub queries? (Choose three.)
See the Exhibit and examine the structure of the CUSTOMERS table: Using theCUSTOMERS table, you need to generate a report that shown the average credit limit forcustomers in WASHINGTON and NEW YORK. Which SQL statement would produce therequired result?
Evaluate these two SQL statements: SELECT last_name, salary, hire_date FROMEMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROMEMPLOYEES ORDER BY 2 DESC; What is true about them?
Where can sub queries be used? (Choose all that apply)
Which three SQL statements would display the value 1890.55 as $1,890.55? (Choosethree.)
Evaluate the following SQL statement: Which statement is true regarding the outcome of theabove query?