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 16580Which 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 14499If 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 21326What is the use of cursor ? how cursor allocate context area for executing the sql statement?
4 16609what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?
3 11456what 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 5357Post New HCL SQL PLSQL Interview Questions
What is internal payroll process?
How to make qtp understand the difference amongst the same type of objects .suppose there are 5 check boxes in a page and I have to choose the 2nd one, how to do that through script?
What is presto?
What is ivy rendering engine in angular 7?
What are the advantages of speed control using thyristor?
What type of steps comes from Product Costing to CO-PA ?
What are the differences between Subscription Administrator and Directory Administrator?
How can one know if the apache web server is running?
Why is Apache Spark faster than Apache Hadoop?
What is a sql trace file?
What purpose do Work Workers serve and what are some of their benefits?
define is catalog and types of catalogs in cognos?
How do you create margins in word?
Overview of G/L account :- Dear, what type of G/L account use in SAP.How to see all type of G/L account in sap those are used in a organization
What are the biggest challenges you see in AI implementation across industries?