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

sudhir

• Aug 8th, 2007

1) Identify the data file to be moved.2) Identify the diskgroup on to which the file has to be moved.3) Take the file offline.4) Copy the file to new diskgroup using Either RMAN or DBMS_FILE_TRANSFER....

Answer Question  Select Best Answer

kailash prasad

• Aug 21st, 2007

The basic reason for Mutation error is the way that Oracle manages a read consistent view of data. The error is encountered when a row-level trigger accesses the same table on which it is based, w...

Answer Question  Select Best Answer

List the rules used to enforce table level integrity.

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Apr 5th, 2012

There are 3 rules to enforce table level integrity. 1.Foreign key value can be modified only if we want to match the corresponding primary key value. 2.We cannot delete records either from parent or c...

Answer Question  Select Best Answer

What is meant by type of participation? Name the three types of relationship participation.

chaitra murthy

 Profile Answers by chaitra murthy Questions by chaitra murthy

• Jan 16th, 2009

I just know two types of Participation: Total and Partial.Lets take an example of 2 entities Department and Employee. Relation: For each department there is an Head of the Department (who is an emplo...

Answer Question  Select Best Answer

Name three activities involved in requirement gathering

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Apr 5th, 2012

Three activities involved in requirement gathering are
1.Eliciting requirement
2.Analyzing requirement
3.Recording requirement

Answer Question  Select Best Answer