TRB-CS-VIP ONLINE COACHING CENTER ( TEST-1) *RDBMS Fundamentals*

TRB-CS-VIP ONLINE COACHING CENTER ( TEST-1) *RDBMS Fundamentals*

TRB-CS-VIP ONLINE COACHING CENTER ( TEST-1) *RDBMS Fundamentals*

Quiz

 

1. Usage of Preemption and Transaction Rollback prevents ______.
   1.   Deadlock situation
   2.   Data manipulation
   3.   Deadlock situation
   4.   Unauthorised usage of data file
2. Views are useful for _____ unwanted information, and for collecting together information from more than one relation into a single view.
   1.   Deleting
   2.   Highlighting
   3.   Hiding
   4.   All of the above
3. The decision tree classifier is a widely used technique for ______.
   1.   Association
   2.   Classification
   3.   Clustering
   4.   Partition
4. Cross_tab displays permit users to view ______ of multidimensional data at a time.
   1.   1 − dimension
   2.   2 − dimensions
   3.   3 − dimensions
   4.   Multidimensions
5. 5 . Thoma’s-write rule is ______.
   1.   Sliding window protocol
   2.   One phase locking protocol
   3.   Two phase locking protocol
   4.   Time stamp ordering protocol
6. 
   6 . Value that appears in one relation for a given set of attributes also appears for a certain set of attributes in another relation.
   1.   Domain Integrity
   2.   Data Integrity
   3.   Referential Integrity
   4.   Logical Integrity
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
   1.   All branches that have greater assets than all branches in Mumbai.
   2.   All branches that have greater assets than some branch located in Mumbai,
   3.   Any branch that has greater assets than any branch in Mumbai.
   4.   The branch that has greatest asset in Mumbai.
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) Bor
   1.   {t |t(customer_name) | t∈borrow[?] t[amount]›12000}
   2.   {t |[?] ∈ borrow (t(customer_name)[?] s[amount] ›12000}
   3.   t(customer_name) | t∈borrow[?] t[amount]›12000}
   4.   {t |[?] ∈ borrow (t(customer_name=s(customer_ name))[?] [amount]›12000}
9. Find Incorrect match?
   1.   Create - DDL
   2.   Select - DML
   3.   Rectangle - DAL
   4.   Record - Relationship Mode
10. Which of the following is true ?
    1.   BCNF and 3NF are same
    2.   A relation in BCNF is always in 3NF
    3.   A relation in BCNF is not in 3NF
    4.   A relation in 3NF is always in BCNF
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
    
    1.   DBMS & the Host record
    2.   Host program and Host record
    3.   Host program and Host language
    4.   Host program and DBMS
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 fun
    1.   (R1 ∩ R2) → R1 or R1 ∩ R2 → R2
    2.   R1 ∩ R2 → R1 and R1 ∩ R2 → R2
    3.   R1 ∩ R2 → R2
    4.   R1 ∩ R2 → R1
13. Which level of Abstraction describes how data are stored in the data base ?
    1.   Physical level
    2.   Abstraction level
    3.   Logical level
    4.   View level
14. Third normal form is based on the concept of ______.
    1.   Normal Dependency
    2.   Closure Dependency
    3.   Functional Dependency
    4.   Transitive Dependency
15. Referential integrity is directly related to
    1.   Foreign key
    2.   Candidate key
    3.   Relation key
    4.   Primary key
16. In multiuser database if two users wish to update the same record at the same time, they are prevented from doing so by
    
    1.   Password
    2.   Record lock
    3.   Documentation
    4.   Jamming
17. B+ tree are preferred to binary tree in Database because
    1.   Disk access is much slower than memory access
    2.   Disk capacity are greater than memory capacities
    3.   Disks are more reliable than Memory
    4.   Disk data transfer rates are much less than memory data transfer rate
18. A Transaction Manager is which of the following ?
    1.   Maintains before and after database images
    2.   Maintains appropriate concurrency control
    3.   Maintains a log of transactions
    4.   All of the above
19. . What is Granularity ?
    1.   The size of data item
    2.   The size of database
    3.   The size of file
    4.   The size of record
20. Which level of Abstraction describes what data are stored in the Database ?
    1.   Abstraction level
    2.   Physical level
    3.   Logical level
    4.   View level
21. The problem that occurs when one transaction updates a database item and then the transaction fails for some reason is ________.
    1.   Temporary Modify Problem
    2.   Temporary Select Problem
    3.   Dirty Read Problem
    4.   None of these
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
    1.   Lossless Join
    2.   Dependency preserving and lossless join
    3.   Lossless Join but not dependency preserving
    4.   Dependency preserving but not lossless join
23. If D1,D2, ....Dn are domains in a relational model, then the relation is a table, which is a subset of
    1.   D1ΧD2Χ ... ΧDn
    2.   D1∪D2∪... ∪Dn
    3.   D1−D2−...−Dn
    4.   D1+D2+... +Dn
24. Which of the following is not a type of Database Management System ?
    1.   Sequential
    2.   Hierarchical
    3.   Relational
    4.   Network
25. Manager&rsquos salary details are to be hidden from Employee Table. This Technique is called as
    1.   Physical level Datahiding
    2.   Conceptual level Datahiding
    3.   Logical level Datahiding
    4.   External level Datahiding