1. In the architecture of a database system external level is the
a) physical level
b) logical level
c) conceptual level
d) view level
Discussion
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
Discussion
3. In a Hierarchical model records are organized as
a) Graph
b) List
c) Links
d) Tree
Discussion
4. In an E-R diagram attributes are represented by
a) rectangle
b) square
c) ellipse
d) triangle
Discussion
5. In case of entity integrity, the primary key may be
a) not Null
b) Null
c) both Null & not Null
d) any value
Discussion
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
Discussion
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
Discussion
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)
Discussion
9. Related fields in a database are grouped to form a
a) data file
b) data record
c) menu
d) bank
Discussion
10. The database environment has all of the following components except:
a) users
b) separate files
c) database
d) database administrator
Discussion