JobSandhan.com

Latest Govt Job Notification Sarkari Naukri Employment News 2018

SQL Questions Programming MCQ Answers Download PDF Set

SQL Programming MCQ Questions Answers Download PDF Set

SQL Programming Language MCQ Questions Answers Download PDF Set

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

a)MAX

b) COUNT

c) SUM

d) COUNT (*)

View Answer

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

a) %

b) _%

c)%_

d) _ _

View Answer

3) In SQL, 10/NULL will evaluate to

a) FALES

b)  – 1

c) NULL

d) 10

View Answer

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

a) Dates

b) Column Alias

c) Strings

d) All of these

View Answer

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

a) %%

b) _%

c) %_

d) _ _

View Answer

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

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

a) ab

b) abb

c) a_b

d) a _%b

View Answer

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

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

[fbcomments]
JobSandhan.com © 2018        Home     About Us     Sitemap     Disclaimer     Privacy Policy     Contact us