When we give SELECT * FROM EMP; How does oracle respond?
- 24 Answers
- 52191 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
Is join and inner join the same?
What is keys and its types?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is sql injection vulnerability?
What is the advantage of nosql?
How bulk collect improves performance?
How do I edit a trigger in sql developer?
How to avoid duplicate records in a query?
What is difference between nchar and nvarchar?
What is sql prepared statement?
What is clause?
what is a trigger? : Sql dba
How to fix oracle error ora-00942: table or view does not exist
What are the different dml commands in sql?
What are the different datatypes available in PL/SQL?
