Basic SQL Quiz For School Learners!
This is a quiz on the SQL system. Needed for learning at school
- 1.When did SQL appear
- A.
1974
- B.
1922
- C.
1977
- D.
1987
- 2.Who developed SQL
- A.
IBM
- B.
DELL
- C.
SQL
- D.
Microsoft
- E.
Apple
- 3.Who designed the SQL system
- A.
Donald D. Chamberlin
- B.
Raymond F. Boyce
- C.
Jerron Q. Refter
- D.
Both A & B
- E.
Both A & C
- 4.What is a query?
- A.
A question
- B.
Desire results
- 5.What is null
- A.
Add
- B.
Rule out
- 6.What does SQL Lack
- A.
The complexity and size of the SQL standard means that most databases DO NOT implement the entire standard.
- B.
The simplicity and size of the SQL standard means that most databases DO implement the entire standard.
- C.
The simplicity and size of the SQL standard means that most databases DO NOT implement the entire standard.
- D.
The complexity and size of the SQL standard means that most databases DO implement the entire standard.
- 7.Which of the following is true about SQL joins?
- A.
The join condition is not separated from other search conditions in a query
- B.
The ON clause makes code difficult to understand
- C.
The join condition for natural join is basically an equijoin of all columns with same name.
- D.
None of the above.
- 8.Which of the following functions can be used on both numeric as well as non-numeric data?
- A.
COUNT
- B.
AVG
- C.
STDDEV
- D.
VARIANCE
- 9.Which of the following is not true about the COUNT function?
- A.
COUNT(*) returns the number of rows in the table.
- B.
COUNT(DISTINCT exp) returns the number of unique, non-null values in the column
- C.
COUNT(DISTINCT exp) returns the number of unique, non-null values in the column
- D.
All are true.
- 10.Which of the following is not true about inserting news rows to a table?
- A.
The INSERT INTO statement is used for inserting new rows to a table
- B.
You cannot insert rows with NULL values to a table.
- C.
You may insert a new row containing values for each column.
- D.
All of the above.
Back to top