Quiz  /  Database Gate & PSU MCQ Questions With Answers

  • 1. 
    The Sports Club has had an Open Day and has gained a new member. How will they add their details to the database?

  • Add another field
  • Amend a record
  • Add a new record
  • Delete a record

  • 2. 
    Text/String, Integer, Real/Float, Boolean and Date/Time are all examples of...

  • Data Types
  • Filters
  • Sorts
  • Validations

  • 3. 
    A gym has a database with all their members they want to include email addresses in the database, what will they do?

  • Add a record
  • Add a field
  • Edit a record
  • Delete a field

  • 4. 
    The columns in a database are called:

  • Records
  • Fields
  • Primary key
  • Foreign key

  • 5. 
    A data type used for storing numbers with a fractional part e.g. 3.142

  • Integer
  • Boolean
  • Real / Float
  • String

  • 6. 
    How many characters are allowed in the Text field?

  • . More than 255
  • 1-255
  • 1-9
  • Unlimited

  • 7. 
    . What is a field in a related database table that refers to the primary key in the primary table?

  • Secondary key
  • Table key
  • Foreign key
  • Common key

  • 8. 
    One of the members of the Sports Club has decided to resign. What would the secretary do with the record for that member on the database?

  • Amend the record
  • Delete the field
  • Delete the record
  • Delete the file

  • 9. 
    In which of the following must the data be unique?

  • the foriegn key
  • the primary key
  • the junction table
  • the common field

  • 10. 
    Which language is used to develop and manage databases?

  • sql
  • java
  • html
  • dbms

  • 11. 
    Which of these is not a type of validation?

  • Proof Reading
  • Range
  • Limit
  • Presence

  • 12. 
    A data type that can only hold 2 values e.g. Yes/No or True/False.

  • Boolean
  • Integer
  • Real
  • String

  • 13. 
    A database does NOT consist of .........

  • field
  • table
  • character
  • report

  • 14. 
    In a database, Yes/No, Text and Date/Time are all examples of:

  • data types
  • data queries
  • tabs you can select
  • records in the data table

  • 15. 
    A method of only displaying records in a table that match specific criteria...

  • Filter
  • Validation
  • Sort
  • Verification
Report Question
warning
access_time
  Time