Answer / vijay

Stored procedures are precompiled database queries that
improve the security, efficiency and usability of database
client/server applications. Developers specify a stored
procedure in terms of input and output variables. They then
compile the code on the database platform and make it
available to aplication developers for use in other
environments, such as web applications. All of the major
database platforms, including Oracle, SQL Server and MySQL
support stored procedures. The major benefits of this
technology are the substantial performance gains from
precompiled execution, the reduction of client/server
traffic, development efficiency gains from code reuse and
abstraction and the security controls inherent in granting
users permissions on specific stored procedures instead of
the underlying database tables.

Answer / hokar

stored procedure is a set of sql statements that are stored
in the database on a server rather than storing it in the
database.

Answer / casmir

stored procedure is a set of sql statements that are stored
in the database on a server rather than storing it in the
database.

How much space does sql server 2016 take?

0 Answers  

---

This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

0 Answers   TCS,

---

What is GUID in sql server?

0 Answers   BirlaSoft,

---

What is normalization in Database ?

4 Answers  

---

Explain the categories of stored procedure?

0 Answers  

---

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

0 Answers   ABC, TCS,

---

What do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  

---

what is difference between having and where clause ?

3 Answers  

---

whate is advantages of sql server 2000

0 Answers  

---

Explain what is the difference between union and union all?

0 Answers  

---

What do you understand by physical_only option in dbcc checkdb?

0 Answers  

---

Explain transaction server explicit transaction?

0 Answers  

---