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

1.Usage of Preemption and Transaction Rollback prevents ______.
A.Unauthorised usage of data file
B.Deadlock situation
C.Data manipulation
D.File preemption
View/Hide Ans
Explanation
2.Views are useful for _____ unwanted information, and for collecting together information from more than one relation into a single view.
A.Hiding
B.Deleting
C.Highlighting
D.All of the above
View/Hide Ans
Explanation
3.The decision tree classifier is a widely used technique for ______.
A.Classification
B.Association
C.Partition
D.Clustering
View/Hide Ans
Explanation
4.Cross_tab displays permit users to view ______ of multidimensional data at a time.
A.1 − dimension
B.2 − dimensions
C.3 − dimensions
D.Multidimensions
View/Hide Ans
Explanation
5.Thoma’s-write rule is ______.
A.Two phase locking protocol
B.Timestamp ordering protocol
C.One phase locking protocol
D.Sliding window protocol
View/Hide Ans
Explanation
6.Value that appears in one relation for a given set of attributes also appears for a certain set of attributes in another relation.
A.Logical Integrity
B.Referential Integrity
C.Domain Integrity
D.Data Integrity
View/Hide Ans
Explanation
7.The SQL expression Select distinct T, branch_name from branch T, branch S where T.assets ‹ S.assets and S.branch_city= “Mumbai” finds the names of
A.All branches that have greater assets than some branch located in Mumbai.
B.All branches that have greater assets than all branches in Mumbai.
C.The branch that has greatest asset in Mumbai.
D.Any branch that has greater assets than any branch in Mumbai.
View/Hide Ans
Explanation
8.Consider the following schemas : Branch_Schema = (branch_name, assets, city) Customer_Schema = (cutstomer_name, street, city) Deposit_Schema = (branch_name, account_number, customer_name, balance) Borrow_Schema = (branch_name, loan_number, customer_name, amount) Which of the following tuple relational calculus finds all customers who have loan amount more than ` 12,000 ?
A.t(customer_name) | t∈borrow[?] t[amount]›12000}
B.{t |t(customer_name) | t∈borrow[?] t[amount]›12000}
C.{t |[?] ∈ borrow (t(customer_name=s(customer_ name))[?] [amount]›12000}
D.{t |[?] ∈ borrow (t(customer_name)[?] s[amount] ›12000}
View/Hide Ans
Explanation
9.Match the following :
(a) Create     (i) The E-R Model
(b) Select     (ii) Relationship Model
(c) Rectangle     (iii) DDL
(d) Record     (iv) DML
Codes :
(a) (b) (c) (d)
A.(iii) (iv) (i) (ii)
B.(iv) (iii) (ii) (i)
C.(iv) (iii) (i) (ii)
D.(iii) (iv) (ii) (i)
View/Hide Ans
Explanation
10.Which of the following is true ?
A.A relation in BCNF is always in 3NF
B.A relation in 3NF is always in BCNF
C.BCNF and 3NF are same
D.A relation in BCNF is not in 3NF
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