Sonata SQL PLSQL 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 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 8674

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 10200

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 12337

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 6608

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

10 15965

Post New Sonata SQL PLSQL Interview Questions

Sonata SQL PLSQL Interview Questions

Sonata SQL PLSQL Interview Questions (5)

Un-Answered Questions

What number of parts are there in blue prism?

368

A. Distinguish between the individual and the group decision - making, explaining the advantages and disadvantages of group decision-making. B. Distinguish between individual change and organizational change.

3230

What is a phase change memory?

947

What is a case?

391

What is the difference between Java1.4 and Java1.5

2254

How to find the bearing dimension from its number for ex 24040

2070

What is default controller in codeigniter?

571

Why is sql server log file full?

979

Explain what is “map” and what is "reducer" in hadoop?

597

What is the name for the celestial body of interstellar gas and dust where stars are sometimes born?

102

What is a copy constructor? What is the need for it?

950

This person established the one fluid theory of electricity and performed some of the first investigations into electrical grounding and insulation:

884

What is a good presentation?

307

Mention the command syntax that is used to view mongo is using the link?

What is a web tag?

733