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
Correct Answer
A. 1974Explanation
SQL, which stands for Structured Query Language, appeared in 1974. It was developed by IBM researchers Donald D. Chamberlin and Raymond F. Boyce. SQL is a programming language used for managing and manipulating relational databases. It provides a standardized way to interact with databases, allowing users to create, modify, and retrieve data. The introduction of SQL revolutionized the field of database management and has since become the industry standard for working with relational databases.Rate this question:
-
- 2.
Who developed SQL
- A.
IBM
- B.
DELL
- C.
SQL
- D.
Microsoft
- E.
Apple
Correct Answer
A. IBMExplanation
IBM is the correct answer because they were the company that developed SQL. SQL, which stands for Structured Query Language, was developed by IBM in the 1970s as a way to manage and manipulate relational databases. It has since become the standard language for managing databases and is widely used in the industry. While other companies like Microsoft and Oracle have also contributed to the development and enhancement of SQL, IBM is credited with its initial creation.Rate this question:
-
- 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
Correct Answer
D. Both A & BExplanation
Both Donald D. Chamberlin and Raymond F. Boyce designed the SQL system. This means that the correct answer is "Both A & B".Rate this question:
-
- 4.
What is a query?
- A.
A question
- B.
Desire results
Correct Answer
B. Desire resultsExplanation
A query refers to a request for information or data from a database or search engine. It is used to retrieve specific desired results or information that matches certain criteria or conditions. Therefore, the answer "desire results" accurately describes the purpose of a query.Rate this question:
-
- 5.
What is null
- A.
Add
- B.
Rule out
Correct Answer
B. Rule outExplanation
Null is a term used to describe the absence or lack of something. In this context, "rule out" means to eliminate or exclude as a possibility. Therefore, the correct answer suggests that null is not an option or cannot be considered in the given situation.Rate this question:
-
- 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.
Correct Answer
A. The complexity and size of the SQL standard means that most databases DO NOT implement the entire standard.Explanation
The correct answer is stating that most databases do not implement the entire SQL standard because of its complexity and size. This implies that there are certain aspects or features of the SQL standard that are not implemented in most databases.Rate this question:
-
- 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.
Correct Answer
C. The join condition for natural join is basically an equijoin of all columns with same name.Explanation
The correct answer is that the join condition for natural join is basically an equijoin of all columns with the same name. This means that when using a natural join, the join condition is automatically determined based on columns with identical names in the tables being joined. This can simplify the join process as it eliminates the need to specify the join condition explicitly. However, it also means that the join may not be as flexible or customizable as when using other types of joins.Rate this question:
-
- 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
Correct Answer
A. COUNTExplanation
The COUNT function can be used on both numeric as well as non-numeric data. It returns the number of rows in a specified column or expression, regardless of the data type. This makes it a versatile function that can be applied to any type of data, whether it is numeric values or non-numeric values such as strings or dates.Rate this question:
-
- 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.
Correct Answer
D. All are true.Explanation
The given answer is correct because all the statements mentioned about the COUNT function are true. COUNT(*) returns the total number of rows in the table, COUNT(exp) returns the number of non-null values in the column, and COUNT(DISTINCT exp) returns the number of unique, non-null values in the column. Therefore, all the statements are true.Rate this question:
-
- 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.
Correct Answer
B. You cannot insert rows with NULL values to a table.Explanation
The correct answer is "You cannot insert rows with NULL values to a table." This statement is not true because it is possible to insert rows with NULL values into a table. In SQL, NULL represents a missing or unknown value, and it is allowed to be inserted into a table's columns.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Oct 12, 2023Quiz Edited by
ProProfs Editorial Team -
Feb 19, 2008Quiz Created by
2lifetodeath
Back to top