YouworkwithaSQLServer2005databasethatprovidesbankinginformationforcustomers.Youwantcustome

YouworkwithaSQLServer2005databasethatprovidesbankinginformationforcustomers.Youwantcustomerstoseebankingreportsthatcombinedatathatisretrievedfromthedatabasewithreal-timeinvestmentinformationthatcomesfromaWebserviceprovidedbyathirdparty.Theinvestmentinformationmustbecurrentwhenthereportsareexecuted.Youneedtocreatetheappropriateobjectsthatsupportthereports.Whatshouldyoudo?（）

A.PublishthedatainthedatabaseasanXMLWebservicebyusingtheFORXMLAUTOclause.

B.Createatabletostorethebankinginformationforeachcustomer.CreateatriggerthatfireswhendataisinsertedintothetablethatjoinswiththedatacomingfromtheWebservice.

C.CreateaTransact-SQLstoredprocedurethatusesatemporarytabletostorethebankinginformationforeachcustomer.UpdatethetablewiththevaluesfromtheWebservice.

D.HaveadeveloperinyourcompanycreateanassemblythatcallstheremoteWebservice.CreateaCLRfunctionbyusingtheassembly.CalltheCLRfunctionandcombinetheresultswithbankinginformationinthedatabase.

Youareadatabaseadministratorforyourcompany.Thecompanyusesavendorcompany’sapplicationthatisbasedonaproprietarydatabase.YouquerydatafromtheapplicationdatabaseandimportthedataintoaSQLServer2005database.TheapplicationvendorprovidesyouwithanewOLEDBdrivertobeusedwhenqueryingtheapplicationdatabase.CompanypolicyprohibitsconnectionsbetweentheSQLServerdatabaseandtheapplicationdatabase，exceptwhenqueryingthisdata.Youneedtoprovideawaytoquerydatafromtheapplicationdatabase.

Whatshouldyou？（）

YouworkinacompanywhichisnamedWiikigoCorp.ThecompanyusesSQLServer2008.Youaretheadministratorofthecompanydatabase.NowyouareinchargeofaSQLServer2008instance.ThereisadatabasenamedDB1intheinstance.Inthedatabase,asmallpercentageofdataismodifiedeveryday.Everdayinthemorning,youhavetocreatearead-onlycopyofthedatabaseforreportingpurposesandmakesurethatyouuseaslittlediskspaceaspossible.Intheoptionsbelow,whichstrategyshouldyouuse?（）

A.Youshouldusedatabasesnapshots

B.Youshouldusedatabasebackupandrestore

C.Youshouldusedatabasebackupandrestorealongwithcompression

D.Youshoulduseschema-boundviewsinaread-onlydatabase.Thedatabaseresidesonthesame instance.

You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and added to the database. You currently use the following BULK INSERT statement to add the account information:

BULK INSERT finance.dbo.customers

FROM ‘di\bulk\accts143_10141000.txt’

WITH DATAFILETYPE = ‘char’,

FIELD/TERMINATOR = ‘\t’,

ROWTERMINATOR = ‘\n,’

TABLOCK

You want to ensure that response times do not slow when new account information is added to the database. What should you do?

A．Drop the indexes for the customers table before the data load, and then re-create the indexes after the data load is complete.

B．Remove the TABLOCK option from the BULK INSERT statement.

C．Add the BATCHSIZE option to the BULK INSERT statement and then set the option equal to 10 percent of the number of rows to be loaded.

D．Add the ROWS_PER_BATCH option to the BULK INSERT statement and then set the option equal to 10 percent of the number of rows to be loaded.

听力原文： Collecting information about pre-employment and filling out an application form. are closely connected. However, filling out an application form. is much easier because you have total control and have enough time to think and plan. That you are given a form. to fill out does not necessarily mean you have to answer all the questions in it. If the form. contains unclear questions or terms and conditions, you can make some changes before signing it, or refuse to answer some of the questions. What you must realise is that those terms and conditions have been written by highly-paid lawyers. Each word is important, or it would not be there; and you can be sure that there is not anything there that is written with your interests in mind. I know what I speak of, because as a lawyer for Litton Industries, I wrote the terms and conditions that were printed on the back of order forms. I wrote the most tiring terms and conditions anyone has ever seen. Still, 90 percent of the buyers would just sign on them without questioning anything. If anyone questions them, we would reach an agreement on something that was acceptable to both sides. So when you see a preprinted application that contains questions or terms and conditions, read it all and read it slowly. If you dont like something, you can simply change the parts you dont like. Remember that everything can be settled by discussion. To what degree it can be settled depends on your position, of course, and that is something only you can determine. Questions 16 to 18 are based on the passage you have just heard. 16. Why is filling out application forms much easier? 17. What can we learn from the expression "Each word is important"? 18. What can we infer from the passage?16．

A．Each question in a form. must be answered.

B．Everything in a form. must be read carefully.

C．Something of your interest is most important.

D．The conditions that interest you are changeable.

听力原文： Collecting information about pre-employment and filling out an application form. are closely connected. However, filling out an application form. is much easier because you have total control and have enough time to think and plan.

That you are given a form. to fill out does not necessarily mean that you have to answer all the questions in it. If the form. contains unclear questions or terms and conditions, you can make some changes before signing it, or refuse to answer some of the questions. What you must realize is that those terms and conditions have been written by highly-paid lawyers. Each word is important, or it would not be there; and you can be sure that there is not anything there that is written with your interests in mind.

I know what I speak of because, as a lawyer for Litton Industries. I wrote the terms and conditions that were printed on the back of order forms. I wrote the most tiring terms and conditions anyone has ever seen. Still, 90 percent of the buyers would just sign on them without questioning anything. If anyone questions them, we would reach an agreement on something that was acceptable to both sides.

So when you see a preprinted application that contains questions or terms and conditions, read it all and read it slowly. If you don't like something, you can simply change the parts you don't like. Remember that everything can be settled by discussion. To what degree it can be settled depends on your position, of course, and that is something only you can determine.

(30)

A．Because you can plan and have control of the needed time.

B．Because you can control the form. filling with enough time.

C．Because everything connected with application forms is easier.

D．Because it is easier to collect information about pre-employment.

You want to provide all users in your corporation with a single agent that provides access to multiple connection types conditionally. For example, you connect to the Junos Pulse Access Control Service if you are connected to the intranet, but you connect to the Junos Pulse Secure Access Service if you are on a remote network.Which agent should you use for this type of connection requirement?（）

A. Junos Pulse should be configured with location awareness rules configured.

B. Odyssey Access Client should be installed with Host Checker configured to check the client‘s location.

C. Junos Pulse should be configured with all components installed.

D. Agentless access should be enabled so that clients can connect to any service without concern for installing an agent.

听力原文：M: So, Marie, you work with computers?

W: That's right. I'm a computer programmer.

M: John told me you're working in a movie studio. Is that true?

W: That's right. I work for Walt Disney. Ever heard of them?

M: Sure I have! They make the cartoons, right? So, what's it like?

W: Great, but today was exceptionally busy. I've never experienced a day worse than today.

M: If you have a good boss, however, it can't be that bad.

W: Oh, don't even get me started about my boss!

M: Why not? Don't you get along with him?

W: No one gets along with him! Even his wife left him because she couldn't take it anymore. It's not just that, my job involves a lot of time at the computer, many hours, it can be very tiring.

M: Why not quit?

W: Never! I may work long hours and have lots of pressure, but the pay's great and I love what I do. It was my childhood dream to work on cartoons.

M: I'm confused. Why do you continue with a job that gives you so much pressure?

W: I like the money and the title, and the idea of working on cartoons. If I keep working like this I'm going to be dead before I'm 40!

M: I think you should have a chat with your boss, tell him how you feel.

W: Maybe you are right. I think I'll do that. This has got to be one of the worst days of my life!

(23)

A．Yes, a very nice man.

B．No, nobody likes him.

C．He's OK.

D．She doesn't have a boss.

听力原文：M: So, Marie you work with computers?

W: That's right. I'm a computer programmer.

M: He told me you're working in a movie studio. Is that true?

W: That's right. I work for Walt Disney. Ever heard of them?

M: Sure I have! They make the cartoons, right? So, what's it like?

W: Great, but today was exceptionally busy. I've never experienced a day worse than to day.

M: If you have a good boss, however, it can't be that bad?

W: Oh, don't even get me started about my boss!

M: Why not? Don't you get along with him?

W: No one gets along with him! Even his wife left him because she couldn't take it any more. It's not just that, my job involves a lot of time at the computer, many hours, it can be very tiring.

M: Why not quit?

W: Never! I may work long hours and have lots of pressure, but the pay's great and I love what I do. It was my childhood dream to work on cartoons.

M: I'm confused. Why do you continue with a job that gives you so much pressure?

W: Maybe you are right. I like the money and the title, and the idea of working on cartoons,. If I keep working like this I'm going to be dead before I'm 40!

M: I think you should have a chat with your boss, tell him how you feel.

W: Maybe you are right. I think I'll do that. This has got to be one of the worst days. of my life !

(23)

A．yes, a very nice marl

B．no, nobody likes him.

C．he's OK.

D．she doesn't have a boss.

You are the network administrator for your company. All network servers run Windows Server 2003.The network includes a file server named File1. File1 contains a single disk for system files and two SCSIhard disks that comprise a 72-GB mirrored volume with 65 GB of read-only data. Users connect to thisdata by using shortcuts on their desktops.File1 is scheduled for replacement. You have a scheduled maintenance window to complete this task.Before the maintenance window, you build a new server.You need to bring the new server online with current data and re-establish redundancy as quickly aspossible. You must also ensure that the desktop shortcuts will continue to function.What should you do? （）

A. Name the new server File2. Create a new mirrored volume by using two 72-GB disks. Connect File2 to the network and copy the data from File1. When copying is complete, shut down the old File1.

B. Name the new server File1. Move both disks from the old File1 to the new File1. Scan the disks for changes. Import the disks. Connect the new File1 to the network.

C. Name the new server File1. Break the mirror on the old File1. Move one of the disks from the old File1 to the new File1. Scan the disk for changes. Initialize the disk. Select the spare disk and create the mirror. Connect the new File1 to the network.

D. Name the new server File1. Remove one of the disks in the mirror from the old File1. Move the disk to the new File1. Scan the disk for changes. Import the disk. Shut down the old File1 and connect the new File1 to the network.