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

Kajal Pancholi

• Mar 16th, 2006

I think that this is not possible in the ORACLE. 

Answer Question  Select Best Answer

opbang

 Profile Answers by opbang Questions by opbang

• Sep 23rd, 2006

A  Hash index stores key value pairs based on a pseudo randomizing function called hash functionA B+- Tree is a balanced tree whose leaves contain a sequence of key pointer pairs.- Use a hash index for point queries only. Use a B- Tree if multipoint queries or range queries are used.

Answer Question  Select Best Answer

sri

• Oct 11th, 2006

We can normalize the many to many realationship, by creating a third table contaaining the primary keys of both the tables

sv_shali

 Profile Answers by sv_shali Questions by sv_shali

• Feb 18th, 2006

By creating a third relation table containing only the primary keys of both master tables.

Answer Question  Select Best Answer

sudip Barman

• Aug 8th, 2007

No, more then one query can not been run on same tables becasues if osme query fire a delete operation and the other query some how update the same row then it gives some error cause it may be po...

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

saratchand

• Dec 8th, 2012

Two type

In software :top down and button up approach
IN DBMS: generalization and specialization other is aggregation

Answer Question  Select Best Answer

John

• Jun 8th, 2006

There are restrictions on indexed views in SQL server such as the columns are not nullable.

Harsh Gupta

• Apr 8th, 2006

Hi1) Sql Server 2000 and Oracle does have added the facility of indexed views. Prior to Sql Server 2000 indexed views were not there.2) Oracle call them as Materialized views and Sql Server 2000 call ...

Answer Question  Select Best Answer

ox

• Apr 4th, 2007

in the task bar type (after the QMF returns your query results)-EXPORT REPORT TO filename.txt hit enter and the console will display the complete name of the data set to which your results have been e...

Answer Question  Select Best Answer

Sri

• Oct 11th, 2006

Other than those mentioned above the different indexes are1)ClusteredRequires the date to be sortedwe can create 1 clustered2)Non-Clustereddoesnt require the data to be sortedWe can create 249 non-clustered indexes

opbang

 Profile Answers by opbang Questions by opbang

• Sep 23rd, 2006

Types of IndexesThere are different types of indexes that can be created on tables in a database, all of which serve the same goal?to improve database performance by expediting data retrieval. Indexes...

Answer Question  Select Best Answer

sangam.princesalim

 Profile Answers by sangam.princesalim Questions by sangam.princesalim

• Apr 8th, 2010

There are a set of rules known as Codd's rules. In all there are 13 rules. 12 were defined by Codd & the 0th rule is interpreted by Subject experts. Altough there is no Database which is fully compliant with the Codd's rules and hence we do not have a perfect / accurate RDBMS as of now.

Answer Question  Select Best Answer

prashant10153

• Jan 25th, 2007

Listener.ora is the configuration file for the listener, living on theserver. Tnsnames.ora is one of the sqlnet configuration files on the client.

Answer Question  Select Best Answer

aswin

• Nov 14th, 2006

Data objects in a database are of the objects that are used for storing data that are of type (tables,indexes....)

Answer Question  Select Best Answer

rajesh

• Jan 18th, 2007

component based Arc:The database building structure depends upon to the component such as Kernel level.Advantage:The accessing speed will be more than other component.

Answer Question  Select Best Answer

narendra kumar

• Feb 15th, 2007

SQL (Transact-SQL) is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL) including transaction control, exception and error hand...

Answer Question  Select Best Answer

sarat chand

• Dec 8th, 2012

Logical memory is based on schema design. but virtual memory is based on data access that means we want a data from hard disk(physical memory ) to main memory.

Answer Question  Select Best Answer

kashyap_aseem

 Profile Answers by kashyap_aseem Questions by kashyap_aseem

• Feb 14th, 2008

DAO is quite older one and doesnt support few rdbms'swhile ado is the later one that supports all dbms as well as rdbms

Answer Question  Select Best Answer

manish

• Oct 15th, 2007

user_tab_partitions,all_tab_partitions,dba_tab_partitions

Answer Question  Select Best Answer

kumar1974

 Profile Answers by kumar1974 Questions by kumar1974

• Jan 22nd, 2008

Latches are the seriliazation mechanisms to protect shared data structures in System Global Area. Example Latches protect the list of users presently accessing the database and protect the data struct...

Answer Question  Select Best Answer