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

GeekInterview.com

I am new, Sign me up!

GeekInterview.com > Interview Questions > Database > SQL

Go To First | Previous Question | Next Question

SQL | Question 43 of 139

Print

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

?

Total Answers and Comments: 18

Last Update: January 11, 2007 Asked by: SaratKumar

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

Sorting Options

Page 1 of 2

« First

1

October 18, 2005 04:04:40

#1

don

RE: When we give SELECT * FROM EMP; How does oracle re...

when u give SELECT * FROM EMP;

the server check all the data in the EMP file and it displays the data of the EMP file

Is this answer useful? Yes | No

October 18, 2005 04:05:00

#2

don

RE: When we give SELECT * FROM EMP; How does oracle re...

when u give SELECT * FROM EMP;

the server check all the data in the EMP file and it displays the data of the EMP file

Is this answer useful? Yes | No

October 24, 2005 05:16:04

#3

Shanker

RE: When we give SELECT * FROM EMP; How does oracle re...

Its gives complete employees details which are present in emp table.

Is this answer useful? Yes | No

October 24, 2005 05:43:16

#4

Muruganandam

Select statement

If we give select * from emp then oracle response by displaying all the records with all its column. This is used to view the full sturcture of the table with all its records with field name as its column title.

Is this answer useful? Yes | No

November 03, 2005 02:18:14

#5

Rajesh Sakhamuri

RE: When we give SELECT * FROM EMP; How does oracle re...

Which data u have in the EMP table at the database that data willbe displays.

Is this answer useful? Yes | No

November 03, 2005 09:30:30

#6

asdf

RE: When we give SELECT * FROM EMP; How does oracle re...

the SQL parser will first checks the which command it is.And then the table table columns which are selected and then the display of selected lsit.

Is this answer useful? Yes | No

November 03, 2005 23:22:51

#7

Dhayanand darshanala

RE: When we give SELECT * FROM EMP; How does oracle re...

Select All the rows from the Emp table

Is this answer useful? Yes | No

November 08, 2005 01:39:35

#8

shobhit sharma

RE: When we give SELECT * FROM EMP; How does oracle re...

when we give select * from emp; The server search for the database schema called Emp here. If there exists any schema called emp then it checks its all attributes then match this attribute with the arguments in after the select statement. If everthing is allright then it will display all the rows with all its attributes.

Is this answer useful? Yes | No

November 09, 2005 09:04:25

#9

bhaskar

RE: When we give SELECT * FROM EMP; How does oracle re...

wellfirst it checks the data dictionary part in the blockand then it checks the table emp and the concerned record block leveland gives the answer

Is this answer useful? Yes | No

November 11, 2005 02:02:13

#10

shuaib

RE: When we give SELECT * FROM EMP; How does oracle re...

it will return the all rows from emp table.

Is this answer useful? Yes | No

Page 1 of 2

« First

1

Sponsored Links

Related Categories

—

Sponsored Links

About Us - Privacy Policy - Terms and Conditions - Contact - Ask Question - Propose Category - Site Updates

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved