Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
Online Practice Test
>
SQL Server 3
« Previous
Next »
___________________repeatedly sent from the client are compiled and optimized every time they are executed by SQL Server.
Options
- Transact-SQL statements
- Stored Procedures
CORRECT ANSWER : Transact-SQL statements
Discussion Board
Transact-SQL statements
Transact-SQL statements repeatedly sent from the client each time they run are compiled and optimized every time they are executed by SQL Server. They can reduce network traffic. An operation requiring hundreds of lines of Transact-SQL code can be performed through a single statement that executes the code in a procedure, rather than by sending hundreds of lines of code over the network. They can be used as a security mechanism. Users can be granted permission to execute a stored procedure even if they do not have permission to execute the procedure's statements directly.
Prajakta Pandit 03-8-2017 05:25 AM
.NET, UI-Design ,Frontend Technologies
I want develop new website for education purpose.
Attuluri Chandrasekhar 06-24-2016 10:56 AM
« Previous
Next »
Write your comments
*
*
Email must be in the form someone@domain.com
*
*
Enter the code shown above:
Please enter the code shown above
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
Related Content
SQL Server (40)
SQL Server (28)
SQL Server (25)
Data Warehousing (10)
Biztalk (15)
SQL Server DBA (15)
Database (30)
Database (28)
DBMS (20)
Advertisement
▲