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 Retesting?

22 32738

Consider if there is no Test lead, No Test Manager and QA Manager. If you are the senior test engineer, you are getting pressure from the client to give the build. But you see that, there r 5 high and 5 low sevierity bugs. So, what you will do and how you interact with the client.

14 23693

What is Integration Testing and its types

7 47938

What is the maximum length of the test case we can write?

4 12459

which will be first in c compiling ,linking or compiling ,debugging.

3 8915

What is the difference b/w Readonly Variable and Constant Variable?

7 23404

where u use Abstraction and Interface in real time

3 8906

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 8824

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 10458

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 12667

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 6715

what load_dll in winrunner

2 6103

what is diff. between CMMI and CMM levels?

9 22633

Is there any feature like summing total in crystal report?

11 31044

If I do not check any of the add-ins that pops up initially, for which type of application can I do scripting?

2 5212

Post New Sonata Interview Questions

Sonata Interview Questions

Un-Answered Questions

Is file format in data services type of a data store?

What is the use of connection factory in jms?

860

What is the default microsoft word font?

641

What COM Interfaces u r using in QTp While Connecting QC or TD? Or in QTP?Any body plz urgent...

1960

WHY TERTIARY OF POWER TRANSFORMERS IS LOADED WITH EQUIPMENTS LIKE CT,PT,ISOLATOR AND CB

1908

Explain $_FILES Superglobal Array?

1039

Is pl sql a scripting language?

1031

What happens when a value is too big for fixnum?

How can you link a query to a data container manually in Report Studio?

2360

What are the most common sources for cGMP

2671

why require the ph, buffer during hplc mobile phase?

861

What guarantees the integration of all application modules?

699

What is joomla programming language?

Tell me how will you create a progress bar using bootstrap?

WORKING-STORAGE SECTION. 77 W-A PIC 9(3)V99 VALUE 23.75. 77 W-B PIC ZZ9V99 VALUE 123.45. PROCEDURE DIVISION. MOVE W-A TO W-B. DISPLAY W-B. STOP RUN. compiler : IGYGR1080-S A "VALUE" clause literal was not compatible with the data category o subject data item. The "VALUE" clause was discarded. WORKING-STORAGE SECTION. 77 W-A PIC 9(3)V99 VALUE 23.75. 77 W-B PIC ZZ9V99. PROCEDURE DIVISION. MOVE 123.45 TO W-B. MOVE W-A TO W-B. DISPLAY W-B. STOP RUN. 2375

1477