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 is scope of pl sql developer in future?

589


Is null operator in sql?

604


What is sql procedures and functions?

529


How do you concatenate in sql?

548


What is the best partition size for windows 10?

479






Define the select into statement.

568


What does t sql mean?

532


Does sql full backup truncate logs?

527


What are different joins used in sql?

548


Can we use join in subquery?

565


what is a unique key ? : Sql dba

541


How do I save the results of sql query in a file?

533


Can %notfound return null after a fetch?

585


How can you load multi line records? : aql loader

655


What is denormalization in a database?

587