An application program interface (API) is which of the following? The same thing as ODB Middleware that does not provide access to a database. The same thing as JDB Middleware that provides access to a database. TRUE ANSWER : ? YOUR ANSWER : ?
Stored procedures have which of the following advantages? Result in thicker client and thinner database server. 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. TRUE ANSWER : ? YOUR ANSWER : ?
Client/server security includes which of the following? Physical security Change control security All of these Measures taken to secure all systems TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following statements is true about symmetric multiprocessing? The problems of memory contention are unlikely. 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. TRUE ANSWER : ? YOUR ANSWER : ?
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 these TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following statements is true concerning JDBC? It consists of three main layers. It is similar in concept to ODB It is useful for all object-oriented languages. It is language independent. TRUE ANSWER : ? YOUR ANSWER : ?
The database server is responsible for database storage, access, and processing. True False TRUE ANSWER : ? YOUR ANSWER : ?
The first client/server architectures developed were file servers. True False TRUE ANSWER : ? YOUR ANSWER : ?
With an asynchronous system, the requesting system waits for a response in real time. False True TRUE ANSWER : ? YOUR ANSWER : ?