|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
In the first query the result is -> no rows selected.
In the second query result is -> all the data in the emp table will be displayed.
Create Date
:
Sunday, March 09, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
No. We can use update statement on single table only.
Create Date
:
Sunday, March 09, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
Transaction is a logical unit of work. transaction is series of actions that should happen without any fail.
It Should be Satisfy ACID Property.
A - Acit
C - Consistency
I - Isolation
D - Durability.
Create Date
:
Sunday, March 09, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
Serialization, This is the higest level of Isolation.When this is on, no dirty reads,
no nonrepeatable reads and no phantom rows.
Create Date
:
Sunday, March 09, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
DELETE FROM table_name a
WHERE ROWID >(SELECT min(ROWID) FROM table_name b WHERE a.col_1=b.col_1 ).
Create Date
:
Sunday, March 09, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
basically we use joins to query a sql with 1 or more tables.
1) self join.. join within the same table using aliases
2) equi join.. join between the 2 tables with commom columns
3) outer join.. and it is divided into 2 catagories left outer join and right outer join.
View :- its a logical representation of one or more tables.View doesn't have the data of its own. But still you
can perform DML on a view ..the changes will be done in the underlying base tables.
Create Date
:
Sunday, March 09, 2008
Click here
to improve the Interview Question, Answer and other fields.