forum_image

Discussion Forum

Interative Forum for discussing any query literally to UGC-NET Computer Science, GATE Computer Science and Computer Sciene and Technology in general.

ugc_net image

UGC-NET Computer Science

Correspondence Courses and Test Series to prepare for UGC-NET computer science and applications

GATE image

GATE

MCQs, Lecture Notes, Ebooks for GATE preparation

freestuff image
jobs image

Jobs Newsfeed

Timely information of various Recruitments.

NextPrev

MCQs DBMS|UGC-NET|GATE|Computer Science

11.The User Work Area (UWA) is a set of Program variables declared in the host program to communicate the contents of individual records between
A.DBMS & the Host record
B.Host program and Host record
C.Host program and DBMS
D.Host program and Host language
View/Hide Ans
Explanation
12.If a relation with a Schema R is decomposed into two relations R1 and R2 such that (R1 ∪ R2) = R1 then which one of the following is to be satisfied for a lossless joint decomposition (→ indicates functional dependency)
A.(R1 ∩ R2) → R1 or R1 ∩ R2 → R2
B.R1 ∩ R2 → R1
C. R1 ∩ R2 → R2
D.R1 ∩ R2 → R1 and R1 ∩ R2 → R2
View/Hide Ans
Explanation
13.Which level of Abstraction describes how data are stored in the data base ?
A.Physical level
B.View level
C.Abstraction level
D.Logical level
View/Hide Ans
Explanation
14.Third normal form is based on the concept of ______.
A.Closure Dependency
B.Transitive Dependency
C.Normal Dependency
D.Functional Dependency
View/Hide Ans
Explanation
15.Referential integrity is directly related to
A.Relation key
B.Foreign key
C.Primary key
D.Candidate key
View/Hide Ans
Explanation
16.In multiuser database if two users wish to update the same record at the same time, they are prevented from doing so by
A.Jamming
B.Password
C.Documentation
D.Record lock
View/Hide Ans
Explanation
17.B+ tree are preferred to binary tree in Database because
A.Disk capacity are greater than memory capacities
B.Disk access is much slower than memory access
C.Disk data transfer rates are much less than memory data transfer rate
D.Disks are more reliable than Memory
View/Hide Ans
Explanation
18.A Transaction Manager is which of the following ?
A.Maintains a log of transactions
B.Maintains before and after database images
C.Maintains appropriate concurrency control
D.All of the above
View/Hide Ans
Explanation
19.What is Granularity ?
A.The size of database
B.The size of data item
C.The size of record
D.The size of file
View/Hide Ans
Explanation
20.Which level of Abstraction describes what data are stored in the Database ?
A.Physical level
B.View level
C.Abstraction level
D.Logical level
View/Hide Ans
Explanation


Author Does Not claim of any answer these answers are as per expert opinion


Pages: 1 2 3 4 5 6 7 8 9