A．抑制RNA多聚酶 B．抑制蛋白质合成 C．抑制分枝菌酸合成 D．抑制二氢叶酸合成酶 E．抑制二氢叶酸还原酶

information from a Microsoft access database into a SQL Server 2000 database. The table has 12,000 rows. Each row averages 5,000 bytes. The table contains lockup data that does not change.

You want to minimize the size of the data file and the time required to back up the data. Which two actions should you take？ (Each correct answer presents part of the solution. Choose two)

A. Create a 60-MB data file named geography.ndf

B. Create a 95-MB data file named geography.ndf

C. Create a 60-MB data file named geography.mdf

D. Create a 95-MB data file named geography.mdf

E. Place the table in the PRIMARY filegroup.

F. Place the table in a new filegroup named LOCATION.

ment. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.

You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.

You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.

What should you do？

A．Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.

B．Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.

C．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.

D．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.

creating a new temporary tablespace as follows:CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE ‘/u1/data/temp1.dbf‘ SIZE 10MTABLESPACE GROUP ‘‘;Which statement regarding the above command is correct？（）

A. It will create the tablespace TEMP1 in group G1.

B. It will create the tablespace TEMP1 in group G3.

C. It will not add the tablespace TEMP1 to any group.

D. It will create the tablespace TEMP1 in the default group.

med Inventory. The Inventory database has a table named StorageLocations that stores the location of parts contained in your company's warehouses. The StorageLocations table is configured as shown in the exhibit.

The LocationDescription field is usually described with a name 10 to 25 characters in length. The locations never store more than 100,000 units of any given part.

You want to modify the table's schema to save space. You cannot lose any existing data. You want to do this by using the minimum amount of administrative time and server resources.

Which Transact-SQL statement should you execute？

A．ALTER TABLE [dbo].[StorageLocations] ALTER COLUMN [UnitsStored] [int] NOT NULL

B．ALTER TABLE [dbo].[StorageLocations] [LocationDescription] [char] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL

C．ALTER TABLE [dbo].[StorageLocations] ALTER COLUMN [UnitsStored] [smallint] NOT NULL

D．ALTER TABLE [dbo].[StorageLocations] [LocationDescription] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL

equests that are initiated by the server. You install the Microsoft network monitor 3.0 application on CRM1. You capture all local traffic on CRM1 for 24hours. You save the capture file as data.cap. you find that the size of this file is more than 1GB. You need to create a file named DNSdata.cap from the existing capture file that contains only DNS –related data what should you do？（）

A.Apply the display filter IDNS and save the displayed frames as DNSdata.cap file.

B.Apply the capture filter IDNS and save the displayed frames as DNSdata.cap file.

C.Add a new alisa named DNS to the aliases table and save the file as DNSdata.cap.

D.Run the nmcap.exe /inputcapture data.cap /capture DNS /file DNSdata.cap command.

equests that are initiated by the server. You install the Microsoft Network Monitor 3.0 application on CRM1. You capture all local traffic on CRM1 for 24 hours. You save the capture file as data.cap. You find that the size of the file is more than 1 GB. You need to create a file named DNSdata.cap from the existing capture file that contains only DNS-related data.What should you do？ （）

A. Apply the display filter !DNS and save the displayed frames as a DNSdata.cap file.

B. Apply the capture filter DNS and save the displayed frames as a DNSdata.cap file.

C. Add a new alias named DNS to the aliases table and save the file as DNSdata.cap.

D. Run the nmcap.exe /inputcapture data.cap /capture DNS /file DNSdata.cap command.

A. CREATE USER susan;

B. CREATE OR REPLACE USER susan;

C. CREATE NEW USER susan DEFAULT;

D. CREATE USER susan IDENTIFIED BY blue;

E. CREATE NEW USER susanIDENTIFIED by blue;

F. CREATE OR REPLACE USER susan IDENTIFIED BY blue;