Home
10th Grade
11th And 12th
11th Grade
12th Grade
3rd Grade
4th Grade
5th Grade
6th Grade
7th Grade
8th Grade
9th Grade
Advance Accountancy
Auditing
Computer Aptitude
Direct And Indirect Taxation
Exams
General Hindi
Indian Finance System
Information Technology And Application In Business
Macro Economics
Town Planning
Aerospace And Aeronautical
Analytical Instrumentation
Banking Awareness
Banking Exam
Biochemistry
Bioinformatics
Biology
Biotechnology
Business Statistics
C Program
C Programming
C++ Programming
Career Aptitude Test
Cell Biology
Central Superior Service (css)
Chemical Engineering
Chemistry
Civil Engineering
Commerce
Computer
Computer Fundamentals
Computer Science
Cost Accounting
Css
Database
Drug And Pharmaceutical Biotechnology
Ecat And Mcat Entry Test
Economics
Electrical Engineering
Electrical Engineering Questions
Electrical Measurement And Instrumentation
Engineering
English
English Literature
Environment Management
Environmental Biotechnology
Enzyme Technology
Financial Management And Financial Markets
Gate
General Knowledge
Graduate Assessment Test (gat)
Health And Physical
Heat Transfer
Html
Human Anatomy And Physiology
Human And Cultural Diversity
Human Resource Management
Ias
Indian Economy
Indian Economy
Indian General Awareness
Indian Geography
Indian Geography
Indian History
Indian History
Indian Polity
Instrumentation Transducers
International Relations
Java Program
Javascript
Judiciary And Law
Life Sciences
Management
Marketing And Marketing Management
Mass Transfer
Mechanical Engineering
Mechanics Of Materials
Medical Subjects
Microbiology
Networking
Php
Placement Tests
Professional Communication
Quantitative Aptitude
Reasoning Aptitude
Renewable Energy
Science
Sociology
Sql
Surveying
Total Quality Management
Uidai Aadhaar Supervisor Certification
Virology
Notificatin
Exam
Blog
Contact Us
Distributed Databases(Database ) Questions and Answers
Home
Topic
Database
Distributed Databases
Question 1.
A distributed database has which of the following advantages over a centralized database?
Software cost
Software complexity
Slow Response
Modular growth
Explanation:-
Answer: Option D. ->
Modular growth
Question 2.
An autonomous homogenous environment is which of the following?
The same DBMS is at each node and each DBMS works independently.
The same DBMS is at each node and a central DBMS coordinates database access.
A different DBMS is at each node and each DBMS works independently.
A different DBMS is at each node and a central DBMS coordinates database access.
Explanation:-
Answer: Option A. ->
The same DBMS is at each node and each DBMS works independently.
Question 3.
Location transparency allows for which of the following?
Users to treat the data as if it is at one location
Programmers to treat the data as if it is at one location
Managers to treat the data as if it is at one location
All of the above
Explanation:-
Answer: Option D. ->
All of the above
Question 4.
A transaction manager is which of the following?
Maintains a log of transactions
Maintains before and after database images
Maintains appropriate concurrency control
All of the above
Explanation:-
Answer: Option D. ->
All of the above
Question 5.
A heterogeneous distributed database is which of the following?
The same DBMS is used at each location and data are not distributed across all nodes.
The same DBMS is used at each location and data are distributed across all nodes.
A different DBMS is used at each location and data are not distributed across all nodes.
A different DBMS is used at each location and data are distributed across all nodes.
Explanation:-
Answer: Option D. ->
A different DBMS is used at each location and data are distributed across all nodes.
Question 6.
A semijoin is which of the following?
Only the joining attributes are sent from one site to another and then all of the rows are returned.
All of the attributes are sent from one site to another and then only the required rows are returned.
Only the joining attributes are sent from one site to another and then only the required rows are returned.
All of the attributes are sent from one site to another and then only the required rows are returned.
Explanation:-
Answer: Option C. ->
Only the joining attributes are sent from one site to another and then only the required rows are returned.
Question 7.
A distributed database is which of the following?
A single logical database that is spread to multiple locations and is interconnected by a network
A loose collection of file that is spread to multiple locations and is interconnected by a network
A single logical database that is limited to one location.
A loose collection of file that is limited to one location.
Explanation:-
Answer: Option A. ->
A single logical database that is spread to multiple locations and is interconnected by a network
Question 8.
Which of the following is a disadvantage of replication?
Reduced network traffic
If the database fails at one site, a copy can be located at another site.
Each site must have the same storage capacity.
Each transaction may proceed without coordination across the network.
Explanation:-
Answer: Option C. ->
Each site must have the same storage capacity.
Question 9.
A distributed database can use which of the following strategies?
Totally centralized at one location and accessed by many sites
Partially or totally replicated across sites
Partitioned into segments at different sites
All of the above
Explanation:-
Answer: Option D. ->
All of the above
Question 10.
Which of the following is not one of the stages in the evolution of distributed DBMS?
Unit of work
Remote unit of work
Distributed unit of Work
Distributed request
Explanation:-
Answer: Option A. ->
Unit of work
1
2
3
Next →
One click Login
Login With Google
Old way of Login
Login With Email