Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, ...

[Pineapplelove6]

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

[juiceman1987]

Answer to Question 1

D

Answer to Question 2

FALSE

[Pineapplelove6]

Excellent

[irishcancer18]

TYSM