软考中级
Data mining is an(66)research field in database and artificial intelligence. In this paper, the data mining techniques are introduced broadly including its producing background, its application and its classification. The principal techniques used in the
题目
Data mining is an(66)research field in database and artificial intelligence. In this paper, the data mining techniques are introduced broadly including its producing background, its application and its classification. The principal techniques used in the data mining are surveyed also, which include rule induction, decision(67), artificial(68)network, genetic algorithm, fuzzy technique, rough set and visualization technique. Association rule mining, classification rule mining, outlier mining and clustering method are discussed in detail. The research achievements in association rule, the shortcomings of association rule measure standards and its(69), the evaluation methods of classification rules are presented. Existing outlier mining approaches are introduced which include outlier mining approach based on statistics, distance-based outlier mining approach, data detection method for deviation, rule-based outlier mining approach and multi-strategy method. Finally, the applications of data mining to science research, financial investment, market, insurance, manufacturing industry and communication network management are introduced. The application(70)of data mining are described.
A．intractable
B．emerging
C．easy
D．scabrous
相似问题和答案
第1题：
长期存储在计算机内，有组织的、可共享的大量数据的集合是（）。
A．数据（Data）
B．数据库（DataBase）
C．数据库管理系统（DBMS）
D．数据库系统（DBS）
第2题：
长期存储在计算机内，有组织的、可共享的大量数据的集合是（）。 A、数据（Data） B、数据库（DataBase） C、数据库管理系统（DBMS） D、数据库系统（DBS）
A．数据（Data）
B．数据库（DataBase）
C．数据库管理系统（DBMS）
D．数据库系统（DBS）
第3题：
长期存储在计算机内，有组织的、可共享的大量的数据的集合是（）。
A．数据（Data）
B．数据库（DataBase）
C．数据库管理系统（DBMS)
D．数据库系统（DBS）
第4题：
B.Buffer
C.DatA.record
D.Database
第5题：
A word processor enables you to create a(66), store it electronically on a disk, display it on a screen, modify it by entering commands and characters from the keyboard, and print it on a printer.
A．file
B．document
C．text
D．paper
解析：字处理器(软件)让你能够去创建一个文档，将它电子方式地存储在磁盘上，显示在显示器中，从键盘中输入命令和字符去修改它，以及在打印机上打印出来。
第6题：
A.run{openscriptbackup_database；runscriptbackup_database}
B.run{engagescriptbackup_database；}
C.run{runscriptbackup_database；}
D.Run{executescriptbackup_database；}
E.Thenamebackup_databaseisaninvalidnameforanRMANscript.TryingtorunitfromRMAN wouldresultinanerror.
第7题：
A word processor enables you to create a(66)., store it electronically on a disk, display it on a screen, modify it by entering commands and characters from the keyboard, and print it on a printer.
A．file
B．document
C．text
D．paper
解析：字处理器(软件)让你能够去创建一个文档，将它电子方式地存储在磁盘上，显示在显示器中，从键盘中输入命令和字符去修改它，以及在打印机上打印出来。
第8题：
You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database.
The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.
You need to configure a SQL Server computer for the new branch office in Sydney. You want to copy the Los Angeles package and modify it so that it writes data to the SQL Server database in Sydney.
You use the DTS Designer to modify the DTS package so that it imports regional data from the mainframe. database to the server in Sydney. The modified DTS package runs successfully on the server in Los Angeles. You save this DTS package to the server in Sydney, but the server in Sydney cannot connect to the mainframe. database.
You want to enable the server in Sydney to connect to the mainframe. database. What should you do?
A．Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database.
B．Modify the workflow in the DTS package so that the server in Sydney is included.
C．On the server in Sydney, install an OLE DB provider for the mainframe. database.
D．On the server in Sydney, delete and then re-create the DTS package.
解析：Explanation: OLE DB is an API that allows COM applications to use data from OLE DB data sources, which includes data stored in different formats. An application uses an OLE DB provider to access an OLE DB data source. An OLE DB provider is a COM component that accepts calls to the OLE DB API and performs the necessary processing required by request against the data source. In this scenario the OLE DB source is the company's mainframe. database, which contains all company data. As each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database, all existing and future branch office SQL Server 2000 servers will require an OLE DB provider to access the company's mainframe. database.
Incorrect Answers:
A: The DTS package requires an OLE DB provider to access an OLE DB data source. It needs this provider to connect to the company's mainframe. database. Resetting the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database will not provide the DTS package with the required access to the mainframe. database.
B: A separate DTS package must be created for the Sydney branch office. This DTS package must extract data from the company's mainframe. computer that is relevant to the branch office in Sydney. The existing DTS package used to extract data from the company's mainframe. for the Los Angeles SQL Server 2000 server can be modified to serve the same function for the Sydney office.
D: Re-creating the DTS package on the SQL Server 2000 server in the branch office in Sydney is unnecessary the that SQL Server 2000 server would still require an OLE DB provider to access the company’s mainframe. database. It would require less administrative effort to modify the existing DTS package.
第9题：
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.
解析：Explanation: The TABLOCK hint increases the number of locks during the adding process. This is the reason why response time are slows down during this process. By removing the TABLOCK hint the default more granular row-level lock will be used. This would decrease the scope of the locks which would result in less waiting jobs and performance would improve.
Note: The BULK INSERT statement is used to copy a data file into a database table or view in a format specified by the user. The BULK INSERT statement accepts the TABLOCK hint, which allows the user to specify the locking behavior. that the BULK INSERT statement should use. TABLOCK specifies that a bulk update table-level lock is taken for the duration of the bulk copy. If TABLOCK is not specified, the default uses row-level locks.
Incorrect Answers:
A: The recommendation to perform. the bulk copy operation with the indexes in place depends on the amount of data to be copied into the table compared to the amount of existing data already in the table. The large the amount of data to be loaded into a table, relative to the amount of data already in the table, the more efficient it is to drop all indexes on the table, perform. the bulk copy operation, and then re-create the indexes after the data is loaded
C: The BATCHSIZE option of the BULK INSERT statement is used to specify that SQL Server 2000 must treat each batch of rows inserted into the table as a separate transaction. This is useful when errors occur in the bulk copy operation, which would cause the transaction to be rolled back. By specifying the BATCHSIZE option, only the current transaction will be rolled back if an error occurs and the destination table still contains the other batches of rows that were successfully inserted.
D: The ROWS_PER_BATCH option of the BULK INSERT statement SQL Server can be used to
indicate the approximate number of rows in a batch. SQL Server 2000 then optimizes the load automatically, according to the batch size value, which may result in better performance. Although accuracy in the clause is not critical, the larger the batch size is, the better the performance of the bulk copy operation.