Topics
Products
Follow Us:

SQL Server Questions and Answers (Q&A)

E. Stanley, Technical writer
Answered: Feb 20, 2019
The correct answer is option A
A deadlock occurs when the first process is waiting on a resource held by the second process. Each process is stuck waiting for each other to release a...Read More

2 Answers

239 views
Kwinzar
Answered: Oct 23, 2019

Statement "SELECT 'Test'" is valid with no FROM clause - would return one row with the word 'Test'? Losing confidence in this quiz now.

2 Answers

219 views
Telliant
Answered: Jul 04, 2020
DELETE FROM EMP OUTPUT deleted. INTO EmpCompress FROM Emp JOIN Dept ON EMP.DeptId = Dept.DeptId ;

1 Answer

214 views
John Adney
Answered: Mar 02, 2017
Hi i have a doubt ,the data is commited when you rollback will the commited data be removed?

2 Answers

212 views
Nidhooo
Answered: Jul 04, 2020
Add indexes on the PostalCode, State, and DateOfBirth columns of the Customers table.
Denormalize the Customers table

1 Answer

207 views
Telliant
Answered: Jul 04, 2020
DELETE FROM EMP OUTPUT deleted. INTO EmpCompress FROM Emp JOIN Dept ON EMP.DeptId = Dept.DeptId ;

1 Answer

206 views
Telliant
Answered: Jul 04, 2020
Both A and C.

1 Answer

203 views
Rickyhk
Answered: Jul 04, 2020
Enable Mixed-Mode Authentication
Enable TCP/IP binding over TCP 1433
Enable SQL "sa" account

1 Answer

202 views

Related Topics Of SQL Server

Loading, please wait...

Email Sent
We have sent an email to your address "" with instructions to reset your password.