CLIENT SERVER DATABASE QUIZ

Results in a thinner client and database server

New modules can be built to support specific business needs

Performance improves for compiled SQL statements

All of these

False

True

True

False

Data presentation logic

Data processing logic

All of these

Database storage

It consists of three main layers.

It is language independent.

It is similar in concept to ODB

It is useful for all object-oriented languages.

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

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

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

All of these

False

True

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

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

The problems of memory contention are unlikely.

Bottlenecks increase with uniprocessor systems because tasks are not shared.

Understand the requirements.

Determine network bandwidth capabilities.

Include the use of a file server.

Assure that tools will connect with middleware.

All of these

Physical security

Change control security

Measures taken to secure all systems