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 16007Which 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 13992If 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 20708What is the use of cursor ? how cursor allocate context area for executing the sql statement?
4 16198what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?
3 11161what 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 5099Post New HCL SQL PLSQL Interview Questions
Hi every body my name is Purushottam Kumar I am newly jobholder or fresher in sales and marketing.Plz help me how to do the better performance in this sector?I would be thankful for your cooperation. Purushottam.
What is a Encryption Process ?
How do you view private pages on wordpress?
Advantage of LT panel vs HT panel
Can we create two sessionfactory in hibernate?
What kind of framework is angular?
What is 'cheap money'?
Why dll files are missing?
Why doesn’t the focus feature on the tag work in every circumstance?
Why is singleton used?
abdul, you have technical background but why do you want to come in BPO & for non- technical process?
what is Anti-pumping?
Where people codes get stored?
Explain the use of constraints option in exp command.
Does sap use sql?