laboursonline – MCQs, Mock Tests | SQL MCQ

What does SQL is used to perform operations on?

1. Update Records
2. Insert Records
3. Both A and B
4. None of the above

✅ Correct Answer: 3

What does SQL stand for?

1. SQL stands for Sample Query Language
2. SQL stands for Structured Query List
3. SQL stands for Structured Query Language
4. SQL stands for Sample Query List

✅ Correct Answer: 3

What does this SQL database language design to?

1. Maintain the data in hierarchal database management systems.
2. Maintain the data in relational database management systems.
3. Maintain the data in network database management systems.
4. Maintain the data in object-oriented database management systems.

✅ Correct Answer: 2

SQL became the standard of?

1. ASCII
2. ANSI
3. ISO
4. Both B and C

✅ Correct Answer: 4

Which statement is not true about SQL?

1. Using SQL in relational databases is all about inserting, updating, and deleting data.
2. Sample data can also be described with the aid of this tool.
3. It helps develop relational database functions, events, and views.
4. A SQL user can also set restrictions and permissions for a table column, a view, and a stored procedure.

✅ Correct Answer: 2

SQL contains which component in its process?

1. Optimization Engines SQL
2. Query Engines
3. Query Dispatchers
4. All of the above

✅ Correct Answer: 4

Determine the correct SQL command?

1. CREATE
2. UPDATE
3. DELETE
4. All the above

✅ Correct Answer: 4

What is the work of CREATE command?

1. Using this command, you can remove or erase recorded information from a database table.
2. It enables you to create new databases, tables, table views, and other objects using this command.
3. 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.
4. 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.

✅ Correct Answer: 2

What is the work of UPDATE command?

1. 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.
2. Using this command, you can remove or erase recorded information from a database table.
3. Database data can be updated or changed using this command.
4. Database data can be updated or changed using this command.

✅ Correct Answer: 3

What is the work of DELETE command?

1. 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.
2. Database data can be updated or changed using this command.
3. Database objects such as tables, table views, and other objects can be deleted using this command.
4. Using this command, you can remove or erase recorded information from a database table.

✅ Correct Answer: 4

What is the work of SELECT command?

1. Database objects such as tables, table views, and other objects can be deleted using this command.
2. Database objects such as tables, table views, and other objects can be deleted using this command.
3. 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.
4. It enables you to create new databases, tables, table views, and other objects using this command.

✅ Correct Answer: 3

What is the work of DROP command?

1. Using this command, you can remove or erase recorded information from a database table.
2. Database objects such as tables, table views, and other objects can be deleted using this command.
3. 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.
4. It enables you to create new databases, tables, table views, and other objects using this command.

✅ Correct Answer: 2

What is the work of INSERT command?

1. 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.
2. 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.
3. It enables you to create new databases, tables, table views, and other objects using this command.
4. Database objects such as tables, table views, and other objects can be deleted using this command.

✅ Correct Answer: 1

Which statement is not true?

1. SQL is rational whereas No-SQL is non-rational.
2. SQL follows BASE Model whereas No-SQL follows ACID Model.
3. SQL database are vertically scalable whereas No-SQL database are horizontally scalable.
4. SQL databases are preferable to store hierarchical data in comparison SQL databases.

✅ Correct Answer: 2

Which statement is true about the SQL?

1. SQL databases are vertically scalable.
2. SQL follows BASE Model.
3. SQL database cannot handle complex queries.
4. SQL database does not require object-relational mapping.

✅ Correct Answer: 1

Which statement is true about the No-SQL?

1. No-SQL follows ACID Model
2. No-SQL does require object-relational mapping.
3. Dynamic schemas for unstructured data are used in No-SQL databases.
4. No-SQL databases are not preferable for storage of hierarchal data.

✅ Correct Answer: 3

SQL has the advantage of?

1. SQL require a lot of programming.
2. SQL provides High-Speed Query Processing.
3. SQL follows the standard languages of ANSI and ISO.
4. SQL is easily portable.

✅ Correct Answer: 1

SQL has the disadvantage of?

1. SQL is cheap. .
2. SQL interface is simple
3. Both A and B
4. None of the above

✅ Correct Answer: 4

What is meant by Partial Database Control?

1. Business rules are hidden.
2. Users or professionals can't have the full control over the database.
3. Both A and B
4. None of the above

✅ Correct Answer: 3

Learning and understanding SQL is easy

1. It can also be used for communicating with the database.
2. In a few seconds, complex queries can also be answered using this language.
3. It can also be used for communicating with the database.
4. All the above

✅ Correct Answer: 4

Syntax of the Structured Query Language is ____?

1. Case-sensitive
2. Not case-sensitive
3. Both of a and b
4. None of the above

✅ Correct Answer: 2

Syntax of the Structured Query Language is ____?

1. Case-sensitive
2. Not case-sensitive
3. Both of a and b
4. None of the above

✅ Correct Answer: 2

Which of the following statement is false?

1. There is no difference between a lower case and upper case keyword in SQL.
2. It is easier to read SQL queries when the keywords are in lowercase.
3. An SQL statement's syntax is determined by its text line.
4. One or more SQL statements can be placed on a single line of text.

✅ Correct Answer: 2

Which of the following statement is true?

1. SQL statements are used for most operations in a database.
2. Relational algebra and tuple relationship calculus are needed for SQL syntax.
3. Both of the above
4. All the above

✅ Correct Answer: 3

Which of the following is not an SQL Statement?

1. SELECT Statement
2. UPDATE Statement
3. TRUNCATE TABLE Statement
4. FROM Statement

✅ Correct Answer: 4

What does the SELECT Statement do?

1. Data is read from the SQL database by this statement and displayed to the database user.
2. The stored data in the SQL database is changed or modified by this SQL statement.
3. By deleting the stored data, this SQL statement deletes the database.
4. A new table in SQL is created using this SQL statement.

✅ Correct Answer: 1

What does the UPDATE Statement do?

1. By deleting the stored data, this SQL statement deletes the database.
2. A new table in SQL is created using this SQL statement.
3. The stored data in the SQL database is changed or modified by this SQL statement.
4. Columns in the SQL database can be created, deleted, or modified with this SQL statement.

✅ Correct Answer: 3

What does the DELETE Statement do?

1. A new table in SQL is created using this SQL statement.
2. By deleting the stored data, this SQL statement deletes the database.
3. Columns in the SQL database can be created, deleted, or modified with this SQL statement.
4. By executing this SQL statement, you remove the table and all the information that it contains, including the structure, views, permissions, and triggers.

✅ Correct Answer: 2

What does the ALTER TABLE Statement do?

1. By deleting the stored data, this SQL statement deletes the database.
2. Columns in the SQL database can be created, deleted, or modified with this SQL statement.
3. A new table in SQL is created using this SQL statement.
4. A new table in SQL is created using this SQL statement.

✅ Correct Answer: 2

What does the DROP TABLE Statement do?

1. The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
2. A new table in SQL is created using this SQL statement.
3. Columns in the SQL database can be created, deleted, or modified with this SQL statement.
4. A new database will be created through this SQL statement.

✅ Correct Answer: 1

What does the CREATE DATABASE Statement do?

1. Columns in the SQL database can be created, deleted, or modified with this SQL statement.
2. The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
3. In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
4. A new database will be created through this SQL statement.

✅ Correct Answer: 4

What does the DROP DATABASE Statement do?

1. The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
2. In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
3. A new database will be created through this SQL statement.
4. 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.

✅ Correct Answer: 2

What does the INSERT INTO Statement do?

1. 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.
2. A new database will be created through this SQL statement.
3. In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
4. By executing this SQL statement, all records in the SQL database will be deleted.

✅ Correct Answer: 1

What does the TRUNCATE TABLE Statement do?

1. In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.
2. 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.
3. By executing this SQL statement, all records in the SQL database will be deleted.
4. The data specified in this table or view is reported in this SQL statement.

✅ Correct Answer: 3

What does the DESCRIBE Statement do?

1. 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.
2. By executing this SQL statement, all records in the SQL database will be deleted.
3. Specify the columns of the table in this SQL statement to return distinct values.
4. The data specified in this table or view is reported in this SQL statement.

✅ Correct Answer: 4

What does the DISTINCT Clause do?

1. Specify the columns of the table in this SQL clause to return distinct values.
2. By executing this SQL statement, all records in the SQL database will be deleted.
3. The data specified in this table or view is reported in this SQL statement.
4. Changes made in the SQL database transaction are permanently saved using this SQL statement.

✅ Correct Answer: 1

What does the COMMIT Statement do?

1. The data specified in this table or view is reported in this SQL statement.
2. Changes made in the SQL database transaction are permanently saved using this SQL statement.
3. Specify the columns of the table in this SQL statement to return distinct values.
4. By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.

✅ Correct Answer: 2

What does the ROLLBACK Statement do?

1. Specify the columns of the table in this SQL statement to return distinct values.
2. Changes made in the SQL database transaction are permanently saved using this SQL statement.
3. By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
4. An index is created in a SQL database table with this SQL statement.

✅ Correct Answer: 3

What does the CREATE INDEX Statement do?

1. An index is created in a SQL database table with this SQL statement.
2. Changes made in the SQL database transaction are permanently saved using this SQL statement.
3. By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
4. The SQL database table's index is deleted using this SQL statement.

✅ Correct Answer: 1

What does the DROP INDEX Statement do?

1. By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
2. The SQL database table's index is deleted using this SQL statement.
3. An index is created in a SQL database table with this SQL statement.
4. 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.

✅ Correct Answer: 2

SQL MCQ Quiz Hub

MCQ | SQL – Basics