DATABASE FUNDAMENTALS
WHAT IS DATABASE MANAGEMENT
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Open Exclusive Mode
|
|
|
Open Mode
|
|
|
Exclusive Read-Only Mode
|
|
|
Open Read-Only Mode
|
Detailed explanation-1: -Row-level locking means that only the row that is accessed by an application will be locked. Hence, all other rows that belong to the same page are free and can be used by other applications. The Database Engine can also lock the page on which the row that has to be locked is stored.
Detailed explanation-2: -Sharing of data and multiuser system That is, they allow many users to access the same database at the same time. This access is achieved through features called concurrency control strategies.
Detailed explanation-3: -A database lock is used to “lock” some data in a database so that only one database user/session may update that particular data. So, database locks exist to prevent two or more database users from updating the same exact piece of data at the same exact time.
Detailed explanation-4: -Right-click the database name, and then click Properties. In the Properties dialog box, clear the Read-only check box under Attributes. Click OK to apply the change. Open your database in Access.