Stored procedures have which of the following advantages? – McqOptions

MCQOPTIONS

1.	Stored procedures have which of the following advantages?
A.	It takes a longer time to write them as compared to writing Visual Basic.
B.	Network traffic increases
C.	Data integrity improves as multiple applications access the same stored procedure.
D.	Result in thicker client and thinner database server.
Answer» D. Result in thicker client and thinner database server.

Discussion

No Comment Found

Related MCQs

Writing stored procedures takes less time than using Visual Basic or PowerBuilder to create an application.
The database server is responsible for database storage, access, and processing.
Data processing logic includes such activities as data validation and identification of processing errors.
Query-by-Example (QBE) is the most widely available direct-manipulation database query language.
ODBC requires the specific driver.
A fat client is a PC configured for handling user interfaces and some application processing, usually with no or limited local data storage.
Centralized systems are more susceptible to security threats than client/server architectures.
Client/server environments use a local area network (LAN) to support a network of personal computers, each with its own storage, that are also able to share common devices and software attached to the LAN.
An application program interface (API) is which of the following?
A server cannot serve on which of the following levels?