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 11413Which 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 9391If 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 14145What is the use of cursor ? how cursor allocate context area for executing the sql statement?
4 12606what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?
3 8672what 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 2515Post New HCL SQL PLSQL Interview Questions
What are the tools for process improvement?
Explain what is tableau data extract?
Is a hash table an array?
Can we create users in blue prism?
Explain how are 16- and 32-bit numbers stored?
What is Metrics designer?
what is the reason of hat and work is not conserved energy?
Can we create dynamic classes in objective c?
Name the types of motors used in vacuum cleaners, phonographic appliances, vending machines,refrigerators, rolling mills, lathes, power factor improvement and cranes.
What are the advantages of the code-behind feature?
Explain how to create prt master records?
what is difference between set screen and call screen ?
What are the uses of API's in cloud services?
What is ioc container in spring?
How many types of normalization are there?