Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

Cognizant SQL Server Interview Questions
Questions Answers Views Company eMail

how to find nth highest salary

 103 134418

About types of indexes in SQL server ?

 2 5522

Difference between writing SQL query and stored procedure ?

 15 65597

About DTS usage ?

 2 5746

How do you optimize Sql queries ?

 1447




Rate yourself in .NET and SQL ?

 1 6430

how to retrive only second row from table in sql server 2000?

 15 18019

After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

 1179

How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)

 10 12706

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

12 9028

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

 2 5450

How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...

 1 2427

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(, 1) BACKUP LOG WITH TRUNCATE_ONLY DBCC SHRINKFILE(, 1) GO

 1 3286

one of my database size is 2gb and Unrestricted Growth for Data file up to 10%.But every day after day I am getting Primary Data file is full 99.999 please take appropriate actions.Why it is? Even disk space is also not full,but still I am getting the alerts.

 1 3739

Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.

 1 6016

Post New Cognizant SQL Server Interview Questions




Cognizant SQL Server Interview Questions


Un-Answered Questions

C. Normalize the following data up to the 3rd Normal form. Create the tables and insert the data given. Emp_ID Name Dept_Name Salary Course_Title Date_Completed 100 Adam Marketing 48,000 SPSS 6/19/2008 Surveys 10/7/2008 140 Bob Accounting 52,000 Tax Acc 12/8/2008 110 Cathy IT SQL Server 1/12/2008 C# 4/22/2008 190 Dan Finance 150 Emily Marketing 55,000 SPSS 6/16/2008 42,000 Analysis 8/12/2008 Queries 1. Find all Names who have completed the SPSS Course. 2. Find employee with max salary. 3. Find employee with 2nd max salary. 4. Find all employees in Dept “Marketing”. 5. Find all the employees who have taken more than 2 courses. 6. Find all the employees who have completed the courses before month of September.

1602

Can we change the body of the flume event?

15

What happens if main method is not static?

86

What are the duties of QA/QC Coordinator

2235

What is difference between delegate and datasource in ios?

76




Have you ever used a new idea without being certain of the outcome?

147

What is back end and front end?

67

Explain the file types in aix.

1

Can a generic class extend another generic class??

951

What is casting in python?

112

Explain a file operation in C with an example.

154

What is doctype?

100

Explain me bills receivable?

115

Define brain stromming and cause effect graphing?

140

What is Decryption Process ?

333