|
|
Authorized user can see question and answers.
Please log in or sign up. 
|
#33. A database is set up to store the text of speeches by government officials in a text field in a table called Speech. It was created with the following code: CREATE table Speech( Speechid Char(32) Speechtext text AuthorID Char(32)) GO Fulltext for all columns Sr on. You want to search the frase "Fore Score and only" What do you write near the Where clause?
Show comments for this question (0)
Add comments
Link to this question
|
|
#34. You are the SQL Administrator for a fish canning company. Each day, fish purchases are made. Tuna must be bought in lots of 100; Salmon in lots of 50. Cannot exceed 150 Salmon in any given day due to government restrictions. Every month, a report must be submitted to the government listing kind, quantity and supplier of the purchased fish. The lots in the report must be integer form. You design your model as follows: Table1: Company CompanyID Table2: Purchase CompanyID, PurchaseID, PurchaseDate Table3: PurchaseDetail PurchaseID, FishName, Quantity, Price, etc. Table4: FishName FishName You then create the following triggers: (A) A Trigger on inserts to PurchaseDetail that only allows purchases in lots of 50 or 100. (B) A Trigger on inserts to PurchaseDetail that does not accept purchases of 150 salmon. (C) A Trigger that return the value of lots in a integer form. Does this implementation satisfy the objectives? (Choose all that apply)
Show comments for this question (0)
Add comments
Link to this question
|
|
#35. You are to implement a logical data model. All of the tables in your logical data model are normalized to at least third normal form There are no surrogate primary keys in any of the tables. Some tables relationships involve up to eight levels of parent, child, grandchild and so forth. In the model the primary key of each descendant table inherits the primary key of all concerned tables. You want to accomplish the following goals: - Allow table at any level in the hierarchy to be joined to any other table in the hierarchy. - Ensure that tables are joined on a single column. - Limit the index length of primary key to 10bytes or less. - Ensure that key column are always compared on a basis regardless of which options where selected during the installation of SQL server. You do the following: - Implement the data model as is. - Create indexes on all foreign keys. (Choose all that apply)
Show comments for this question (0)
Add comments
Link to this question
|
|
#36. You are designing a data model that will record standardized student assessments for a school district. The school district wants assessments to be completed online. The school district also wants each student's responses and scores to be stored immediately in the database. Every year, each student will complete a behavior assessment and an academic assessment. The school district needs to prevent changes to assessment responses after the assessment is complete, but students should be allowed to change their responses during the course of the assessment. The school district wants to require each student to answer all items on each assessment. When the student indicates completion, 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 an AssessmentScore column. * Create a StudentAcademic table with a foreign 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. * Add an INSERT trigger on the StudentBehavior table preventing changes in the assessment response if the AssessmentScore column is not null. * Add an INSERT trigger on the StudentAcademic table preventing changes in the assessment response if the AssessmentScore column is not null. What does this accomplish?
Show comments for this question (0)
Add comments
Link to this question
|
|
#40. You have a HQ offices and 3 Region offices (RG1, RG2, RG3). Each office have a employee tables with the following columns: emp_id, salary, hire_date, department, s_number, jod_id You want to write view that gives the following form of results: Office emp_id department hire_date ------------- --------------- ----------------- -----------------
What of the following do you use to with the create view?
Show comments for this question (0)
Add comments
Link to this question
|
|
|
|
 gen. 0.082
|
Server date 02:38 08-01-2009
|
Developed by Zip © 2006
|
|
|
|
|
Forum
Master braindump