Home

What is the difference between Open and Open Exclusively?

A. Open statement opens access database files and Open Exclusively opens database files of other program like Oracle

B. Open Exclusive locks whole database so that no one can access it whereas Open locks only the record that is being accessed

C. Both Open and Open Exclusively are same

D. Open Exclusive command does not exist in MS Access

Please do not use chat terms. Example: avoid using "grt" instead of "great".

You can do it
  1. Unlike text data type, this can store up to maximum of 65, 535 characters.
  2. Which of the following is a method to create a new table in MS Access?
  3. Queries in Access can be used as
  4. A search value can be an exact value or it can be
  5. The size of Yes No field is always
  6. To create a new table, in which method you dont need to specify the field type and size?
  7. Which of the following term is least related to database?
  8. Which of the following creates a drop down list of values to choose from a list?
  9. Database Management Systems are featured with:
  10. To create primary key for a table when in design view
  11. A database can be best described as
  12. To create relationship between two tables
  13. Which of the following is not a database object?
  14. In one-to-many relationship the table in one side is called _______ and on many side is called _______
  15. The__ button on the tool box display data from a related table
  16. Which is not a view to display a table in Access?
  17. What is the difference between Open and Open Exclusively?
  18. After entering all fields required for a table, if you realize that the third field is not needed, how…
  19. A composite key is
  20. The third stage in designing a database is when we analyze our tables more closely and create a ___________…
  21. Microsoft Access is a
  22. Which field type can store photos?
  23. In table design view, which key can be used to switch between the field names and properties panels?
  24. The database language that allows you to access or maintain data in a database
  25. The command center of access file that appears when you create or open the MS Access database file.
  26. Following is not a database model
  27. A __________ enables you to view data from a table based on a specific criterion
  28. The___ operator will cause a record to be selected only if two or more conditions are satisfied
  29. Which of the following store command to retrieve data from database?
  30. In a database table, the category of information is called ____________