What Is The Difference Between 'open' And 'open Exclusively'
Answer: B) Open Exclusive Locks Whole Database So That No One Can Access It Whereas Open Locks Only The Record That Is Being Accessed
In Microsoft Access, Open and Open Exclusive differ in how they control access to a database.
- Open: Opens the database in shared mode, allowing other users to open the same database simultaneously, subject to the database's locking settings.
- Open Exclusive: Opens the database in exclusive mode, preventing other users from opening it while the exclusive user has it open.
Important: Option B gives the basic exam distinction, but its wording is not technically precise. Normal shared access does not necessarily lock only the record being accessed; Access locking can be configured at record or page level.
Microsoft Access मा Open र Open Exclusive बीचको मुख्य भिन्नता Database Access गर्ने अधिकारमा हुन्छ।
- Open: Database लाई Shared Mode मा खोल्छ, जसले गर्दा अन्य Users ले पनि सोही Database खोल्न सक्छन्।
- Open Exclusive: Database लाई Exclusive Mode मा खोल्छ। यो अवस्थामा अन्य Users ले Database खोल्न पाउँदैनन्।
ध्यान दिनुहोस्: विकल्प B को मुख्य अवधारणा सही भए पनि Open गर्दा केवल एउटा Record मात्र Lock हुन्छ भन्ने कुरा सधैँ सही हुँदैन। Access मा Locking Setting अनुसार Record वा Page Level मा Lock हुन सक्छ।
Exam Tip:
Open = Shared Access
Open Exclusive = Exclusive Access
त्यसैले परीक्षाको अपेक्षित उत्तर B हो।