Q.1
Three-tier architecture includes which of the following?
  • Three server layers
  • A client layer and two server layers
  • Two client layers and one server layer
  • Three client layers
Q.2
An application program interface (API) is which of the following?
  • The same thing as ODB
  • Middleware that does not provide access to a database.
  • Middleware that provides access to a database.
  • The same thing as JDB
Q.3
Client/server security includes which of the following?
  • Physical security
  • Change control security
  • Measures taken to secure all systems
  • All of the above
Q.4
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.
Q.5
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.
Q.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.
Q.7
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 P
  • Acts as a fat client and is shared on a network.
  • Acts as a fat client and is limited to one P
Q.8
Which of the following statements is true concerning JDBC?
  • It is language independent.
  • It is similar in concept to ODB
  • It is useful for all object-oriented languages.
  • It consists of three main layers.
Q.9
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.
Q.10
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.
Q.11
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.
Q.12
Central Computer which is powerful than other computers in the network is called as __________.
  • Client
  • Server
  • Hub
  • Both A & B
Q.13
Writing stored procedures takes less time than using Visual Basic or PowerBuilder to create an application.
  • True
  • False
Q.14
Each server in a computer dedicated server network is known as
  • dedicated server
  • dedicated receiver
  • dedicated client
  • None of these
Q.15
Network in which each computer is either acts as server or a client is called
  • dedicated server network
  • peer-to-peer network
  • metropolitan area network
  • dedicated server network
Q.16
The WWW today is a _______ client-server service, in which a client using a browser can access a service using a server.
  • limited
  • vast
  • Both A & B
  • distributed
Q.17
In RPC (remote procedure call), while a server is processing the call, the client is blocked
  • unless the call processing is complete
  • for the complete duration of the connection
  • unless the client sends an asynchronous request to the server
Q.18
An RPC application requires
  • specific protocol for client server communication
  • a client program
  • a server program
  • all of the above
Q.19
RPC (remote procedure call) is used to
  • establish a server on remote machine that can respond to queries
  • retrieve information by calling a query
  • Both A & B
  • None of these
Q.20
In remote procedure call, the client program must be bound with a small library procedure called ...................
  • Server stub
  • Marshalling
  • Client hub
  • Client stub
0 h : 0 m : 1 s