Distributed Database MCQ with Answers
Distributed Database MCQ with Answers – important Distributed Database MCQs are here for the students to qualify for various academic and competitive exams.
- Which of the following is true concerning a global transaction?
a. The required data are at one local site and the distributed DBMS routes request as necessary
b. The required data are located in at least one nonlocal site and the distributed DBMS routes request as necessary.
c. The required data are at one local site and the distributed DBMS passes the request to only the local DBMS
d. The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS
Answer b
2. A homogenous distributed database is which of the following?
a. The same DBMS is used at each location and data are not distributed across all nodes
b. The same DBMS is used at each location and data are distributed across all nodes.
c. A different DBMS is used at each location and data are not distributed across all nodes
d. A different DBMS is used at each location and data are distributed across all nodes.
Answer b
3. Storing a separate copy of the database at multiple locations is which of the following
a. Data Replication
b. Horizontal Partitioning
c. Vertical Partitioning
d. None of the above
Answer a
4. Which of the following is the advantage of a distributed database over a centralized database?
a. Module wise growth
b. Simplicity and ease
c. Slow Response
d. None of the above
Answer a
5. A distributed database is a collection of data which belong —————– to the same system but are spread over the ————– of the network.
a. Logically, sites
b. Physically, sites
c. Database, DBMS
d. None of the above
Answer a
6. —————– mean programs can be written as if a database is not distributed for its user.
a. Transparency
b. Distribution Transparency
c. Robustness
d. None of the above
Answer b
7. In a distributed Database reduction of redundancy is obtained by ———————
a. Data fragmentation
b. Data Replication
c. Data Sharing
d. None of the above
Answer c
8. Which of the following is/are the main goals of a distributed database?
a. Interconnection of database
b. Incremental growth
c. Reduced communication overhead
d. All of the above
Answer d
9. An autonomous homogenous environment is which of the following?
a. The same DBMS is used at each site and each DBMS works independently
b. The same DBMS is at each site and a central DBMS coordinates database access
c. A different DBMS is at each node and each DBMS works independently
d. None of the above
Answer a
10. A transaction manager is which of the following?
a. A manager that maintains a log of transactions
b. That maintains before and after database images
c. That maintains appropriate concurrency control
d. All of the above
Answer d
11. Location transparency allows for which of the following
a. Users to treat the data as if it is at one location
b. Programmers to treat the data as if it is at one location
c. Manager to treat the data as if it is at one location
d. All of the above
Answer d
12. Which of the following is a heterogeneous distributed database?
a. The same DBMS is used at each location and data are not distributed across all nodes
b. The same DBMS is used at each location and data are distributed across all nodes
c. A different DBMS is used at each location and data are not distributed across all nodes
d. A different DBMS is used at each location and data are distributed across all nodes
Answer d
13. In which of the following some of the columns of a relation are from different sites?
a. Horizontal partition
b. Vertical partition
c. Both a and b
d. None
Answer b
14. Which of the following is a distributed database?
a. A single logical database that is spread to multiple locations and is interconnected by a network
b. A loose collection of a file that is spread to multiple locations and is interconnected by a network
c. A single logical database that is limited to one location.
d. None
Answer a
15. Which of the following strategies is used by a distributed database?
a. Totally centralized at one location and accessed by many sites
b. Totally or partially at one location and distributed at many sites
c. Partitioned into segments at different sites
d. All of the above
Answer d
16. Commit and rollback are related to ……….
a. Data consistency
b. Data integrity
c. Data Security
d. Data Recovery
Answer a
17. Which of the mode is required to edit the data item?
a. Exclusive Mode
b. Shared Mode
c. Inclusive Mode
d. Unshared Mode
Answer A
18. For committing a transaction, the DBMS might discard all the records.
a. after image
b. before image
c. log
d. redo log
Answer b
19. A sophisticated locking mechanism is known as 2-phase locking which includes the Growing phase and …….
a. Shrinking Phase
b. Release phase
c. Commit phase
d. Acquire Phase
Answer a
20. A Transaction ends
a. only when it is Committed
b. only when it is Rolled-back
c. when it is Committed or Rolled-back
d. only when it is initialized
Answer c
21. In which of the following phase new lock are acquired?
a.Shrinking Phase
b.Release phase
c.Commit phase
d.Growing Phase
Answer d
22. A transaction processing system is also called as …….
a.processing monitor
b.Transaction monitor
c. TP Monitor
d.None
Answer c
23. The transactions are always ……… if it always locks a data item in shared mode before reading it.
a.Well formed
b.Well distributed
c.Well locked
d.Well shared
Answer a
24. ………is a server which is widely used in relational database systems.
a. Data servers
b.Transaction server
c. Query servers
d.Client servers
Answer b
25. Which of the following transaction property will check whether all the operation of a transaction completed or none?
a. Atomicity
b. Consistency
c. Isolation
d. Durability
Answer a
26. The total ordering of operations across groups ensures ………..of transactions.
a. serializability
b. synchronizability
c. atomicity
d. durability
Answer a
27. In which state, the transaction will wait for the final statement has been executed?
a. Active
b. Failed
c. Aborted
d. partially committed
Answer d
28. The ORDER concurrency control technique is based on the ———– property.
a. ordering mechanism
b. inherent ordering
c. total ordering
d. partial ordering
Answer c
29. Transactions per rollback segment is derived from …..
a. Db_Block_Buffers
b. Processes
c. shared_Pool_size
d. buffers
Answer b
30. The …………is responsible for ensuring correct execution in the presence of failures.
a. Database Manager
b. Transaction Manager
c. Recovery Manager
d. Executive Manager
Answer a
31. A distributed transaction can be …………. if queries are issued at one or more nodes.
a. fully read-only
b. partially read-only
c. fully read-write
d. partially read-write
Answer b
32. A database administrator can manually force the COMMIT or ROLLBACK of a local ………… distributed transaction.
a.in-force
b.in-doubt
c.in-local
d.in-manual
Answer b
33. Which of the heterogeneous database systems is/are independent in nature and integrated together so that they function as a single database system?
a. Federated database
b. Unfedareated database
c. Both a and b
d. None of the above
Answer a
34. Which of the following database systems employ a central coordinating module through which the databases are accessed?
- Federated
- Un-federated
- Client-server
- None of the above
Answer b
35. Which of the following is true for a heterogeneous database system?
a. Query processing is complex due to dissimilar schemas.
b. Transaction processing is complex due to dissimilar software.
c. Different sites use dissimilar schemas and software
d. All of the above
Answer d
36. Which of the following include/s language translators to translate subqueries from the canonical language to the language of the server?
a. DBMS
b. FDBMS
c. HDBMS
d. None of the above
Answer b
37. ——————- refers to the degree to which two or more processes are interdependent.
a. Coupling
b. Cohesion
c. Integrity
d. None
Answer a
38. Which of the following is a loosely coupled system?
a. Hadoop
b. Gnutella
c. Both a and b
d. None
Answer b
39. Which of the following is a tightly coupled system?
a. Gnutella
b. Hadoop
c. Neither a nor b
d. Both a and b
Answer b
40. Which of the following use shared memory?
a. Loosely coupled
b. Tightly coupled
c. Both
d. None
Answer b
41. Which of the following have a high data rate?
a. Loosely coupled
b. Tightly coupled
c. Both
d. None
Answer b