经济法的三大特征是【 】A．经济性、公共性、现代性B．经济性、规制性、后现代性、C．经济性、规制性、现代性

nd SQL Server 7.0.

You install a named instance of SQL Server 2000, and then run the SQL server upgrade wizard. On the database selection screen, some of the SQL Server 6.5 databases are not listed.

You cancel the SQL Server upgrade wizard.

You need to ensure that the SQL Server 6.5 databases are listed in the wizard. What should you do？

A．Uninstall SQL Server 7.0, and then rerun the SQL Server upgrade wizard.

B．Run the Microsoft SQL Server-switch application, and then rerun the SQL Server upgrade wizard.

C．Create a data transformation services package that imports the databases from SQL Server 6.5 to SQL Server 2000, and then execute the package.

D．Uninstall SQL Server 2000, and then reinstall SQL Server 2000 as the default instance.

SQL Server 2000 on the computer.

Your company contains a variety of client computers that will connect to the SQL server 2000 computer by using a specific Net-Library, as shown in the following table.

You need to allow the client computers to connect to the SQL Server 2000 computer. You also want to minimize the number of configuration changes required on the client computers.

Which three actions should you take？ (Each correct answer presents part of the solution. Choose three)

A. Install SQL Server 2000 as a named instance.

B. Install SQL Server 2000 as the default instance.

C. Configure the new instance for Mixed Mode Authentication.

D. Configure the new instance for Windows Authentication.

E. Configure the server to use the Named Pipes, IPX/SPX, and TCP/IP Net-Libraries.

F. Configure the server to use the Multiprotocol Net-Library.

mation from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_General_CR437_BIN collation.

However, the existing SQL server computers in your office are configured to use the

SQL_Latin1_General_CP1_CI_AS collation.

You do not want to join tables in the inventory database with tables in other databases. You need to restore the inventory database to a SQL Server 2000 computer by using the least amount of administrative effort.

What should you do？

A．Use the rebuildm utility to rebuild the system database on an existing SQL server computer. Configure all the databases on that server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the server.

B．Restore the inventory database to an existing SQL server computer. Accept the SQL_Latin1_General_CR437_BIN collation for that database.

C．Install a new named instance of SQL Server 2000 on an existing SQL Server 2000 computer. Configure the named instance to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the named instance.

D．Install SQL Server 2000 on a new computer. Configure the new server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the new server.

rver and schedule them to run during the evening.

You configure an operator on the server and configure the jobs to send an e-mail to this operator if a job fails for any reason.

While testing the jobs, you discover that e-mail messages are not being sent to the operator when a job fails. You use SQL Server Enterprise Manager to confirm that SQL Mail is started.

You need to ensure that e-mail messages are sent to the operator whenever a job fails. What should you do？

A．Configure SQLAgentMail to use a valid MAPI profile

B．Configure SQL Mail to use a mailbox that delegates permissions to the operator

C．Use the net send notification method to send the operator e-mail messages

D．Create a job that executes the xp_startmail stored procedure Configure the job to run whenever SQL Server 2000 starts

tore service contract information for its customers.

You are also the administrator of Oracle relational database management system (RDBMS) server.

This server is used to store your company’s financial information. The financial information is updated frequently throughout the day.

You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.

You want to create reports on the SQL Server computer by using the minimum amount of disk space.

What should you do？

A．Set up SQL server replication to replicate the data from the oracle server to the SQL server computer.

B．Set up the oracle server as a linked server. Create a view that joins the service contract information and the financial information.

C．Set up data transformation services (DTS) package that imports and transforms the database from the oracle server to the SQL server computer. Use SQL server agent to execute the DTS package throughout the day as needed.

D．Set up Microsoft ActiveX script. that connects to the oracle server and imports the financial information into SQL server temporary table. Create a view that joins the service contract information and the temporary table.

r 2000 on a new Microsoft Windows 2000 Server computer. The computer will run two client/server database applications that your company has purchased. Each application uses a separate database.

During the installation, you specify SQL_Latin1_General_CP1_CI_AI as the default collation for the SQL server computer. After completing the installation, you discover that one of the new applications, named Financials, is sorting information incorrectly.

You contact the application vendor and discover that the Financials application requires the SQL_Latin1_CP437_BIN collation. You need to configure the correct collation for the applications without diminishing the performance of the SQL Server computer.

What should you do？

A．Rerun the SQL Server Setup and specify the SQL_Latin1_General_CP437_BIN collation.

B．Run the rebuildm utility and specify the SQL_Latin1_General_CP437_BIN collation.

C．Use the ALTER DATABASE statement to specify the SQL_Latin1_General_CP437_BIN collation for the Financials database.

D．Use the ALTER TABLE statement to specify the SQL_Latin1_General_CP437_BIN collation for each table in the Financials database.

at has the torn page detection database option enabled. Backups of the database are made daily.

The server loses power for one minute. When power is restored, torn pages are detected. You notice in SQL Server Enterprise Manager that the database is marked suspect.

You need to correct the problem. What should you do？

A．Execute the DBCC CHECKDB statement, and then specify the PHYSICAL_ONLY option.

B．Execute the DBCC CHECKDB statement, and then specify the REPAIR_REBUILD option.

C．Execute the sp_resetstatus stored procedure.

D．Restore the suspect database from backups.

You are the administrator of a new Microsoft Windows 2000 Server computer named CPSRV1.

CPSRV1 is a member server in your company's Windows NT 4.0 domain, which is named CPDOMAIN. A separate Windows NT domain named CPUSERS contains all of your company's user accounts. A trust relationship exists between the CPDOMAIN domain and the CPUSERS domain.

You are installing SQL Server 2000 on CPSRV1.

You specify a service account for each SQL Server service as shown in the following table:

After the installation is complete, the MSSQLServer service and the SQLServerAgent service do not start. You need to configure the services to start without changing any security settings in either domain.

What should you do？

A．Configure the services to run under the local system account

B．Add CPSRV1 to the CPUSERS domain

C．Add CPUSERS\sqlsvr and CPUSERS\sqlagent to the local administrators group on CPSRV1

D．Add CPUSERS\sqlsvr and CPUSERS\sqlagent to the CPUSERS\Domain Admins groups.

E．Add CPUSERS\sqlsvr and CPUSERS\sqlagent to the CPUSERS\Domain users groups.

A.SQL Server 2000企业版

B.SQL Server 2000标准版

C.SQL Server 2000个人版

D.SQL Server 2000企业版；SQL Server 2000标准版；SQL Server 2000个人版都是