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

Show how functions and procedures are called in a pl/sql block.

1038

What is difference between nchar and nvarchar?

953

What is normalization in sql?

961

What is sql and also describe types of sql statements?

993

how to get help information from the server? : Sql dba

874

how do you login to mysql using unix shell? : Sql dba

1013

What is ttitle and btitle?

1006

How do I order by ascending in sql?

954

What is a subquery in sql?

974

Is it mandatory for the primary key to be given a value when a new record is inserted?

1139

What is before trigger?

943

Differentiate between % rowtype and type record.

1192

What is a pdo connection?

943

Explain the order of sql statement execution?

974

What is on delete restrict?

936