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 16332Which 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 14283If 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 21066What is the use of cursor ? how cursor allocate context area for executing the sql statement?
4 16437what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?
3 11326what 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 5256Post New HCL SQL PLSQL Interview Questions
What does the scope of variables means?
Do you know what is a trace frag? Where do we use it?
What are wordpress functions?
Does the existing Authorization Service of CORBASec scale in a "well" distributed-object environment?
What is the difference between rss feeds and atom feeds?
What is the use of LC? How is it useful in export sales?
What is an attribute dictionary and what are its benefits?
What is the purpose of requestdispatcher interface?
Data structure used to implements a menu:
Define piggybacking?
Where is apache installed?
What are the advantages of redux?
What is nextint java?
What is the best email software for windows 10?
Why is search engine optimization and marketing so important?