database mcq DB-MCQS 4

Multiple Choice Questions

Set 4

1:    SQL is a …    

a. Non-Procedural Language

b- Procedural Language

Answer - Click Here:

2:     Oracle Corporation started in

a. 1950

b-1970

c-1990

d-1980

Answer - Click Here:

3:     SQL is the …… and, so far, only standard database language to gain wide acceptance.

a fourth   b-second     c-third       d- first

Answer - Click Here:

4:       SQL is used in other standards and even influences the development of other standards as a ……. tool.

a. addition

b- definitional

c-deletion

d- explanation

Answer - Click Here:

5:         SQL allows the table produced as the result of the ……..statement to contain duplicate rows

a-DELETE

b-ADD

c- SELECT

Answer - Click Here:

6:        An SQL statement consists of ……

a- functions 

b- reserved words

c-counting

d- alphabats

7:          The use of parentheses is always recommended in order to….  any possible ambiguities.

a-  increase

b- Overcome

c- compare

Answer - Click Here:

8:           COUNT – returns the ……. in a specified column

a- Product

b-sum

c- number of values

d- average

Answer - Click Here:

9:           SUM – returns the …… of the values in a specified column

a- sum

b-number

c-average

d-smallest

Answer - Click Here:

10:          AVG – returns the …….. of the values in a specified column

a- smallest

b- average

c-sum

d- number

Answer - Click Here:

 

 

 

 

 

 

Fazal Rehman Shamil
Welcome to all friends. The reason for our success is only your love for T4Tutorials. Our team is always available to answer your queries regarding any kind of confusions or discussion regarding your study and career matters. For discussion with us please join our facebook group "T4Tutorials.com". The link of the group is mentioned below. Thanks and love to all for connecting with us. We are nothing without you. Love you all.....
https://web.facebook.com/groups/2066136233601097/