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 16095Which 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 14047If 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 20798What is the use of cursor ? how cursor allocate context area for executing the sql statement?
4 16264what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?
3 11209what 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 5145Post New HCL SQL PLSQL Interview Questions
What are the uses of explode() and implode() functions?
Is set ordered in java?
How can sedimentary processes concentrate and form resources? Give an example of a resource formed by a sedimentary process.
What is css attribute?
What is the benefit of using bw reporting over sap reporting?
How does cross join work?
interviw tips for bhel supervisor trainee
How can you hide an html element just by a button click in angular?
What is google dagger?
how can we design robots
What is kpis (key performance indicators)?
What are grep commands?
What is difference between Auto design and Generate design ? If we uses both designs in a report what design will be print?
how do you round the addition or subtraction of two numbers in assembler? what does the following code do? change process tool(code changes from dev to prd) the changes made to your code should be effected in live. How the process takes place. That is how can you move the code changes from development to production?
What do you mean by rollback?