Database Management System Questions and Answers Part-4

1. In the architecture of a database system external level is the
a) physical level
b) logical level
c) conceptual level
d) view level

Answer: d

2. An entity set that does not have sufficient attributes to form a primary key is a
a) strong entity set
b) weak entity set
c) simple entity set
d) primary entity set

Answer: b

3. In a Hierarchical model records are organized as
a) Graph
b) List
c) Links
d) Tree

Answer: d

4. In an E-R diagram attributes are represented by
a) rectangle
b) square
c) ellipse
d) triangle

Answer: c

5. In case of entity integrity, the primary key may be
a) not Null
b) Null
c) both Null & not Null
d) any value

Answer: a

6. NULL is
a) the same as 0 for integer
b) the same as blank for character
c) the same as 0 for integer and blank for character
d) not a value

Answer: d

7. The language used in application programs to request data from the DBMS is referred to as the
a) DML
b) DDL
c) VDL
d) SDL

Answer: a

8. A logical schema
a) is the entire database.
b) is a standard way of organizing information into accessible parts
c) describes how data is actually stored on disk
d) both (A) and (C)

Answer: a

9. Related fields in a database are grouped to form a
a) data file
b) data record
c) menu
d) bank

Answer: b

10. The database environment has all of the following components except:
a) users
b) separate files
c) database
d) database administrator

Answer: a