Give two examples of referential integrity constraints.
How can you rebuild an index?
what is correlated subquery
How many segment are present in Oracle Manufacturing
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
What does coalescing a tablespace do?
Explain the difference between a data block, an extent and a segment.
how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
How would you determine what sessions are connected and what resources they are waiting for?
how to display last 5 letters from a name (take emp table ename )