Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 58685 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 primary and foreign key?
What is the use of nvl function?
What is difference between joins and union?
Why do we use sql constraints?
Can we use views in stored procedure?
Can we use pl sql in mysql?
Write a sql select query that only returns each name only once from a table?
Is pl sql useful?
Why is sharding used?
What is sql profiling in oracle?
What are the 3 modes of parameter?
How do you truncate?
What is server name sql?
How do you identify a primary key?
Is sql easier than java?
