Structured Query Language (SQL) Practice Test

12th Standard Computer Science — Structured Query Language (SQL): Online Practice Test

Pick how many questions you want and set a time limit, then start. You'll get your score at the end with the correct answer and an explanation for every question. Free, in Tamil and English — 20 questions available.

Set up your test

Number of questions

Time limit

Time remaining00:00

Which SQL commands provide definitions for creating table structures, deleting relations, and modifying relation schemas?

A.DDL B.DML C.DCL D.DQL

Which command lets you change the structure of a table?

A.SELECT B.ORDER BY C.MODIFY D.ALTER

Which of the following commands deletes a table along with its structure?

A.DROP B.DELETE C.DELETE ALL D.ALTER TABLE

Queries can be generated using which of the following commands?

A.SELECT B.ORDER BY C.MODIFY D.ALTER

Which clause is used to sort data in a database?

A.SORT BY B.ORDER BY C.GROUP BY D.SELECT

What was the original name of the Structured Query Language (SQL) when it was developed at IBM's Research centre in the early 1970s?

A.SEQUEL B.SCRIPT C.ACCESS D.SYSTEM

According to the textbook, in which year was the latest SQL standard mentioned released?

A.1986 B.1992 C.2008 D.2012

Relational Database Management Systems (RDBMS) include functions related to Create, Read, Update, and Delete operations. What is the collective abbreviation used for these operations?

A.CRUD B.DDL C.TCL D.DML

Which processing skill of SQL includes commands that allow users to define views of tables?

A.Data Definition Language (DDL) B.Data Manipulation Language (DML) C.View Definition D.Authorization

Q10

Which of the following is a function performed by the Data Definition Language (DDL) in SQL?

A.To insert new data into the database B.To specify the proper data type and define the size of a data item C.To permanently save a database transaction D.To retrieve information stored in a database

Q11

What type of DML requires a user to specify what data is needed without specifying how to get it?

A.Procedural DML B.Non-Procedural DML C.Transaction DML D.Structural DML

Q12

Which of the following SQL commands is classified under the Data Control Language (DCL)?

A.ALTER B.COMMIT C.GRANT D.TRUNCATE

Q13

Which command is used to restore the database to the last committed state or jump to a particular savepoint?

A.COMMIT B.ROLLBACK C.SAVEPOINT D.REVOKE

Q14

In SQL data types, which type represents a double-precision floating point number where the base 10 exponential precision exceeds 64?

A.float B.real C.dec D.double

Q15

When two or more constraints, such as NOT NULL and UNIQUE, are applied to a single field in a table, what is this known as?

A.Primary constraints B.Composite constraints C.Multiple constraints D.Schema constraints

Q16

According to the textbook, the UNIQUE constraint can be applied only to fields that have also been declared as which of the following?

A.DEFAULT B.NOT NULL C.PRIMARY KEY D.CHECK

Q17

In a CREATE TABLE statement, where is a table constraint (which applies to a group of fields) normally specified?

A.Immediately after the CREATE TABLE keyword B.At the end of the table definition C.Inside the database configuration block D.Before any column names are declared

Q18

In the textbook's example showing the DEFAULT constraint on the Student table, what default age is assigned to the 'Age' field?

A.15 B.17 C.18 D.19

Q19

When the DISTINCT keyword is used in a SELECT query, how many NULL values are returned even if more than one NULL value exists in that column?

A.None B.Only one C.All of them D.An error is thrown

Q20

What is the default sorting order of the ORDER BY clause in an SQL statement?

A.Descending order B.Ascending order C.Chronological order D.Unsorted original order

More for this chapter

About this Structured Query Language (SQL) test

This free online practice test covers Structured Query Language (SQL) from the 12th Standard Computer Science (Samacheer Kalvi) syllabus. Choose the number of questions and an optional time limit, then answer and submit — everything is checked in your browser, with the correct answers and a worked explanation shown at the end. For the full solutions to every question in this set, see the solved MCQs page.

More chapters in Computer Science

View all