You are a database administrator for your company. The company uses a SQL Server 2005 application. Each night， data is imported into a database， and the database is then set to be read-only. During business hours， users run predefined and ad hoc queries. 

题目

You are a database administrator for your company. The company uses a SQL Server 2005 application. Each night， data is imported into a database， and the database is then set to be read-only. During business hours， users run predefined and ad hoc queries. You need to monitor the servers performance during the day. What are two possible ways to achieve this goal？（）

  • A、Use the Lock Waits/sec performance counter.
  • B、Use the Number of Deadlocks/sec performance counter.
  • C、Use the Transactions/sec performance counter.
  • D、Use the Full Scans/sec performance counter.
  • E、Use the Batches/sec performance counter.
相似考题

1.Exhibit: You are developing a Web application. The Web application uses a GridView control to display data. You build your Web Forms for the Web application by dragging and dropping tables from the Data Connections tree in Server Explorer. You need to add a connection to your data by using the Add Connection dialog box as shown in the exhibit. During the process, you need to configure the .NET Data Provider that you use to create the data source objects. What should you do?（）A. Right-click the connection, and click Properties. Modify the Provider property of the data connection.B. Click the Change button, and change the data provider for the selected data source.C. Click the Advanced button, and change the Data Source property to the target provider.D. Click the Advanced button, and change the Application Name property to the target provider.

2.From SQL*Plus, you issue this SELECT statement:You use this statement to retrieve data from a data table for()。A. UpdatingB. ViewingC. DeletingD. InsertingE. Truncating

3.You are the administrator of SQL Server 2000 computer named FABSQL2K01. You create a Data Transformation Services package that contains definition for two transform. data tasks.The tasks gets data from two text files named Customers and Sales. The DTS package is configured as shown in the exhibit.You do not want the DTS package to add any data to the server unless both transform. data tasks complete successfully.You select the use transactions check box of DTS package and the Join transaction of present check box of both transform. data tasks. You then select the fail package on step failure check box of both transform. data tasks.You want to use the DTS package to import data from the text files to the server. You want to ensure that changes are committed if all imported data is successfully transformed.What should you do?A．Select the commit on successful completion check box of the DTS package.B．Select the commit transaction on successful completion of this step check box of the customers transform. data task.C．Select the commit transaction on successful completion of this step check box of the sales transform. data task.D．Select the commit transaction on successful completion of this step check box of both transform. data tasks.

4.In which case would you use a FULL OUTER JOIN? ()A. Both tables have NULL values.B. You want all unmatched data from one table.C. You want all matched data from both tables.D. You want all unmatched data from both tables.E. One of the tables has more data than the other.F. You want all matched and unmatched data from only one table.

参考答案和解析
正确答案:D,E
更多“You are a data”相关问题

  • 第1题：

    You are the administrator of a SQL Server 2000 computer. You are creating a data transformation services package. As the first step in this process, you need to load data from text files into a database table. These text files contain data on new stores that join your franchise. The text files list the data columns in the following format StoreID, StoreName, Address, City, State, PostalCode, ManagerID, StoreTypeID, FacilityID.

    The destination table is configured as shown in the exhibit.

    You want to load the data into the table as quickly as possible. What should you do?

    A．Use a Bulk Insert Task to read the data into a temporary table. Use an Execute SQL task to import the appropriate data into the destination table.

    B．Create and edit a format file to select the columns you want to import. Use a Bulk Insert Task, and then specify the format file to import the appropriate data into the destination table.

    C．Use a transform. data task to import the data. Use Microsoft ActiveX transformation scripts to write the appropriate data to the appropriate columns in the destination table.

    D．Create and edit a format file to select the columns you want to import. Use a transform. data task, and then specify the format file to import the appropriate data into the destination table.


    正确答案：B
    解析：Explanation:TheBulkInsertTaskisthefastestmechanismforcopyinglargeamountsofdataintoaSQLServer2000tableorview.However,transformationscannotbeperformedonthedatawhileitismovedfromthesourcefiletothetableorview,asthiswouldslowdownthedatacopyprocess.ThusthetextfilemustbeformattedbeforetheBulkInsertTaskisused.TheformatfileprovidesthedefaultinformationusedeithertobulkcopythedatainthedatafileintoaninstanceofSQLServer2000ortobulkcopydataoutfromthetable.TheformatfilealsoprovidesawaytobulkcopydataselectivelyfromadatafiletoaninstanceofSQLServer.Thisallowsforthetransferofdatatoatablewhenthereisamismatchbetweenfieldsinthedatafileandcolumnsinthetable.Byusingaformatfile,itispossibletobulkcopydataintoaninstanceofSQLServerwithouthavingtoaddordeleteunnecessarydata,orreorderexistingdata,inthedatafile.IncorrectAnswers:A:TheBulkInsertTaskisthefastestmechanismforcopyinglargeamountsofdataintoaSQLServer2000tableorview.Itcanmakeuseofaformatfilethatallowsforthetransferofdatatoatablewhenthereisamismatchbetweenfieldsinthedatafileandcolumnsinthetable.Byusingaformatfile,itispossibletobulkcopydataintoaninstanceofSQLServerwithouthavingtoaddordeleteunnecessarydata,orreorderexistingdata,inthedatafile.Itthusmakestheneedtofirstimportthedataintoatemporarytableobsolete.C:TheTransform.Datataskisusedtocopydatabetweenasourceanddestinationandtooptionallyapplycolumn-leveltransformationstothedata.TheTransform.DatataskisthemostbasicimplementationofthedatapumpengineinDataTransformationServices(DTS)andisoptimizedforinsert-basedcopyingandtransformingofcolumn-leveldatabetweencommercialdatabases,spreadsheets,andtextfiles.However,theBulkInserttaskprovidesthebestperformanceforbulkinsertingtextfilesintoSQLServer2000,althoughitcannotbeusedtotransform.data.D:TheBulkInsertTaskisthefastestmechanismforcopyinglargeamountsofdataintoaSQLServer2000tableorview.Itcanmakeuseofaformatfilethatallowsforthetransferofdatatoatablewhenthereisamismatchbetweenfieldsinthedatafileandcolumnsinthetable.Byusingaformatfile,itispossibletobulkcopydataintoaninstanceofSQLServerwithouthavingtoaddordeleteunnecessarydata,orreorderexistingdata,inthedatafile.

  • 第2题：

    You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database（）

    • A、Use the external table population.
    • B、Use the Oracle Data Pump export and import utility.
    • C、Use the conventional path data load of the SQL*Loader utility.
    • D、Use the INSERT INTO...SELECT command to load the data

    正确答案:C

  • 第3题：

    Which  statements are true regarding the Oracle Data Pump export and import operations（）

    • A、You cannot export data from a remote database.
    • B、You can rename tables during an import operation.
    • C、You can overwrite existing dump files during an export operation.
    • D、You can compress the data during export but not the metadata because it is not supported

    正确答案:B,C

  • 第4题：

    Which two statements are true regarding the Oracle Data Pump export and import operations（）

    • A、You cannot export data from a remote database.
    • B、You can rename tables during an import operation.
    • C、You can overwrite existing dump files during an export operation.
    • D、You can compress the data during export but not the metadata because it is not supported.

    正确答案:B,C

  • 第5题：

    You are designing a Windows Azure application that will store data. You have the following requirements：   - The data storage system must support the storage of more than 500 GB of data.   - Data retrieval must be possible from a large number of parallel threads without threads blocking each other.   You need to recommend an approach for storing data.  What should you recommend？（）

    • A、 Use Windows Azure Queues.
    • B、 Use Windows Live Mesh 2011.
    • C、 Use a single SQL Azure database.
    • D、 Use Windows Azure Table storage

    正确答案:D

  • 第6题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. You are going to use the data collector to gather performance data periodically on all instances. You must store all collected data in the same database. This database is hosted on a single instance. Every five hours, you have to collect and load performance data in the management data warehouse. Which data collection process should you implement? （） 

    • A、You should create a cached data collection 
    • B、You should create an on-demand non-cached data collection 
    • C、You should create a scheduled non-cached data collection. 
    • D、You should create two different SQL Agent jobs. The two jobs are scheduled at the same time. One job uploads the data collection and the other job creates a data collection.

    正确答案:C

  • 第7题：

    单选题
    Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace.  You place the DATA1 tablespace in backup mode by issuing the following statement：   ALTER TABLESPACE data1 BEGIN BACKUP；   While you are performing the backup， an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true？（）
    A

     The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.

    B

     If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is opened.

    C

     If you restart the database，the DATA1 tablespace will be automatically taken out of backup mode  when the database is mounted.

    D

     If you restart the database，the database will not be opened.


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）
    A

    Use the external table population.

    B

    Use the Oracle Data Pump export and import utility.

    C

    Use the conventional path data load of the SQL*Loader utility.

    D

    Use the INSERT INTO...SELECT command to load the data.


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. You are going to use the data collector to gather performance data periodically on all instances. You must store all collected data in the same database. This database is hosted on a single instance. Every five hours, you have to collect and load performance data in the management data warehouse. Which data collection process should you implement? （）
    A

    You should create a cached data collection 

    B

    You should create an on-demand non-cached data collection 

    C

    You should create a scheduled non-cached data collection. 

    D

    You should create two different SQL Agent jobs. The two jobs are scheduled at the same time. One job uploads the data collection and the other job creates a data collection.


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a management data warehouse that uses the data collector to collect performance data. You intend to maintain the management data. You want to implement a data collection process. The process can gather and upload data in the management data warehouse on different schedules.  What process should you implement？（）
    A

    You should create a cached data collection

    B

    You should create an on-demand non-cached data collection 

    C

    You should create a scheduled non-cached data collection 

    D

    You should create two different SQL Agent jobs that are scheduled stimultaneously


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution by using SQL Server 2008. Several reports on the server use a shared data source named DSProduction. You modify an existing report that uses the DSProduction data source. After deployment， the modified report must use an alternate data source. You need to prevent the modified report from affecting other reports. What should you do？（）
    A

     Update the connection string of the DSProduction shared data source to point to the alternate data source.

    B

     Update the modified report to use a report-specific data source. Update the connection string of the report-specific data source to point to the alternate data source.

    C

     Create a new shared data source named DSProduction in the same folder as that of the modified report. Update the connection string of the new shared data source to point to the alternate data source.

    D

     Disable the DSProduction data source. Update the modified report to use a report-specific data source. Update the connection string of the report-specific data source to point to the alternate data source.


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    You want to put a specific tablespace called MY_DATA in hot backup mode so you can back it up. What command would you use？（）
    A

     alter tablespace MY_DATA begin backup

    B

     alter tablespace MY_DATA start backup

    C

     alter tablespace MY_DATA backup begin

    D

     alter MY_DATA begin backup

    E

     You cannot back up individual tablespaces


    正确答案： B
    解析： 暂无解析

  • 第13题：

    You install a custom application on a computer that runs Microsoft Windows XP. The application stores each user’s data in the %programfiles%\app1\data folder on the computer. You install the custom application on a computer that runs Windows Vista.On the Windows Vista computer, you back up the %programfiles%\app1\data folder and notice that the backup contains no data.You need to back up the application’s user data on the Windows Vista computer.What should you do?（）

    A.A

    B.B

    C.C

    D.D


    参考答案：D

  • 第14题：

    From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.

    • A、Updating
    • B、Viewing
    • C、Deleting
    • D、Inserting
    • E、Truncating

    正确答案:B,D

  • 第15题：

    Which two statements are true regarding the usage of the SQL*Loader utility（）

    • A、You can load data into multiple tables during the same load session.
    • B、You can load data from multiple files to a table during the same load session.
    • C、You cannot perform selective data loading based on the values available in the records.
    • D、You can use an export file generated by the EXPDP utility as an input data file to load the data.
    • E、You can load data only if the input file is available on the disk and tape but not in a named pipes.

    正确答案:A,B

  • 第16题：

    Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g？（） 

    • A、 Generate reports on data failure such as data file failures.
    • B、 You can track the Service Request （SR） and implement repairs.
    • C、 You can package and upload diagnostic data to Oracle Support.
    • D、 You can manually run health checks to gather diagnostic data for a problem.

    正确答案:B,C,D

  • 第17题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a management data warehouse that uses the data collector to collect performance data. You intend to maintain the management data. You want to implement a data collection process. The process can gather and upload data in the management data warehouse on different schedules.  What process should you implement？（） 

    • A、You should create a cached data collection
    • B、You should create an on-demand non-cached data collection 
    • C、You should create a scheduled non-cached data collection 
    • D、You should create two different SQL Agent jobs that are scheduled stimultaneously

    正确答案:A

  • 第18题：

    单选题
    You are developing a data contract for a Windows Communication Foundation (WCF) service. The data in the data contract must participate in round trips. Strict schema validity is not required. You need to ensure that the contract is forward-compatible and allows new data members to be added to it. Which interface should you implement in the data contract class?（）
    A

    ICommunicationObject

    B

    IExtension

    C

    IExtensibleObject

    D

    IExtensibleDataObject


    正确答案： C
    解析： 暂无解析

  • 第19题：

    单选题
    Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）
    A

    The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.

    B

    If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.

    C

    If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.

    D

    If you restart the database, the database will not be opened.


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    You need to base a data block on the EMP table, but you do not want to give the users of the application access privileges on the table. Which type of data source would you use to create the data block?（）
    A

    table 

    B

    transactional trigger 

    C

    stored procedure 

    D

    FROM clause query


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）
    A

    use the external table population

    B

    use the Oracle Data Pump export and import utility

    C

    use the conventional path data load of SQL*Loader utility

    D

    use the direct path data load of Oracle export and import utility


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?（）
    A

    using only the RMAN SWITCH command to set the new location for the data file

    B

    placing the database in the MOUNT state for the restore and recovery operations.

    C

    using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.

    D

    configuring two channels: one for the restore operation and the other for the recovery operation


    正确答案： A
    解析： 暂无解析

  • 第23题：

    多选题
    From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.
    A

    Updating

    B

    Viewing

    C

    Deleting

    D

    Inserting

    E

    Truncating


    正确答案： B,E
    解析： 暂无解析

  • 第24题：

    单选题
    You design a Business Intelligence （BI） solution by using SQL Server 2008. You design a SQL Server 2008 Analysis Services （SSAS） solution. Customer data is stored in the tables named CustomerDetails and CustomerContact. The solution uses the following two data sources from two different servers： ·Contoso that accesses the CustomerDetails table ·ContosoCRM that accesses the CustomerContact table You plan to create a dimension named DimCustomer to analyze customer data. You need to ensure that the DimCustomer dimension represents the tables as a snowflake schema to include attributes from the two tables. What should you do？（）
    A

     Create a data source view named DsvContoso that is associated with the two data sources and add the tables to the data source view.

    B

     Create a data source view named DsvContoso that is associated with the two data sources and create a named query in the data source view to merge the tables.

    C

     Create a data source view named DsvCustomer that is associated with the Contoso data source and add the CustomerDetails table to the data source view.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and add the CustomerContact table to the data source view.

    D

     Create a data source view named DsvCustomer that is associated with the Contoso data source and create a named query in the data source view to select data from the CustomerDetails table.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and create a named query in the data source view to select data from the CustomerContact table.


    正确答案： D
    解析： 暂无解析

相关内容