DBMS - DISTRIBUTED DATABASES MCQ
- A distributed database has which of the following advantages over a centralized database?
- An autonomous homogenous environment is which of the following?
- A transaction manager is which of the following?
- Location transparency allows for which of the following?
- A heterogeneous distributed database is which of the following?
- Some of the columns of a relation are at different sites is which of the following?
- Which of the following is true concerning a global transaction?
- A homogeneous distributed database is which of the following?
- Replication should be used when which of the following exist?
- Storing a separate copy of the database at multiple locations is which of the following?
- A distributed database is which of the following?
- A semijoin is which of the following?
- Which of the following is a disadvantage of replication?
- A distributed database can use which of the following strategies?
- Which of the following is not one of the stages in the evolution of distributed DBMS?
- A distributed transaction can be ............. if queries are issued at one or more nodes
- Depending on the situation each node in the Distributed Database system can act as, _________
- Which transaction contains statements that access more than one node?
- 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?
- Stored procedures have which of the following advantages?
- Which of the following is true concerning QBE?
- Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?
- Which of the following statements is true concerning JDBC?
- A characteristic of a file server is which of the following?
- Three-tier architecture includes which of the following?
- A database server is responsible for which of the following?
- A benefit of the three-tier architecture is which of the following?
- Which of the following statements is true about symmetric multiprocessing?
- Client/server security includes which of the following?
- An application program interface (API) is which of the following?
- Which of the following items are not necessary for client/server?
- The three different application logic components are which of the following?
- Which of the following is true concerning the mainframe?
- A server cannot serve on which of the following levels?
- Websites without a database attached to them have which of the following characteristics?
- Which of the following is true concerning the standard network protocol for connecting a client to a Web or database server via the Internet?
- An intranet provides which of the following?
- A proxy server is used for which of the following?
- What is Hypertext Transfer Protocol (HTTP)?
- XML is which of the following?
- A server-side extension is needed to do what?
- Client-side extensions:
- Which of the following is true concerning Web services standards?
- Which of the following is true about Microsoft Active Server Pages (ASP)?
- Features of XML include which of the following?
- An intrusion detection system does not perform which of the following?
- Web servers should be configured in which of the following ways?
- A homogenous distributed database is which of the following?
- A _____ DBMS distributes data processing tasks between the workstation and a network server
Database
(c).Only the joining attributes are sent from one site to another and then only the required rows are returned.
need an explanation for this answer? contact us directly to get an explanation for this answer