 Related Questions How to check intact, state of a particular index, what are the impacts of invalid index? How to recover it? Read Answers (1) | Asked by : reddy Latest Answer : Index will only help you in searching the data but unique index will provide uniqueness to the indexed column. But in both the cases NULL values are allowed to insert. ... Latest Answer : select * from user_indexes where status ='Invalid'you can specify index_name in the same query to look for a particular INDEX. ... 1. Queris for Nth maximum Nth row?2. In One table there are 5 fields. empno, ename, deptcd, managr_id, salary.Select the departments whoose sum of the salary greater than the sum of salaries of any department?3. When index will be usd in the Query? Read Answers (7) | Asked by : DEBPROSAD BANERJEE Latest Answer : If you are a DBA, login on the host using sqlplus to the database using sys as sysdba privilege.$ export ORACLE_HOME=$ export ORACLE_SID=$ sqlplus "/ as sysdba"Execute the Oracle-supplied utility to ... Latest Answer : Index are reference to data in tables's columns on what they are based. Index work exactly in way like we have book's index describing its chapters and what page # chapter can be found.They only contain reference to the data. There are two types on ... Read Answers (1) | Asked by : Iniyavan
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
