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 86731 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 10195SELECT 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 12328Which 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 6607How 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 15961Post New Sonata SQL PLSQL Interview Questions
Explain hard disk and what is its purpose? : Dot net architecture
difference between semiconductor & conductor & insulator?
What are lookups in excel?
What are taxonomies in wordpress?
Can you explain what does aldb_server do?
Explain cakephp and why it is used?
What css class do you use to span 12 columns on medium sized screens but only 6 columns on large screens in the latest version of bootstrap?
Describe when would you practice joins vs. Blending in tableau?
How are animals classified according to the germ layers present in their embryonic development?
can I create a dff on any database column?
We use Potassium Dichromate solution for the calibration of UV-Visible Spectrophotometer in UV region. My question is to calibrate visible region which solution could be used in photometric accuracy
What is JDBC RowSet? What are different types of RowSet?
How many numbers of line items in one single entry you can have?
Can multiple xml namespace declarations be in scope at the same time?
What is cdk in angular?