When we give SELECT * FROM EMP; How does oracle respond?

Answer Posted / senthil vinayagam

Full table scan of emp occurs and all the records from
emp is displayed

Is This Answer Correct ?    11 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does plv msg allows you to do?

681


What is t-sql? : Transact sql

542


What are the three pl sql block types?

573


What are reports usually used for?

568


what are the differences between binary and varbinary? : Sql dba

535






What is the difference between numeric and autonumber?

502


What is tuple in sql?

547


Are pl sql variables case sensitive?

598


Differentiate between pl/sql and sql?

619


What does partition by mean in sql?

515


What is pl sql quora?

649


What are sql indexes?

546


how can we know the number of days between two given dates using mysql? : Sql dba

548


Why schema is used in sql?

517


what is offset-fetch filter in tsql? : Transact sql

539