Client Server Database(Engineering > Computer Science And Engineering > Database System ) Questions and Answers

Question 1. Which of the following items are not necessary for client/server?
  1.    Include the use of a file server.
  2.    Determine network bandwidth capabilities.
  3.    Understand the requirements.
  4.    Assure that tools will connect with middleware.
Explanation:-
Answer: Option A. -> Include the use of a file server.
Question 2. A benefit of the three-tier architecture is which of the following?
  1.    Performance improves for compiled SQL statements
  2.    Results in a thinner client and database server
  3.    All of these
  4.    New modules can be built to support specific business needs
Explanation:-
Answer: Option D. -> New modules can be built to support specific business needs
Question 3. Which of the following statements is true about symmetric multiprocessing?
  1.    The problems of memory contention are unlikely.
  2.    Useful for situations where data must remain in memory to process.
  3.    A single copy of the operating system resides in each processor.
  4.    Bottlenecks increase with uniprocessor systems because tasks are not shared.
Explanation:-
Answer: Option B. -> Useful for situations where data must remain in memory to process.
Question 4. A characteristic of a file server is which of the following?
  1.    Manages file operations and is shared on a network.
  2.    Acts as a fat client and is limited to one P
  3.    Acts as a fat client and is shared on a network.
  4.    Manages file operations and is limited to one P
Explanation:-
Answer: Option A. -> Manages file operations and is shared on a network.
Question 5. Which of the following statements is true concerning JDBC?
  1.    It is useful for all object-oriented languages.
  2.    It consists of three main layers.
  3.    It is similar in concept to ODB
  4.    It is language independent.
Explanation:-
Answer: Option C. -> It is similar in concept to ODB
Question 6. Which of the following is true concerning QBE?
  1.    QBE cannot be used for client/server systems.
  2.    Complete applications can be written using QB
  3.    QBE does not give the programmer a visual programming environment.
  4.    An official standard has been defined for QB
Explanation:-
Answer: Option B. -> Complete applications can be written using QB
Question 7. An application program interface (API) is which of the following?
  1.    Middleware that does not provide access to a database.
  2.    The same thing as JDB
  3.    The same thing as ODB
  4.    Middleware that provides access to a database.
Explanation:-
Answer: Option D. -> Middleware that provides access to a database.
Question 8. Client/server security includes which of the following?
  1.    All of these
  2.    Change control security
  3.    Measures taken to secure all systems
  4.    Physical security
Explanation:-
Answer: Option A. -> All of these
Question 9. Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?
  1.    All of these
  2.    Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed.
  3.    Each vendor desiring to be ODBC-complaint provides an ODBC driver.
  4.    Requires certain criteria to be met in order to establish an ODBC connection.
Explanation:-
Answer: Option A. -> All of these
Question 10. Stored procedures have which of the following advantages?
  1.    Data integrity improves as multiple applications access the same stored procedure.
  2.    Result in thicker client and thinner database server.
  3.    It takes a longer time to write them as compared to writing Visual Basic.
  4.    Network traffic increases.
Explanation:-
Answer: Option A. -> Data integrity improves as multiple applications access the same stored procedure.
© Lakshya_Education.com, All Right Reserved.
Contact Us services