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

You can do it
  1. Which field type can store photos?
  2. When creating a new table which method can be used to choose fields from standard databases and tables
  3. Query design window has two parts. The upper part shows
  4. Unlike text data type, this can store up to maximum of 65, 535 characters.
  5. What happens when you release mouse pointer after you drop the primary key of a table into foreign key…
  6. Which of the following is not a type of relationship that can be applied in Access database
  7. To achieve AND effect when you are entering criteria in a query design window
  8. It is most common type of query. It retrieves records from one or more tables and then displays the
  9. The___ operator will cause a record to be selected only if two or more conditions are satisfied
  10. To create a new table, in which method you dont need to specify the field type and size?
  11. In one-to-many relationship the table in one side is called _______ and on many side is called _______
  12. A part of database that stores only one type of data is
  13. DCL provides commands to perform actions like
  14. A small button with three dots usually displayed at the right of field properties box
  15. To create primary key for a table when in design view
  16. Which field type will you select when creating a new table if you require to enter long text in that…
  17. Which of the following store command to retrieve data from database?
  18. Which of the field has width 8 bytes?
  19. After entering all fields required for a table, if you realize that the third field is not needed, how…
  20. To create relationship between two tables
  21. Microsoft Access is a
  22. A primary key in any table has the properties
  23. Which is not a view to display a table in Access?
  24. The database language that allows you to access or maintain data in a database
  25. When entering field name, how many characters you can type in maximum?
  26. If you write criteria values vertically (one in a row) it will mean
  27. To sort records in a table
  28. The expression builder is an access tool that controls an expression___ for entering an expression
  29. This data type allows alphanumeric characters and special symbols.
  30. Which of the following is NOT a type of Microsoft Access database object?