DBMS-Distributed Database Systems Questions and Answers

Practice Mode
Showing 10 of 49 questions
Q31
The main components of the client/server architecture is
  • A communication networks
  • B server
  • C application softwares
  • D All of these
Answer: Option D
Q32
Which of the following is not a benefit of client/server architecture ?
  • A Reduction in operating cost
  • B Adaptablility
  • C Platform independence
  • D None of these
Answer: Option D
Q33
Which of the following are the components of DDBS ?
  • A Communication network
  • B Server
  • C Client
  • D All of these
Answer: Option D
Q34
Which of the computing architecture is used by DDBS
  • A Client/Server computing
  • B Mainframe computing
  • C Personal computing
  • D None of these
Answer: Option A
Q35
In collaborating server architecture.
  • A there are several database servers.
  • B Each server is capable of running transactions against local data.
  • C Transactions are executed spannng multiple servers.
  • D All of these.
Answer: Option D
Q36
The middleware database architecture
  • A is designed to allow single query to span multiple servers.
  • B provides users with a consistent interface to multiple DBMSs and file systems in a transparent manner.
  • C provides users with a means of accessing live data in multiple sources.
  • D All of these
Answer: Option D
Q37
Data ragmentation is a
  • A technique of breaking up the database into logical units, which may be assigned for storage at the various sites.
  • B process of deciding about locating (or placing) data to several sites.
  • C technique that permits storage of certain data in more than one site.
  • D None of these.
Answer: Option A
Q38
A horizontal fragmentation is produced by specifying a
  • A predicate operation of relational algebra.
  • B projection operation of relational algebra.
  • C selection and projection operations of relational algebra.
  • D None of these.
Answer: Option A
Q39
A vertical fragmentation is produced by specifying a
  • A predicate operation of relational algebra.
  • B projection operation of relational algebra.
  • C selection and projection operations of relational jalgebra.
  • D None of these.
Answer: Option B
Q40
A mied ragmentation is produced by specifying a
  • A predicate operation of relational algebra.
  • B projection operation of relationalj algebra.
  • C selection and projection operations of relationalj algebra.
  • D None of these.
Answer: Option C

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test