Logo F2FInterview

Oracle Data Access Interview Questions

Q   |   QA

Rule-based and Cost-based.

select to_number(rollnumber) from tname order by rollnumber

Commit, Rollback, DCL command like grant revoke.When exit from oracle (implicite commit happened), When database abnormally closed then an implicit rollback happened. When user invokes an DDl command

ROLLBACK retracts any of the changes resulting from the SQL statements in the transaction.

Considering available access paths and determining the most efficient execution plan based on statistics in the data dictionary for the tables accessed by the statement and their associated clusters and indexes.

In order to link this F2FInterview's page as Reference on your website or Blog, click on below text area and pres (CTRL-C) to copy the code in clipboard or right click then copy the following lines after that paste into your website or Blog.

Get Reference Link To This Page: (copy below code by (CTRL-C) and paste into your website or Blog)
HTML Rendering of above code: