NIELIT Technical Assistant Sample Paper on Data Base Management System

Shivaji University Kolhapur M.Sc Semester-I Computer Science Paper March 2019

A primary key for an entity is _____
(a) Candidates key
(b) Any attribute
(c) A unique attribute
(d) A super key

The database schema is written in _____
(a) HLL
(b) DML
(c) DDL
(d) DCL

An operation that will increase the length of a list is _____
(a) Modify
(b) Look-up
(c) Insert
(d) All of the above

Multilevel dependency among attribute is checked at which level _____
(a) 2NF
(b) 5NF
(c) 4NF
(d) 3NF

______ Command can be used to modify a column in a table
(a) Update
(b) Alter
(c) Insert
(d) Create

In an E-R model ____ is described in the database by storing its data
(a) Entity
(b) Attribute
(c) Relationship
(d) None of the above

Which normal form is considered adequate for relational database design ____?
(a) 2 NF
(b) 3 NF
(c) 4 NF
(d) BCNF

Which operator is used to select values within a range _____?
(a) WITHIN
(b) RANGE
(c) BETWEEN
(d) all of these

In case of entity integrity, the primary key may be ____
(a) not null
(b) NULL
(c) Both null and not null
(d) Any value

A relational database developer refers to record as ______
(a) A criteria
(b) A relation
(c) A tuple
(d) A attribute

A subschema expresses _______
(a) The logical view
(b) The physical view
(c) The external view
(d) All of the above

Which of the following is a valid SQL type?
(a) CHARACTER
(b) NUMERIC
(c) FLOAT
(d) All of these

The data model which describes how the data is acutally stored as _____
(a) Internal model
(b) External model
(c) Logical model
(d) None of these

A domain is ____ if elements of the domain are considered to be indivisibile units
(a) Subatomic
(b) Atomic
(c) Sub structure
(d) Subset