How many LONG columns are allowed in a table?6 20922
What cursor type do you use to retrieve multiple recordsets?17 61896
What is normalization ?9 18226
What is an index and types of indexes. How many number of indexes can be used per table ?12 77105
State the difference between implict and explict cursor's?7 19716
how can we find the select statement is indexed or not?3 14879
What are wait events. Describe the wait event tables.1 6010
How do u count no of rows in a table?8 12441
When do we create bitmap indexes2 8445
sql query to get zero records from a table having n no of records8 21283
function can return multiple value?how give give sample coding2 14715
Difference between NVL, NVL2 and NULLIF1 34980
Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?2 9137
What are the Diff B/W Cursor and REF Cursor3 11136
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins986
What is a singleton factory?
Mention what is the hadoop mapreduce apis contract for a key and value class?
What are the parameter we cannot use in procedure?
Can c++ do everything c can?
What is the msi mode in weblogic? How can you enable and disable this option?
Give the detailed structure from marketing planner to service
What is a master or primary?
What are the differences between the java collection and the java list? : java collections
What is data validation and what is its purpose?
What is the tax slab for 2018 19?
If RDBMS is halted what will you do ?
What is cube dimension? : sql server analysis services, ssas
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
Define an ecosystem?
How do I use vlookup?