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 15000Which 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 13007If 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 19220What is the use of cursor ? how cursor allocate context area for executing the sql statement?
4 15288what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?
3 10523what 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 4387Post New HCL SQL PLSQL Interview Questions
What is catalog profile?
why athanol-water mixtuere have maximum viscocity in wt% 40?
Why do we use class in c#?
What's new in sql management studio for sql server? : sql server management studio
Explain the difference between int and int32?
How do i write a test condition to test the following simple program with the intention of 100% statement coverage Print “Hello World” If Date $ = ‘01-01-2000’ then Print “Happy New Year” END IF PRINT “The date is = “Date $ PRINT “The time is = “Time $ END Could anyone please clarify in detail. Would really appreciate it....
Why is it called c sharp?
How can we work with error tags?
Give me the asset revaluation (at the time of asset value increase & decrease) journal entrys?
Discuss the potential biases that AI might introduce in legal applications.
can u please explain what is the exact difference between qtp8.2 and 9.0
what is the command to see the error log?
Actinium is part of the actinide series. Could you explain the significance of this series and its placement in the periodic table?
What is the origin of CSS ?
Hi All , Would be providing online trainings for SAP ABAP , guidance with real time experience examples , guidance in profile prepartion . Any one intrested please contact on 8978890047.