Describe the different type of Integrity Constraints
supported by ORACLE ?
Answer Posted / prna
SELECT MIN(SAL) FROM (SELECT SAL FROM (select sal from emp group by sal order by sal desc) WHERE ROWNUM<=3)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How to convert character types to numeric types?
What do you understand by a database object? Can you list a few of them?
what is reindexing?
What is the data pump import utility?
How do I limit the number of rows returned by an oracle query after ordering?
How to invoke the data pump import utility?
How to check the server version in oracle?
6. Display the client name and order date for all orders using the traditional method.
What is a proxy object?
Where is the export dump file located?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What do you mean by merge in oracle and how can you merge two tables?
How oracle handles dead locks?
What is a sub query and what are the different types of subqueries?
Explain a private synonyms?