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.
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 (*)
2) From the following combinations of wildcard characters, choose those that are equivalent.
a) %
b) _%
c)%_
d) _ _
3) In SQL, 10/NULL will evaluate to
a) FALES
b) – 1
c) NULL
d) 10
4) Which of the following must enclosed in double quote?
a) Dates
b) Column Alias
c) Strings
d) All of these
5) Which of the following combinations of wildcard characters has the same meaning as the wildcard character %?
a) %%
b) _%
c) %_
d) _ _
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
7) The WHERE clause – WHERE city LIKE ‘%\ _%b’ cannot display
a) ab
b) abb
c) a_b
d) a _%b
8) 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
9) Almost all the DATE functions return a value of data type DATE, except
a) MONTHS _ BETWEEN
b) ROUND
c) NEXT _ DAY
d) TRUNC
All The Best!!