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 16365Which 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 14320If 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 21103What is the use of cursor ? how cursor allocate context area for executing the sql statement?
4 16454what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?
3 11338what 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 5266Post New HCL SQL PLSQL Interview Questions
What is pki?
What is type I hypersensitivity?
Is string a class?
what is the difference between the below two statements:- (1) var myname = "akiii"; (2) myname = "akiii";
can anybody help me how to write a test case for a program eg: c or C++ ,and also how to check their outputs
Is Python good for backend?
explain safety measures in alternator?
1)why do you select bpo industry? 2)why you left your previous hotel industry? 3)what do you know about this bpo industry? 4)Are you intrested to work in this industry?
Can you outline a schema at run time?
How you get a ToolTip over a disabled element in WPF?
Igfet is a
Does windows 10 fresh start work?
What is session and cookies in django?
Explain unsecured loans.
Use of list-databases command in hadoop sqoop?