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

  • Accenture aptitute test questions (64)
  • Accenture interview questions (1802)
  • Accenture placement papers (24)
  • Accenture technical test questions (103)



Accenture SQL Server Interview Questions
Questions Answers Views Company eMail

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 10111

Difference between Cluster and Non-cluster index?

32 122798

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1149

What is the difference between NOROW and LOCKROW?

1292

explain different types of jions with examples briefly?

2 5597





Which databases are part of SQL server default installation? Explain the usage of each?

2 4688

What all db objects can be found in MSDB database of a SQL Server instance?

2 4907

Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

3 8364

What is Query Execution Plan? How does it help optimize or tune a database driven application?

2 6984

How do you fine the performance tunning?

2 5357

What are mdf,ndf,ldf files and how to see the data in those files?

6 53223

how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

15 14081

Differences between functions and stored procedures?

8 8932

event classes in sql server

2 4463

1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.

11 11013

Post New Accenture SQL Server Interview Questions



Un-Answered Questions

What type of entry after consignment business starting?

885


Purpose of TTL. How it gets modified.

887


What are the causes of positive and negative propeller slip?

831


How much qty of stone ; sand; cement in R/R stone masonry of 136 CUM

620


How to calculate closing stock? I have opening stock of 72 lacs (average costing without tax) and purchase of 49 lacs (with tax) and sales of 101 lacs (without tax). What is my closing stock then???? Should i add tax in sales? Where all should tax be included and where all should tax NOT be included? Right now i calculated => 72(no tax)+49(with tax)-101(no tax) = 20 lacs. IS this correct?

1076






Hi Friends i am going to write BARC written test by this month 20th (20-5-2008). So please if any body knows the details about this or having previous question papers pls mail me to kkumarei@gmail.com. For Suggestions give one message to 9962122264

1147


What do you like most about Quality Assurance/Testing?

1804


i completed bsc microbiology,DMLT and i finished ILETS exam and got overall 5.5 score,is it possible to get job in melbourne hospital,wat i hav to do

2006


What is missing report and how to prepare

133


How do you compare the structure of 2 tables in database and check whether they are similar using qtp.

749


"WHERE THERE IS A RIGHT, THERE IS REMEDY" EXPLAIN THIS WITH REFERENCE TO BREACH OF CONTRACT.

996


Somebody tell me in what way i need to prepare for csio pgrpe(adv instrum eng)interview?what all the quest can i expect?

1245


purchase car from toyota innova 50000 cheque from one firm and 449893 from other firm.... and 1350000 loan saction from kotak mahindra.....how can entry make with interest

579


hi i want license key for qtp 9.2 pls its adjust product name : quick test professional locking code :8 - 54A6A license type : seat license maintenance number : 88888888-8888 pls send license key to my email id borusu.ramkumar@gmail.com

2781


please guide me from where I got semple of written test solved paper

739






Accenture SQL Server Interview Questions
  • C (57)
  • OOPS (10)
  • C++ General (4)
  • COM DCOM (1)
  • Delphi (1)
  • PHP (1)
  • Programming Languages AllOther (13)
  • JavaScript (1)
  • VB Script (7)
  • JSP (1)
  • Awk (1)
  • Scripts AllOther (1)
  • SNMP (2)
  • TCP IP (1)
  • Protocols AllOther (6)
  • Networking Administration (5)
  • Networking Security (1)
  • Networking AllOther (1)
  • Visual Basic (1)
  • C Sharp (10)
  • ASP.NET (74)
  • ADO.NET (5)
  • Crystal Reports (1)
  • BizTalk (5)
  • Dot Net Framework (13)
  • Dot Net WindowsForms (1)
  • Dot Net General (2)
  • Dot Net AllOther (2)
  • Exchange Server (5)
  • Microsoft Related AllOther (2)
  • Oracle General (5)
  • Forms Reports (1)
  • Oracle AllOther (3)
  • SQL Server (21)
  • MySQL (1)
  • DB Administration (2)
  • SQL PLSQL (15)
  • Databases AllOther (2)
  • SDK (1)
  • Windows Threads (1)
  • Windows General (4)
  • Windows AllOther (4)
  • Linux System Calls (2)
  • Linux AllOther (3)
  • Unix Commands (2)
  • Unix General (8)
  • Unix AllOther (2)
  • Solaris Commands (4)
  • Solaris System Calls (1)
  • Solaris AllOther (2)
  • Operating Systems General Concepts (3)
  • Data Structures (1)
  • WinRunner (24)
  • Load Runner (12)
  • QTP (64)
  • Test Director (1)
  • Rational TestSuite (3)
  • Selenium (1)
  • Automation Testing AllOther (5)
  • Manual Testing (120)
  • QA Concepts (7)
  • Test Cases (9)
  • Test Documents Reporting (1)
  • Testing AllOther (17)
  • COBOL (13)
  • JCL (12)
  • CICS (10)
  • DB2 (13)
  • IMS (2)
  • IBM MainFrame AllOther (14)
  • RPG400 (1)
  • COBOL400 (1)
  • DB400 (2)
  • IBM AS400 AllOther (3)
  • Core Java (36)
  • Advanced Java (2)
  • Swing (1)
  • EJB (1)
  • Servlets (6)
  • Struts (5)
  • JDBC (1)
  • J2EE (1)
  • Weblogic (2)
  • Java Networking (2)
  • Java J2EE AllOther (1)
  • Middleware AllOther (2)
  • HTML DHTML (1)
  • XML XSLT RSS (1)
  • Teradata (4)
  • Business Objects (29)
  • Cognos (8)
  • Informatica (60)
  • Ab Initio (4)
  • Data Stage (12)
  • SAS (97)
  • ETL (6)
  • Data Warehouse General (6)
  • HR Questions (34)
  • Design Patterns (3)
  • Project Planning (1)
  • VSS (1)
  • SAP Basis (25)
  • SAP ABAP (155)
  • SAPScript (4)
  • SAP SD (104)
  • SAP MM (32)
  • SAP QM (1)
  • SAP PP (7)
  • SAP PM (1)
  • SAP PS (1)
  • SAP FI CO (111)
  • SAP HR (20)
  • SAP CRM (17)
  • SAP APO (2)
  • SAP Business Warehouse (20)
  • SAP Security (28)
  • SAP Interfaces (1)
  • SAP Netweaver (4)
  • SAP ALE IDocs (2)
  • SAP B1 (3)
  • SAP AllOther (3)
  • PeopleSoft Administration (1)
  • PeopleSoft Tools (2)
  • Siebel (4)
  • Oracle Apps Technical (37)
  • Oracle Apps Financial (21)
  • Oracle Apps Manufacturing (2)
  • Oracle Apps HRMS (1)
  • Oracle Apps SCM (5)
  • Oracle Install Base (1)
  • Oracle Service Contracts (2)
  • ERP CRM AllOther (1)
  • Client Server Architecture (3)
  • AI Tools (3)
  • WebMethods (7)
  • TIBCO (11)
  • EAI AllOther (12)
  • Change Request Management (1)
  • Bio Informatics (1)
  • Sciences AllOther (1)
  • Electrical Engineering (12)
  • Electronics Communications (5)
  • Engineering AllOther (4)
  • Business Administration (1)
  • Marketing Sales (3)
  • Banking Finance (7)
  • Human Resources (4)
  • IT Management (2)
  • Non Technical (1)
  • Business Management AllOther (1)
  • Audit (4)
  • CompanyAffairs CS (1)
  • Taxation (8)
  • Accounting General (90)
  • Accounting AllOther (59)
  • Call Centre AllOther (32)
  • APPSC AllOther (1)
  • General Knowledge_Current Affairs (4)
  • Government AllOther (2)
  • Everything Else AllOther (6)
  • English (3)
  • General Aptitude (47)
  • Puzzles (6)
  • Placement Papers (25)
  • CCNA (2)
  • Microsoft Certifications (2)
  • Oracle Certifications (1)
  • Certifications AllOther (2)
  • L1 Visa (2)
  • USA AllOther Visa (4)
  • Australia Visa (1)
  • C Code (4)
  • GATE (1)
  • GMAT (3)
  • Scripts Errors (1)