|
Home > Archive > SQL server exams > September 2001 > Seeksinsights in the 029 qeustions
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Seeksinsights in the 029 qeustions
|
|
|
| Taken from a braindump, I am in doubt of the "correct" answers and asking for you help to confirm the originals or give the best answer.
1.You are designing a data model that will record standardized student assessments for a school district. The school district wants the assessments to be completed online. The school district also wants each student's
responses and scores to be stored mmediately in the database.
Every year, each student will complete a behavior assessment and an academic assessments. The school district needs to prevent changes to assessments
responses after the assessment is completed but student should be allowed to change their responses during the course of the
assessment.
The school district wants to request each student to <assume> all items on each assessment. When a student indicate completion of the score for the entire assessment must be computed and recorded.
You design a student table and an
assessment table.
You want to accomplish the following goals:
?Ensure that there is no redundant or derived data.
?Ensure that an assessment response cannot be change after the assessment is complete and the score is entered.
?Ensure that all assessment item have responses when the assessment is completed and the score is entered.
?Ensure that an assessment score is computed and stored when the assessment is completed and the score is entered .
You take the following steps:
?Create a subtype table name BehaviorAssessment and a subtype table named
AcademicAssessment. Each with a primary key consisting of AssessmentID. Include a column in each table for the text of each
assessment item.
?Create a StudentBehavior table with a foreign key referencing the Student table, a foreign key referencing the BehaviorAssessment table and a primary
key consisting a StudentID and AssessmentID. Include a nonnullable column in the StudentBehavior table for each assessment
response, as well as a AssessmentScore column.
?Create a StudentAcademic table with a foreing key referencing the Student table a foreign key referncing the AcademicAssessment
table, and a primary key consisting of StudentID and AssessmentID. Include a nonnullable column in the StudentAcademic table for each assessment response, as well as an AssessmentScore column.
?Add an INSERT trigger on the StudentBehavior table computing a value for
the AssessmentScore column when a row is inserted.
?Add an INSERT trigger on the StudentAcademic table computing value for the AssessmentScore column when a row is inserted.
Choices:
a. There is no redundant or derived data.
b. An assessment response cannot be changed after the
assessment is
completed and the score is entered.
c. An assessment item having response. When the
assessment is computed and
the score is entered.
d. An assessment score is completed and stored when
the assessment is
completed and the score is enter.
Ans: A, C, D.
slam: I initially chose B. Why isn't B?
BTW, I got couple other ones coming in.
quote:
Ciao!
| |
|
| 2. Application takes an exec. time to complete an operation over time , with the addition of insert and update , the performance has worsened. You want to check
whether the tables are optimallly indexed , profiler to do ????
Choices:
a.find the worst performance query
b.identify scans of large table
c. identify the cause of DEADDLOCK
d. trace t-sql activity by app
e. trace t-sql activity by user
Ans: A,B,D
slam: I totally get lost. Anyone can help?
quote:
Ciao!
| |
|
| 3. You have a to create a 6 gb database on an NT server. The server has 2 disk controllers each with four 6 gb drives, NT
installed on C drive NTFS and swap file and Sql Server.
Drives C D E F G H I J
choices:
A & D skipped out cuz I've already know they should be out
b) 4 2Gb files on D-G disks, 3 log file H-J
c) 6 1gb files D-I, log files on I
Answer: C
slam: I think either B or C works, but C just happens to be a better answer. Can someone tell my guess is right or not?
quote:
Ciao!
|
|
|
|
|