Client Server Database(Database ) Questions and Answers

Question 1. A benefit of the three-tier architecture is which of the following?
  1.    New modules can be built to support specific business needs
  2.    Performance improves for compiled SQL statements
  3.    Results in a thinner client and database server
  4.    All of the above.
Explanation:-
Answer: Option A. -> New modules can be built to support specific business needs
Question 2. Which of the following statements is true about symmetric multiprocessing?
  1.    A single copy of the operating system resides in each processor.
  2.    Useful for situations where data must remain in memory to process.
  3.    Bottlenecks increase with uniprocessor systems because tasks are not shared.
  4.    The problems of memory contention are unlikely.
Explanation:-
Answer: Option B. -> Useful for situations where data must remain in memory to process.
Question 3. Which of the following items are not necessary for client/server?
  1.    Assure that tools will connect with middleware.
  2.    Understand the requirements.
  3.    Determine network bandwidth capabilities.
  4.    Include the use of a file server.
Explanation:-
Answer: Option D. -> Include the use of a file server.
Question 4. Which of the following statements is true concerning JDBC?
  1.    It is language independent.
  2.    It is similar in concept to ODBC.
  3.    It is useful for all object-oriented languages.
  4.    It consists of three main layers.
Explanation:-
Answer: Option B. -> It is similar in concept to ODBC.
Question 5. A characteristic of a file server is which of the following?
  1.    Manages file operations and is shared on a network.
  2.    Manages file operations and is limited to one PC.
  3.    Acts as a fat client and is shared on a network.
  4.    Acts as a fat client and is limited to one PC.
Explanation:-
Answer: Option A. -> Manages file operations and is shared on a network.
Question 6. Three-tier architecture includes which of the following?
  1.    Three server layers
  2.    A client layer and two server layers
  3.    Two client layers and one server layer
  4.    Three client layers
Explanation:-
Answer: Option B. -> A client layer and two server layers
Question 7. Which of the following is true concerning the mainframe?
  1.    It is the same thing as client/server.
  2.    Requires someone to decide which code should be on the workstation or the server.
  3.    Mission-critical systems have tended to remain there.
  4.    All of the above.
Explanation:-
Answer: Option C. -> Mission-critical systems have tended to remain there.
Question 8. A database server is responsible for which of the following?
  1.    Database storage
  2.    Data processing logic
  3.    Data presentation logic
  4.    All of the above
Explanation:-
Answer: Option A. -> Database storage
Question 9. A server cannot serve on which of the following levels?
  1.    Client Layer
  2.    Business Layer
  3.    Database Layer
  4.    All of the above
Explanation:-
Answer: Option A. -> Client Layer
Question 10. The three different application logic components are which of the following?
  1.    Presentation, Client, and Storage
  2.    Presentation, Client, and Processing
  3.    Presentation, Processing, and Storage
  4.    Presentation, Processing, and Network
Explanation:-
Answer: Option C. -> Presentation, Processing, and Storage
© Lakshya_Education.com, All Right Reserved.
Contact Us services