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 86741 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 10200SELECT 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 12337Which 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 6608Post New Sonata Interview Questions
In Third Party sale process, I am getting an error- in MIRO(Error No. M8889-A/c 893010 has been set as not relevant for Tax, but when I want to change the Account Assignment in ME21 it is taking only G/L A/C 893010 and refusing all other G/L A/C's by giving 2 errors. They are ME045-G/L A/c 39010 cannot be used(please correct)and ME038-No direct posting can be made to G/L A/C 34000. Experts please share your knowledge to solve this problem. Warm Regards.
default triggers available for reports
What is the different between ResultSet and RowSet?
Is it possible to call oracle database through ADO control or Object?
What is menu bar in ms powerpoint?
What is line group in CUCM?
How do I show the toolbar in excel 2010?
What is faster than apache spark?
Explain Secret splitting protocol?
How can you call a controller method from javascript?
Which fields are indexed by default in salesforce?
What is the pay scale type?
How to create filled maps?
Is there any method apart from bdc for data upload to sap? : abap bdc
How to create war file?