SQL QUIZ

The AVG SQL function returns the ...

• the sum of values in a column

• average in the values in agroup.

• maximum value from a column.

What does follow after the SQL SELECT clause?

• List of columns that will be selected or the * symbol.

• The JOIN SQL clause.

• The name of the table we are selecting from.

You can add a column in existing table using SQL in a database with which of the following?

• INSERT

• COLUMN

• ALTER

• TABLE

• ADD

The command to remove rows from a table 'CUSTOMER' is:

• REMOVE FROM CUSTOMER ...

• DROP FROM CUSTOMER ...

• DELETE FROM CUSTOMER WHERE ...

• UPDATE FROM CUSTOMER ...

The SQL WHERE clause:

• limits the column data that are returned.

• limits the row data are returned.

• Both A and B are correct.

• Neither A nor B are correct.

The command to eliminate a table from a database is:

• REMOVE TABLE CUSTOMER;

• DROP TABLE CUSTOMER;

• DELETE TABLE CUSTOMER;

• UPDATE TABLE CUSTOMER;

Consider the below schema :-

STUDENTS(student_code, first_name, last_name, email,

phone_no, date_of_birth, honours_subject, percentage_of_marks)

-------------------------------------------------------------------------

Which of the following query would display names of all the students whose honours subject is English, or honours subject is Spanish and percentage of marks more than 80?

• select first_name, last name from students where (honours_subject = “English” or honours_subject = “Spanish” ) and percentage_of_marks > 80;

• select first_name, last name from students where honours_subject = “English” or honours_subject = “Spanish” and percentage_of_marks > 80;

• select first_name, last name from students where honours_subject = “English” and honours_subject = “Spanish” or percentage_of_marks > 80;

• select * from students where honours_subject = “English” or honours_subject = “Spanish” and percentage_of_marks > 80;

The result of a SQL SELECT statement is a(n) ________ .

• report

• form

• file

• table

Which of the following are the five built-in functions provided by SQL?

• COUNT, SUM, AVG, MAX, MIN

• SUM, AVG, MIN, MAX, MULT

• SUM, AVG, MULT, DIV, MIN

• SUM, AVG, MIN, MAX, NAME

In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:

• all columns of the table are to be returned.

• all records meeting the full criteria are to be returned.

• all records with even partial criteria met are to be returned.

• None of the above is correct.