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

State few characteristics of pl/sql?

723

Define commit?

745

Can a varchar be a primary key?

697

What is a sql select statement?

763

what is the use of double ampersand (&&) in sql queries?

820

What is example of database?

699

Does oracle roll back the transaction on an error?

743

how do you know if your mysql server is alive? : Sql dba

778

What is scalar and vector?

720

What view means?

733

What is optimistic concurrency control? : Transact sql

746

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

842

What is the limitation on the block size of pl/sql?

701

What are all the different normalizations?

744

What is the purpose of the partition table?

752