Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
A.
processing only local temporary variables
B.
processing a query whose required data may reside at multiple sites
C.
backing up one file manually
D.
compiling Java code in a DBMS
Show Answer
Correct Answer: B. processing a query whose required data may reside at multiple sites
Explanation:
The correct answer explains distributed query processing in the context of Distributed Databases.
Choose an option to check your answer.
A.
a non-relational database approach designed for flexible schemas and scalable data models
B.
a database that forbids all indexing
C.
a database that can run only on one laptop
D.
a database that never stores data
Show Answer
Correct Answer: A. a non-relational database approach designed for flexible schemas and scalable data models
Explanation:
NoSQL database is used in Advanced DBMS because a non-relational database approach designed for flexible schemas and scalable data models.
Choose an option to check your answer.
A.
forcing users to manually choose every disk sector
B.
hiding distribution details such as location, fragmentation, or replication from users
C.
preventing SQL queries from executing
D.
showing every physical block address to every user
Show Answer
Correct Answer: B. hiding distribution details such as location, fragmentation, or replication from users
Explanation:
The correct answer explains distributed DBMS transparency in the context of Distributed Databases.
Choose an option to check your answer.
A.
processing a query whose required data may reside at multiple sites
B.
compiling Java code in a DBMS
C.
backing up one file manually
D.
processing only local temporary variables
Show Answer
Correct Answer: A. processing a query whose required data may reside at multiple sites
Explanation:
distributed query processing is used in Advanced DBMS because processing a query whose required data may reside at multiple sites.
Choose an option to check your answer.
A.
a non-relational database approach designed for flexible schemas and scalable data models
B.
a database that can run only on one laptop
C.
a database that never stores data
D.
a database that forbids all indexing
Show Answer
Correct Answer: A. a non-relational database approach designed for flexible schemas and scalable data models
Explanation:
This statement is correct because NoSQL database means that a non-relational database approach designed for flexible schemas and scalable data models.
Choose an option to check your answer.
A.
showing every physical block address to every user
B.
forcing users to manually choose every disk sector
C.
preventing SQL queries from executing
D.
hiding distribution details such as location, fragmentation, or replication from users
Show Answer
Correct Answer: D. hiding distribution details such as location, fragmentation, or replication from users
Explanation:
distributed DBMS transparency is used in Advanced DBMS because hiding distribution details such as location, fragmentation, or replication from users.
Choose an option to check your answer.
A.
processing a query whose required data may reside at multiple sites
B.
compiling Java code in a DBMS
C.
processing only local temporary variables
D.
backing up one file manually
Show Answer
Correct Answer: A. processing a query whose required data may reside at multiple sites
Explanation:
This statement is correct because distributed query processing means that processing a query whose required data may reside at multiple sites.
Choose an option to check your answer.
A.
a model that cannot store nested data
B.
a model that stores only fixed two-column tables
C.
a NoSQL model that stores semi-structured documents such as JSON or BSON
D.
a model used only for transaction logs
Show Answer
Correct Answer: C. a NoSQL model that stores semi-structured documents such as JSON or BSON
Explanation:
The correct answer explains document database in the context of NoSQL.
Choose an option to check your answer.
A.
hiding distribution details such as location, fragmentation, or replication from users
B.
showing every physical block address to every user
C.
preventing SQL queries from executing
D.
forcing users to manually choose every disk sector
Show Answer
Correct Answer: A. hiding distribution details such as location, fragmentation, or replication from users
Explanation:
This statement is correct because distributed DBMS transparency means that hiding distribution details such as location, fragmentation, or replication from users.
Choose an option to check your answer.
A.
deleting remote data after a query
B.
forcing every query to run centrally
C.
turning all local data into passwords
D.
transforming a distributed query into operations on fragments at relevant sites
Show Answer
Correct Answer: D. transforming a distributed query into operations on fragments at relevant sites
Explanation:
The correct answer explains data localization in the context of Distributed Databases.
Choose an option to check your answer.
A.
a model that cannot store nested data
B.
a NoSQL model that stores semi-structured documents such as JSON or BSON
C.
a model used only for transaction logs
D.
a model that stores only fixed two-column tables
Show Answer
Correct Answer: B. a NoSQL model that stores semi-structured documents such as JSON or BSON
Explanation:
document database is used in Advanced DBMS because a NoSQL model that stores semi-structured documents such as JSON or BSON.
Choose an option to check your answer.
A.
all data must be stored in one location
B.
users must specify exact disk addresses
C.
users can access data without knowing its physical site location
D.
queries cannot access remote data
Show Answer
Correct Answer: C. users can access data without knowing its physical site location
Explanation:
The correct answer explains location transparency in the context of Distributed Databases.
