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:
#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:
#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?
gen. 0.088
Forum
Master braindump