Interview Questions Answers in SQL PLSQL, Oracle General

nageswara rao

{ City } bangalore
< Country > india
* Profession * software engineer
User No # 53039

Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 2
Users Marked my Answers as Wrong # 2

Questions / { nageswara rao }

Questions Answers Category Views Company eMail

Answers / { nageswara rao }

Question { CTS, 22981 }

State the difference between implict and explict cursor's?

Answer

Implicit cursors: used for all DML statements and
single-row queries
Explicit cursors: used for queries of zero, one, or
more rows

Is This Answer Correct ?

1 Yes

0 No

Question { Oracle, 7653 }

i have executed the Delete command after the I have created
table whether deletions will be
commit or not? if table is successfully created?

Answer

commit will not happen until and unless you enable the option AUTO COMMIT or manually you give commit.

hope you understand.

Is This Answer Correct ?

1 Yes

2 No