Client Server Database MCQs with Explanations

Useful for situations where data must remain in memory to process. is the correct answer to “Which of the following statements is true about symmetric multiprocessing”. This question is standard in competitive examination syllabi for Client Server Database.

Include the use of a file server. is the correct answer to “Which of the following items are not necessary for client/server”. This question is standard in competitive examination syllabi for Client Server Database.

New modules can be built to support specific business needs is the correct answer to “A benefit of the three-tier architecture is which of the following”. This question is standard in competitive examination syllabi for Client Server Database.

It is similar in concept to ODBC. is the correct answer to “Which of the following statements is true concerning JDBC”. This question is standard in competitive examination syllabi for Client Server Database.

Manages file operations and is shared on a network. is the correct answer to “A characteristic of a file server is which of the following”. This question is standard in competitive examination syllabi for Client Server Database.

Data integrity improves as multiple applications access the same stored procedure. is the correct answer to “Stored procedures have which of the following advantages”. This question is standard in competitive examination syllabi for Client Server Database.

All of the above. is the correct answer to “Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)”. This question is standard in competitive examination syllabi for Client Server Database.

Complete applications can be written using QBE. is the correct answer to “Which of the following is true concerning QBE”. This question is standard in competitive examination syllabi for Client Server Database.

All of the above is the correct answer to “Client/server security includes which of the following”. This question is standard in competitive examination syllabi for Client Server Database.

Middleware that provides access to a database. is the correct answer to “An application program interface (API) is which of the following”. This question is standard in competitive examination syllabi for Client Server Database.

A client layer and two server layers is the correct answer to “Three-tier architecture includes which of the following”. This question is standard in competitive examination syllabi for Client Server Database.

Mission-critical systems have tended to remain there. is the correct answer to “Which of the following is true concerning the mainframe”. This question is standard in competitive examination syllabi for Client Server Database.

Client Layer is the correct answer to “A server cannot serve on which of the following levels”. This question is standard in competitive examination syllabi for Client Server Database.

Presentation, Processing, and Storage is the correct answer to “The three different application logic components are which of the following”. This question is standard in competitive examination syllabi for Client Server Database.

Database storage is the correct answer to “A database server is responsible for which of the following”. This question is standard in competitive examination syllabi for Client Server Database.

False is the correct answer to “Activities of a DBMS occur in the processing component logic.”. This question is standard in competitive examination syllabi for Client Server Database.

True is the correct answer to “The presentation logic component is responsible for formatting and presenting data on the user's screen or other output device, and for managing user input from a keyboard or other input device.”. This question is standard in competitive examination syllabi for Client Server Database.

True is the correct answer to “Symmetric multiprocessing (SMP) architectures are useful for situations where data must remain in memory during processing to achieve the desired performance level.”. This question is standard in competitive examination syllabi for Client Server Database.

True is the correct answer to “Massively parallel processing (MPP) systems require a complete copy of the operating system to be resident in each dedicated memory.”. This question is standard in competitive examination syllabi for Client Server Database.

True is the correct answer to “The Windows operating system and Windows applications are event driven.”. This question is standard in competitive examination syllabi for Client Server Database.

False is the correct answer to “With an asynchronous system, the requesting system waits for a response in real time.”. This question is standard in competitive examination syllabi for Client Server Database.

True is the correct answer to “Query-by-Example (QBE) is the most widely available direct-manipulation database query language.”. This question is standard in competitive examination syllabi for Client Server Database.

False is the correct answer to “A fat client is a PC configured for handling user interfaces and some application processing, usually with no or limited local data storage.”. This question is standard in competitive examination syllabi for Client Server Database.

True is the correct answer to “Client/server environments use a local area network (LAN) to support a network of personal computers, each with its own storage, that are also able to share common devices and software attached to the LAN.”. This question is standard in competitive examination syllabi for Client Server Database.

True is the correct answer to “The database server is responsible for database storage, access, and processing.”. This question is standard in competitive examination syllabi for Client Server Database.

True is the correct answer to “The first client/server architectures developed were file servers.”. This question is standard in competitive examination syllabi for Client Server Database.

False is the correct answer to “Centralized systems are more susceptible to security threats than client/server architectures.”. This question is standard in competitive examination syllabi for Client Server Database.

False is the correct answer to “Writing stored procedures takes less time than using Visual Basic or PowerBuilder to create an application.”. This question is standard in competitive examination syllabi for Client Server Database.

True is the correct answer to “Data processing logic includes such activities as data validation and identification of processing errors.”. This question is standard in competitive examination syllabi for Client Server Database.

True is the correct answer to “ODBC requires the specific driver.”. This question is standard in competitive examination syllabi for Client Server Database.