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
Support mcqgeeks.com by disabling your adblocker.
Please disable the adBlock and continue. Thank you.