Quiz  /  Sql Mcq Questions Answers MCQ Quiz Questions and Answers

  • 1. 
    DBMS is

  • Collection of data
  • Set of programs to access those data
  • All of the above
  • None of the above

  • 2. 
    To locate a data item for storage is

  • Field
  • Feed
  • Fetch
  • Database

  • 3. 
    In ER diagram, relationship type is represented by

  • Rectangle
  • Ellipse
  • Dashed ellipse
  • Diamond

  • 4. 
    A program that generally be more user-friendly interface than a DBMS is called file records is called---------- file

  • Repository
  • Restructuring
  • Form
  • Front end

  • 5. 
    The database stores information in

  • Blocks
  • Tracks and passwords
  • Rows and columns
  • All of the above

  • 6. 
    A collection of related files is called

  • Database
  • Record
  • Field
  • Character

  • 7. 
    A set of possible data values is called

  • Tuple
  • Degree
  • Domain
  • Attribute

  • 8. 
    The particular field of a record that uniquely identifies each records is called the

  • Primary field
  • Master field
  • Order field
  • Key fields

  • 9. 
    Items such as names and addresses are considered as

  • Input
  • Data
  • Output
  • Records

  • 10. 
    An entity set that does not have sufficient attributes to form a primary key, is a

  • Simple entity set
  • Primary entity se
  • Strong entity set
  • Weak entity set

  • 11. 
    A computer checks the _______ of username and password for a march before granting access.

  • Website
  • Network
  • Backup file
  • Database

  • 12. 
    Which of the following contains information about a single entity in the database like a person, place, event or thing?

  • Record
  • Form
  • Query
  • Table

  • 13. 
    ______ means that the data contained in a database is accurate and reliable.

  • Data integrity
  • Data reliability
  • Data consistency
  • Data redundancy

  • 14. 
    Rows of a relation are called

  • Data structure
  • Tuples
  • Relation
  • An entity

  • 15. 
    In a ER diagram, an entity key of one file that also appears in another file

  • Primary key
  • Foreign key
  • Physical key
  • Logical key

  • 16. 
    Periodically adding, changing and deleting file records is called ______ file.

  • Updating
  • Upgrading
  • Restructuring
  • Renewing

  • 17. 
    The smallest unit of information about a record in a database is called a

  • Cell
  • Field
  • Query
  • Record

  • 18. 
    The primary key must be

  • Unique
  • Multiple
  • Related
  • Numeric

  • 19. 
    A database that contains tables linked by common fields is called a

  • Relational database
  • Centralised database
  • Flat file database
  • Ranges, sheet

  • 20. 
    A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as

  • DBMS
  • Database
  • ER model
  • Data model

  • 21. 
    A ______ is a collection of data that is stored electronically as a records in a table.

  • Database
  • Spreadsheet
  • Presentation
  • Web page

  • 22. 
    Which of the following types of table constraints will prevent the entry of duplicate rows?

  • Primary key
  • Unique
  • Null
  • Foreign key

  • 23. 
    In an ER diagram, attributes are represented by

  • Square
  • Ellipse
  • Triangle
  • Rectangle

  • 24. 
    Key to represent relationship between tables is called

  • Foreign key
  • Secondary key
  • Primary key
  • Composite key
Report Question
warning
access_time
  Time