Author Question: Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following ... (Read 67 times)

Pineapplelove6 · **on:** Jul 7, 2018

Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following is not a valid ANSI SQL command?

A) SELECT
FROM EMPLOYEE
WHERE Name LIKE 'Ja';
B) SELECT COUNT()
FROM EMPLOYEE
WHERE Salary < 30000;
C) SELECT HireDate, COUNT()
FROM EMPLOYEE
GROUP BY HireDate;
D) SELECT HireDate, COUNT()
FROM EMPLOYEE
WHERE Salary < 30000;

Question 2

Cascading deletions are generally not used with relationships for weak child entities.

Indicate whether the statement is true or false