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 16002Which 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 13991If 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 20705What is the use of cursor ? how cursor allocate context area for executing the sql statement?
4 16197what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?
3 11158what 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 5098Post New HCL SQL PLSQL Interview Questions
Explain what do you understand by cassandra- cql collections?
express your imagination of a situation where you were at the verge of failure but turned it into success through your ingenuity?
in cobol,wat is the difference in using 'set index in occurs clause' ....and 'occurs depending-on clause'
What are the advantages of c++?
What are the difference between normal application Transformer and Solar application Transformer?
Why services are used in angularjs?
How to extract bacteria from HUT TEST ?
Explain what is mongodb?
can u give example for factless fact table
Is ms access part of ms office?
Is linux supported as a frontend platform?
what are the basic features of seu?
You are a B.E Student? How can u manage Banking?
What is EndPoint in camel?
On what basis name node distribute blocks across the data nodes?