When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 53593 Views
- Accenture, HCL, Infosys, I also Faced
- E-Mail Answers
Answer Posted / senthil vinayagam
Full table scan of emp occurs and all the records from
emp is displayed
| Is This Answer Correct ? | 11 Yes | 5 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
What is nvl?
What are the advantages of indexing?
what is meant by urlencode and urldocode? : Sql dba
what are string data types? : Sql dba
What is a table in a database?
What is blind sql injection?
Can we use pl sql in sql server?
Can we join more than 2 tables in sql?
How to get unique records from a table?
How do I edit a stored procedure?
Which function is used to return remainder in a division operator in sql?
What is a temp table?
Can ddl statements be used in pl/sql?
How do I view stored procedures?
who introduced sql?
