You work as a Database Designer for Tech Perfect Inc. The company has a Windows Vista-based computer with Microsoft Office 2010 installed on it. You are working on a database named Orders created in…

Question

Options

• AOpen exclusively
• BOpen read-only
• COpen exclusive read-only
• DOpen

• A
  71% (32)
• B
  7% (3)
• C
  18% (8)
• D
  4% (2)

Explanation

In order to accomplish the task, you should open the database in open exclusively mode. The database is located on a network; therefore, you need to ensure that no one is using it. After opening the database in open exclusive mode, you can prevent unauthorized users from opening the database by assigning a password. Answer: D is incorrect. When a database is opened in open mode, it is shared with all users and all of them can insert, modify, and delete data from the database. Answer: B is incorrect. When a database is opened in open read-only mode, data can be viewed but data cannot be inserted, modified, or deleted. Other users can perform all tasks on the Answer: C is incorrect. When a database is opened in open exclusive read-only mode, data can be viewed but data cannot be inserted, modified, or deleted. Other users can also open the database, but the database will be opened in read-only mode.

No community discussion yet for this question.