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 (351)
  • Accenture interview questions (1897)
  • 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 76646

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

12 70500

What is a constraint. Types of constraints ?

5 20068

What is a trigger ?

10 12877

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 11960





will function return more than one value how

9 15942

what is purge command explain about oracle performance tuning

2 20434

Give an example of any procedure.

5 11311

How will we see framework of a table?

2 7878

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

24 36319

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 6419

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

1 6954

What is different between union and minus?

7 16592

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 9291

What is the relation b/w view and trigger

3 8960

Post New Accenture SQL PLSQL Interview Questions



Un-Answered Questions

who among the following is responsible for establishing IS Audit function in the organisation?

270


types of indexes and the rationale behind choosing a particular index for a situation.

1212


From where compressor recive power in automobile?

1883


How do you ensure that your departments goals are in line with the overall company goals?

581


How to Create a Working Folder for a Shared Project?

393






How to manage cookie in AngularJS?

652


Difference b/w External ID & Unique ID?

1


if we know load bearing capacity of the soil and building load falling in each footing, then how to choose the type of foundation??? and if it is shallow foundation then which type of shallow foundation should be choosen i.e either strip or isolated or raft or combined or cantilever footing???????

1110


Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

1818


Why do you want to join accenture and why not other IT firms?

3


Trafo ratio is 11kV/6.6kv,Vector group is YND11. What will be the effect if secondary is used for earthed system.

2613


what are the responsibilities of a quality analyst in call center

3722


What would happen if you drilled through the Earth all the way to the other side and then jumped into the hole?

2


what is the difference in Gas Welding and Gas Cutting?? Second Question is for Huge Casting which method is used??

520


Let us suppose one application needs 2GB RAM to run and dependent plugins will be load while running application. Here My doubt is how many processes will create for this application. I know the concept of virtual memory, which will provide RAM on demand. My straight forward question is what is the size of the process and is it single process will create by operating system to complete the task of my application.??? Thanks in Advance.

1340






Accenture SQL PLSQL Interview Questions
  • C (59)
  • 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 (29)
  • ASP.NET (77)
  • ADO.NET (5)
  • Crystal Reports (1)
  • BizTalk (5)
  • Dot Net Framework (13)
  • Dot Net WindowsForms (1)
  • Dot Net General (7)
  • Dot Net AllOther (2)
  • Exchange Server (5)
  • SharePoint (16)
  • Microsoft Related AllOther (2)
  • Oracle General (6)
  • Forms Reports (1)
  • Oracle AllOther (4)
  • SQL Server (25)
  • MySQL (1)
  • DB Administration (2)
  • SQL PLSQL (15)
  • Databases AllOther (4)
  • 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 (121)
  • QA Concepts (7)
  • Test Cases (9)
  • Test Documents Reporting (1)
  • Testing AllOther (17)
  • COBOL (14)
  • JCL (12)
  • CICS (10)
  • DB2 (13)
  • IMS (2)
  • IBM MainFrame AllOther (14)
  • RPG400 (1)
  • COBOL400 (1)
  • DB400 (2)
  • IBM AS400 AllOther (3)
  • Core Java (37)
  • 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 (5)
  • Data Stage (12)
  • SAS (97)
  • ETL (6)
  • Data Warehouse General (6)
  • HR Questions (63)
  • 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)
  • Salesforce (5)
  • 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 (337)
  • Puzzles (6)
  • Placement Papers (25)
  • CCNA (2)
  • Microsoft Certifications (2)
  • Oracle Certifications (1)
  • Certifications AllOther (2)
  • USA Student Visa F1 Visa (1)
  • L1 Visa (2)
  • USA AllOther Visa (4)
  • Australia Visa (1)
  • C Code (4)
  • GATE (1)
  • GMAT (3)
  • Scripts Errors (1)