Q.1. Arrange the following in increasing order of their size
(1) Data Base < File < Record < Field < Byte < Bit
(2) Bit < Byte < Field < Record < File < Database
(3) Bit > Byte < Field < Record < Field > File > Database
(4) Bit > Byte > Record > Field > File > Database
(5) None of these
Q.2. In the architecture of a database system external level is the ________.
(1) physical level
(2) logical level
(3) conceptual level
(4) view level
(5) Internal level
Q.3. A(n) __________ converts all the source code into machine code, creating an executable file.
(1) linker
(2) compiler
(3) assembler
(4) interpreter
(5) None of these
Q.4. __________ are text files containing OS commands.
(1) Initialization files
(2) Batch files
(3) Executable files
(4) Help files
(5) None of these
Q.5. When the computer has to play a sound, it generates a(n) __________.
(1) request
(2) command
(3) interrupt
(4) sequence
(5) All
Q.6. An entity set that does not have sufficient attributes to form a primary key is a ______.
(1) strong entity set
(2) weak entity set
(3) simple entity set
(4) primary entity set
(5) Foreign entity set
Q.7. In a Hierarchical model records are organized as ________.
(1) Graph
(2) List
(3) Links
(4) Tree
(5) Index
Q.8. In an E-R diagram attributes are represented by _______.
(1) rectangle
(2) square
(3) ellipse
(4) triangle
(5) Diamond
Q.9. In case of entity integrity, the primary key may be ______.
(1) not Null
(2) Null
(3) both Null & not Null
(4) any value
(5) 0
Q.10. The _______ is the physical path over which a message travels.
(1) Protocol
(2) Medium
(3) Signal
(4) All the above
(5) None of these
Answers
Q.1. (2) Bit < Byte < Field < Record < File < Database
Q.2. (4) In the architecture of a database system external level is the view level
Q.3. (2) A compiler converts all the source code into machine code, creating an executable file
Q.4. (2) Batch files are text files containing OS commands
Q.5. (3) When the computer has to play a sound, it generates an interrupt
Q.6. (2) An entity set that does not have sufficient attributes to form a primary key is a weak entity set
Q.7. (4) In a Hierarchical model records are organized as Tree
Q.8. (3) In an E-R diagram attributes are represented by ellipse
Q.9. (1) In case of entity integrity, the primary key may be “not null”
Q.10. (2) The Medium is the physical path over which a message travels
