what is meant by DML?5 7337
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 9875
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 7955
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 12228
Types of locks in database ?8 68233
What is normalization ?9 14254
What is the use of cursor ? how cursor allocate context area for executing the sql statement?4 11190
Can a table have two primary keys?44 65853
what is the boundary line in varrays?1 5261
When we give SELECT * FROM EMP; How does oracle respond?24 35204
Write one update command to update seqno field of a table on the basis of row number.4 12865
what is indexing, searching and user interface?1 2965
what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?3 7757
i want to display 1 to 10 numbers using one select statement.18 27846
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 1970
what is used of Property........End Property loop ? how to write the script for it?
can i change the runtime properties of an object ? How can i check if a parameter exists in database ?
What is normal radiation field out side the reactor building?
what are the different phases in delivering the project during development and maintenance?
what is pouring and explain
what is machine tpm
what is the uniform public construction cost accounting act?
i know the syllabus for the tax assistantexam but i would appreciate some tips fromyou on how to prepare for the general awareness paper.
what do you know about US culture?
What are the causes if one cylinder in a diesel engine has a high temperature?
write test case for gmail login page
can you explain about the design calculations and procedure of boiler
The sodium vapor lamp is not glows when it is connected a distance of 5 meters above from gearbox, why ?
What are the main components of the CERT Taxonomy?
all possible test cases for normal number field,name field date field,check box,