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

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

Question Posted / senthil vinayagam

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

Please Help Members By Posting Answers For Below Questions

Explain the difference between sql and mysql.

1113

What are inner and outer joins examples of both?

1009

How do you get column names only for a table (sql server)?

1217

Can we perform dml in function?

1133

How do I view stored procedures?

1023

What is error ora-01000: maximum open cursors exceeded

1210

What information is needed to connect sql*plus an oracle server?

1078

What is having clause in sql?

1018

How do I upgrade sql?

1051

What are the disadvantages of not performing database normalization?

1216

What is sql lookup?

971

How to display Row Number with Records in Oracle SQL Plus?

1095

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2552

What is record type in pl sql?

1036

What is view? Can we update view

1523