Basic SQL Quiz For School Learners!

1974

1922

1977

1987

IBM

DELL

SQL

Microsoft

Apple

Donald D. Chamberlin

Raymond F. Boyce

Jerron Q. Refter

Both A & B

Both A & C

A question

Desire results

Add

Rule out

The complexity and size of the SQL standard means that most databases DO NOT implement the entire standard.

The simplicity and size of the SQL standard means that most databases DO implement the entire standard.

The simplicity and size of the SQL standard means that most databases DO NOT implement the entire standard.

The complexity and size of the SQL standard means that most databases DO implement the entire standard.

The join condition is not separated from other search conditions in a query

The ON clause makes code difficult to understand

The join condition for natural join is basically an equijoin of all columns with same name.

None of the above.

COUNT

AVG

STDDEV

VARIANCE

COUNT(*) returns the number of rows in the table.

COUNT(DISTINCT exp) returns the number of unique, non-null values in the column

COUNT(DISTINCT exp) returns the number of unique, non-null values in the column

All are true.

The INSERT INTO statement is used for inserting new rows to a table

You cannot insert rows with NULL values to a table.

You may insert a new row containing values for each column.

All of the above.