Merits of employing stored procedures
Illustrate the main merits of employing stored procedures?
Expert
The merits of stored procedures are as follows:
(1) Superior security,
(2) Reduced the network traffic.
(3) Fact which the SQL can be optimized.
(4) Code sharing that leads to less work, specialization among developers.and standardized processing.
What do you mean by the term Open Server in the Sybase?
Describe briefly the difference between a Java applet and a Java servlet?
Clarify briefly why dimension tables is de-normalized in the nature?
Write about the Sequencers?
Explain the following term: a) OLAP b) OLTP
Explain the Normalizer transformation?
Specify the types of connections we use while connecting with the database?
Explain the relationship between JDBC and Sybase.
Explain the object qualification?
Explain the command line functions which export and import the DS jobs?
18,76,764
1937133 Asked
3,689
Active Tutors
1450567
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!