Interested to Buy Any Domain ? << Click Here >> for more details...
When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 57884 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 difference between inner join and self join?
What are the different types of constraints?
What do you understand by pl/sql records?
Does sql backup shrink transaction log?
What is your daily office routine?
explain advantages of innodb over myisam. : Sql dba
what are the nonstandard string types? : Sql dba
explain primary keys and auto increment fields in mysql : sql dba
How does rowid help in running a query faster?
what are the authentication modes in sql server? : Sql dba
What are the parts of a basic sql query?
What are predefined functions in sql?
What is lexical units in pl sql?
Why do you partition data?
How do I run a query in pl sql developer?
