One Stop GATE eBooks Guides Discussions Group

1 Message

Digest #1975

TOP SQL SERVER INTERVIEW QUESTIONS & ANSWERS by "Meghana" a.maheshi

Message

1 TOP SQL SERVER INTERVIEW QUESTIONS & ANSWERS

Fri Oct 17, 2014 9:41 pm (PDT) . Posted by:

"Meghana" a.maheshi

Interview Questions | Job Interview Questions & Answers | Free Sample Interview Questions | Java, ASP, .Net Interview Questions | Technical Interview Questions

________________________________

SQL SERVER INTERVIEW QUESTIONS

Download Free Interview Questions eBook of 500 Questions

(If you do not have a Yahoo! account, you can get it by simply sending a blank email to CoolInterview-Subscribe@yahoogroups.com and confirm the verification email received. Once your email is confirmed, we will instantly send the download link to you.)
SQL Server Interview Questions
* How will you copy the structure of a table without copying the data?
http://www.coolinterview.com/interview/14933/

* What is the difference between weak entity set & strong entity set?
http://www.coolinterview.com/interview/16561/

* Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no.
http://www.coolinterview.com/interview/14947/

* Which RAID levels store parity information?
http://www.coolinterview.com/interview/22325/

* Explain about SQL server 2005?
http://www.coolinterview.com/interview/23174/

* What is DESCRIBE command in SQL Server?What is its purpose?How to use it?
http://www.coolinterview.com/interview/14931/

* Where does Profiler store its temporary data in SQL Server 2005?
http://www.coolinterview.com/interview/14918/

* What is updatable view & non updatable view
http://www.coolinterview.com/interview/34123/

* Explain about the command line tool SQLCMD?
http://www.coolinterview.com/interview/23164/

* What does a @@fetch_status of -2 mean in SQL Server 2005?
http://www.coolinterview.com/interview/22278/

* How functional dependency is related to database table design?
http://www.coolinterview.com/interview/14965/

* What is the difference between primary key and unique key?
http://www.coolinterview.com/interview/34124/

* Detail about query optimizer?
http://www.coolinterview.com/interview/23180/

* Explain about reporting services of MYSQL?
http://www.coolinterview.com/interview/23157/

* What are "HINTS"? What is "index covering" of a query?
http://www.coolinterview.com/interview/14954/

* What is the difference between User Identification and Authentication?
http://www.coolinterview.com/interview/14952/

* Detail about the hardware which is supported by SQL server?
http://www.coolinterview.com/interview/23144/

* What does the Log Reader agent in SQL Server 2005 replication do?
http://www.coolinterview.com/interview/14922/

* What is difference between SET & SELECT
http://www.coolinterview.com/interview/34122/

* Which protocols support Kerberos authentication on SQL Server 2005?
http://www.coolinterview.com/interview/22338/

* Report Builder has no built in support for source control. Which of the following choices could be implemented if you decided that those reports needed to be under source control?
http://www.coolinterview.com/interview/22345/

* Write sql query for retrieving employee names from employee table who are having salary greater than 5000 without using where clause?
http://www.coolinterview.com/interview/14958/

* Explain about SQLOS?
http://www.coolinterview.com/interview/23145/

* Explain about thread and memory management process of SQL?
http://www.coolinterview.com/interview/23148/

* Setting the TRUSTWORTHY database property to ON allows you to execute the following from within the context of the database
http://www.coolinterview.com/interview/22346/

* What does the Queue Reader Agent do in SQL Server 2005 replication?
http://www.coolinterview.com/interview/14910/

* Explain about protocol layer present in SQL server?
http://www.coolinterview.com/interview/23150/

* What does this return? select (1324 & 1024)
http://www.coolinterview.com/interview/22269/

* What does the DEALLOCATE statement do in SQL Server 2005?
http://www.coolinterview.com/interview/22344/

* Which of the following modules within SQL Server 2005 cannot be signed with a digital signature?
http://www.coolinterview.com/interview/14914/

* How to get the list of tables in Sybase?
http://www.coolinterview.com/interview/14989/

* How does a differential backup know which extents have changed so that it can be very quickly run?
http://www.coolinterview.com/interview/14908/

* Describe and explain about SQL native client?
http://www.coolinterview.com/interview/23172/

* What is the difference between Varchar and Varchar2?
http://www.coolinterview.com/interview/14974/

* What is DYNAMIC SQL method ?
http://www.coolinterview.com/interview/14964/

* Explain about the architecture of MYSQL?
http://www.coolinterview.com/interview/23142/

* What does the Log Reader agent in SQL Server 2005 replication do?
http://www.coolinterview.com/interview/22272/

* What is the difference between the full, simple and bulk log recovery models?
http://www.coolinterview.com/interview/14927/

* What is the scale of measurement for the cost threshold for parallelism setting in SQL Server 2005?
http://www.coolinterview.com/interview/22296/

* What does this return? declare @i int select @i = -5 select +@i
http://www.coolinterview.com/interview/14916/

* Using Reporting Services 2005, it is true or false that subreports execute a query against the datasource once for every detail row in the report?
http://www.coolinterview.com/interview/22329/

* Explain about integration services of Microsoft SQL server?
http://www.coolinterview.com/interview/23161/

* Explain real time situation where you would use clustered and Non-clustered Indexes?
http://www.coolinterview.com/interview/14956/

* Explain about analysis services?
http://www.coolinterview.com/interview/23177/

* Explain in brief about Microsoft SQL server?
http://www.coolinterview.com/interview/23140/

* What is the Disadvantage of StoredProcedure?
http://www.coolinterview.com/interview/14980/

* How to replace particular string. For example:- suppose their are 1000 of records for email-id. like tarun.it@hotmail.com..but i want to replace the only hotmail.com for all email-ids not the user name(tarun.it) with yahoo.com.
http://www.coolinterview.com/interview/15082/

* True or false, Report Builder offers direct export to a Microsoft Access database as one of its supported export options?
http://www.coolinterview.com/interview/22311/

* When you create a new Message Type in the SQL Server 2005 Service Broker, what does the Authorization parameter signify?
http://www.coolinterview.com/interview/22211/

* What is Extended Stored Procedure in SQL Server 2000?
http://www.coolinterview.com/interview/14982/