Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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
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 6891

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 6484

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 7772

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 5201

what load_dll in winrunner

2 4129





What is Smoke testing,in smoke testing time u will prepare the test cases or not?

10 8568

In real time where u can apply traceability matrix

5 8069

what is diff between stress & load testing

8 7162

When a new build comes what is the first step taken by a tester in testing

1 2614

what is the difference between verification and validation

1961

what is test strategy

1051

What a test plan contains

1197

what is the use of testing? is testing compulsary

16 18994

Post New Sonata Interview Questions






Un-Answered Questions

How do you create a template in pages?

24


create a menu which has the following options:cut-can be on/off,copy-can be on/off,paste-can be on/off,delete-can be on/off,select all-put all4 options on,unselect all-put all 4 options off,using event handling in MIDP application

4665


write a program that changes 74H to 47H in 8085 assembly programming

1526


What is hash in java?

201


Name the command to display characters to the html page?

210






What is a table cluster? : abap data dictionary

299


Define outer join in sql server joins?

230


What is rtm stands for?

203


what is the use of primary cost component split in PC? How would you calculate the overheads per qty without using costing sheet?

3182


What is ‘natural fibers'?

1


How do I check my cpu speed?

222


What do bd65 t-code stand for?

227


Why is xhtml needed?

175


Can a windows 7 be upgraded to windows 10?

183


What is the advantage of outlook?

1