|
|
Microsoft 70-019: Designing and Implementing Data Warehouses with Microsoft SQL Server 7.0
|
#1. 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 ech(
Speechid Char(32)
Speechtext text)
GO
Fulltext for all columns
To find a phrase 'Fore Score and' use:
|
|
#2. Want to export data to Pivot table in Excel spreadsheet from SQL. Data changes frequently. Want to automate the process of updating the Excel spreadsheet - use SQL Server Agent to schedule Job to automate.
|
|
#3. You are a database manager for Manufacturing Company for OLTP and decision support system (DSS). Activities that access same information in new production monitoring application. APP design to capture prod. information from shop floor in real time. APP must report production results, trends, variances in a timely fashion. Maximize performance.
|
|
#4. You have a Loans database with four tables. The tables are all related from right to left, like the first two tables( Shedule and Payments) on the right, reference with each of their primary key, the middle table called Loan. The middle table (Loan), references the last table on the left with it's primary key. The last table on the left is called Customer. You need to delete a customer from the database and all information with regards to this customer, once the loan is paid for. Choices given:
|
|
#5. A stored procedure is created and a VB user with SQL authentication is trying to execute it but can't. Choices given
|
|
#6. A question where you need to choose the appropriate fill factor on a table that increases 20% over two years. Choices given:
|
|
#7. You want to Delete orders that are > 3 years old. How?
|
|
#8. You have a table for employees. One of the field is Social Security Number. You don't want this field to contain nulls. If no value is given, you want a value of "UNKNOWN" to be inserted in this field. What must you do?
|
|
#9. You use DTS to move orders data from DBase III to SQL server, after you created sql table using:CREATE TABLE [Order] (Order int,CustNo int,OrderDate smalldate,Foreign bit)The Import fails every time you run DTS wizard. What to do?
|
|
#10. Installing SQL on a network, there are Windows 95, NT Workstations and Netware clients. All must be able to connect. (Choose all that apply):
|
|
|
|
 gen. 0.067
|
Server date 11:19 16-03-2010
|
Developed by Zip © 2006
|
|
|
|
|
70-019 certification
70-019 master dump