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 16352Which 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 14311If 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 21091What is the use of cursor ? how cursor allocate context area for executing the sql statement?
4 16444what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?
3 11329what 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 5260Post New HCL SQL PLSQL Interview Questions
What is the master repository?
Which are all the commonly used Bordon tubes in the pressure gauges. Do any one use ASTM A 312 tubes for this purpose?
How do you reverse a list?
How can you add a new partition for the month December in the above partitioned table?
Define shortest path?
Is java util list serializable?
What are the parts of ms word 2010?
By default what is the prefix Joomla have?
Which are the two types of 'writes' in HDFS?
What are the apex data types?
What is a de-referenced variable?
Explain the t code for payroll driver.
What does it mean when tags or attributes are said to be deprecated?
Should I use br tag?
What are the responsibilities of clinical lab technician?