INTERVIEW QUESTIONS DATABASE SQL DETAILS

Question: What is output of following query
Select 2 from employee;

Answer: It depends upon number of rows in table. This query will print 2 as many times as rows in table.

It depends upon number of rows in table. This query will print 2 as many times as rows in table. Source: CoolInterview.com

So select 2 from employee means
It retrieves second column values from employee table.I don't whether this answer is correct or not but this is my perception. Source: CoolInterview.com

This query displays the value 2 for all rows in a specified table. Source: CoolInterview.com

It will show column name as 2 and data in column is also 2 Source: CoolInterview.com

It will generate a new column in the result set with 2 as the value in all the rows. The number os rows will be the total number of rows present in the employee table. Source: CoolInterview.com

It gives error because column don't start with number. Source: CoolInterview.com

It will give an output
2
2
2
2
2
.
.
.
(upto number of rows in employee table) Source: CoolInterview.com

It will select Second column from employee table. Source: CoolInterview.com

The output will be just 2. Source: CoolInterview.com

IT DISPLAY 2.(NUMBER TIMES MUST BE DEPENDING ON YOUR NUMBER OF ROWS IN YOUR TABLE Source: CoolInterview.com

Second row of the employee table will be selected. Source: CoolInterview.com

It will give '2' as column name and column data .no. of rows are same as no. of rows of Employee table. Source: CoolInterview.com

this query will return 2 as amany rows in hte tables
2
2
2
2
2
2
2
uptill no of rows Source: CoolInterview.com

It will display the no.2 as the output with no column name. Source: CoolInterview.com

this query returns 2 for the no of rows in employee table with no column name .if employee table having 5 rows it returns:
no column name
-------------
2
2
2
2
2 Source: CoolInterview.com

SQL> select * from emp;

NAME SALARY
-------------------- ----------
satyam 25000
Veena 30000
Abhishek 22000
Monica 25000
veena 31000
nitin 22000
rakesh 21000
mummy 15000

8 rows selected.

SQL> select 2 from emp;

2
----------
2
2
2
2
2
2
2
2

8 rows selected.
Yes, it will display 2 as an output and will depend on number of records consisting in table. Source: CoolInterview.com

It will dispay 2 as an ouput and the number of rows as an output will dpend on number of records existing in table.
select 2 from emp;
2
2
2
2
2
2
2
Source: CoolInterview.com

it will display n time 2. where n is number of row available. Source: CoolInterview.com

It will give an output
2
2
2
2
2
.
.
.
(upto number of rows in employee table) Source: CoolInterview.com

Bydefault emp table contains 14records, for each and every row 2 will be displayed.
The output is
2
__
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2
2 Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question