Test Preparation on UGC-NET, GATE, DBMS & Computer Science Test Preparation
1.
Usage of Preemption and Transaction Rollback prevents ______.
2.
Views are useful for _____ unwanted information, and for collecting together information from more than one relation into a single view.
3.
The decision tree classifier is a widely used technique for ______.
4.
Cross_tab displays permit users to view ______ of multidimensional data at a time.
5.
Thoma's-write rule is ______.
6.
Value that appears in one relation for a given set of attributes also appears for a certain set of attributes in another relation.
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"
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 ?
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)
-
Check your progress:
 Right Ans |
 Wrong Ans |
 Not Attempted |