Practice Library
All MCQs
Browse exam-wise, subject-wise, and country-wise MCQs with explanations.
Choose an option to check your answer.
A.
users must join fragments manually every time
B.
fragments must be encrypted only
C.
users need not know how relations are fragmented across sites
D.
fragments cannot be reconstructed
Show Answer
Correct Answer: C. users need not know how relations are fragmented across sites
Explanation:
This statement is correct because fragmentation transparency means that users need not know how relations are fragmented across sites.
Choose an option to check your answer.
A.
users need not know how relations are fragmented across sites
B.
users must join fragments manually every time
C.
fragments cannot be reconstructed
D.
fragments must be encrypted only
Show Answer
Correct Answer: A. users need not know how relations are fragmented across sites
Explanation:
fragmentation transparency is used in Advanced DBMS because users need not know how relations are fragmented across sites.
Choose an option to check your answer.
A.
users must join fragments manually every time
B.
fragments cannot be reconstructed
C.
users need not know how relations are fragmented across sites
D.
fragments must be encrypted only
Show Answer
Correct Answer: C. users need not know how relations are fragmented across sites
Explanation:
The correct answer explains fragmentation transparency in the context of Distributed Databases.
Choose an option to check your answer.
A.
users can access data without knowing its physical site location
B.
users must specify exact disk addresses
C.
queries cannot access remote data
D.
all data must be stored in one location
Show Answer
Correct Answer: A. users can access data without knowing its physical site location
Explanation:
This statement is correct because location transparency means that users can access data without knowing its physical site location.
Choose an option to check your answer.
A.
users can access data without knowing its physical site location
B.
users must specify exact disk addresses
C.
queries cannot access remote data
D.
all data must be stored in one location
Show Answer
Correct Answer: A. users can access data without knowing its physical site location
Explanation:
location transparency is used in Advanced DBMS because users can access data without knowing its physical site location.
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.
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.
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.
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.
a database stored only on one personal computer
B.
a database without any schema or users
C.
a logically related database whose data is stored across multiple networked sites
D.
a backup file outside the DBMS
Show Answer
Correct Answer: C. a logically related database whose data is stored across multiple networked sites
Explanation:
This statement is correct because distributed database means that a logically related database whose data is stored across multiple networked sites.
Choose an option to check your answer.
A.
a database stored only on one personal computer
B.
a logically related database whose data is stored across multiple networked sites
C.
a backup file outside the DBMS
D.
a database without any schema or users
Show Answer
Correct Answer: B. a logically related database whose data is stored across multiple networked sites
Explanation:
distributed database is used in Advanced DBMS because a logically related database whose data is stored across multiple networked sites.
Choose an option to check your answer.
A.
a database stored only on one personal computer
B.
a database without any schema or users
C.
a logically related database whose data is stored across multiple networked sites
D.
a backup file outside the DBMS
Show Answer
Correct Answer: C. a logically related database whose data is stored across multiple networked sites
Explanation:
The correct answer explains distributed database in the context of Distributed Databases.
