Sonata Interview Questions Answers, Sonata Placement Papers, Sonata Technical, HR Interview Questions, Sonata Aptitude Test Questions, Sonata Campus Placements Exam Questions

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 8951

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 10632

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 12902

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 6778

what load_dll in winrunner

2 6205

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

10 14206

In real time where u can apply traceability matrix

5 11295

what is diff between stress & load testing

8 11570

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

1 4035

what is the difference between verification and validation

2925

what is test strategy

2051

What a test plan contains

2104

what is the use of testing? is testing compulsary

16 26853

Post New Sonata Interview Questions

Sonata Interview Questions

Un-Answered Questions

What are Paired RDD?

331

What is the rule of six for powerpoint?

396

Does salesforce count calls to system.debug() against the code coverage?

719

Explain the aims of teaching mathematics at secondary level.

1092

What is difference between Agile and V model? Explain

2355

How do I put password to protect my entire spreadsheet so data cannot be changed?

697

Is jms a message broker?

945

What is tag file in jsp?

933

Explain the difference between jakarta struts and apache struts?

994

What do you mean by roles in azure?

634

Explain the mapping variable usage example in informatica

1224

Explain the difference between sql statements and metasql statements?

731

What are three soil science meanings of the term "clay"? : soil science

1053

What are commit, rollback, and savepoint?

1049

What is IPv6 (Internet Protocol version 6)? What is multicasting? Explain the headers of packet format of IPv6 and IPv4?

1172