Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the
SQL statement? (Choose three.)
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 STUDENT_ID. The STUDENT_ID column in the STUDENTS table is
a primary key. You need to create a foreign key on the STUDENT_ID column of the
STUDENT_GRADES table that points to the STUDENT_ID column of the STUDENTS
table. Which statement creates the foreign key?
Which three statements are true regarding sub queries? (Choose three.)
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)
Which three SQL statements would display the value 1890.55 as $1,890.55? (Choose