Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 6 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.

1.

__________GIVES_AMOUNT_OF_TIME,_IN_TICKS,_THAT_SQL_SERVER_HAS_BEEN_IDLE_SINCE_IT_WAS_LAST_STARTED.?$

A. @@ERROR
B. @@IDLE
C. @@LANGID
D. @@LANGUAGE
Answer» C. @@LANGID
Discussion
2.

Which of the following global has return type ‘numeric’ ?$

A. @@ERROR
B. @@MAX_CONNECTIONS
C. @@CPU_BUSY
D. @@IDENTITY
Answer» E.
Discussion
3.

Point out the right statement :

A. The server always maintain the values of local variable
B. Local variable names begin with a @@ prefix
C. T-SQL restricts the use of variables in ways that aren’t common in other development environments
D. None of the mentioned
Answer» D. None of the mentioned
Discussion
4.

Which of the following is a global variable ?

A. @@CPU_BUSY
B. @@CPU_IO
C. @@CPU
D. @@I_BUSY
Answer» B. @@CPU_IO
Discussion
5.

Which of the following keyword is not associated with initialization of variable ?

A. DECLARE
B. SET
C. SELECT
D. All of the mentioned
Answer» E.
Discussion
6.

Variables was added newly to SQL Server version :

A. 2005
B. 2008
C. 2012
D. 2014
Answer» C. 2012
Discussion