Home

Which of the following statement is true?

A. Foreign key fields dont allow duplicate values

B. In primary key field you can enter duplicate value

C. In an indexed field you may or may not enter duplicate value depending upon setting

D. All statements are true

You can do it
  1. In table design view, which key can be used to switch between the field names and properties panels?
  2. It is a database object to view, change, and analyze data in different ways
  3. A search value can be an exact value or it can be
  4. What does the show check box in query design window indicate
  5. A part of database that stores only one type of data is
  6. What happens when you release mouse pointer after you drop the primary key of a table into foreign key…
  7. Which of the following is not a field type in Access
  8. If you need to edit a relationship
  9. Which of the following expresses correct order?
  10. Unlike text data type, this can store up to maximum of 65, 535 characters.
  11. Each record is constituted by a number of individual data items which are called
  12. The size of Yes No field is always
  13. While creating relationship, when you drag a field of a field to drop into another table the mouse pointer…
  14. To duplicate a controls formatting you can use___
  15. To create relationship between two tables
  16. In table design view what are the first column of buttons used for
  17. In a database table, the category of information is called ____________
  18. What is the difference between Open and Open Exclusively?
  19. The___ operator will cause a record to be selected only if two or more conditions are satisfied
  20. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you…
  21. The third stage in designing a database is when we analyze our tables more closely and create a ___________…
  22. A database language concerned with the definition of the whole database structure and schema is ________
  23. How can you link a table with another so that a field in current table will display values in drop down…
  24. To create primary key for a table when in design view
  25. The complete information about an entity in a database is called
  26. When entering field name, how many characters you can type in maximum?
  27. An Access database object that is used to enter, view or edit records
  28. Which of the following can be an example of a database?
  29. Which field type will you select when creating a new table if you require to enter long text in that…
  30. If you write criteria values vertically (one in a row) it will mean