InterviewUp – Job Interview Questions and Answers

Add or view comments about this interview question

Comments (0) |

Share this interview question with your friend

Email

|

Inappropriate

|

View all interview questions asked by this user

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)

Be the first one to answer the question Click here to answer

Create Date

:

Friday, April 25, 2008

Tags

:

None

Asked At

:

verident

Job Positions

:

None

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

Comments (0) :

87

UPs

When you are working on a SQL database How will you check using a T-SQL query (on system tables) that what has changed in the database, if suddenly a developer changes the code and your queries results start giving errors?

Comments (0) |

Email

|

Inappropriate

|

Asked By: detech3 |

See Answer

Edit

Your Name:

To Email:

Subject:

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

Be the first one to answer the question Click here to answer

Create Date

:

Sunday, March 09, 2008

Tags

:

database, sql database, T-sql

Asked At

:

microsoft

Job Positions

:

database

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

Comments (0) :

84

UPs

what is cost based optimisation ?

Comments (0) |

Email

|

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)

The cost manager calculates the cost of execution of SQL trees..the optimiser calls the cost manager during all the phases of optimization to calculate the relative cost of various subtrees it considers.The cost parameters are time, cardinality, selectivity...

This is part of the database internals concepts.

Create Date

:

Friday, February 29, 2008

Tags

:

database

Asked At

:

oracle

Job Positions

:

None