Stored procedures have which of the following advantages?

A It takes a longer time to write them as compared to writing Visual Basic.
B Data integrity improves as multiple applications access the same stored procedure.
C Network traffic increases
D Result in thicker client and thinner database server.

Correct Answer: Data integrity improves as multiple applications access the same stored procedure.

Bissoy MCQ
#Database

Related Questions

What is not an advantage of stored procedures?
A Greater security
B SQL can be optimized
C Code sharing
D Increased network traffic
Read the paragraph and answer the question-photosynthesis is a process in which radiant energy from sun is stored as chemical energy , which in turn is used to decompose carbon dioxide and water. The product of their decomposition are recombined into a new compound which successively builds, up into more and more complex organic substances like sugars, starches and cellulose that comprise the plant.The word stored in the paragraph is closest in morning to
A specified
B retained
C converted
D discovered
Semiconductor memory device in which stored data will remain permanently stored as long as power is supplied is --
A dynamic memory device
B storage device
C flash device
D static memory device
The strain energy stored in a body, when suddenly loaded, is __________ the strain energy stored when same load is applied gradually.
A Equal to
B One-half
C Twice
D Four times
Working at home might seem like an interesting option. However, _____ contact with other co-workers does have advantages.
A tele conferencing
B communication
C face-to face
D top-to-bottom
E None of the above
What advantages do ICs have over discrete-device circuits due to their greater complexity (i.e. more circuitary in less area)
A Smaller size
B Higher reliability
C Lower cost
D All of the above
E None of the above
Which one of the following is not a valid reason for the disparity of international accounting procedures ?
A The problems of translation from one language to another
B The nature of the country's legal system
C The relationship between taxation requirements and financial reporting requirements
D The relative strength of the accounting profession
Which of the following level of managers develop short and medium range plans, schedules, and budgets and specify the policies, procedures, and business objectives for their sub units of the company?
A Strategic
B Tactical
C Operational
D Front Line
Which of the following represents processor activities, methods, and procedures in a data flow diagram?
A datagram
B actigram
C feed back
D flow chart
E None of the above
Reactionary haemorrhage is a more frequent complication in following surgical procedures
A Thyroidectomy
B Cholecystectomy
C Tonsillectomy
D Parotidectomy
E Haemorrhoidectomy

Next steps