Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 19th, 2006

These answers are probably all correct---if it's SQLServer or Sybase. I don't think the DBMS was identified and for sure the data dictionary/relational catalog/system tables are not standard in naming...

rajnarayan yadav

• Jan 16th, 2006

 Index information in : user_indexes Constraint information in : user_constraints and user_cons_columns

Answer Question  Select Best Answer

sandyasel

 Profile Answers by sandyasel Questions by sandyasel

• Mar 17th, 2006

It is the property of the database to utilize the additional resources such as the memory and processors to meet the increased demand. By scaling performance is increased to a greater extend

sandyasel

 Profile Answers by sandyasel Questions by sandyasel

• Mar 17th, 2006

Scalabilty is a database property by means of which the database utilizes the available additional resources such as the memory and the processors to meet the  increasing demand.

Answer Question  Select Best Answer

Kajal Pancholi

• Mar 16th, 2006

I think that this is not possible in the ORACLE. 

Answer Question  Select Best Answer

apiplani

 Profile Answers by apiplani Questions by apiplani

• Feb 14th, 2006

There are a number of things you can add to checklist while setting up DBMS and the checklist will depend on which kind of organisation is it. I am assuming you are a DBA setting up DBMS for software ...

Answer Question  Select Best Answer

DIPTENDU HUI

• Jan 28th, 2006

For Indexes you can use :DBA_INDEXESALL_INDEXESUSER_INDEXESFor Constraint you can use :DBA_CONSTRAINTSALL_CONSTRAINTSUSER_CONSTRAINTSFor index upon which table and which column you can query on:DBA_CONS_COLUMNSALL_CONS_COLUMNSUSER_CONS_COLUMNS

Answer Question  Select Best Answer