Which of the following has support for transaction ?
sp_bindsession
sp_getbindtoken also can be used for transactions.
sp_monitor
sp_status
None of the Options are Correct
Category: Computer Science
Data return using output parameter is :
Data return using output parameter is :
None of the mentioned
Return codes, which are always an integer value
A global cursor that can be referenced outside the stored procedure
A single cursor that can be referenced inside the stored procedur
None of the Options are Correct
Which of the following is a control flow keyword ?
Which of the following is a control flow keyword ?
GOTO
The Transact-SQL statement or statements that follow GOTO are skipped and processing continues at the label.
IF
GO
None of the Options are Correct
Which of the following statements can be checked for Errors ?
Which of the following statements can be checked for Errors ?
INSERT
DML statements can be checked for handling errors.
DROP
DELETE
None of the Options are Correct
DML triggers in SQL Server is applicable to :
DML triggers in SQL Server is applicable to :
All of the mentioned
In SQL Server we can create triggers on DML statements (like INSERT, UPDATE, and DELETE) and stored procedures that perform DML-like operations.
Insert
Update
Delete
Point out the wrong statement :
Point out the wrong statement :
The input type @Type is passed as the first parameter to sp_executesql
The output type @retType is passed as the second parameter to sp_executesql.
The @stmt parameter in sp_executesql is a Unicode string containing valid SQL commands
We can specify the parameters for both input and output in sp_executesql
None of the Options are Correct
Point out the correct statement :
Point out the correct statement :
Logon triggers are special type of trigger that fire when LOGON event of Sql Server is raised
Logon event is raised when a user session is being established with Sql Server that is made after the authentication phase finishes.
DDL triggers are special type of trigger that fire when LOGON event of Sql Server is raised
DML triggers are special type of trigger that fire when LOGON event of Sql Server is raised
None of the Options are Correct
How many type of cursor is present in SQL Server ?
How many type of cursor is present in SQL Server ?
4
SQL Server supports four types of cursor.
3
5
6
How many types of stored procedures are present in SQL Server ?
How many types of stored procedures are present in SQL Server ?
4
SQL Server is packed full of useful system stored procedures there for its own use that you can use as well.
3
5
8
Which of the following operations requires the relations to be union compatible?
Which of the following operations requires the relations to be union compatible?
ALL OF THESE
Explanation: None
UNION
INTERSECTION
DIFFERENCE