SQL Questions Programming MCQ Answers Download PDF Set

SQL Programming MCQ Questions Answers Download PDF Set

Candidates who want to study SQL can study on our website as we provide all kinds of material here.

SQL questions, SQL questions mcq, sql mcq questions and answers, sql mcq questions with answers, sql multiple choice questions with answers, sql objective questions with answers, sql mcq questions, sql interview questions

Are you preparing for Competitive Exam for Computer Engineering? But you have to read SQL questions well.But now most of the exams have answers to SQL questions mcq, you must practice SQL mcq. Some of the examinees requested us that we know that sql mcq questions and answers.We sql objective questions with answers as per the test takers.Not just for the written test we provide sql interview questions here.

1) Which of the following group function ignore NULL values?

a)MAX

b) COUNT

c) SUM

d) COUNT (*)

View Answer
Option –a,b, c)

2) From the following combinations of wildcard characters, choose those that are equivalent.

a) %

b) _%

c)%_

d) _ _

View Answer
Option –b, c)

3) In SQL, 10/NULL will evaluate to

a) FALES

b)  – 1

c) NULL

d) 10

View Answer
Option – c)

4) Which of the following must enclosed in double quote?

a) Dates

b) Column Alias

c) Strings

d) All of these

View Answer
Option – b)

5) Which of the following combinations of wildcard characters has the same meaning as the wildcard character %?

a) %%

b) _%

c) %_

d) _ _

View Answer
Option – a)

6) Which of the following SQL commands can be used to add data to a database table?

a) ADD

b) UPDATE

c) APPEND

d) INSERT

View Answer
Option – d)

8) The WHERE clause – WHERE city LIKE ‘%\ _%b’ cannot display

a) ab

b) abb

c) a_b

d) a _%b

View Answer
Option – a,b)

9) Which of the following SQL commands can be used to modify existing data in a database table?

a) MODIFY

b) UPDATE

c) CHANGE

d) NEW

View Answer
Option – b)

10) Almost all the DATE functions return a value of data type DATE, except

a) MONTHS _ BETWEEN

b) ROUND

c) NEXT _ DAY

d) TRUNC

View Answer
Option – a)

error: Content is protected !!