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 6088

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 4998

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 5945

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 4579

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 8275

Post New Sonata SQL PLSQL Interview Questions



Un-Answered Questions

what is the purpose of bypass mode in energy lighting transformer?

1280


What are video parameters?

289


i want syllabus for section engnieer and previous year question papers

813


i want to retrive data from one spead sheet to another UI (workbook). control will search cell by cell for each row and load the data in another workbook(UI).

1038


Hi I want to start online training couses for testing Any body plz help me out how to start the online courses Plz post the answer here or send me a mail for kommineni.1020@gmail.com

863






How to calculate heat load .For example 10 TR .Then how we will find load (we want rh(relatavie humidity) sir)

439


1.what is the power consumption of three element drum level control in sugar industries? 2.how to reduce that?

459


How can I get know that my pc contains dram or sram..?

732


what are different storage options supported by oracle ?

946


I am surekha new commer for this site? I have some doubt's pls clarify it..... I finished my B.tech and S/w Testing Course Now iam searching for a job in Testing, I did not have any experience in real time projects. Any body can send me the sample Testcases,Srs,Matrix for Banking,ERP Projects etc.Here is my email id surekhai@yahoo.com

2754


how to identify vector group of three phase transformer by voltage method?

406


What a test plan contains

806


What are BRI and PRI? What are Channels?

369


Why does Oracle not permit the use of PCTUSED with indexes?

1594


Describe Bone marrow transplantation ?

795






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)