Interested to Buy Any Domain ? << Click Here >> for more details...
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 89371 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 10621SELECT 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 12882Which 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 6769How 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 16600Post New Sonata SQL PLSQL Interview Questions
- Sonata C Interview Questions (2)
- Sonata PHP Interview Questions (1)
- Sonata Programming Languages AllOther Interview Questions (1)
- Sonata VB.NET Interview Questions (1)
- Sonata Crystal Reports Interview Questions (1)
- Sonata BizTalk Interview Questions (1)
- Sonata Dot Net Framework Interview Questions (1)
- Sonata SQL Server Interview Questions (1) Sonata SQL PLSQL Interview Questions (5)
- Sonata WinRunner Interview Questions (3)
- Sonata QTP Interview Questions (4)
- Sonata Manual Testing Interview Questions (15)
- Sonata QA Concepts Interview Questions (2)
- Sonata Mobile Testing Interview Questions (1)
- Sonata Testing AllOther Interview Questions (2)
- Sonata Core Java Interview Questions (2)
- Sonata Cognos Interview Questions (1)
- Sonata Informatica Interview Questions (3)
- Sonata SAP FI-CO (Financial Accounting & Controlling) Interview Questions (1)
- Sonata Oracle Apps Financial Interview Questions (2)
- Sonata ERP CRM AllOther Interview Questions (1)
- Sonata Engineering AllOther Interview Questions (4)
- Sonata Banking Finance Interview Questions (1)
- Sonata Operations Management Interview Questions (1)
- Sonata General Aptitude Interview Questions (16)
- Sonata Placement Papers Interview Questions (2)
Compare javascript remoting and
MY name is Bartlemou (bartek for short)Uzeph Kazmeria I am from poland and one day i want to go on polsfactors IM POLISH AND I KNOW IT :D
Alprazolam has the potential for misuse and addiction. How would you approach prescribing Alprazolam to a patient with a history of substance abuse?
What is a composer in PHP?
What is the difference between malloc() and calloc()?
Why main() method is public, static and void in java ?
What is risc architecture?
what is the meaning of 40/20 src
How to create a variable in typescript?
Is singleton a bad practice?
How do i carry out or know the vector group of a Dyn1 and Dyn5 transformer
In which process internal energy remains constant ?
how do you declare variables in javascript?
Do you know what's the “kernel trick” and how is it useful?
How cakephp url looks in address bar
