Database Link is a named path through which a remote database can be accessed.

tarun1282

 Profile Answers by tarun1282 Questions by tarun1282

• Apr 27th, 2006

When u want to access the database from remote database then u hv to create a database link with creating a directory .

Answer Question  Select Best Answer

Shankar

• Feb 24th, 2006

The startup of database depends on the nature of Oracle server :Incase Of Enterprise Server and Unix Environment :Go to Unix and type the following commands :sqldba lmode=yconnect internalstartupThis ...

rajat dey

• Feb 9th, 2006

in oracle 7.1.6 unix enviournmentsqldba lmode=y connect internelstatuporacle 7.3.4 and 8isvrmgrl connect internelstatupin 9isqlplus /nologconnect /as sysdbastartup u can use option like alter database openstartup mount /nomount

Answer Question  Select Best Answer

Integrity constraint is a rule that restricts values to a column in a table.

samiksc

 Profile Answers by samiksc Questions by samiksc

• Jan 19th, 2006

Integrity constraint restricts values of a column so that only meaningful values as per the business logic of the table be entered into the column.Integrity constraints are of the following types:Not ...

Answer Question  Select Best Answer

vijaya

• Jan 10th, 2006

If DEFINE is isqlplus command then how do u define ACCEPT command. what is difference between them?i think define is a command in sql *plus which works same in isqlplus with ACCEPT.pls do forward the argument.

marthand

• Dec 27th, 2005

define is not a sql commanddefine is Isql*plus command.  to give a global variable we use it

Answer Question  Select Best Answer

Narender Reddy

• Jan 4th, 2006

In Oracle 9i instead of snapshot we can use meterialized views which can act as snapshot.Diff between view & snapshot is view is not a table its a virtual table to join one or more table or to pre...

prakash2906

 Profile Answers by prakash2906 Questions by prakash2906

• Dec 27th, 2005

A snapshot is a table that contains the     results of a query of one or more tables or views, often located on     a remote database.

Answer Question  Select Best Answer

Transaction is logical unit between two commits and commit and rollback.

Vaibhavi

• Dec 21st, 2005

A  Transaction  is  a  logical  unit of work that comprises one or more SQL statements executed by a single user.

j lehew

• Aug 25th, 2005

A transaction either commits (i.e. all its actions happen), or it aborts (i.e. all its actions are undone). This all-or-nothing quality makes for a simple programming model.   Transactions also meets the ACID test: Atomic, Consistent, Isolation, and Durable

Answer Question  Select Best Answer

SaratKumar Puranam

• Oct 4th, 2005

Non corelated subquery, where the subquery has been executed once for the entire parent statement.

Answer Question  Select Best Answer

Jayakumar M

• Nov 9th, 2005

Cursor_already_open, Invalid_cursor

kumar vikal

• Jul 27th, 2005

Invalid_cursor, cursor_not_open

Answer Question  Select Best Answer

To protect some of the columns of a table from other users.To hide complexity of a query.To hide complexity of calculations.

SaratKumar Puranam

• Oct 4th, 2005

Advantages of view:1. Restricts the access to particular columns and rows of the base tables.2. Hide the data complexity.3. Can access the data for two different base tables with out performing a join...

Answer Question  Select Best Answer

Atal

 Profile Answers by Atal Questions by Atal

• Sep 16th, 2005

scott@8i> create database link ora8idev  2  connect to scott  3  identified by tiger  4  using 'ora8idev'  5  /Database link created.scott@8i> select * from dual@ora8idev;D-Xscott@8i>

Swapnil

• Jul 28th, 2005

It is a way of connecting to remote database. usage is  @xyz.tablename.column

Answer Question  Select Best Answer

flamey

• Aug 25th, 2005

LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN

Answer Question  Select Best Answer

Sandipanni Bharadwaj

• Aug 10th, 2005

5. The query of the view shoud not consist of any aggregate funtion  6. The query shoud not consist of any subquery 7 And the other option is we can use the instead of trigger to update the ...

Swapnil

• Jul 28th, 2005

An Insert,Update,delete can be done through views is 1. inserts/updates/deletes done only in one base table at a time 2. primary key columns should be part of view 3. columns which are going to be updated must be part of vew def. 4. it shouldn't voielet the contraints

Answer Question  Select Best Answer

Scott

• May 12th, 2005

By utilizing savepoints, you are able to rollback to a given point in your processing. An example of this would be: ... COMMIT;  INSERT UPDATE SAVEPOINT A  DELE...

Ratan

• Mar 25th, 2005

Savepoints are the temporary bookmarks. it is possible to rollback up to the named savepoint.

Answer Question  Select Best Answer

I. to modify data type of a column ? ii. to add a column with NOT NULL constraint ? To Modify the datatype of a column the column must be empty. to add a column with NOT NULL constrain, the table must be empty.