aInfoEra
Home
MCQs
SQL — Learn
MCQ | SQL – Basics
Review each question and reveal answers to strengthen your understanding
Home
/
MCQs
/
MCQ | SQL – Basics
1
What does SQL is used to perform operations on?
A
Update Records
B
Insert Records
C
Both A and B
D
None of the above
Show Answer
✅ Correct Answer: 3
2
What does SQL stand for?
A
SQL stands for Sample Query Language
B
SQL stands for Structured Query List
C
SQL stands for Structured Query Language
D
SQL stands for Sample Query List
Show Answer
✅ Correct Answer: 3
3
What does this SQL database language design to?
A
Maintain the data in hierarchal database management systems.
B
Maintain the data in relational database management systems.
C
Maintain the data in network database management systems.
D
Maintain the data in object-oriented database management systems.
Show Answer
✅ Correct Answer: 2
4
SQL became the standard of?
A
ASCII
B
ANSI
C
ISO
D
Both B and C
Show Answer
✅ Correct Answer: 4
5
Which statement is not true about SQL?
A
Using SQL in relational databases is all about inserting, updating, and deleting data.
B
Sample data can also be described with the aid of this tool.
C
It helps develop relational database functions, events, and views.
D
A SQL user can also set restrictions and permissions for a table column, a view, and a stored procedure.
Show Answer
✅ Correct Answer: 2
6
SQL contains which component in its process?
A
Optimization Engines SQL
B
Query Engines
C
Query Dispatchers
D
All of the above
Show Answer
✅ Correct Answer: 4
7
Determine the correct SQL command?
A
CREATE
B
UPDATE
C
DELETE
D
All the above
Show Answer
✅ Correct Answer: 4
8
What is the work of CREATE command?
A
Using this command, you can remove or erase recorded information from a database table.
B
It enables you to create new databases, tables, table views, and other objects using this command.
C
Inserting records or data into the database tables is accomplished with this command. In addition to inserting records in single rows, we can insert records in multiple rows as well.
D
A single or multiple rows can be accessed using this command from one or more tables of a database. Using the WHERE clause with this command is also possible.
Show Answer
✅ Correct Answer: 2
9
What is the work of UPDATE command?
A
A single or multiple rows can be accessed using this command from one or more tables of a database. Using the WHERE clause with this command is also possible.
B
Using this command, you can remove or erase recorded information from a database table.
C
Database data can be updated or changed using this command.
D
Database data can be updated or changed using this command.
Show Answer
✅ Correct Answer: 3
10
What is the work of DELETE command?
A
A single or multiple rows can be accessed using this command from one or more tables of a database. Using the WHERE clause with this command is also possible.
B
Database data can be updated or changed using this command.
C
Database objects such as tables, table views, and other objects can be deleted using this command.
D
Using this command, you can remove or erase recorded information from a database table.
Show Answer
✅ Correct Answer: 4
11
What is the work of SELECT command?
A
Database objects such as tables, table views, and other objects can be deleted using this command.
B
Database objects such as tables, table views, and other objects can be deleted using this command.
C
One or more rows from one or more tables of the database can be accessed with this command. Using the WHERE clause with this command is also possible.
D
It enables you to create new databases, tables, table views, and other objects using this command.
Show Answer
✅ Correct Answer: 3
12
What is the work of DROP command?
A
Using this command, you can remove or erase recorded information from a database table.
B
Database objects such as tables, table views, and other objects can be deleted using this command.
C
One or more rows from one or more tables of the database can be accessed with this command. Using the WHERE clause with this command is also possible.
D
It enables you to create new databases, tables, table views, and other objects using this command.
Show Answer
✅ Correct Answer: 2
13
What is the work of INSERT command?
A
Inserting records or data into the database tables is accomplished with this command. In addition to inserting records in single rows, we can insert records in multiple rows as well.
B
One or more rows from one or more tables of the database can be accessed with this command. Using the WHERE clause with this command is also possible.
C
It enables you to create new databases, tables, table views, and other objects using this command.
D
Database objects such as tables, table views, and other objects can be deleted using this command.
Show Answer
✅ Correct Answer: 1
14
Which statement is not true?
A
SQL is rational whereas No-SQL is non-rational.
B
SQL follows BASE Model whereas No-SQL follows ACID Model.
C
SQL database are vertically scalable whereas No-SQL database are horizontally scalable.
D
SQL databases are preferable to store hierarchical data in comparison SQL databases.
Show Answer
✅ Correct Answer: 2
15
Which statement is true about the SQL?
A
SQL databases are vertically scalable.
B
SQL follows BASE Model.
C
SQL database cannot handle complex queries.
D
SQL database does not require object-relational mapping.
Show Answer
✅ Correct Answer: 1
16
Which statement is true about the No-SQL?
A
No-SQL follows ACID Model
B
No-SQL does require object-relational mapping.
C
Dynamic schemas for unstructured data are used in No-SQL databases.
D
No-SQL databases are not preferable for storage of hierarchal data.
Show Answer
✅ Correct Answer: 3
17
SQL has the advantage of?
A
SQL require a lot of programming.
B
SQL provides High-Speed Query Processing.
C
SQL follows the standard languages of ANSI and ISO.
D
SQL is easily portable.
Show Answer
✅ Correct Answer: 1
18
SQL has the disadvantage of?
A
SQL is cheap. .
B
SQL interface is simple
C
Both A and B
D
None of the above
Show Answer
✅ Correct Answer: 4
19
What is meant by Partial Database Control?
A
Business rules are hidden.
B
Users or professionals can't have the full control over the database.
C
Both A and B
D
None of the above
Show Answer
✅ Correct Answer: 3
20
Learning and understanding SQL is easy
A
It can also be used for communicating with the database.
B
In a few seconds, complex queries can also be answered using this language.
C
It can also be used for communicating with the database.
D
All the above
Show Answer
✅ Correct Answer: 4
21
Syntax of the Structured Query Language is ____?
A
Case-sensitive
B
Not case-sensitive
C
Both of a and b
D
None of the above
Show Answer
✅ Correct Answer: 2
22
Syntax of the Structured Query Language is ____?
A
Case-sensitive
B
Not case-sensitive
C
Both of a and b
D
None of the above
Show Answer
✅ Correct Answer: 2
23
Which of the following statement is false?
A
There is no difference between a lower case and upper case keyword in SQL.
B
It is easier to read SQL queries when the keywords are in lowercase.
C
An SQL statement's syntax is determined by its text line.
D
One or more SQL statements can be placed on a single line of text.
Show Answer
✅ Correct Answer: 2
24
Which of the following statement is true?
A
SQL statements are used for most operations in a database.
B
Relational algebra and tuple relationship calculus are needed for SQL syntax.
C
Both of the above
D
All the above
Show Answer
✅ Correct Answer: 3
25
Which of the following is not an SQL Statement?
A
SELECT Statement
B
UPDATE Statement
C
TRUNCATE TABLE Statement
D
FROM Statement
Show Answer
✅ Correct Answer: 4
26
What does the SELECT Statement do?
A
Data is read from the SQL database by this statement and displayed to the database user.
B
The stored data in the SQL database is changed or modified by this SQL statement.
C
By deleting the stored data, this SQL statement deletes the database.
D
A new table in SQL is created using this SQL statement.
Show Answer
✅ Correct Answer: 1
27
What does the UPDATE Statement do?
A
By deleting the stored data, this SQL statement deletes the database.
B
A new table in SQL is created using this SQL statement.
C
The stored data in the SQL database is changed or modified by this SQL statement.
D
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
Show Answer
✅ Correct Answer: 3
28
What does the DELETE Statement do?
A
A new table in SQL is created using this SQL statement.
B
By deleting the stored data, this SQL statement deletes the database.
C
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
D
By executing this SQL statement, you remove the table and all the information that it contains, including the structure, views, permissions, and triggers.
Show Answer
✅ Correct Answer: 2
29
What does the ALTER TABLE Statement do?
A
By deleting the stored data, this SQL statement deletes the database.
B
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
C
A new table in SQL is created using this SQL statement.
D
A new table in SQL is created using this SQL statement.
Show Answer
✅ Correct Answer: 2
30
What does the DROP TABLE Statement do?
A
The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
B
A new table in SQL is created using this SQL statement.
C
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
D
A new database will be created through this SQL statement.
Show Answer
✅ Correct Answer: 1
31
What does the CREATE DATABASE Statement do?
A
Columns in the SQL database can be created, deleted, or modified with this SQL statement.
B
The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
C
In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
D
A new database will be created through this SQL statement.
Show Answer
✅ Correct Answer: 4
32
What does the DROP DATABASE Statement do?
A
The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
B
In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
C
A new database will be created through this SQL statement.
D
In this SQL statement, the data or records are inserted into an existing database table. One query statement can insert multiple records simultaneously using this statement.
Show Answer
✅ Correct Answer: 2
33
What does the INSERT INTO Statement do?
A
In this SQL statement, the data or records are inserted into an existing database table. One query statement can insert multiple records simultaneously using this statement.
B
A new database will be created through this SQL statement.
C
In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
D
By executing this SQL statement, all records in the SQL database will be deleted.
Show Answer
✅ Correct Answer: 1
34
What does the TRUNCATE TABLE Statement do?
A
In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
B
In this SQL statement, the data or records are inserted into an existing database table. One query statement can insert multiple records simultaneously using this statement.
C
By executing this SQL statement, all records in the SQL database will be deleted.
D
The data specified in this table or view is reported in this SQL statement.
Show Answer
✅ Correct Answer: 3
35
What does the DESCRIBE Statement do?
A
In this SQL statement, the data or records are inserted into an existing database table. One query statement can insert multiple records simultaneously using this statement.
B
By executing this SQL statement, all records in the SQL database will be deleted.
C
Specify the columns of the table in this SQL statement to return distinct values.
D
The data specified in this table or view is reported in this SQL statement.
Show Answer
✅ Correct Answer: 4
36
What does the DISTINCT Clause do?
A
Specify the columns of the table in this SQL clause to return distinct values.
B
By executing this SQL statement, all records in the SQL database will be deleted.
C
The data specified in this table or view is reported in this SQL statement.
D
Changes made in the SQL database transaction are permanently saved using this SQL statement.
Show Answer
✅ Correct Answer: 1
37
What does the COMMIT Statement do?
A
The data specified in this table or view is reported in this SQL statement.
B
Changes made in the SQL database transaction are permanently saved using this SQL statement.
C
Specify the columns of the table in this SQL statement to return distinct values.
D
By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
Show Answer
✅ Correct Answer: 2
38
What does the ROLLBACK Statement do?
A
Specify the columns of the table in this SQL statement to return distinct values.
B
Changes made in the SQL database transaction are permanently saved using this SQL statement.
C
By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
D
An index is created in a SQL database table with this SQL statement.
Show Answer
✅ Correct Answer: 3
39
What does the CREATE INDEX Statement do?
A
An index is created in a SQL database table with this SQL statement.
B
Changes made in the SQL database transaction are permanently saved using this SQL statement.
C
By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
D
The SQL database table's index is deleted using this SQL statement.
Show Answer
✅ Correct Answer: 1
40
What does the DROP INDEX Statement do?
A
By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
B
The SQL database table's index is deleted using this SQL statement.
C
An index is created in a SQL database table with this SQL statement.
D
An existing SQL database is selected with this SQL statement. A database must be selected from several existing databases before you can perform operations on the table.
Show Answer
✅ Correct Answer: 2
Back to All Quizzes