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 7676

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 8531

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 10102

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 5853

what load_dll in winrunner

 2 5094

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

 10 10868

In real time where u can apply traceability matrix

 5 9526

what is diff between stress & load testing

 8 9106

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

 1 3238

what is the difference between verification and validation

 2332

what is test strategy

 1435

What a test plan contains

 1552

what is the use of testing? is testing compulsary

 16 22265

Post New Sonata Interview Questions


Sonata Interview Questions


Un-Answered Questions

How do I print horizontally?

305

Explain call flow for roaming mobile to roaming mobile?(Both users are belongs to same state but staying on roaming in different states)

564

what is the benefit of applying Connect Patches in Magento?

5

How can you find out which stored procedures are recompiling?

516

What is Basic Response in Laravel ?

830




What is a parent child selector?

318

What is intranet application?

476

types of laps in column

1922

What is actionerrors?

528

What kind of Reporting you do?

1380

How do I disable iis express?

546

Give me an example of a time when you were 75% of the way through a project, and you had to pivot strategy--how were you able to make that into a success story?

1584

What are certificates?

523

What are the rules of the move verb?

708

From a strategic perspective, how can senior management make the best use of human resource function?

1919