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 (472)
  • 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 124678

About types of indexes in SQL server ?

2 5051

Difference between writing SQL query and stored procedure ?

15 62476

About DTS usage ?

2 5199

How do you optimize Sql queries ?

1191





Rate yourself in .NET and SQL ?

1 5694

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

15 16286

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

916

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

10 11449

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 7449

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 4844

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 2060

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 2929

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 3341

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 5526

Post New Cognizant SQL Server Interview Questions



Un-Answered Questions

What is the nature of duties & responsibilites senior civil engineer ?what is self confident & satisfaction should be a senior civil engineer?

886


What are events and how you use it in BW?

970


In usability testing we check spelling, content, look and feel, color combination, link or menu navigation? please let me know more about usability testing.

758


define the non synchoronism of synchoronous machine in general g or m??

762


What is meant by a stray loss of a induction motor??? What is the equation to find it

1596






As per Kandal suggestions, we have implemented rolling starts on 140 (+/- 5) degrees and we kept 3 rollars to complete the rolling before falling 125 degrees and the Aggregate AIV is below 22. But When the DBM bed is being rolled 3rd high viabration, (Before 1 plain & low ,2 high Viabrations), the aggregate is getting sharp edge agg. projections are damaged. As the literature is said that, the VG-30 Grade having better control the temp. susceptibility than Penetration grade. if so we could not get this problem at site. But we are facing on site. let me know.

654


In mammals, somatosensory, visual, auditory, and olfactory sensory systems all project to the cerebral cortex. To what extent does this imply some common form of neural processing?

1093


what is tower earthing and what for it is required

791


What are the stable versions of Hadoop?

160


What other TCP setting can you modify besides MTU to shorten packets

3041


what is the difference b/w carpet area,covered area and build- up area and how it is calculated.......

971


What is the treatment of claim settled by insurance company but still receivable in profit and loss account

80


Will you be happy to work in night shifts or over the weekends?

1079


as  per partnership deed, salary to working partner is rs 8000/ per month (96000 annually), suppose if i have book profit of rs 50000/ only,then what is the procedure to give salary

1441


How to Print a TStringGrid / TDBGrid?

734






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)
  • 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)