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

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

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

Quiz

 

1. Redundancy is dangerous as it is a potential threat to data
   1.   Integrity
   2.   Consistency
   3.   Both (a) and (b)
   4.   Sufficiency
2. Who is more concerned about the conceptual level of the DBMS
   1.   The Systems programmer
   2.   The end user
   3.   Client
   4.   DBA
3. An Attribute of one table matching the primary key of another table is called as
   1.   Candidate key
   2.   Foreign key
   3.   Secondary key
   4.   Composite
4. If a relation is in BCNF, then it is also in
   1.   1NF
   2.   2NF
   3.   3NF
   4.   All of the above
5. The way a particular application views the data from the database that the application uses is a
   1.   Schema
   2.   Sub Schema
   3.   Relational Model
   4.   Module
6. Locking can be used for:
   1.   Lost Update
   2.   Uncommitted dependency
   3.   Inconsistent data
   4.   All of the above
7. In relation Model Column is referred to as :
   1.   Attribute
   2.   Entity
   3.   Degree
   4.   Tuple
8. ER Model Comes under
   1.   Record based logical Model
   2.   Object based logical Model
   3.   Physical data Model
   4.   All of above
9. Which of following is the problem of file management system? (a) Lack of data independence(b) Data redundancy(c) Update (d) all Periodically adding, changing, & Deleting file records is called file
   1.   Restructuring
   2.   Upgrading
   3.   Renewing
   4.   Updating
10. Which of the following is a relational database
    1.   DAL
    2.   FoxPro
    3.   dbase-IV
    4.   4th Dimensions
11. The Index consists of :
    1.   A list of keys
    2.   Pointers to the master list
    3.   Both (a) & (b)
    4.   None of the above
12. Report generators are used to
    1.   Store data input by a user
    2.   retrieve information from files
    3.   Answer queries
    4.   Both (b) & (c)
13. In a relational schema, each tuple is divided into fields called :
    1.   Relations
    2.   Domains
    3.   Queries
    4.   None of above
14. The set of permitted values for each attribute is called its :
    1.   Attribute range
    2.   Attribute set
    3.   Group
    4.   Domain
15. A DBMS consists of application programs called :
    1.   TOTAL
    2.   BPL
    3.   AUTOFLOW
    4.   FORTRAN
16. A locked file can be :
    1.   is used to hide sensitive information
    2.   is used to hide sensitive information
    3.   Accessed by only one user
    4.   None
17. Transaction X holds a shared lock R. if transaction Y requests for a shared lock on R :
    1.   Immediately Granted
    2.   Immediately rejected
    3.   Granted as is released by X
    4.   result in deadlock situation
18. Command used to select only one copy of each set of duplicable rows :
    1.   Select Unique
    2.   Select Different
    3.   Select Distant
    4.   None
19. Which of following is the characteristics of a relational database model?
    1.   Tables
    2.   records
    3.   Complex logical relationship
    4.   All of these
20. Which command is used to remove rows from a table?
    1.   Delete
    2.   Remove
    3.   Both (a) & (b)
    4.   Truncate
21. Which command is used to remove a table or index from the database in SQL?
    1.   Drop table
    2.   Delete Table
    3.   Erase Table
    4.   None of above
22. A report generator is used to :
    1.   Data Entry
    2.   Update files
    3.   Print files on paper
    4.   None
23. The modify operation is likely to be done after :
    1.   Insert
    2.   Look-up
    3.   Delete
    4.   None of above
24. The database environment has all of the following components except :
    1.   Separate files
    2.   Database
    3.   Users
    4.   DBA
25. If every non key attribute is functionally dependent on the primary key, then the relation will be in :
    1.   1NF
    2.   2NF
    3.   3NF
    4.   4NF