SQL MCQ Question and Answer

Question - 1

What is returned by INSTR ('FREEONLINETEST', 'S')?

Solutions

Question - 2

Which of the following query is correct for using comparison operators in SQL?

SELECT name,department FROM employee WHERE age>50 and <60;
SELECT name,department FROM employee WHERE age>50 and age<60;
SELECT name,department FROM employee WHERE age>50 and WHERE age<60;
None of these

Solutions

Question - 3

The SQL keyword BETWEEN is used for which query

to limit the columns displayed.
for ranges.
as a wildcard.
None of these above

Solutions

Question - 4

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

INSERT
MODIFY
LOOK-UP
All of the above

Solutions

Question - 5

When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s)

NOT IN only
Wildcard
Both IN and NOT IN
None of the above

Solutions

Question - 6

Which of the following is true about the HAVING clause?

Similar to WHERE clause but is used for groups rather than rows.
Similar to WHERE clause but is used for rows rather than columns.
Similar to the WHERE clause but is used for columns rather than groups.
None of the above

Solutions

Question - 7

The result of a SQL SELECT statement is a ________ .

report
table
blob
file

Solutions

Question - 8

The HAVING clause does which of the following?

Acts like a WHERE clause.
Acts like a WHERE clause but is used for columns rather than groups.
Acts like a WHERE clause but is used for groups rather than rows.
None of the above

Solutions

Question - 9

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

ROLLBACK
TRUNCATE
COMMIT
DELETE

Solutions

Question - 10

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

Outer JOIN
EQUI JOIN
Natural JOIN
LEFT JOIN

Solutions

Question - 11

Which statement is true regarding routines and triggers?

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

Solutions

Question - 12

A sequence in SQL can generate a maximum number

38 digits
42 digits
48 digits
64 digits

Solutions

Question - 13

The SQL WHERE clause

limits the row data are fetched.
limits the column data that are fetched.
Both A and B are correct.
Neither A nor B are correct.

Solutions

Question - 14

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

Equal to
IN
IS
None of the above

Solutions

Question - 15

The wildcard in a WHERE clause is useful when?

An exact match is necessary in a SELECT statement.
An exact match is not possible in a SELECT statement.
An exact match is necessary in a CREATE statement.
An exact match is not possible in a CREATE statement.

Solutions

Question - 16

Which below option is not a type of index?

Unique Index.
Clustered Index
NonClustered Index
FULLTEXT Index

Solutions

Question - 17

Which below option is not a scalar function?

UCASE()
UCASE()
MID()
MIN()

Solutions

Question - 18

Which below option is not a Aggregate function?

AVG()
ROUND()
SUM()
FIRST()

Solutions

Question - 19

OLTP stands for ____?

Online Translating Processing
Optimum Transaction Processing
Online Transaction Processing
None of the above

Solutions

Question - 20

What is the command used to fetch first 5 characters of the string?

Select SUBSTRING(Name,1,5) as name from student
Select SUBSTRING(Name,0,5) as name from student
Select name from student limit 1,5
None of the above

Solutions

Practice more set questions

Tags:

60+ Best SQL Interview Questions, SQL MCQ questions for placement,SQL interview questions, Previously asked SQL Questions, Frequently asked SQL Questions,SQL Questions for TCS, SQL Interview Questions for Freshers, SQL Interview Questions for Experience, Accenture SQL Interview Questions, SQL Objective Questions for Interview,

Practice More sets Questions

Topic wise Database