Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)
6 16585Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause
6 14500If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING
10 21327What is the use of cursor ? how cursor allocate context area for executing the sql statement?
4 16613what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?
3 11458what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...
1 5359Post New HCL SQL PLSQL Interview Questions
Explain batch processing in ab initio?
What is a values collection view ?
What are the ansi data types supported in oracle?
How would you convert bytes to string?
What is emulator?
When would you use get and post requests?
How many kinds of kohonen networks exist?
how to change the instance-operating unit?
Define water softening?
properties of fehling's reagent
What is the difference between the bandwidth of half duplex and simplex transmission?
11KV AND 22KV NETWORK KW CAPACITY IN RING AND RADIAL?
What are the applications of graph data structure?
Why r-c filters are suitable only for light loads?
Why do you have an inclination towards this industry?