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 125666

About types of indexes in SQL server ?

2 5120

Difference between writing SQL query and stored procedure ?

15 62953

About DTS usage ?

2 5303

How do you optimize Sql queries ?

1224





Rate yourself in .NET and SQL ?

1 5783

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

15 16517

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

957

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

10 11584

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 7639

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 4933

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 2110

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 2991

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 3408

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 5617

Post New Cognizant SQL Server Interview Questions



Un-Answered Questions

2. A current i=(10+10 sin t)amperes is passed through MI type ammeter. its reading will be.........

992


When usin qtp iam able to get the data from the database only in a single row that is if i have 2 columns in database,when using database output value , all the values in Database are transfered to a single row in QTP datatable. I want the values to appear as it is from the database , can anyone suggest some ideas?

802


How did you debug your Hadoop code ?

503


HI Everybody, I am using QTP 9.2, I have a problem and hope everybody help me solve it. Now I need to use mouse wheel event to zoom in or zoom out in web client, but QTP can't catch this event. I look forward helping of everybody. Thank you very much.

945


Is there any criteria for percentage define of TDS rates? and What is the major advantage of introducing DTC and GST by Central Govt?

626






What are the AP accounting entries for EXPENSE ITEM VS Inventory Item in oracle ERP

2026


when we calibrate uv for control of wavelength we scan for 200 to 800 nm but we get the result only for some specific wavelength how we confirm for all other wavelength?

1189


in shunt clippers why a resistor is used in sereis with the input

790


how does we calibrate a square root flow transmitter ,give an example and explain it step by step like range calculation , calibration hook up series connection , zero check , and how to apply pressure , and if not geting proportional output then what should we do ?

4537


what is the pulse and audio frequency transformer? what is different between induction regulators and tap changing transformer?

856


How did you test the form u developed? How did you taken printout ?

777


How do you see the future of multimedia in India?

1466


high forex rate or low forex rate- which one will attract more foreign investment?( my doubt: if the ruppe value is more against dollar, foreign investor get les , else it resemble a week economy)

990


Like OPTION EXPLICIT statement what are the other statements used in vbscript and their usage. Please post me all the statements please.

984


how to manage the requirement if it is included after Requirement specifications phase

1136






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)