How many LONG columns are allowed in a table?6 18684
What cursor type do you use to retrieve multiple recordsets?17 56962
What is normalization ?9 16007
What is an index and types of indexes. How many number of indexes can be used per table ?12 73073
State the difference between implict and explict cursor's?7 18259
how can we find the select statement is indexed or not?3 12981
What are wait events. Describe the wait event tables.1 5047
How do u count no of rows in a table?8 10930
When do we create bitmap indexes2 7760
sql query to get zero records from a table having n no of records8 17858
function can return multiple value?how give give sample coding2 13843
Difference between NVL, NVL2 and NULLIF1 33582
Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?2 8346
What are the Diff B/W Cursor and REF Cursor3 10208
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) Joins738
What's the last thing you learned that you thought was really interesting? : insurance cold calling
Explain what are the steps to build the data warehouse?
Is it ok to delete downloaded program files?
How many commands are there in linux?
What is the use of the persistence layer in sap hana system?
In a barber shop there are 2 doors. customer come in 1 door, leave in other. minimum # of chairs. barber spend his life in cutting. always barber can cut 1 customer. few chairs in the shop. if barber busy customer waits, if chairs full, customer leave. if no customer, barber sleeps. treat barber and customer as 2 threads. you can use Semaphore class with arrive and depart and count as parameter.
How to sort double array in java?
which dance form does you like most?
Is it cc or c in a letter?
What are the advantages of java?
Why we are using Macros instead of Function Modules
will you be comfortable in relocating?
When creating your own loops always create a counter and throw an exception if it loops to much in blue prism. Is it true or false?
Which files are created during the session rums by informatics server?
what are the different theories of failure under static load, explain briefly?