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 6039

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 4930

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 5866

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 4541

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 8144

Post New Sonata SQL PLSQL Interview Questions



Un-Answered Questions

i am electronics & comm engg & appling 4 the AAI jr executive (electronics/ATC) written test. pls forward me the syllabus & old question papers.I will be very much thankful to you, snehalsanap@gmail.com

837


HOw can I get the negative sign while deduct high value from low value

996


Anybody please send me the papers of the reliance exam (apti and tech) so that i can go through it) mail me at raminder_verma@rediffmail.com

850


Which is the pin no of CN1 TERMINAL and the parameter using in delta servo drive for auto/man input and start forward input

789


what is the difference between vat return and return for remittance on value added tax.

1247






Why humidity limit is 30 to 55 % for raw material storage?

2505


Can anyone send me the what the scenario's client given in the real time,I mean functionalspecs,reporting scenarios?

997


Why slip ring ind. motor power consumption is low compare to induction motor .same 90 kw motor used same load output

476


How many ways you can restrict data in business objects

888


how to introdu5ce my self in serco

775


What is batch input? why we use batch input session in SAP(FICO)?

3751


What is the use of INV-Receipts and PO-Reciepts,Just give me the Differences&When,At what Instances to use Them...?

11313


why u have not worked anywhere for 3 years

926


hai can anyone send me soft copy of o.p gupta or tell me downloading link please please at saify_0@hotmail.com

1190


what is bailout fund and what are the main drawbacks of bailout funds? what is the role of bailout fund in an economy and what are the impact of bailout fund on market , economy , the bailout provider and the bailout reciever?

1009






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)