In the array, the elements are numbered from …
0 to 9
Explanation: None
0 to 9
1 to 10
None of the Options are Correct
Tag: Databases MCQs
Which of the following keyword is not associated with initialization of variable ?
Which of the following keyword is not associated with initialization of variable ?
All of the mentioned
Variables are declared in the body of a batch or procedure with the DECLARE statement and are assigned values by using either a SET or SELECT statement.
DECLARE
SET
SELECT
Which of the following statements cannot be included in the definition of a Transact-SQL user-defined function ?
Which of the following statements cannot be included in the definition of a Transact-SQL user-defined function ?
All of the mentioned
Most of the Service broker statements cannot be included in the definition of a Transact-SQL user-defined function.
GET CONVERSATION GROUP
MOVE CONVERSATION
RECEIVE
Function cannot be used for __________ statement.
Function cannot be used for __________ statement.
Insert
We can’t use function to Insert, Update, Delete records in the database table(s).
Create
Drop
Select
RECEIVE service broker statement applies to which of the versions ?
RECEIVE service broker statement applies to which of the versions ?
2008
RECEIVE retrieves one or more messages from a queue. Depending on the retention setting for the queue, either removes the message from the queue or updates the status of the message in the queue.
2000
2005
None of the Options are Correct
Which of the following has support for transaction ?
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
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