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

How do I view a table in sql?

948

How much does a sql dba make? : SQL DBA

889

Does truncate remove indexes?

970

What is file based approach?

875

Can we use threading in pl/sql?

971

What is foreign key and example?

886

Is it possible to include an insert statement on the same table to which the trigger is assigned?

956

Define sql delete statement.

953

How many joins can you have in sql?

880

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

953

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1021

How can you view the errors encountered in a trigger?

915

What is use of term?

1008

Is a secondary key the same as a foreign key?

953

What can I use instead of union in sql?

903