[EC-705C] DATABASE MANAGEMENT SYSTEM [2013-14]

Submitted by Anonymous (not verified) on Sun, 12/29/2013 - 11:01

 

CS/B.TECH/(ECE-New)/SEM-7/EC-705C/2013-14

2013

DATABASE MANAGEMENT SYSTEM

Time Allotted : 3 Hours                                    Full Marks : 70

The figures in the margin indicate full marks.

Candidates are required to give their answers in their own words

as far as practicable.

GROUP – A

(Multiple Choice Type Question)

1.       Choose the correct alternatives for the following:          10 x 1 = 10

          i)        Which one is not an aggregate function?

                   a)       Sum                               b)       Count

                   c)       Select                             d)       max.

          ii)       Which of the following is not a DDL statement?

                   a)       SELECT                         b)       ALTER

                   c)       CREATE                         d)       DROP.

          iii)      View is a

                   a)       Virtual relation               b)       Temporary relation

                   c)       Dynamic relation           d)       all of these.

          iv)      In relational model degree of a relation is

                   a)       no. of Attributes

                   b)       no. of Rows

                   c)       no. of Prime Attributes

                   d)       schema.

Comments

Related Items