Client Server Database - MCQ Questions and answers- Technical Aptitude

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

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

C. Bottlenecks increase with uniprocessor systems because tasks are not shared.

D. The problems of memory contention are unlikely.

A. Assure that tools will connect with middleware.

B. Understand the requirements.

C. Determine network bandwidth capabilities.

D. Include the use of a file server.

A. New modules can be built to support specific business needs

B. Performance improves for compiled SQL statements

C. Results in a thinner client and database server

D. All of the above.

A. It is language independent.

B. It is similar in concept to ODBC.

C. It is useful for all object-oriented languages.

D. It consists of three main layers.

A. Manages file operations and is shared on a network.

B. Manages file operations and is limited to one PC.

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

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

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

B. Network traffic increases.

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

D. Result in thicker client and thinner database server.

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

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

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

D. All of the above.

A. An official standard has been defined for QBE.

B. QBE cannot be used for client/server systems.

C. QBE does not give the programmer a visual programming environment.

D. Complete applications can be written using QBE.

A. Physical security

B. Change control security

C. Measures taken to secure all systems

D. All of the above

A. The same thing as ODBC.

B. Middleware that does not provide access to a database.

C. Middleware that provides access to a database.

D. The same thing as JDBC.