70-029 Microsoft - Braindumps.com.ua: question list for "Designing and Implementing Databases with Microsoft SQL Server 7.0", page: 6

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

Microsoft 70-029: Designing and Implementing Databases with Microsoft SQL Server 7.0

#51. If you attempt to create a stored procedure using the name of an existing stored procedure in the database you will get an error. Therefore, when writing a script to create a stored procedure it is important to check for an existing stored procedure with the same name and drop it if it exists. Assuming that you are the database owner, which of the following SQL batches will drop a stored procedure named sp_myprocedure from the current database?

#52. In your results you want to display the character string 'The name of this product is' immediately before the product name. Which of the following SQL SELECT statements could you use?

#53. In the pubs database the titleauthor table is used to define the many-to-many relationships between authors and books. Which of the following SQL SELECT statements will show which books (titles) have more than one author?

#54. You are DBA at photo-reseller shop. Your shop buys photographs from organizations, individual photographers and occasionally from your customers. You also have photographers on staff. From time to time individual independent photographers become your employees and sometimes leave for independent careers. You create the following tables: В§ INDIVIDUAL with IndividualID as Indentity - Primary Key, and with Employee as boolean В§ ORGANIZATION with OrganizationID as Indentity - Primary Key В§ INDIVIDUALORGANIZATION with IndividualID - foreign key references INDIVIDUALS.IndividualID, and OrganizationID - foreign key references ORGANIZATIONS.OrganizationID (Choose all that apply)

#55. You are designing a data model to track research projects. A project might be undertaken in one research institution or in multiple institutions, some research institutes are part of a university or a large research institutes.

Each project is assigned a group of Scientists who might perform different jobs in each project. A scientist who is a member of the staff at one institute might also be assigned to a project that is being undertaken at another institute. Exhibit : Project: (PK) projectID Institutes: instituteID Projectinstitution : (PK) instituteID, projectID ScientistProject: (PK) scientistID, projectID, jobname Scientist: (PK) scientistID Job: (PK) jobID - No self join on Institution table - No direct relation between Scientist and Institution

Projectinstitution TB: projectid, institutionID ----> Institution TB: instituteID Projectinstitution TB: projectID, institutionID ----> Project TB: projectID Projectscientist TB: projectID, scientistID, jobname ----> Project TB: projectID Projectscientist TB: projectID, scientistID, jobname ----> Job TB: jobID Projectscientist TB: projectID, scientistID, jobname ----> Scientist TB: scientistID

You want to accomplish the following goals: - Ensure that all the scientist conducting research for any specific project can be reported. - Ensure that a scientist's job for a specific project in a specific institute can be reported. - Ensure that all of the institute participating in any specific project can be reported. - Ensure that the institute at which a scientist is a staff member can be tracked. - Ensure that an institute can be identified as part of another institute.

What task will be achieved (choose all that apply):

#56. Scientists in a research institute, Institute may have parent organization/institute. Scientists might work for more than one institute. Exhibit: В§ Project: (PK) projectID, instituteID В§ Institutes: instituteID, instituteID2 В§ InstituteScientist: (PK) instituteID, scientistID В§ ScientistProject: (PK) scientistID, projectID В§ Scientist: (PK) scientistID, jobID В§ Job: (PK) jobID, jobdescr (Choose all that apply)

#57. You need a report on every salesperson's best sales on 9/15/98. Select the right script.

#58. Two tables: SalesInfo SalesPerson --------------- ---------------- SaleId SalesPersonId SalesPersonId RegionId RegionId FirstName Amount LastName .. .. You want to ensure that a SalesPerson will enter SalesAmount in his region only. Choices given:

#59. You will be given an exhibit for the following two tables: Department: DepartmentId, DepartmentName, EmployeeId Employee: EmployeeId, SSN, DepartmentId, DepartmentName, blah, blah Question: to follow the normalization rule (dependent on the whole primary key)

#60. Students from group home with the following structure in exhibit: Table A: StudentId Table B: StudentId, StudentId (for family relationship) (composite) Table C: StudentId, EventName (for student events) Table D: StudentId, Alias (for student alias) Table E: StudentId, Address StudentId in B-D reference StudentId in table A as foreign key Background: Student needs description, may have multiple aliases, Student can relate to student as family relationship. (Choose all that apply):

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] ... [24]

gen. 0.096

Server date 04:11 08-01-2009

Microsoft 70-029

Forum

Start online exam simulation

Master braindump