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

21.The problem that occurs when one transaction updates a database item and then the transaction fails for some reason is ________.
A.Temporary Select Problem
B.Temporary Modify Problem
C.Dirty Read Problem
D.None
View/Hide Ans
Explanation
22.Consider a schema R(A, B, C, D) and functional dependencies A → B and C → D. Then the decomposition R1(A, B) and R2(C, D) is
A.Dependency preserving but not lossless join
B.Dependency preserving and lossless join
C.Lossless Join but not dependency preserving
D.Lossless Join
View/Hide Ans
Explanation
23.If D1,D2, ....Dn are domains in a relational model, then the relation is a table, which is a subset of
A.D1+D2+... +Dn
B.D1ΧD2Χ ... ΧDn
C.D1∪D2∪... ∪Dn
D.D1−D2−...−Dn
View/Hide Ans
Explanation
24.Which of the following is not a type of Database Management System ?
A.Hierarchical
B.Network
C.Relational
D.Sequential
View/Hide Ans
Explanation
25.Manager&rsquos salary details are to be hidden from Employee Table. This Technique is called as
A.Conceptual level Datahiding
B.Physical level Datahiding
C.External level Datahiding
D.Logical level Datahiding
View/Hide Ans
Explanation
26.A Network Schema
A.restricts to one to many relationship
B.permits many to many relationship
C.stores Data in a Database
D.stores Data in a Relation
View/Hide Ans
Explanation
27.The relation “divides” on a set of positive integers is ________.
A.Symmetric and transitive
B.Anti symmetric and transitive
C.Symmetric only
D.Transitive only
View/Hide Ans
Explanation
28.The “PROJECT” operator of a relational algebra creates a new table that has always
A.More columns than columns in original table
B.More rows than original table
C.Same number of rows as the original table
D.Same number of columns as the original table
View/Hide Ans
Explanation
29.The employee information of an Organization is stored in the relation : Employee (name, sex, salary, deptname) Consider the following SQL query Select deptname from Employee Where sex = ‘M’ group by deptname having avg (salary) > {select avg (salary) from Employee} Output of the given query corresponds to
A.Average salary of employee more than average salary of the organization.
B.Average salary less than average salary of the organization.
C.Average salary of employee equal to average salary of the organization
D.Average salary of male employees in a department is more than average salary of the organization
View/Hide Ans
Explanation
30.For a database relation R(a, b, c, d) where the domains of a, b, c, d include only the atomic values. The functional dependency a → c, b → d holds in the following relation
A.In 1NF not in 2NF
B.In 2NF not in 3NF
C.In 3NF
D.In 1NF
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