Distributed Databases Mcqs
Our collections of Multiple choice questions and answers focuses on study of ” Distributed Databases “. These questions are chosen from a collection of most authoritative and best reference books on DBMS. Our aim is to prepare an individual for competitive exams like NTS | GAT | ECAT | Data Warehouse jobs | Data Mining | DB administration jobs | Nadra Jobs | Software House and Data Base and Web Developer jobs | University and College entrance exams and various tests and job interviews. One should practice our Mcqs to assimilate knowledge on Distributed Databases comprehensively.
17. Which transaction contains statements that access more than one node?
A Remote Transaction
A Distributed transaction
Both A & B
None of the above
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
18. 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?
Commit
Commit transaction
Two-phase commit
Three-phase commit
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
19. Stored procedures have which of the following advantages?
It takes a longer time to write them as compared to writing Visual Basic.
Network traffic increases
Data integrity improves as multiple applications access the same stored procedure.
Result in thicker client and thinner database server.
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
20. Which of the following is true concerning QBE?
An official standard has been defined for QBE.
QBE cannot be used for client/server systems.
QBE does not give the programmer a visual programming environment.
Complete applications can be written using QBE.
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
21. Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?
Each vendor desiring to be ODBC-complaint provides an ODBC driver.
Requires certain criteria to be met in order to establish an ODBC connection.
Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed.
All of the above.
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
22. Which of the following statements is true concerning JDBC?
It is language independent.
It is similar in concept to ODBC.
It is useful for all object-oriented languages.
It consists of three main layers.
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
23. A characteristic of a file server is which of the following?
Manages file operations and is shared on a network.
Manages file operations and is limited to one PC.
Acts as a fat client and is shared on a network.
Acts as a fat client and is limited to one PC.
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
24. Three-tier architecture includes which of the following?
Three server layers
A client layer and two server layers
Two client layers and one server layer
Three client layers
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
25. A database server is responsible for which of the following?
Database storage
Data processing logic
Data presentation logic
All of the above.
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
26. A benefit of the three-tier architecture is which of the following?
New modules can be built to support specific business needs
Performance improves for compiled SQL statements
Results in a thinner client and database server
All of the above.
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
27. Which of the following statements is true about symmetric multiprocessing?
A single copy of the operating system resides in each processor.
Useful for situations where data must remain in memory to process.
Bottlenecks increase with uniprocessor systems because tasks are not shared.
The problems of memory contention are unlikely.
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
28. Client/server security includes which of the following?
Physical security
Change control security
Measures taken to secure all systems
All of the above.
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
29. An application program interface (API) is which of the following?
The same thing as ODBC.
Middleware that does not provide access to a database.
Middleware that provides access to a database.
The same thing as JDBC.
Answer & Solution
No Solution for this Answer..! Report or Discus this Question
30. Which of the following items are not necessary for client/server?
Assure that tools will connect with middleware.
Understand the requirements.
Determine network bandwidth capabilities.
Include the use of a file server.
Answer & Solution
No Solution for this Answer..! Report or Discus this Question