This set of SQL Multiple Choice Questions & Answers (MCQs) focuses on “SQL Basics”.
1. Which of the following cannot be done using SQL?
a) Insert records into a Database
b) Retrieve data from a Database
c) Delete records from a Database
d) Update multiple tables of a Database
View Answer
Explanation: We can update only a single table at a time using UPDATE. INSERT INTO is used to insert records, SELECT is used to retrieve data; DELETE is used to delete records.
2. Which of the following terms represents a COLUMN of a Database table?
a) Attribute, Field
b) Field, Record
c) Tuple, Record
d) Tuple, Attribute
View Answer
Explanation: A Database table consists of columns and rows. These columns are known as Attributes and Fields, rows are known as Tuples and Records.
3. Which of the following terms represents a ROW of a Database table?
a) Field, Record
b) Attribute, Field
c) Tuple, Attribute
d) Tuple, Record
View Answer
Explanation: A Database table is divided into several rows and columns. These Rows are known as Tuples and Records, Columns are known as Attributes and Fields.
4. RDBMS stands for _______
a) Relative Database Management System
b) Related Database Management System
c) Relational Database Management System
d) Relative Database Management System
View Answer
Explanation: RDBMS stands for Relational Database Management System. RDBMS is the basis for SQL.
5. Which of the following is basis for SQL?
a) DBMS
b) RDBMS
c) SQL Server
d) Oracle
View Answer
Explanation: RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL and Microsoft Access.
6. The data in RDBMS is stored in ______
a) Database Object
b) SQL Object
c) SQL Server
d) Database server
View Answer
Explanation: The data in RDBMS is stored in database objects called tables, which is a collection of related data entries.
7. Which of the following is not true about tables?
a) It is a Database Object
b) It is a collection of irrelevant data entries
c) It consists of Fields known as Columns
d) It consists of Records known as Rows
View Answer
Explanation: A table is a collection of related data entries and it consists of columns and rows.
8. Where the specific information about every record of a table is stored?
a) Field
b) Record
c) Row
d) Database Object
View Answer
Explanation: A field is a column in a table that is designed to maintain information about every record in the table. A record which is also called as a row contains each individual entry that exists in a table.
9. What is a Record?
a) A record is a Vertical entity
b) A record is each individual entry that exists in a table
c) A record is an entity that contains all information associated with the fields of a table
d) A record is a column
View Answer
Explanation: A record is a horizontal entity of a table. A column is a vertical entity in a table which contains information associated with all fields of a table.
10. SQL is a Programming Language.
a) True
b) False
View Answer
Explanation: SQL is not a Programming Language. It is a Querying language, which lets users to access and manipulate databases.
Sanfoundry Global Education & Learning Series – SQL.
To practice all areas of SQL, here is complete set of 1000+ Multiple Choice Questions and Answers.
If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]
