The oracle engine will execute the command,and retrives all the data from

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

Question Posted / gvprasad

Answer Posted / gvprasad

The oracle engine will execute the command,and retrives all
the data from the database and give it to the end user.

Is This Answer Correct ?

23 Yes

13 No

Please Help Members By Posting Answers For Below Questions

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1032

What is the most restrictive isolation level? : Transact sql

1083

what is heap table? : Sql dba

1105

Is a view faster than a stored procedure?

969

How does a covering index work?

958

Why are indexes and views important to an organization?

956

How do I count records in sql?

1002

what are dynamic queries in t-sql? : Transact sql

1019

What is a stored procedure in sql with example?

1129

How many types of relationship are there?

1031

What is natural join in sql?

989

what is cross join? : Sql dba

996

What are the ddl commands?

1010

Does execute immediate commit?

1216

Explain the advantages and disadvantages of stored procedure?

1147