| Other SQL PLSQL Interview Questions |
|| Asked @
|select 1,col1,col2 from table1. output?
|select top 3 sal from each dept?
|CAN U CREATE A PRIMARY KEY WITH OUT UNIQUE INDEX.
|What packages(if any) has oracle provided for use by developers?
|What is difference between CHAR and VARCHAR2?What is the
maximum SIZE allowed for each type?
|Can you have multiple SPs with the same name on a database?
|what the meaning of sql
|can we delete the trigger in a view? if yes why if not why?
|Store procedure will return a value?
|what is data integrity
|How to trace the errors in pl/sql block code?
|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
|For more SQL PLSQL Interview Questions Click Here |