Transact SQL interview questions
Transact SQL interview questions
Take as many assements as you can to improve your validate your skill rating
Total Questions: 15
1. True or False: Stored procedures are optimized at creation – and their optimized/compiled plan is saved to disk.
Correct Answer is : FALSE
2. What is returned? create procedure dbo.testProc @testVar varchar(4) as select @testVar GO exec testProc 'This is a test string' GO
Correct Answer is : This
3. Select the control which can’t be placed in the toolbox
Correct Answer is : User control
4. What is the number of locks held by any T-SQL statement on a single reference of a table that triggers Lock Escalation (i.e. Row lock to Page level lock)?
Correct Answer is : 5000
5. create table address_staging (clientid int primary key,addressdetails varchar(250)); insert into address_staging select 100,'hyderbad,india' union all select 101,'banglore,india' union all select 102,'banglore,india' ; create table address_oltp (client_id int primary key,address_details varchar(250)); insert into address_oltp select 104,'newyork,usa' union all select 105,'chicago,usa' union all select 106,'washington,usa' ; select * from address_oltp where client_id in (select client_id from address_staging) How many rows are returned from the last SELECT?
Correct Answer is : 3 rows from address_oltp
6. Which of the following is proprietary extension of SQL for Microsoft SQL Server ?
Correct Answer is : T-SQL
7. Applications that can generate Transact-SQL can be :
Correct Answer is : All of the mentioned
8. Which of the following is not a SERVICE BROKER statement ?
Correct Answer is : CREATE USERS
9. RECEIVE service broker statement applies to which of the versions ?
Correct Answer is : 2008
10. Which of the following Statement ends one side of an existing conversation ?
Correct Answer is : END CONVERSATION TIMER
11. Purpose of GET_TRANSMISSION_STATUS is :
Correct Answer is : Returns the status for the last transmission for one side of a conversation
12. Point out the correct statement :
Correct Answer is : T-SQL is SQL language for SYBASE
13. Which of the following is- a security statement ?
Correct Answer is : All of the mentioned
14. Purpose of CLOSE MASTER KEY is :
Correct Answer is : Deletes the master key of the current database
15. Which of the following statement decrypts a symmetric key ?
Correct Answer is : OPEN SYMMETRIC KEY
