InterviewUp – Job Interview Questions and Answers – what is the out put of below queries? a....

January 07, 2009

Home

Sign-In

My Interview Questions

Question & Additional Information

129

UPs

what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;

Comments (0) |

Inappropriate

Asked By: detech3

Back

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Answer

Edit

In the first query the result is -> no rows selected.
In the second query result is -> all the data in the emp table will be displayed.

Tags

Edit

database, sqlserver

Asked At

Edit

patni

Job Titles

Edit

database

Comments (0) :

Your Name:

Add your comment text

Related Questions

UPs

How do you execute a UNIX command in the background?

Add or view comments about this interview question

Comments (0) |

Share this interview question with your friend

Inappropriate

View all interview questions asked by this user

Asked By: thunderd |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

To run the count program, which will display the process identification number of the job, enter: count &

To check the status of your job, enter: ps

To bring a background process to the foreground, enter: fg

If you have more than one job suspended in the background, enter: fg %#

Replace # with the job number, as shown in the first column of the output of the jobs command.

You can kill a background process by entering: kill PID

Replace PID with the process ID of the job. If that fails, enter the following:

kill -KILL PID

To determine a job's PID, enter: jobs -l

If you are using sh, ksh, bash, or zsh, you may prevent background processes from sending error messages to the terminal. Redirect the output to /dev/null using the following syntax: count 2> /dev/null &

Create Date

Sunday, May 11, 2008

Tags

Bluetooth

Asked At

None

Job Positions

Network Administrator

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

130

UPs

Why do you want to work here?

Comments (1) |

Inappropriate

Asked By: chinna |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

If you have done your homework about this organization, now is the time to use that knowledge. Remember, even as a recruited candidate, some facilities will want to understand why you would select them. If you are a recruited candidate, remind them that you were not looking when you were contacted, but that the challenge sounded intriguing and that a solid opportunity for career advancement is important to you.

Create Date

Thursday, March 20, 2008

Tags

nurse, work

Asked At

None

Job Positions

nurse

Click here to improve the Interview Question, Answer and other fields.

Comments (1) :

tt2tt

Friday, July 04, 2008 10:41 AM

Y so many answers for the same question ?

See all 1 comments

189

UPs

In System.out.println(), what is System, out and println in java?

Comments (1) |

Inappropriate

Asked By: Anonymous |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

System is a predefined final class, out is a PrintStream object and println is a built-in overloaded method in the out object.

Create Date

Sunday, September 02, 2007

Tags

java, system, printin, out, sysrem.out.printin()

Asked At

None

Job Positions

None

Click here to improve the Interview Question, Answer and other fields.

Comments (1) :

pavan

Thursday, May 29, 2008 10:22 PM

System is a predefined final class in java
out is a PrintStream object

See all 1 comments

UPs

How can we know the number of days between two given dates using MySQL?

Comments (0) |

Inappropriate

Asked By: Anonymous |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

Select datediff('2008-09-07','2006-10-02');

Create Date

Sunday, May 11, 2008

Tags

php

Asked At

None

Job Positions

web developer

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

120

UPs

Define the "integrity rules"

Comments (0) |

Inappropriate

Asked By: edward |

See Answer

Edit

Your Name:

To Email:

Subject:

Note to go along with the question: (Optional, no more than 1,000 characters)

There are two Integrity rules. Entity Integrity: States that "Primary key cannot have NULL value"
Referential Integrity: States that "Foreign Key can be either a NULL value or should be Primary Key value of other relation.

Create Date

Tuesday, May 13, 2008

Tags

RDBMS, Database, Data Warehousing

Asked At

None

Job Positions

Database Engineer

Click here to improve the Interview Question, Answer and other fields.

Comments (0) :

114

UPs