InterviewUp – Job Interview Questions and Answers – Your development team is designing a new SQL...

March 21, 2010

Home

Sign-In

My Interview Questions

InterviewUp is actively seeking partnerships. Inquire at business@interviewup.com

Question & Additional Information

260

UPs

Your development team is designing a new SQL server database. A design issue whether to implement referential data integrity using constraints or triggers is a point of discussion. Both can maintain referential data integrity, but what other issues should you take into consideration before proceeding.

Comments (0) |

Inappropriate

Asked By: mformalejo29

Back

Your Name:

To Email:

Subject:

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

Answer

Edit

Constraints are proactive, meaning they react before modifications are made to the database. This is more efficient because no logging takes place, whereas triggers are reactive. They are invoked after changes are made to the database. Triggers can cascade changes where as constraints cannot. You can write Transact-SQL statements for other actions to take places.

Tags

Edit

SQL

Asked At

Edit

None

Job Titles

Edit

systems programmer

Comments (0) :

Your Name:

Add your comment text

Tags

interview, general, business, information, hr, human resource, job, store, sales, customer, management, manager, all, human resources, working environment, skill

Asked At

Best Western

Job Positions

Service Crew, Sales Clerk, Consumer Banker, Front Desk Clerk

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

Comments (0) :

277

UPs

What are your thoughts on team-teaching?

Add or view comments about this interview question

Comments (1) |

Share this interview question with your friend

Inappropriate

View all interview questions asked by this user

Asked By: Matt |

See Answer

Edit

Your Name:

To Email:

Subject:

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

The interviewer who asks this question wants to discover if you are flexible, enjoy working in a team environment, have experience in this area, and what your viewpoints are on the subject.

Create Date

Friday, March 21, 2008

Tags

interview, human resource, job, communication, general interview, leadership, human resources

Asked At

None

Job Positions

teacher, Instructor, Professor

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

Comments (1) :

Candace Davies

Friday, October 30, 2009 5:58 AM

The interviewer who asks this question wants to discover if you are flexible, enjoy working in a team environment, have experience in this area, and what your viewpoints are on the subject. It is always wise to speak about some of the positive aspects of team-teaching, such as: It is an effective strategy for teaching large groups of students. Team teaching encourages teachers to collaborate and generate ideas, as well as learn from each other ... two heads are always better than one! Talk about team-teaching experiences you have had, and the positive results that transpired.
If you haven't had any hands-on experience, explain that you enjoy working in a team setting and are excited about the possibility of participating in team teaching.

Candace Davies, Owner of A+ Resumes for Teachers
http://www.resumes-for-teachers.com

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)

Deoxyribonucleic acid (DNA) is a nucleic acid that contains the genetic instructions used in the development and functioning of all known living organisms and some viruses. The main role of DNA molecules is the long-term storage of information.

Create Date

Saturday, April 26, 2008

Tags

dna, cisco

Asked At

None

Job Positions

Network Administrator

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

Comments (0) :

279

UPs

# error - what it does?

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)

#error is the preprocessor directive which produces compile time error messages. These directives are most useful for detecting programmer inconsistencies and violation of constraints during preprocessing.

Create Date

Wednesday, November 07, 2007

Tags

error, programmer, embedded, preprocessor, time, compile, # error, messages

Asked At

None

Job Positions

None

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

Comments (1) :

Francesco8106

Wednesday, August 26, 2009 8:56 AM

Al momento non sono ancora in grado d'espletare alcun giudizio al riguardo.

See all 1 comments

238

UPs

How can you ensure that sales meetings are productive?

Comments (0) |

Inappropriate

Asked By: Athena |

See Answer

Edit

Your Name:

To Email:

Subject:

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

Email meeting time and date with prompt arrival reqd. Have any questions submitted in advance from others (not meaning that all questions will be addressed in this meeting necessarily). Have written agenda at every table position in meeting and STAY on agenda. Assign follow-up to certain workers with time and date timeframes. If necessary, schedule next meeting with follow-up issues answered at end of this meeting.

Create Date

Saturday, March 15, 2008

Tags

interview, business, career, marketing, manager, business meeting

Asked At

None

Job Positions

Sales Executive

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

Comments (0) :

261

UPs