Question

Some of the columns of a relation are at different sites is which of the following?

a.

Data Replication

b.

Horizontal Partitioning

c.

Vertical Partitioning

d.

Horizontal and Vertical Partitioning

Posted under Distributed Databases DBMS

Answer: (c).Vertical Partitioning

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Some of the columns of a relation are at different sites is which of the following?

Add Comment

Similar Questions

Discover Related MCQs

Q. Which of the following is true concerning a global transaction?

View solution

Q. A homogeneous distributed database is which of the following?

View solution

Q. Replication should be used when which of the following exist?

View solution

Q. Storing a separate copy of the database at multiple locations is which of the following?

View solution

Q. A distributed database is which of the following?

View solution

Q. A semijoin is which of the following?

View solution

Q. Which of the following is a disadvantage of replication?

View solution

Q. A distributed database can use which of the following strategies?

View solution

Q. Which of the following is not one of the stages in the evolution of distributed DBMS?

View solution

Q. A distributed transaction can be ............. if queries are issued at one or more nodes.

View solution

Q. Depending on the situation each node in the Distributed Database system can act as, _________ .

View solution

Q. Which transaction contains statements that access more than one node?

View solution

Q. What is the mechanism which guarantees that all database servers participating in a distributed transaction either all commit or all roll back the statements in the transaction?

View solution

Q. Stored procedures have which of the following advantages?

View solution

Q. Which of the following is true concerning QBE?

View solution

Q. Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?

View solution

Q. Which of the following statements is true concerning JDBC?

View solution

Q. A characteristic of a file server is which of the following?

View solution

Q. Three-tier architecture includes which of the following?

View solution

Q. A database server is responsible for which of the following?

View solution

View All MCQs on Distributed Databases

Suggested Topics

Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Formal Languages and Automata Theory

Discover the mathematical models of computation with our Formal Languages and...

Visual Basic

Enhance your knowledge of Microsoft's event-driven programming language with our...

Java Spring Framework

Enhance your Java development skills with our Spring Framework MCQs. Learn about...

Cryptography and Network Security

Secure your knowledge of information security with our Cryptography and Network...

Artificial Intelligence

Get started on the path to the future with our Artificial Intelligence MCQs. Covering...

Computer Architecture

Unveil the science behind computer design with our Computer Architecture MCQs. Topics...

UNIX

Become proficient with the Unix operating system using our UNIX MCQs. Learn about...

Cloud Computing

Stay on top of the biggest trend in IT with our Cloud Computing MCQs. These questions...

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...