Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

When we give SELECT * FROM EMP; How does oracle respond?

Question Posted / pankit1515

Answers were Sorted based on User's Feedback



When we give SELECT * FROM EMP; How does oracle respond?..

Answer / belal ansari

The sql engine select the records from the table EMS and it store in IMPLICIT CURSOR then display these recordes.

Is This Answer Correct ?    1 Yes 2 No

When we give SELECT * FROM EMP; How does oracle respond?..

Answer / sun

Oracle responds as

It retrieves all records from the EMP table.

Is This Answer Correct ?    1 Yes 2 No

When we give SELECT * FROM EMP; How does oracle respond?..

Answer / reddy

IT WILL GIVES THE ALL THE ATTRIBUTS IN EMP TABLE

Is This Answer Correct ?    5 Yes 8 No

When we give SELECT * FROM EMP; How does oracle respond?..

Answer / veni

WE give this query when, we need to view the entire record
of emp table. ( i.e) it will display all the rows and
columns of emp table. and the oracle respond the same as
per the query given.

Is This Answer Correct ?    2 Yes 5 No

Post New Answer

More SQL PLSQL Interview Questions

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  

What is pl sql and why it is used for?

0 Answers  

what is difference b/w pravite procedures and public procedures?

3 Answers   Steria, Wipro, Zensar,

What is intersect?

1 Answers  

Are sql views compiled?

1 Answers  




Explain the PL/SQL compilation process.

3 Answers  

Define SQL and state the differences between SQL and other conventional programming Languages?

0 Answers  

Is sql an operating system?

0 Answers  

Why is sql important?

0 Answers  

Mention what is the function that is used to transfer a pl/sql table log to a database table?

0 Answers  

What is the usage of NVL?

7 Answers   Infosys, Micro Infotek,

what is a constraint? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories