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 6161

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 5126

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 6109

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 4632

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 8493

Post New Sonata SQL PLSQL Interview Questions



Un-Answered Questions

Hi,I have recieved an i-20 from 2 years college for my bachelors degree,how can i convince the consular about this course i.e.computer and information science.plz help me as soon as possible.

967


Explain the basic circuits for a current- and voltage- clamp set-up.

939


1)what to do in emergency situation of having total blackout (on a ship) 2)what to do in emergency situation of flooding in the engine room 3)under what conditions would engine room bilges be pumped overboard? 4)why is high pressure required for the injection of fuel into the cylinder of diesel engine. 5)why is doubled walled pipes employed for high pressure fuel lines? 6)reasons for overheating of main engine 7)how to detect choked fuel valve,leaky piston rings and their remedies during operation in diesel engine? 8)effects of insufficient or excessive cylinder lubrication? 9)causes of a diesel engine piston overheating.

2399


diff b/w inter process and in process

868


What is the advantage of Servlets when compared with other server side technologies?

1197






how to answer for the question what is your strength and weakness?

1014


what is the difference between built-i function and In-built function?

883


SonicWALL keep on fail over after upgrade from 6.2.2.2 to 6.2.6.0.anyone have encounter this and what is the next step to solve the issue

512


Hi Could you please share the process of migration of Classical GL Balances to New GL Balances. What are the actions / precautions we need to take at the time of New GL Migration time.

895


Why did you decide to study microbiology? What do you like about it?

1008


cant i ask health related questions? if so how?

837


Under Operations, What are the principles of Control & Management?

1948


Discuss the steps involved in Business Research decision- making process.

947


Explain the word Liquidation

783


what is the anual report of hcl bpo

1011






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)