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 (1800)
  • Accenture placement papers (24)
  • Accenture technical test questions (103)



Accenture SQL PLSQL Interview Questions
Questions Answers Views Company eMail

Write a query to get 2nd maximum salary in an employee table ?

68 72544

What is an index and types of indexes. How many number of indexes can be used per table ?

12 67920

What is a constraint. Types of constraints ?

5 19127

What is a trigger ?

10 11974

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

2 10778





will function return more than one value how

9 14723

what is purge command explain about oracle performance tuning

2 19369

Give an example of any procedure.

5 10507

How will we see framework of a table?

2 7224

When we give SELECT * FROM EMP; How does oracle respond?

24 33669

Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;

7 5549

SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/

1 6415

What is different between union and minus?

7 15079

wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010

5 8456

What is the relation b/w view and trigger

3 8020

Post New Accenture SQL PLSQL Interview Questions



Un-Answered Questions

I have 2+ years of fake experience,actually i could not answer for project questions..?how can i answer please suggest me..?

1875


What is datapool cursor?

895


WHAT IS MEANT BY CST? DO THE SUPPLIER CLAIM CST 2% FROM THE PURCHASER? WHAT ARE ALL THE RULES TO BE FOLLOW WHILE THE BUYER PURCHASE A 'C'FORM FROM THE CTO?

690


In case of new admission of partner what will be the adjustment for the sharing ratios

699


As jobs become more team-oriented, assessment centers will be used more often for non-management jobs. Do you agree or diagree?

1059






for a 400kv t/m line with 10 ampere current will corona occur?

903


design a or gate using transister

585


using gradient pressure in gas chromatography are not ?using gradient pressure why

2035


how we could adj. the entries of prop. & firm in merging time

661


What is Morphological gradient?

262


Why is Client side image is preferred over server side image?

609


please tell me what is graphics card ,version , type slot

925


what do you mean byrecoupment of shortworkings in royalty accounts

2357


What are different ways to invoke a directive?

493


anyone send me aptitude and technical placement paper of Hewitt

631






Accenture SQL PLSQL 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 (119)
  • 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 (110)
  • 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)