what is meant by DML?5 7696
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 10416
Which 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 clause6 8473
If 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. HAVING10 12881
Types of locks in database ?8 69347
What is normalization ?9 14862
What is the use of cursor ? how cursor allocate context area for executing the sql statement?4 11746
Can a table have two primary keys?44 68203
what is the boundary line in varrays?1 5616
When we give SELECT * FROM EMP; How does oracle respond?24 37020
Write one update command to update seqno field of a table on the basis of row number.4 13320
what is indexing, searching and user interface?1 3271
what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?3 8106
i want to display 1 to 10 numbers using one select statement.18 29257
what 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 2181
Give 10 points of differences between C & C++.
What are the Color reduction techniques for graphics?
What is your recommendation for a query running very slow? : sql server database administration
What do you mean by the term “percolate up”?
IF TVM OF TRANSFORMER SHOWS POWER FACTOR ON 33 KV SIDE AS 0.97 LAGGING AND ON 132 KV SIDE IS 0.75 LEADING.IS THIS CORRECT.WHERE IS PROBLEM.
Explain about Views?
Assuming that the density of the solution is the same as the density of water (density of water=1.000g/ml), calculate the mass of water for both reactions using: mass of water = Volume of water Density of water. Mass of water =
What are the system tools you can use?
How to use Hive using the command line and Beeline?
Explain ibm z?
When u create a new record?
i want to do oracle certification..could any one pleas tell me what is the level 1 certification exam in oracle? how do we get dumps?
what is the function and use of cable differential protection relay?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?