Home

Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called

A. Foreign key

B. Native key

C. Composite key

D. Primary key

Correct Answer : D.


Download Objective type questions of Microsoft Access PDF

Visit our PDF store

Get all objective type questions of Microsoft Access MCQ

You can do it
  1. If you need to edit a relationship
  2. Which of the following may not be a database?
  3. Collection of related records in a database is known as
  4. When entering field name, how many characters you can type in maximum?
  5. When a picture or other graphic image is placed in the report header section it will appear____
  6. Queries in Access can be used as
  7. If you write criteria values vertically (one in a row) it will mean
  8. To create a new table, in which method you dont need to specify the field type and size?
  9. You can set a controls border type to make the border invisible.
  10. Referential integrity means
  11. Which of the following is a method to create a new table in MS Access?
  12. Which field type can store photos?
  13. A composite key is
  14. Which of the following creates a drop down list of values to choose from a list?
  15. While creating relationship, when you drag a field of a field to drop into another table the mouse pointer…
  16. It is a sign or symbol that specifies, operator, and values that produce a result
  17. Following is not a database model
  18. A database object in MS Access that stores a question about the data in database?
  19. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you…
  20. To achieve AND effect when you are entering criteria in a query design window
  21. A __ name must be unique within a database
  22. This key uniquely identifies each record
  23. Which of the field has width 8 bytes?
  24. It is a query that when run displays its own dialog box prompting you for information, such as
  25. An Access database object that is used to enter, view or edit records
  26. Which of the following expresses correct order?
  27. Which is not a view to display a table in Access?
  28. A primary key in any table has the properties
  29. Which of the following is not a type of relationship that can be applied in Access database
  30. Unlike text data type, this can store up to maximum of 65, 535 characters.