Question
1
Which of the following IRs is not
part of Armstrong's Inference
rules.
Select one:
Augmentation
Union
Transitive
Reflexive
Feedback
The
correct answer is: Union
Question
2
Which of the following is true in
case of Unordered file organization (to store data records) in DBMS
storage.
Select one:
It
always requires unspanned record organization.
Always
requires Indexing to retrieve a record with given key value.
Searching
for a record with given key value always takes constant time.
Insertion
of a record with given key value is always much easier than searching for
a record.
Feedback
The correct answer is: Insertion of
a record with given key value is always much easier than searching for a
record.
Question
3
In a disk-pack with uniform
structure across surfaces and tracks, the number of cylinders is same as____.
Select one:
Number
of Disks in the pack.
Number
of surfaces that actually store data.
Number
of blocks per surface.
Number
of sectors per track.
Number
of tracks per surface.
Feedback
The correct answer is: Number of
tracks per surface.
Question
4
In Extendible hashing technique, the
number of initial buckets allocated to the file to store data depends
on____.
Select one:
Initial
Local Depth
Blocking
Factor (Bfr)
Initial
Global Depth
Mod
function used
Feedback
The correct answer is: Initial Local
Depth
Question
5
The highest Normal Form satisfied by
the relation R(A,B,C,D,E) with FDs
{ AC--> B; B-->C; AC-->E }
is__ .
Select one or more:
2NF
BCNF
3NF
1NF
Feedback
The correct answer is: 1NF
Question
6
The highest Normal Form satisfied by
the relation R(A,B,C,D,E) with FDs {AB--> CD; AB-->E; B-->E }
is__
Select one:
3NF
BCNF
2NF
1NF
Feedback
The correct answer is: 1NF
Question
7
If a Diskpack contains 4
double-sided disks with uniform structure, and having 128 tracks per surface,
256 blocks per track and with 512 bytes of block size, then the cylinder
capacity in KB is_. (assume 1 KB=1024 Bytes)
Select one:
512KB
256KB
128KB
1024KB
4KB
Feedback
The correct answer is: 1024KB
Question
8
If we have Functional dependencies
(FDs): A-->{BC} , B-->{DE}, then according to inference
rules, A-->E is a valid FD.
Select one:
True
False
Feedback
The correct answer is 'True'.
No comments:
Post a Comment