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

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

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

vibha_kant

 Profile Answers by vibha_kant Questions by vibha_kant

• May 15th, 2007

Clustered Index:A clustered index reorders the way data is physically stored in a disc. Thats why there can be only one clustered index on the table. The leaf nodes of the index contains the data page...

vibha_kant

 Profile Answers by vibha_kant Questions by vibha_kant

• May 14th, 2007

Mutating triggers :I am not aware of mutating triggers in SQL Server.  Per my knowledge only MySQL and Oracle throws this error. Coming back to the point, mutating trigger occurs when the table w...

Answer Question  Select Best Answer

indr

• Apr 6th, 2007

No up to 3nf it is not sufficient to normilize...coz 3nf contains redundancy problem....that can be removed by BCNF...so up to BCNF it is sufficient.....

Kalpesh Patel

• Jan 23rd, 2007

Third Normal Form is sufficient for most situations. But if that isn't normal enough for you.

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

sachin s

• Apr 4th, 2007

IS Predicate comes with Create and AS comes with replace.

shailendra_suman

• Feb 19th, 2007

I don't think there is any difference.  I tried both and worked fineSQL> SQL> create procedure testing is  2    3  begin  4    5  dbms_output.put...

Answer Question  Select Best Answer

ankit

• Mar 16th, 2007

jdbc.odbc

pranali patil

• Oct 19th, 2005

Its a jdbcodbc bridge

Answer Question  Select Best Answer

soumya.rampalli

 Profile Answers by soumya.rampalli Questions by soumya.rampalli

• Mar 7th, 2007

Yes what is the different between schema and database

yuvaraj.r

• Mar 6th, 2007

Normally we are reteriving datas internally in the tables of the database

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

Tejas Makwana

• Feb 12th, 2007

DBMS includes the theoretical part that how datas are stored in a table. It does not relate tables with another. While RDBMS is the procedural way that includes SQL syntaxes for relating tables with a...

M.Mahesh Kumar

• Nov 24th, 2005

RDBMS is enabled nu static 2-dimensional tables. ADBMS is enabled by vector field and is n- dimensional.

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

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

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

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

prakash

• Oct 30th, 2006

Perform is purely based on executionhow we get the result, ie Time , spped etcbutexecute is purely depends on logic of how we had done the design and code,itslike the output for given input for a written logic

anand sharma

• Sep 8th, 2006

what is the difference between perform and execute?

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

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

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

sreyaskvmce&it

 Profile Answers by sreyaskvmce&it Questions by sreyaskvmce&it

• Mar 31st, 2006

Drop user username cascade

ram vara prasad

• Mar 9th, 2006

tx paa,         drop user user_name cascade;           This command really works..

Answer Question  Select Best Answer