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 (458)
  • Cognizant placement papers (2)
  • Cognizant technical test questions (19)



Cognizant SQL Server Interview Questions
Questions Answers Views Company eMail

how to find nth highest salary

103 121731

About types of indexes in SQL server ?

2 4850

Difference between writing SQL query and stored procedure ?

15 60185

About DTS usage ?

2 4928

How do you optimize Sql queries ?

1088





Rate yourself in .NET and SQL ?

1 5390

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

15 15620

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

815

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

10 10931

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 7023

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 4653

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 1927

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 2782

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 3192

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 5215

Post New Cognizant SQL Server Interview Questions




Un-Answered Questions

) what is the difference between AID and HANDLE AID?

751


how to caluclate sienerge qty in construction in ap

962


Why it is a preferable option in parallelextender development ?

742


Since the interest rates on fixed deposits are very low as compared to the other growth oriented investment options, what are the permitted investment options that a public trust like that of a private school or small credit societies have and which are permitted by charity commissioner, Mumbai

623


IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

7452






what are the major differences in requirement when compared among SW project requirement and Product requirement

970


What is meant by Establish Connection in RDO?

885


plz send me a solved paper on SBI of clerk post

812


Iam an MBA student.I need guidance to prepare for AMAZON COMPANY. can u post papers to ammuprathyu@ymail.com

1451


I have 3 cubes for that I created multiprovider and I created a report for that but I didn’t get data in that report what happen?

343


(a) Describe the My Computer and My Documents folders; identify the elements that are present in every Window.

555


how can we tune a PID. If it is by zeiger nichols method..please explain briefly with help of an example.

899


Where do you specify the Mapper Implementation?

87


Can any body provide me the sample web application in asp.net

651


Is there a lower limit to the gland surface finish for static O-rings, gaseous system? surface finish table lists 0.41-0.81 micro-meters for static gaseous systems. What is the drawback of using a smoother surface finish lower than 0.41?

564






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)
  • Data Structures (1)
  • WinRunner (1)
  • Load Runner (5)
  • QTP (6)
  • 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)
  • 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 (6)
  • Informatica (32)
  • Crystal Enterprise Suite (1)
  • Ab Initio (3)
  • Data Stage (3)
  • 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 (1)
  • SAP PP (20)
  • SAP FI CO (17)
  • SAP CRM (1)
  • SAP Business Warehouse (2)
  • 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 (8)
  • Electronics Communications (3)
  • Bio Engineering (1)
  • Engineering AllOther (2)
  • Banking Finance (1)
  • Human Resources (1)
  • Infrastructure Management (1)
  • Audit (3)
  • CompanyAffairs CS (3)
  • Taxation (1)
  • Accounting General (8)
  • Accounting AllOther (15)
  • Call Centre AllOther (62)
  • 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 (2)
  • 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)