SQL*Plus interview Questions

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...

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

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 ...

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

LEFT OUTER JOIN, RIGHT OUTER JOIN, FULL OUTER JOIN

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
-
X

scott@8i>

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

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...

Cursor_already_open, Invalid_cursor

invalid_cursor, cursor_not_open

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

A  Transaction  is  a  logical  unit of 

work that comprises one or more SQL statements 

executed by a single user.

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

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...

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.

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.

define is not a sql command

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

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 ...

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 ...

in oracle 7.1.6

unix enviournment

sqldba lmode=y

connect internel

statup

oracle 7.3.4 and 8i

svrmgrl

connect internel

statup

in 9i

sqlplus /nolog

connect /as sysdba

startup

u can use option like alter database open

startup mount /nomount

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

by using the index and rowid

Nextval must be used to generate a sequence number in the current user's session before currval can be referenced.

You can find the last number used in the session for your sequence from the below mentioned query

select last_number from user_sequences where sequence_name =

Hi,Implementing a project from the begining to the production and maintenance stage.(1) System Planning:        (Scope & Budget of the Project)(2) Business Analy...

TOO_MANY_ROWS

NO_DATA_FOUND

INVALID_CURSORS

CURSOR_ALREADY_OPEN

DUP_VAL_ON_INDEX

I think WHEN_OTHERS is only OTHERS 
NO_DATA_FOUND  
WHEN_OTHERS  
TOO_MANY_ROWS  

Hi,

Yes,We can use current and next values from a sequence.

-Regards,