Database Management System One Mark Questions with Answers - Set 11 - ObjectiveBooks

Database Management System One Mark Questions with Answers - Set 11

Practice Test: Question Set - 11


1. The term ________ is sometimes used to refer to a data file in which all the records have the same record format, that is, the same field names, field lengths, and data types.
    (A) Database
    (B) Table
    (C) Flat file
    (D) Data structure

2. With respect to data input, the most accurate description of batch control is
    (A) Dividing documents to be entered into batches
    (B) Controlling the input of each input clerk
    (C) Comparing to a pre-calculated figure the total of a data item summed across a batch records put into the system
    (D) None of the above

3. A data dictionary is a special file that contains
    (A) The names of all fields in all files
    (B) The data types of all fields in all files
    (C) The widths of all fields in all files
    (D) All of the above

4. Which of the following is not a Storage Manager Component?
    (A) Transaction Manager
    (B) Logical Manager
    (C) Buffer Manager
    (D) File Manager

5. Which of the following is not a Schema?
    (A) Database Schema
    (B) Physical Schema
    (C) Critical Schema
    (D) Logical Schema

6. Who proposed the relational model?
    (A) Bill Gates
    (B) E.F. Codd
    (C) Herman Hollerith
    (D) Charles Babbage

7. In an Entity-Relationship Diagram “Ellipses” represents
    (A) Attributes
    (B) Weak entity set
    (C) Relationship sets
    (D) Multi-valued Attributes

8. Which of the following is an unary operation?
    (A) Selection operation
    (B) Generalized selection
    (C) Primitive operation
    (D) Projection operation

9. A table that displays data redundancies yields _________ anomalies
    (A) Insertion
    (B) Deletion
    (C) Update
    (D) All of the above

10. In SQL, the command(s) is(are) used to create an index for a table or cluster
    (A) CREATE INDEX
    (B) MODIFY INDEX
    (C) SET INDEX TO FILE
    (D) All of the above

11. The index consists of
    (A) A list of keys
    (B) Pointers to the master list
    (C) Both (a) and (b)
    (D) None of the above

12. If a piece of data is stored in two places in the database, then
    (A) Storage space is wasted
    (B) Changing the data is one spot will cause data inconsistency
    (C) It can be more easily accessed
    (D) Both (a) and (b)

13. The Management Information system (MIS) structure with one main computer system is called a
    (A) Hierarchical MIS structure
    (B) Distributed MIS structure
    (C) Centralized MIS structure
    (D) Decentralized MIS structure

14. Data item characteristics that are important in data management include
    (A) Punctuation
    (B) Language
    (C) Spelling
    (D) Width

15. If you want to group the records in the abc database, you could use the Job code as the _________.
    (A) Delete
    (B) Update
    (C) Sort Key
    (D) Index

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests:


    Blogger Comment
    Facebook Comment