laboursonline – MCQs, Mock Tests

What is the full form of SQL?

1. Structured Query List
2. Structure Query Language
3. Sample Query Language
4. None of these.

✅ Correct Answer: 2

Which of the following is not a valid SQL type?

1. FLOAT
2. NUMERIC
3. DECIMAL
4. CHARACTER

✅ Correct Answer: 3

Which of the following is not a DDL command?

1. TRUNCATE
2. ALTER
3. CREATE
4. UPDATE

✅ Correct Answer: 4

Which of the following are TCL commands?

1. COMMIT and ROLLBACK
2. UPDATE and TRUNCATE
3. SELECT and INSERT
4. GRANT and REVOKE

✅ Correct Answer: 1

Which statement is used to delete all rows in a table without having the action logged?

1. DELETE
2. REMOVE
3. DROP
4. TRUNCATE

✅ Correct Answer: 4

SQL Views are also known as

1. Simple tables
2. Virtual tables
3. Complex tables
4. Actual Tables

✅ Correct Answer: 2

How many Primary keys can have in a table?

1. Only 1
2. Only 2
3. Depends on no of Columns
4. Depends on DBA

✅ Correct Answer: 1

Which datatype can store unstructured data in a column?

1. CHAR
2. RAW
3. NUMERIC
4. VARCHAR

✅ Correct Answer: 2

Which of the following is not Constraint in SQL?

1. Primary Key
2. Not Null
3. Check
4. Union

✅ Correct Answer: 4

Which of the following is not a valid aggregate function?

1. COUNT
2. COMPUTE
3. SUM
4. MAX

✅ Correct Answer: 2

Which data manipulation command is used to combines the records from one or more tables?

1. SELECT
2. PROJECT
3. JOIN
4. PRODUCT

✅ Correct Answer: 3

Which operator is used to compare a value to a specified list of values?

1. ANY
2. BETWEEN
3. ALL
4. IN

✅ Correct Answer: 4

What operator tests column for absence of data

1. NOT Operator
2. Exists Operator
3. IS NULL Operator
4. None of the above

✅ Correct Answer: 3

In which of the following cases a DML statement is not executed?

1. When existing rows are modified.
2. When a table is deleted.
3. When some rows are deleted.
4. All of the above

✅ Correct Answer: 2

If we have not specified ASC or DESC after a SQL ORDER BY clause, the following is used by default

1. DESC
2. ASC
3. There is no default value
4. None of the mentioned

✅ Correct Answer: 2

A command that lets you change one or more field in a table is:

1. INSERT
2. MODIFY
3. LOOK-UP
4. All of the above

✅ Correct Answer: 2

Which of the following is also called an INNER JOIN?

1. SELF JOIN
2. EQUI JOIN
3. NON-EQUI JOIN
4. None of the above

✅ Correct Answer: 2

Which of the following is true about the HAVING clause?

1. Similar to the WHERE clause but is used for columns rather than groups.
2. Similar to WHERE clause but is used for rows rather than columns.
3. Similar to WHERE clause but is used for groups rather than rows.
4. Acts exactly like a WHERE clause.

✅ Correct Answer: 3

______ clause creates temporary relation for the query on which it is defined.

1. WITH
2. FROM
3. WHERE
4. SELECT

✅ Correct Answer: 1

The SQL statement: SELECT ROUND (65.726, -1) FROM DUAL; Prints:

1. is illegal
2. garbage
3. 726
4. 70

✅ Correct Answer: 4

Which of the following is true about the SQL AS clause?

1. The AS clause in SQL is used to change the column name in the output or assign a name to a derived column.
2. The SQL AS clause can only be used with the JOIN clause.
3. The AS clause in SQL is used to defines a search condition.
4. All of the mentioned

✅ Correct Answer: 1

____ command makes the updates performed by the transaction permanent in the database?

1. ROLLBACK
2. COMMIT
3. TRUNCATE
4. DELETE

✅ Correct Answer: 2

Which command is used to change the definition of a table in SQL?

1. CREATE
2. UPDATE
3. ALTER
4. SELECT

✅ Correct Answer: 3

Which type of JOIN is used to returns rows that do not have matching values?

1. Natural JOIN
2. Outer JOIN
3. EQUI JOIN
4. All of the above

✅ Correct Answer: 2

A CASE SQL statement is ________?

1. A way to establish a loop in SQL.
2. A way to establish an IF-THEN-ELSE in SQL
3. A way to establish a data definition in SQL
4. All of the above.

✅ Correct Answer: 3

Which statement is true regarding routines and triggers?

1. Both run automatically.
2. Both are stored in the database.
3. Both consist of procedural code.
4. Both have to be called to operate.

✅ Correct Answer: 3

Which statement is true regarding procedures?

1. They include procedural and SQL statements.
2. They work similarly to the functions.
3. It does not need unique names.
4. It cannot be created with SQL statements.

✅ Correct Answer: 1

Which of the following is the basic approaches for joining tables?

1. Union JOIN
2. Natural JOIN
3. Subqueries
4. All of the above

✅ Correct Answer: 4

Why we need to create an index if the primary key is already present in a table?

1. Index improves the speed of data retrieval operations on a table.
2. Indexes are special lookup tables that will be used by the database search engine.
3. Indexes are synonyms of a column in a table.
4. All of the above

✅ Correct Answer: 1

Group of operations that form a single logical unit of work is known as

1. View
2. Network
3. Unit
4. Transaction

✅ Correct Answer: 4

Shared locks are applied while performing

1. Read operations
2. Write operations
3. A & B both
4. None of the above

✅ Correct Answer: 1

Sequence can generate

1. Numeric value
2. Alphanumeric value
3. A & B both
4. None of the above

✅ Correct Answer: 3

A sequence in SQL can generate a maximum number:

1. 39 digits
2. 38 digits
3. 40 digits
4. 37 digits

✅ Correct Answer: 2

Which of the following is the correct order of a SQL statement?

1. SELECT, GROUP BY, WHERE, HAVING
2. SELECT, WHERE, GROUP BY, HAVING
3. SELECT, HAVING, WHERE, GROUP BY
4. SELECT, WHERE, HAVING, GROUP BY

✅ Correct Answer: 2

What is the difference between a PRIMARY KEY and a UNIQUE KEY?

1. Primary key can store null value, whereas a unique key cannot store null value.
2. We can have only one primary key in a table while we can have multiple unique keys
3. Primary key cannot be a date variable whereas unique key can be
4. None of these

✅ Correct Answer: 3

Which operator is used to compare the NULL values in SQL?

1. Equal
2. IN
3. IS
4. None of Above

✅ Correct Answer: 3

When the wildcard in a WHERE clause is useful?

1. When an exact match is required in a SELECT statement.
2. When an exact match is not possible in a SELECT statement.
3. When an exact match is required in a CREATE statement.
4. When an exact match is not possible in a CREATE statement.

✅ Correct Answer: 2

_____ is NOT a type of constraint in SQL language?

1. FOREIGN KEY
2. PRIMARY KEY
3. UNIQUE
4. ALTERNATE KEY

✅ Correct Answer: 4

______ is a program that performs some common action on database data and also stored in the database.

1. Stored Procedure
2. Trigger
3. Stored Function
4. None of the above

✅ Correct Answer: 1

What is the advantage of the clustered index?

1. It is fast to update the records.
2. It does not need extra work for SQL queries.
3. It minimizes the page transfer and maximizes the cache hits.
4. None of the above is correct.

✅ Correct Answer: 3

Which of the following are the DATETIME data types that can be used in column definitions?

1. TIMESTAMP
2. INTERVAL MONTH TO DAY
3. INTERVAL YEAR TO MONTH
4. TIMESTAMP WITH DATABASE TIMEZONE

✅ Correct Answer: 3

Which data dictionary table can be used to show the object privileges granted to the user on specific columns?

1. USER_TAB_PRIVS_MADE
2. USER_COL_PRIVS_MADE
3. USER_TAB_PRIVS
4. USER_COL_PRIVS

✅ Correct Answer: 4

What is the need for our query to execute successfully on an existing view?

1. The specified table must contain data.
2. We must have a SELECT privilege on the view.
3. We should have a SELECT privilege only on the specified table.
4. The specified table must be in the same database or schema.

✅ Correct Answer: 2

Which of the following operator can be used with a multiple-row subquery?

1. =
2. BETWEEN
3. NOT IN
4. <>

✅ Correct Answer: 3

SQL MCQ Quiz Hub

SQL MCQ SET 18