How many LONG columns are allowed in a table?6 14466
What cursor type do you use to retrieve multiple recordsets?17 50390
What is normalization ?9 13270
What is an index and types of indexes. How many number of indexes can be used per table ?12 67178
how can we find the select statement is indexed or not?3 10240
What are wait events. Describe the wait event tables.1 3350
How do u count no of rows in a table?8 8750
When do we create bitmap indexes2 6622
sql query to get zero records from a table having n no of records8 13404
function can return multiple value?how give give sample coding2 11572
Difference between NVL, NVL2 and NULLIF1 28405
Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?2 7044
What are the Diff B/W Cursor and REF Cursor3 8582
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) Joins352
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?301
How much cement and water required for cement selery????
What is blast furnace
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
how to compute slab reinforcements on step by step procedures??
What is difference between SMC supportg and Glass Fibre Reinforced Plastic Support.
what type of mapping is most used in maya production house?
how could test the speedo meter
What problem does Apache Pig solve?
What are the accounting conventions and Practices?
Why does your company have high growth potential? - Venture Capitalists
What is the use of string function asorti(string,[d])?
what is circuit recombiner and how it is different from circuit breaker
what is meant by surge? what we called for high currents?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What is the difference between RFC and BAPI?