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 16114Which 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 14061If 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 20817What is the use of cursor ? how cursor allocate context area for executing the sql statement?
4 16276what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?
3 11214what 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 5149Post New HCL SQL PLSQL Interview Questions
Explain signal isolator
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How much does outlook email cost?
What is dispute management?
How to change chart of accounts of company code after making several sales orders and delivery?
How can I install drupal on a local wamp server?
What is finding and replace feature?
How to delete an index from json obj?
How to insert a large table in word?
What is data loss prevention (dlp)?
Why synchronization is important?
How is the pricing of consignment stocks done? What information does consignment info record contain?
Is there a shortcut key for autosum in excel?
Particulars Dr Cr Capital 10,000 Machinery 3000 debit 2500 1400 sales - 14,500 drawings 900 purchase 9500 wages 5000 bank 1500 Opening balance 2000 rent 450 salary 200 carriage 150 total ___________ _________ 25,900 25,900 ____________ ________ how to find closing stock as on 31st dec,1998. wages outstanding 200/- sunnery expenses outstanding 100/- rent prepaid 100/-
What classes of exceptions may be caught by a catch clause?