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. It is an association established between common fields of two tables.
  2. If I create Student field in Fees table to store student_id of Students table, then this Student field…
  3. DCL provides commands to perform actions like
  4. After entering all fields required for a table, if you realize that the third field is not needed, how…
  5. The complete information about an entity in a database is called
  6. How can you define a field so that when entering data for that field it will display ****** instead…
  7. This is the stage in database design where one gathers and lists all the necessary fields for the database…
  8. Both conditions display on the same row in the design grid when ___operator is in use
  9. This key uniquely identifies each record
  10. We can remove a relationship defined between two tables by
  11. To achieve AND effect when you are entering criteria in a query design window
  12. Which of the following is not a database object?
  13. What happens when you release mouse pointer after you drop the primary key of a table into foreign key…
  14. An Access database object that is used to enter, view or edit records
  15. Which of the following creates a drop down list of values to choose from a list?
  16. When a picture or other graphic image is placed in the report header section it will appear____
  17. To duplicate a controls formatting you can use___
  18. A small button with three dots usually displayed at the right of field properties box
  19. A database object in MS Access that stores a question about the data in database?
  20. Query design window has two parts. The upper part shows
  21. Which of the following is a method to create a new table in MS Access?
  22. Which of the following may not be a database?
  23. The command center of access file that appears when you create or open the MS Access database file.
  24. The___ operator will cause a record to be selected only if two or more conditions are satisfied
  25. In table design view, which key can be used to switch between the field names and properties panels?
  26. It is a query that when run displays its own dialog box prompting you for information, such as
  27. Collection of related records in a database is known as
  28. Which of the field has width 8 bytes?
  29. What do you mean by one to many relationship between Student and Class table?
  30. This data type allows alphanumeric characters and special symbols.