Which is the correct answer for the following SQL query: (Only one answer)

SELECT COUNT(*) FROM Product

Which is not an sql operator? (Choose all that apply)

Returns a relation containing all tuples that appear in the first and not the second of two specified relations.

Which is the correct answer for the following SQL query: (Only one answer)

SELECT COUNT(*) FROM Products WHERE Price > 1000;

Which of the following keywords is used beside the select clause to explicitly specify that duplicates are not removed?

A ______  is a special kind of a stored procedure that executes in response to certain events on the table like insertion, deletion or updation of data.

  Which keyword is used to rename a relation in a query?

How to change surname of a student “Brown” into “Smith”  whose name is “Sam”

Ellipses represent_________

Using the schema below:

• STUDENT(Sid, Sname, Gender, Age, EntranceYear, GPA)

• DEPT(Did, Dname)

• PROF(Pid, Pname, Did, Birth_Date)

• COURSE(Cno, Did, Cname)

• SECTION(Sectno, Did, Cno, Pid)

• ENROLL(Eid, Sid, Cno, Sectno, Grade)

Which SQL query returns the number of students with NULL GPA, grouped by their EntranceYear?