IF WE GIVE SELECT * FROM EMPLOYEES MEANS THE ORACLE WILL DO THE FOLLOWING.

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

Question Posted / d.elumalai

Answer Posted / d.elumalai

IF WE GIVE SELECT * FROM EMPLOYEES MEANS
THE ORACLE WILL DO THE FOLLOWING.

1.SYNTACTIC CHECK
2.SEMANTIC CHECK
3.HARD PARSING
4.SOFT PARSING

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is primary key in db?

1019

What is difference between sql and excel?

1107

What is AUTH_ID and AUTH_USER in pl/sql ?

2199

how to show all tables with 'mysql'? : Sql dba

1128

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

1055

Explain mutating table error.

1214

What is the difference between microsoft access and sql?

1037

Which is the correct statement about truncate and delete?

1121

Name the different types of indexes in sql and define them.

1162

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

951

What are the parameter modes supported by pl/sql?

1118

what is a database lock ? : Sql dba

1183

Can you load data into multiple tables at once? : aql loader

1082

explain normalization concept? : Sql dba

1054

What is the syntax and use of the coalesce function?

1181