Set - 7

Question 1 :

What effect would making a change to the EMPLID field in the above project have?

Answer :

Changes would occur globally; meaning the field is changed everywhere else in the database.

Question 2 :

An employee is transferred where should he refer in this aspection?

Answer :

Business Process

Question 3 :

What are destructive statements in SQL?

Answer :

b) Recreate a Table
d) Recreate a View

Question 4 :

A clients App was 3months behind, what should he do to update the app since it was not working?

Answer :

b) Apply all Service packs

Question 5 :

In Two Tier mode where does authentication happens?

Answer :

Application Server