Database Management System Objective Type Questions and Answers - ObjectiveBooks

Database Management System Objective Type Questions and Answers

Practice Test: Question Set - 15

1. Sophisticated report generators can
    (A) Print row-oriented reports
    (B) Perform arithmetic operations
    (C) Selectively retrieve and print portions of a list
    (D) All of the above

2. The relational model uses some unfamiliar terminology. A tuple is equivalent to a:
    (A) Record
    (B) Field
    (C) File
    (D) Data base

3. Which of the following is a Data Model?
    (A) Entity-Relationship model
    (B) Relational data model
    (C) Object-Based data model
    (D) All of the above

4. UML is stands for
    (A) Universal Modeling Language
    (B) Unified Modeling Language
    (C) United Modeling Language
    (D) Uni Modeling Language

5. Report generators are used to
    (A) Store data input by a user
    (B) Retrieve information from files
    (C) Answer queries
    (D) Both (b) and (c)

6. In a large DBMS
    (A) Each user can "see" only a small part of the entire database
    (B) Each user can access every sub-schema
    (C) Each subschema contains every field in the logical schema
    (D) All of the above

7. Information can be transferred between the DBMS and a
    (A) Spreadsheet program
    (B) Word processor program
    (C) Graphics program
    (D) All of the above

8. In SQL, which command(s) is(are) used to enable/disable a database trigger?
    (A) Modify User
    (B) Change User
    (C) Alter Trigger
    (D) None of the above

9. Which of the following is a type of DBMS software?
    (A) Database manipulation language
    (B) Query language
    (C) Utilities
    (D) Report writer

10. Snapshot of the data in the database at a given instant of time is called
    (A) Database Schema
    (B) Database Instance
    (C) Database Snapshot
    (D) All of the above

11. A functional dependency between two or more non-key attributes is called
    (A) Transitive dependency
    (B) Partial transitive dependency
    (C) Functional dependency
    (D) Partial functional dependency

12. Sort/report generators
    (A) Are faster than index/report generators
    (B) Require more disk space than index/report generators
    (C) Do not need to sort before generating a report
    (D) Both (a) and (b)

13. Which of the following is not a logical data-base structure?
    (A) Tree
    (B) Relational
    (C) Network
    (D) Chain

14. Which of the following is not an advantage of the data-base approach?
    (A) Elimination of the data redundancy
    (B) Ability to associate related data
    (C) Increased security
    (D) All of the above are advantages

15. The highest level in the hierarchy of data organization is called
    (A) Data bank
    (B) Database
    (C) Data file
    (D) Data record

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: