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 13958Which 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 11899If 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 17797What is the use of cursor ? how cursor allocate context area for executing the sql statement?
4 14439what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?
3 9860what 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 3634Post New HCL SQL PLSQL Interview Questions
In job processing, what happens in conversion stage?
What is the default session timeout duration and how can it be set?
How many rows can mysql hold?
Name the numeric constants representing max, min values?
Explain a few methods of overloading best practices in java?
How many postgresql users are there, worldwide?
What is hierarchical relationship in SFDC?
What does ls stand for linux?
What is Flow Switch in UiPath?
How reliable are the site's Internet connections required to be? And how does that affect backup system or redundant connection requirements and testing?
Is outlook 365 the same as outlook 2019?
Hai iam a VAT Registered dealer am a manufacturer and am going to sell my products to unregistered dealers i can pay d 4% vat.. how can i make my bill format for this sgrc.gy@gmail.com. anybdy kno means pls mail me.
What are match types?
When should you use a reducer?
Define joiner transformation?