Quiz 4- SEC A

21 Questions | Total Attempts: 72

SettingsSettingsSettings
Quiz 4- SEC A - Quiz

.


Questions and Answers
  • 1. 
    A top-to-bottom relationship among the items in a database is established by a :
    • A. 

      Hierarchical schema

    • B. 

      Network schema

    • C. 

      Relational schema

    • D. 

      All of the above

  • 2. 
    The level of data abstraction which describes how the data is actually stored is :
    • A. 

      Conceptual level

    • B. 

      Physical level

    • C. 

       file level

    • D. 

      None of these

  • 3. 
    Collection of information stored in a database at a particular moment is :
    • A. 

      View

    • B. 

      Schema

    • C. 

      Instance

    • D. 

      None of the above

  • 4. 
    DBA stands for :
    • A. 

      Data Bank Access

    • B. 

      Database Access

    • C. 

      Data Bank Administration

    • D. 

      Database Administrator

  • 5. 
    Between the users and the database itself, a DBMS will act as :
    • A. 

      Barrier

    • B. 

      Interface

    • C. 

      Referee

    • D. 

      Obstacle

  • 6. 
     A schema describes :
    • A. 

      Record Relationship

    • B. 

      Data Elements

    • C. 

      Record and files

    • D. 

      All of the above

  • 7. 
    Which one is lowest level data model ?
    • A. 

      Physical data model

    • B. 

      Logical data model

    • C. 

      External data model

    • D. 

      None of the above

  • 8. 
    Data are :
    • A. 

      Raw facts and figures

    • B. 

      Information

    • C. 

      Electronic representation of facts

    • D. 

      None of the above

  • 9. 
    DBMS is used to :
    • A. 

      Eliminate data redundancy

    • B. 

      Maintain data integrity

    • C. 

      Establish relationships among different files

    • D. 

      All of the above

  • 10. 
     A set of objects that share a common structure and a common behavior is called :
    • A. 

      Object

    • B. 

      Class

    • C. 

      Entity

    • D. 

      None of these

  • 11. 
    The data dictionary tells the DBMS : 
    • A. 

      What files are in the database

    • B. 

      What attributes are possessed by the data

    • C. 

      What these files contain

    • D. 

      All of the above

  • 12. 
    The logical data structure with a one-to-many relationship is a :
    • A. 

      Network

    • B. 

      Tree

    • C. 

      Chain

    • D. 

      Relationship

  • 13. 
    Data processing comprises of :
    • A. 

      Capturing of data

    • B. 

      Storing of data

    • C. 

      Updating and retrieving data

    • D. 

      All of the above

  • 14. 
    The highest level in the hierarchy of data organization is called :
    • A. 

      Data bank

    • B. 

      Database

    • C. 

      Data file

    • D. 

      Data record

  • 15. 
    File is the collection of all related :
    • A. 

      Database

    • B. 

      Records

    • C. 

      Fields

    • D. 

      File

  • 16. 
    Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?
    • A. 

      DML(Data Manipulation Langauge)

    • B. 

      DDL(Data Definition Langauge)

    • C. 

      Query

    • D. 

      Relational Schema

  • 17. 
    Create table employee (name varchar ,id integer) What type of statement is this 
    • A. 

      DML

    • B. 

      DDL

    • C. 

      View

    • D. 

      Integrity constraint

  • 18. 
    An advantage of the database management approach is
    • A. 

      Data is dependent on programs

    • B. 

      Data redundancy increases.

    • C. 

      Data is integrated and can be accessed by multiple programs.

    • D. 

      None of the above

  • 19. 
    A DBMS query language is designed to
    • A. 

      Support end users who use English-like commands

    • B. 

      Support in the development of complex applications software

    • C. 

      Specify the structure of a database.  

    • D. 

      All of the above.

  • 20. 
    Which database level is closest to the users?
    • A. 

      External

    • B. 

      Internal  

    • C. 

      Physical  

    • D. 

      Conceptual

  • 21. 
    The language which has recently become the defacto standard for interfacing application programs with relational database system is
    • A. 

      . Oracle.

    • B. 

      SQL.

    • C. 

      DBase

    • D. 

      4GL

Back to Top Back to top