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 aptitute test questions (20)
  • Cognizant interview questions (473)
  • Cognizant placement papers (3)
  • Cognizant technical test questions (19)



Cognizant SQL Server Interview Questions
Questions Answers Views Company eMail

how to find nth highest salary

103 126576

About types of indexes in SQL server ?

2 5174

Difference between writing SQL query and stored procedure ?

15 63378

About DTS usage ?

2 5359

How do you optimize Sql queries ?

1257





Rate yourself in .NET and SQL ?

1 5871

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

15 16720

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

990

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

10 11710

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 7772

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 5024

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 2143

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 3040

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 3455

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 5700

Post New Cognizant SQL Server Interview Questions



Un-Answered Questions

hi friends, i got selected in tcs, i m doing my b.e in one of the college in coimbatore.. i don have questions to post u.. but i have valid suggestion..its waste to prepare apti for tcs by looking at last 10 year question from internet.they changed all the apti question this year(2009).. but apti questions is easy..prepare critical reasoning for gre 12th edition..mug up the answers in critical reasoning.. u can download ebook for gre 12th edition..solve the critical reasoing question at the same time mug up it.. there were totally 3 critical reasoning question asked.. two for gre 12th edition so if u mug up u can finish two questions in 3 min.. so u will have 27 min for other question so u can work it out and find the ans..above i mentioned as 3 questions tat is 3 question means ,three paargraph.. each para carries 4 question so totally 12 question in critical reasoning.. if u clear all 12 question u will be selected.80% percent sure.then don mug up synonyms from gre barron because they are asking same question from barron but the choice for the questions are changed.. so study synonyms and antonyms from internet.. some pupils have posted the questions.. in tech and h r don use complex word or don show tat u r so dminant.. talk with them how u will speak wit ur friend. u will be through.. don think wat i have posted above is lik some info in other site.. wat i said is true.. they changed apti tis time.. u will be selected if u follow wat i said..again i m saying pls concentrate on critical reasoning.. if all questions in it are right u r through..bye

2635


if sale aganst c form interstate sale.when i file the return party not give me c form then give by our company wich type panelty give me detail?

753


in a three level hierarchial picklist say country,state,city how do we perform pickmap 2)say if we have values same for country (having value 'A') and for state (having value 'A') and for city having value 'B' and in parent Lic we give value for city as 'A' how do it recognise it as State any other solution

1898


A 100W electric lamp is supplied from a 115V, 60HZ source. The peak instantaneous power dissipated in the lamp filament is

940


which is the best pharma company u think

1051






What is % of piping & equipment cost for a chemical plant having batch process?

1255


How should the personal assets of a salaried employee be shown in his books of accounts ?

426


What are the advantages and disadvantages of ABAP/4 query tool ?

1049


what is the size of ht cable of 33kv ht line and transformers ratings are 1 Mva and 5mva.please send formula also.

242


I want to know that if i get call from Mumbai Circle in SBI. what does it mean where will be my posting and my job profile, will i get accomodation from bank or not.

780


Explain Creepage Distance of Insulator

1031


how to handle errors in fastload?

1019


What is multicollinearity?

1906


I have taken finance as majors but now i want to apply for sales manager job of an automobile company, i have a passion for automobiles and want to work in this industry. could you please help me what reasons can i give when being asked about the similar question in the interview. I did my summer internship in finance as well.

835


What does a PP Consultant do in his/her real time?

1569






Cognizant SQL Server Interview Questions
  • C (3)
  • OOPS (2)
  • C++ General (1)
  • PHP (1)
  • Programming Languages AllOther (3)
  • JavaScript (1)
  • VB Script (1)
  • JSP (2)
  • AJAX (1)
  • Networking Administration (1)
  • Networking AllOther (2)
  • Visual Basic (1)
  • C Sharp (3)
  • ASP.NET (13)
  • ADO.NET (1)
  • IIS (1)
  • Crystal Reports (1)
  • BizTalk (1)
  • Dot Net Framework (1)
  • Exchange Server (1)
  • Oracle General (10)
  • Database Management (1)
  • Forms Reports (1)
  • SQL Server (16)
  • MySQL (2)
  • Sybase (1)
  • DB Architecture (1)
  • DB Administration (2)
  • SQL PLSQL (5)
  • Windows General (2)
  • Unix Commands (1)
  • Solaris General (1)
  • Solaris AllOther (1)
  • Data Structures (1)
  • WinRunner (1)
  • Load Runner (5)
  • QTP (7)
  • Test Director (3)
  • Selenium (2)
  • Automation Testing AllOther (1)
  • Manual Testing (21)
  • QA Concepts (1)
  • Test Cases (6)
  • Testing AllOther (2)
  • COBOL (3)
  • JCL (11)
  • DB2 (3)
  • ADABAS (1)
  • VSAM (2)
  • IBM MainFrame AllOther (1)
  • DB400 (2)
  • IBM AS400 AllOther (3)
  • Core Java (16)
  • Advanced Java (2)
  • Servlets (3)
  • JDBC (1)
  • J2EE (1)
  • Java Related AllOther (1)
  • MQSeries (1)
  • XML XSLT RSS (1)
  • SOAP (3)
  • Teradata (4)
  • Business Objects (5)
  • Cognos (7)
  • Informatica (34)
  • Crystal Enterprise Suite (1)
  • Ab Initio (3)
  • Data Stage (5)
  • SAS (10)
  • Micro Strategy (1)
  • ETL (3)
  • HR Questions (7)
  • OOAD (1)
  • Project Management (1)
  • SAP Basis (1)
  • SAP ABAP (9)
  • SAP SD (7)
  • SAP MM (2)
  • SAP PP (20)
  • SAP FI CO (17)
  • SAP CRM (1)
  • SAP Business Warehouse (4)
  • SAP Security (2)
  • PeopleSoft Administration (1)
  • CRM General (1)
  • Siebel (1)
  • Oracle Apps Financial (10)
  • Client Server General (1)
  • WebMethods (1)
  • JCAPS (1)
  • EAI AllOther (2)
  • Enhancement Design & Development (1)
  • Program Management (1)
  • Pharmacy (1)
  • Civil Engineering (1)
  • Electrical Engineering (9)
  • Electronics Communications (3)
  • Bio Engineering (1)
  • Engineering AllOther (2)
  • Banking Finance (1)
  • Human Resources (1)
  • Infrastructure Management (1)
  • Business Management AllOther (1)
  • Audit (3)
  • CompanyAffairs CS (3)
  • Taxation (1)
  • Accounting General (8)
  • Accounting AllOther (15)
  • Call Centre AllOther (64)
  • BSRB Clerical (2)
  • Group II History (1)
  • General Knowledge_Current Affairs (3)
  • Tourism Hotel AllOther (1)
  • Funny Interview Questions (1)
  • Everything Else AllOther (2)
  • English (1)
  • General Aptitude (18)
  • Puzzles (1)
  • Placement Papers (3)
  • CISA Certification (1)
  • Oracle Certifications (2)
  • Certifications AllOther (1)
  • H1B Visa (1)
  • C Code (2)
  • C++ Code (1)
  • J2EE Code (1)
  • C Sharp Code (1)
  • IIT JEE (1)
  • MySQL Errors (1)