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

List the ways to get the count of records in a table?

0 Answers  

How does left join work in sql?

0 Answers  

What is the difference between cross join and natural join?

0 Answers  

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

6 Answers   IBM,

What is the difference between a procedure and a function?

0 Answers  




What is data control language?

0 Answers  

How do you optimize SQL queries ?

6 Answers   CarrizalSoft Technologies, Infosys, Oracle,

What is a recursive stored procedure?

0 Answers  

What are the data types allowed in a table?

3 Answers  

Inline the values in PL/SQL, what does it mean.?

0 Answers   MCN Solutions,

How can one get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

Difference between aggregate function and analytical function?

3 Answers   Metric Stream,

For more SQL PLSQL Interview Questions Click Here
Categories