What is not an advantage of stored procedures?$? – McqOptions

MCQOPTIONS

1.	What is not an advantage of stored procedures?$?
A.	Greater security
B.	SQL can be optimized
C.	Code sharing
D.	Increased network traffic
Answer» E.

Discussion

No Comment Found

Related MCQs

Three types of triggers are: BEFORE, AFTER and EXCEPTION.~!
A view that contains a computed column can be easily updated.~!
SQL statements can be embedded in triggers, stored procedures, and program code.~!
There are three SQL data modification operations: insert, modify and delete.~!
SQL Server does not support the BEFORE trigger.~!
A SQL view is a virtual table that is constructed from other tables or views.~!
When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.~!
The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.%!
A stored procedure is a program that performs some common action on database data and is stored in the database.%!
If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.%!