DBMS Interview Questions and Answers for Fresher - Set 09 - ObjectiveBooks
Hello everybody! You can translate the content of this page by selecting a language in the select box.

DBMS Interview Questions and Answers for Fresher - Set 09

Practice Test: Question Set - 09


1. A good query system
    (A) Can accept English language commands
    (B) Allows non-programmers to access information stored in a database
    (C) Can be accessed only by data processing professionals
    (D) Both (a) and (b)

2. Each of data files has a _______ that describe the way the data is stored in the file.
    (A) File structure
    (B) Records
    (C) Fields
    (D) Database

3. A ________ contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.
    (A) File structure
    (B) Records
    (C) Fields
    (D) Database

4. In a relational schema, each tuple is divided into fields called
    (A) Relations
    (B) Domains
    (C) Queries
    (D) All of the above

5. A file produced by a spreadsheet
    (A) Is generally stored on disk in an ASCII text format
    (B) Can be used as it by the DBMS
    (C) Can be used for graphic
    (D) All of the above

6. A command that lets you change one or more fields in a record is
    (A) Insert
    (B) Modify
    (C) Look-up
    (D) All of the above

7. The master list of an indexed file
    (A) Is sorted in ascending order
    (B) Contains only a list of keys and record numbers
    (C) Has a number assigned to each record
    (D) Both (b) and (c)

8. The data-base environment has all of the following components except:
    (A) Users
    (B) Separate files
    (C) Data base
    (D) Data-base administrator

9. Which of the following is true of a network structure?
    (A) It is a physical representation of the data
    (B) It allows a many-to-many relationship
    (C) It is conceptually simple
    (D) It will be the dominant data base of the future

10. In an Entity-Relationship Diagram Rectangles represents
    (A) Entity sets
    (B) Attributes
    (C) Database
    (D) Tables

11. A Relation is a
    (A) Subset of a Cartesian product of a list of attributes
    (B) Subset of a Cartesian product of a list of domains
    (C) Subset of a Cartesian product of a list of tuple
    (D) Subset of a Cartesian product of a list of relations

12. Set of permitted values of each attribute is called
    (A) Domain
    (B) Tuple
    (C) Relation
    (D) Schema

13. The attribute that can be divided into other attributes is called
    (A) Simple Attribute
    (B) Composite Attribute
    (C) Multi-valued Attribute
    (D) Derived Attribute

14. Database locking concept is used to solve the problem of
    (A) Lost Update
    (B) Uncommitted Dependency
    (C) Inconsistent Data
    (D) All of the above

15. In DBMS FD stands for _________
    (A) Facilitate data
    (B) Functional data
    (C) Facilitate dependency
    (D) Functional dependency

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests:

    Blogger Comment
    Facebook Comment