Client Server Database MCQs

Question 1

Which of the following statements is true about symmetric multiprocessing?

Accepted Answer

Useful for situations where data must remain in memory to process.

Answer

A single copy of the operating system resides in each processor.

Answer

Bottlenecks increase with uniprocessor systems because tasks are not shared.

Answer

The problems of memory contention are unlikely.

Question 2

Which of the following items are not necessary for client/server?

Accepted Answer

Include the use of a file server.

Answer

Assure that tools will connect with middleware.

Answer

Understand the requirements.

Answer

Determine network bandwidth capabilities.

Question 3

A benefit of the three-tier architecture is which of the following?

Accepted Answer

New modules can be built to support specific business needs

Answer

Performance improves for compiled SQL statements

Answer

Results in a thinner client and database server

Answer

All of the above.

Question 4

Which of the following statements is true concerning JDBC?

Accepted Answer

It is similar in concept to ODBC.

Answer

It is language independent.

Answer

It is useful for all object-oriented languages.

Answer

It consists of three main layers.

Question 5

A characteristic of a file server is which of the following?

Accepted Answer

Manages file operations and is shared on a network.

Answer

Manages file operations and is limited to one PC.

Answer

Acts as a fat client and is shared on a network.

Answer

Acts as a fat client and is limited to one PC.

Question 6

Stored procedures have which of the following advantages?

Accepted Answer

Data integrity improves as multiple applications access the same stored procedure.

Answer

It takes a longer time to write them as compared to writing Visual Basic.

Answer

Network traffic increases.

Answer

Result in thicker client and thinner database server.

Question 7

Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?

Accepted Answer

All of the above.

Answer

Each vendor desiring to be ODBC-complaint provides an ODBC driver.

Answer

Requires certain criteria to be met in order to establish an ODBC connection.

Answer

Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed.

Question 8

Which of the following is true concerning QBE?

Accepted Answer

Complete applications can be written using QBE.

Answer

An official standard has been defined for QBE.

Answer

QBE cannot be used for client/server systems.

Answer

QBE does not give the programmer a visual programming environment.

Question 9

Client/server security includes which of the following?

Accepted Answer

All of the above

Answer

Physical security

Answer

Change control security

Answer

Measures taken to secure all systems