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

You can do it
  1. Which of the following may not be a database?
  2. If I create Student field in Fees table to store student_id of Students table, then this Student field…
  3. How can you define a field so that when entering data for that field it will display ****** instead…
  4. The___ operator will cause a record to be selected only if two or more conditions are satisfied
  5. In a database table, the category of information is called ____________
  6. A composite key is
  7. A primary key in any table has the properties
  8. After entering all fields required for a table, if you realize that the third field is not needed, how…
  9. When creating a new table which method can be used to choose fields from standard databases and tables
  10. What is a form in MS Access
  11. Which of the following can be an example of a database?
  12. To achieve AND effect when you are entering criteria in a query design window
  13. Which of the following statement is true
  14. What is the difference between Open and Open Exclusively?
  15. It is a query that when run displays its own dialog box prompting you for information, such as
  16. In table design view, which key can be used to switch between the field names and properties panels?
  17. Which of the following is not a database object?
  18. A search value can be an exact value or it can be
  19. It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
  20. The two form layout types will display multiple records at one time are tabular and___
  21. It is most common type of query. It retrieves records from one or more tables and then displays the
  22. DCL provides commands to perform actions like
  23. A __________ enables you to view data from a table based on a specific criterion
  24. To create queries in Access
  25. Which of the following is a method to create a new table in MS Access?
  26. What is the maximum length a text field can be?
  27. In one-to-many relationship the table in one side is called _______ and on many side is called _______
  28. A small button with three dots usually displayed at the right of field properties box
  29. The size of Yes No field is always
  30. The default and maximum size of text field in Access