Cognizant SQL Server Interview Questions Answers, Cognizant Placement Papers, Cognizant Technical, HR Interview Questions, Cognizant Aptitude Test Questions, Cognizant Campus Placements Exam Questions

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 183497

About types of indexes in SQL server ?

2 7875

Difference between writing SQL query and stored procedure ?

15 77267

About DTS usage ?

2 8173

How do you optimize Sql queries ?

2449

Rate yourself in .NET and SQL ?

1 9011

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

15 26914

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

2124

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

10 18588

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 15978

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 7920

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 4077

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 5040

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 5414

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 8229

Post New Cognizant SQL Server Interview Questions

Cognizant SQL Server Interview Questions

Cognizant SQL Server Interview Questions (17)

Un-Answered Questions

What is data _null_?

1174

What was the most challenging task you have faced till now?

728

why you are suitable to work here???? plzz give me the ans f this Q. i was told to write 200 words on the spot....

2204

What is the function of union transformation?

1178

How to write a bdc – how do you go about it?

1177

How do you create regression test packs?

1246

what is the journal entry can be passed for an opening balance (bank, fixed asset, provisions)to the new software

1560

What is the difference between arraylist and hashset in java?

1201

Who invented the first spark plug?

238

In case of salient pole alternator when number of poles are 4 or more than 4 it helps the flux wave to be sinusoid as air gap length is increased from center to tip , but if the number of poles are 2 how does the flux wave is sinusoidal?

2001

Are there any scale limitations for customers using managed disks?

597

what is datamapping in hrms? i want detail information about API in hrms?

3006

How to create a table index?

1189

What are the protocols used in Application layer?

1144

Difference between this and element?

279