Database Management System1(TTA)

25 Questions | Total Attempts: 1348

SettingsSettingsSettings
Please wait...
Database Management System1(TTA)

INSTRUCTIONS1. NUMBER OF QUESTIONS 252. HAS A TIME LIMIT OF 15 MINUTES3. HAS A PASS MARKS OF 30%4. QUESTIONS PER PAGE 15. EACH QUESTIONS HAS 1 MARKS6. NEGATIVE MARKING FOR EACH QUESTIONS 0. 257. WILL ALLOW TO YOU GO BACK ,SKIP AND CHANGE YOUR ANSWERS8. WILL ALLOW TO YOU PRINT OUT YOUR RESULT AND CERTIFICATE9. WILL ALLOW TO YOU PRINT OUT YOURS RESPONSE SHEET WITH CORRECT ANSWER KEY AND EXPLANATION10. WE WILL PROVIDE YOURS RESULT,CERTIFICATE AND YOUR RESPONSE SHEET TO YOURS EMAIL ID AT END OF ONLINE TEST. .


Questions and Answers
  • 1. 
    Software that defines a database, stores the data, supports a query language, produces reports and creates data entry screens is a:
    • A. 

      data dictionary

    • B. 

      database management system (DBMS)

    • C. 

      decision support system

    • D. 

      relational database

  • 2. 
    The modern database report writer
    • A. 

      A career path that focuses on creating, managing and supporting the reports generated from databases

    • B. 

      Provide limited control over how information is displayed and reported.

    • C. 

      provides the tools for database designer to display information in the desired

    • D. 

      Provides the tools for the database administrator to monitor and report on database use and activity

  • 3. 
    The separation of the data definition from the program is known as
    • A. 

      data dictionary

    • B. 

      data independence

    • C. 

      data integrity

    • D. 

      referential integrity

  • 4. 
    In the client/server model, the data base
    • A. 

      is downloaded to the client upon request

    • B. 

      is shared by both client and server

    • C. 

      Resides on the client side

    • D. 

      Resides on the server side

  • 5. 
    The traditional storage of data that is organized by customer,stored in separate folders in filing cabinets is an example of what type of 'database' system?
    • A. 

      Hierarchical

    • B. 

      Network

    • C. 

      Object oriented

    • D. 

      Relational database

  • 6. 
    The database designing that consists of multiple tables that are linked together through matching data stored in each table is called a:
    • A. 

      hierarchical database

    • B. 

      Network database

    • C. 

      object oriented database

    • D. 

      relational database

  • 7. 
    What is the main limitation of Hierarchical Databases?
    • A. 

      Limited capacity (unable to hold much data)

    • B. 

      Limited flexibility in accessing data

    • C. 

      Overhead associated with maintaining indexes

    • D. 

      Performance of the database is poor

  • 8. 
    An abstract data type is used to:
    • A. 

      link data from remote databases

    • B. 

      Prevent users from getting to database security information

    • C. 

      Provide a conceptual view of the data so it is easier to understand

    • D. 

      Store complex data structure to represent the properties of objects

  • 9. 
    One of the first phases of a new database project that involves critical areas, expensive hardware or software within the organization is called ___________.
    • A. 

      analysis phase

    • B. 

      feasibility study

    • C. 

      Investigation stage

    • D. 

      System design

  • 10. 
    Which component of the database management system (DBMS) most affects the ability to handle large problems (scalability)?
    • A. 

      Data storage subsystem

    • B. 

      Database engine

    • C. 

      query processor

    • D. 

      Security sub system

  • 11. 
    DBMS Stands for
    • A. 

      Database marginal system

    • B. 

      Directory Based Memory Standard

    • C. 

      Data Base Management System

    • D. 

      Dual Bus Mask Storage

  • 12. 
    In a data base,each row is called as a
    • A. 

      Horizontal data

    • B. 

      record

    • C. 

      Information

    • D. 

      None of these

  • 13. 
    Which command can be used to change or edit the database file
    • A. 

      Edit

    • B. 

      Browse

    • C. 

      Replace

    • D. 

      All of these

  • 14. 
    .Each column of a table may have values of
    • A. 

      Different types

    • B. 

      Same type

    • C. 

      Varied or same type

    • D. 

      none of the above

  • 15. 
    All the rows in a table are
    • A. 

      same

    • B. 

      May or may not same

    • C. 

      different

    • D. 

      All of above

  • 16. 
    SQL stands for
    • A. 

      standard quality literature

    • B. 

      structured query language

    • C. 

      standard query language

    • D. 

      Standard query linguistics

  • 17. 
    Which of the following are the elements of a database
    • A. 

      data

    • B. 

      Relations

    • C. 

      Constraint and schema

    • D. 

      All of these

  • 18. 
    A DBMS enables you to
    • A. 

      Store Information

    • B. 

      Modify Information

    • C. 

      Extract Information

    • D. 

      All of above

  • 19. 
    Meta data is
    • A. 

      Small amount of data

    • B. 

      data about data

    • C. 

      Redundant data

    • D. 

      None of these

  • 20. 
    4GL stands for
    • A. 

      Four general languages

    • B. 

      Fourth generation languages

    • C. 

      Forty General Languages

    • D. 

      none

  • 21. 
    The ascending order of a data hierarchy is
    • A. 

      bit-byte-record-field-file-database

    • B. 

      byte-bit-field-record-file-database

    • C. 

      bit-byte-field-record-file-database

    • D. 

      bit-byte-file-record-field-database

  • 22. 
    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 dominant database of the future

  • 23. 
    Which of the following is a problem in file management system?
    • A. 

      difficult to update

    • B. 

      Lack of data independence

    • C. 

      data redundancy

    • D. 

      All of above

  • 24. 
    One data dictionary software package is called
    • A. 

      DB/DC dictionary

    • B. 

      TOTAL

    • C. 

      ACCESS

    • D. 

      DATA PACK

  • 25. 
    The function of a database is
    • A. 

      to check all input data

    • B. 

      To check all spelling

    • C. 

      To collect and organize input data

    • D. 

      to output data

Back to Top Back to top