| Other SQL PLSQL Interview Questions |
|| Asked @
|What is a constraint. Types of constraints ?
|What are nested triggers ?
|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
|How is Oracle 10g helpful when compared to oracle 9i and what is grid computing
|What can be a size of a pl/sql block? Is there any limit?
|Do view contain data?
|How can I create a table from another table without copying
any values from the old table?
|what is a sub query?how will you calculate working days in
a month using sub query?
|How to come back in normal stage in Mutating Table if
mutating table is locked or update data?
|what is sql and plsql
|How can multiply values of a column? OR How can multiply value
of a row of a column using a single query in SQL?
|What is the Subquery?
|For more SQL PLSQL Interview Questions Click Here |