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 PLSQL Interview Questions
Questions Answers Views Company eMail

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

 68 73388

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

 12 68697

What is a constraint. Types of constraints ?

 5 19379

What is a trigger ?

 10 12196

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 11081




will function return more than one value how

 9 15012

what is purge command explain about oracle performance tuning

 2 19634

Give an example of any procedure.

 5 10688

How will we see framework of a table?

 2 7366

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

 24 34244

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 5736

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

1 6549

What is different between union and minus?

 7 15534

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 8650

What is the relation b/w view and trigger

 3 8283

Post New Accenture SQL PLSQL Interview Questions



Un-Answered Questions

if we use 1.25 bag of cement 3 pharma metal and 2 pharma crush sand what is the strenghtexpected for RCC column

754

can external audit be seen as merely an overhead cost adding no value to the orgnisation

1524

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

890

i am exeprienced person what is selection process

245

i am a animation student. in december i am going to face an interview so plse tell me what type of question they will ask ( about animation) how should i tell the answer (i am poor in comunication skill) pls tell me some tips its help full to me

1186




In the house keeping section of an MVS assembly language program, like the one below STM R14,R12,12(R13) BASR R12,R0 USING *,R12,R11 LA R11,2048 LA R11,2048(R11,R12) .... .... 1. What if BASR R12,R0 IS NOT PRECEDE USING *,R12,R11? 2. USING (base address), REGISTER does USING directive says assembler to treat particular Register as a base register with the mentioned base address..in the above case * i.e current location counter..well if that is the case why we need BASR R12,R0 ? 3. What if I write like STM R14,R12,12(R13) BASR R12,R0 LA R11,2048 LA R11,2048(R11,R12) USING *,R12,R11 there is no address resolution being calculated in both LA statements so is it a right way to set Base register?..will there be any issues with Domain regarding R11 and R12?

638

Where do we show "Dividend paid in FFS ,either in FFO or in FFS? what is teh concept behind?

784

Hi,can anyone help me out with PhD programs related to Instrumentation field?I have a degree in electronic Instrumentation?

614

WHAT IS THE MEAN BY DEALER MANAGEMENT IN THE AUTO MOBILE COMPANY?

1017

How to create SQL queries with SQL Builder?

745

i am new to this tax system if you don't mine "please help me"

748

how to convert the recors form vsam file to db2 table tru file aid

1774

Explain CMOS Inverter transfer characteristics?

2516

wat is mass allocation and when it is used

811

What is supporting documents enclosed & must be required to Submit of quarterly & Yearly Sale Tax Return (Haryana)

692





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