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 60391 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 4930SELECT 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 5866Which 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 4541How 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
8 8144Post New Sonata SQL PLSQL Interview Questions
i am electronics & comm engg & appling 4 the AAI jr executive (electronics/ATC) written test. pls forward me the syllabus & old question papers.I will be very much thankful to you, snehalsanap@gmail.com
HOw can I get the negative sign while deduct high value from low value
Anybody please send me the papers of the reliance exam (apti and tech) so that i can go through it) mail me at raminder_verma@rediffmail.com
Which is the pin no of CN1 TERMINAL and the parameter using in delta servo drive for auto/man input and start forward input
what is the difference between vat return and return for remittance on value added tax.
Why humidity limit is 30 to 55 % for raw material storage?
Can anyone send me the what the scenario's client given in the real time,I mean functionalspecs,reporting scenarios?
Why slip ring ind. motor power consumption is low compare to induction motor .same 90 kw motor used same load output
How many ways you can restrict data in business objects
how to introdu5ce my self in serco
What is batch input? why we use batch input session in SAP(FICO)?
What is the use of INV-Receipts and PO-Reciepts,Just give me the Differences&When,At what Instances to use Them...?
why u have not worked anywhere for 3 years
hai can anyone send me soft copy of o.p gupta or tell me downloading link please please at saify_0@hotmail.com
what is bailout fund and what are the main drawbacks of bailout funds? what is the role of bailout fund in an economy and what are the impact of bailout fund on market , economy , the bailout provider and the bailout reciever?
- C (2)
- PHP (1)
- Programming Languages AllOther (1)
- VB.NET (1)
- Crystal Reports (1)
- BizTalk (1)
- Dot Net Framework (1)
- SQL Server (1) SQL PLSQL (5)
- WinRunner (3)
- QTP (4)
- Manual Testing (15)
- QA Concepts (2)
- Mobile Testing (1)
- Testing AllOther (2)
- Core Java (2)
- Cognos (1)
- Informatica (3)
- SAP FI CO (1)
- Oracle Apps Financial (2)
- ERP CRM AllOther (1)
- Engineering AllOther (4)
- Banking Finance (1)
- Operations Management (1)
- Placement Papers (2)
