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