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

  • Sonata interview questions (44)
  • Sonata placement papers (2)
  • Sonata technical test questions (13)



Sonata SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 6263

1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins

6 5282

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows

8 6333

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 4707

How to retrieve a second highest salary from a table? Note:Suppose salaries are in duplicate values eg: Name Sal Malli 60000 Pandi 60000 Rudra 45000 Ravi 45000

8 8901

Post New Sonata SQL PLSQL Interview Questions



Un-Answered Questions

HI, I WANT TO DO A ISTQB FOUNDATION CERTIFICATION FROM HYDERABAD WHICH INSTITUTE WOULD BE GOOD FOR ME,WHERE I CAN TAKE SOME TRAINING SESSIONS FOR CLEARING THIS EXAMINATION.

1011


what is zinc diffusion?

807


can inline function declare in private part of class?

2670


how offen sand box server refresh?

1863


if the goods are purchased against H Form, is there any specified time limit winthin which they should be exported?; if yes then wat is that limit?

2872






Describe a team experience you found rewarding.

2


At The time of EBS file uploading through T-code FF_5, the errors are showing in FEBAN, those errors are required Business area and Profit center, if we give Business area and Profit center manually than it will clear, my requirement is those Business Area and Profit Center needs to be pick automatically. where we can check/

553


Two trains running in opposite directions cross a man standing on the platform in 27 seconds and 17 seconds respectively and they cross each other in 23 seconds. The ratio of their speeds is:

336


what is publisher?

1040


Colorimtry

323


What is the new three features of COM+ services, which are not there in COM (MTS)

974


which is the cheapest type of flooring (say for using for 6 months in a factory building & dismantling it)?

937


what is mba?

1205


4. Calculate the following from the particulars given below: i) Material Cost Variance ii) Material Price Variance iii) Material Usage Variance iv) Material Mix Variance v) Material Yield Variance Material Standard Actual Qty kgs. Price Rs Value Rs. Qty kgs. Price Rs Value Rs A 50 4 200 40 5 200 B 30 6 180 30 6 180 C 20 3 60 30 3 90 100 440 100 470 Loss 20 ----- 30 ----- 80 440 70 470

1923


What are certificates?

1






Sonata SQL PLSQL Interview Questions
  • C (2)
  • PHP (1)
  • Programming Languages AllOther (1)
  • VB.NET (1)
  • Crystal Reports (1)
  • BizTalk (1)
  • Dot Net Framework (1)
  • SQL Server (1)
  • SQL PLSQL (5)
  • WinRunner (3)
  • QTP (4)
  • Manual Testing (15)
  • QA Concepts (2)
  • Mobile Testing (1)
  • Testing AllOther (2)
  • Core Java (2)
  • Cognos (1)
  • Informatica (3)
  • SAP FI CO (1)
  • Oracle Apps Financial (2)
  • ERP CRM AllOther (1)
  • Engineering AllOther (4)
  • Banking Finance (1)
  • Operations Management (1)
  • Placement Papers (2)