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 (1809)
  • 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 76064

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

12 70181

What is a constraint. Types of constraints ?

5 19952

What is a trigger ?

10 12760

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 11788





will function return more than one value how

9 15799

what is purge command explain about oracle performance tuning

2 20288

Give an example of any procedure.

5 11199

How will we see framework of a table?

2 7788

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

24 35944

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 6315

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

1 6888

What is different between union and minus?

7 16421

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 9173

What is the relation b/w view and trigger

3 8843

Post New Accenture SQL PLSQL Interview Questions



Un-Answered Questions

About Child Lobour

1386


what is sysdba and sysdbc ? which has high priority ?

2646


how to i get B licence,i am completed BE electircal and electronics engineering.i want to konw the proceduure to get b licence

455


what are non standard function in c

731


Plz any one send the sharepoint interview question @ mossdev123@gmail.com

2043






Technical Ability Test: This was difficult. three questions to be attempted in 60 min. The Coplete Technical Paper was as follows: Write the Pseudo code for the following: 1. Wrie a function which returns the most frequent number in a list of integers. Handle the case of more than one number which meets this criterion. public static int[] GetFrequency(int[] list) 2. Counting in Lojban, an artificial language developed over the last fourty years, is easier than in most languages The numbers from zero to nine are: 0 no 1 pa 2 re 3 ci 4 vo 5 mk 6 xa 7 ze 8 bi 9 so Larger numbers are created by gluing the digit togather. For Examle 123 is pareci Write a program that reads in a lojban string(representing a no less than or equal to 1,000,000) and output it in numbers. 3. Where now stands that small knot of villages known as the Endians, a mighty forest once stood. Indeed, legand has it that you could have stoodon the edge of the wood and seen it stretch out for miles, were it not for the trees getting in the way. In one section of the forest, the trees stood in a row and were of hight from 1 to n, each hight occurring once and once only. A tree was only visible if there were no higher trees before it in the row. For example, if the heights were 324165, the only visible trees would have been those of height 3,4 & 6. Write a Program that takes an array of integers representing the heights of the trees in the row as input and prints the list of the visible trees. //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// ////////////////// Ques1: Given an array containing k nos in the range 1..n and another scratch array of size n. Write an program to remove the duplicates from the array. Ques2: Given a table of the form: Product Sold on A 1/1/1980 B 1/1/1980 C 1/1/1980 A 1/1/1980 B 1/1/1980 C 2/1/1980 A 2/1/1980 There are 30 products and 10,000 records of such type. Also the month period during which sales happened is given to u. Write the program to display the result as: Product Month No. of copies A January 12 A February 15 A March 27 B January 54 B February 15 B March 10 C January 37 Ques3: Definition of priority queue was given. We have to implement the priority queue using array of pointers with the priorities given in the range 1..n. The array could be accessed using the variable top. The list corresponding to the array elements contains the items having the priority as the array index. Adding an item would require changing the value of top if it has higher priority than top. Extracting an item would require deleting the first element from the corresponding queue. The following class was given: Ques4: An array of size 5X5 is given to us. The elements from 1 to 25 are to be inserted in the array, such that starting from a particular position for an element i, the next element i+1can be inserted only at the mentioned positions (u,v), and if these all positions are occupied then it returns giving a count of how many positions have been occupied in the array: //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// ////////////////// Example: if the starting element is 1 with the given positions (1,2), then next element 2 can be placed at any one of the positions marked with *. _ _ _ _ _ 1 _ _ _ * _ _ _ _ _ _ _ * _ _ * _ _ _ _ 2. Four questions of programming in c++, questions were:( 1:30 hr) a) Bubble sort through recursion b) Display Pattern: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 … c) Perform the functionality of 2-D array through 1-D array and in it the functions to be performed were: (1) Display the array in 2-D format (2) Display a particular element (3) Display a particular row (4) Display a particular column d) Give an efficient program for string matching like: Text: this is the code in the text which you have to search by code Pattern: Code Count the no. of occurrences of the pattern to be searched //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////// ////////////////// a) suppose u r given a 4*3 rectangle like (take these values from user) Now u have to calculate the no. of squares in this rectangle like: No. of squares of dimension 1 is 12 No. of squares of dimension 2 is 6 No. of squares of dimension 3 is 2 No. of squares of dimension 4 is 0 Total no. of squares are 20. b) Suppose u r given a string. U have to find the occurance of the characters A-Z in that string. Each character must appear in the string and must appear only once. If It that occurs in string more than one time return 1 showing it is a perfect string otherwise return 0 showing it is not a perfect string. c) Suppose u r given 10000 marks. U have to pick up top 20 top marks from them and display it on the screen. (Use the optimal sorting algorithm) d) Suppose u have a chess board. U have to insert 8 queens on the chessboard in the style that the queens don’t intersect in the diagonals, columns and rows. If they intersect return 1 else return 0.(that is no more than one queen should be present either in row or column or diagonals.) If the queen is inserted at a position in the chessboard, its count is 1.

2666


Dataset is the disconnected environment. suppose if you are binding records to gridview (disconnected environment) and you are making changes to the the grid but before updating the database if any other user modify the data, how will you avoid such problem?

874


I am a post dip. in machine maintenance , 2004 passed out and i am persuing my graduateship in industrial engg. and i would like to know, whether i am applicable to do any certification cource . And i would like to know, whether i am eligiable to do ann master degree since i have working experience of more than 8 Years in Larsen & Toubro,

708


Can CPF share given by govt. added in the Financial gross salary while calculating Total gross salary at the end of Financial year.For eg: My gross salary is Rs.X during a Fin. year & govt share of CPF is Y then Total Fin. Year gross salary is =X+Y,is it correct?

1152


hello to all i want code for like this site "Submit Question" page.please give answers thanks.

839


What are the characteristics of cloud architecture that separates it from traditional one?

260


few automation basic questions One question to write a scriot in any language you know.

895


How to Change the default project directory ?

834


whar are the draw backs of programming lang step by step in Clang and next in C++ and next and in Java nad in .Net

942


what are accounting principles

873






Accenture SQL PLSQL Interview Questions
  • C (58)
  • 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 (6)
  • Forms Reports (1)
  • Oracle AllOther (4)
  • 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 (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 (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 (5)
  • 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)
  • 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)