Answer Posted / kavitha
select ename,sal
from employees
where rownum <=1
order by sal desc
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
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) Joins
i have some prob lem to tell me about my self in interview first round ...
What is pl/sql table? Why is it used?
What are the properties of a transaction?
What will you get by the cursor attribute sql%notfound?
What is memory optimized table?
What do you know by pl/sql cursors?
How can you save or place your msg in a table?
what are wild cards used in database for pattern matching ? : Sql dba
Mention what are the benefits of pl/sql packages?
What are views in sql?
What is pl sql architecture?
how many tables will create when we create table, what are they? : Sql dba
How can we link a sql database to an existing android app?
What is database white box testing and black box testing?