When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 50394 Views
- Accenture, HCL, Infosys, I also Faced
- E-Mail Answers
Answer Posted / radha sri seshu.kolla
when we fire select * from emp; first oracle engine checks
the data dictionary called user_tables. if the table emp
existed then it checks all permissions then contacts the
data dictionary called user_tab_columns, and according to
the given condition the sql statement will be executed
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What is package in pl sql?
Can primary key be changed?
Can I learn sql in a week?
Is sql sequential or random?
What is cartesian join in sql?
What is the clause we need to add in function body to return variable?
What are all types of user defined functions?
how to create a new view in mysql? : Sql dba
What is the process of copying data from table a to table b?
What is cross join example?
Explain polymorphism in pl/sql.
what is sql? : Sql dba
Why do we need pl sql?
How much ram can sql express use?
What is a heap in sql?
