It will retrieve all the columns of emp table. There is no need to check

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

Question Posted / geetha priya

Answer Posted / geetha priya

It will retrieve all the columns of emp table. There is no
need to check for conditions as there are no conditions
specified in the given command.

Is This Answer Correct ?

7 Yes

4 No

Please Help Members By Posting Answers For Below Questions

write an sql query to find names of employee start with 'a'? : Sql dba

1027

Where is pl sql used?

954

how to check myisam tables for errors? : Sql dba

1321

how to dump a table to a file with 'mysqldump'? : Sql dba

1035

what are date and time intervals? : Sql dba

1057

What is mutating error in pl sql?

1020

What is recursive join in sql?

1026

How to get unique records from a table?

972

what is a control file ? : Sql dba

1042

Is hadoop a nosql?

1006

what is primary key? : Sql dba

1029

What are sql triggers used for?

995

What is sql constant?

1035

What does closing a cursor do?

1322

Does pl sql work in mysql?

982