Select the block that contains the data to appear in the pie chart.
Select the table that contains the data to appear in the pie chart.
Select the view that contains the data to appear in the pie chart.
Nothing. The wizard will automatically create the pie chart based on the highlighted data.
第1题:
You are the administrator of a SQL Server 2000 computer in your company's personnel department. 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.
第2题:
You want to create a pie-style chart using the Chart Wizard. What must be you do to determine the fields available for use in this chart? ()
第3题:
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()
第4题:
The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the fund code entered. The value needed to generate this summary data are stored in multiple tables. How would you define the data source for this data block without having the DBA create a database object? ()
第5题:
A sales analyst reviews the first draft on your Sales application, and requests that the application graphically represent revenue generated for each sales representative, in addition to the textual data currently displayed for the ORDER block. How would you incorporate this graphic in your form? ()
第6题:
You want to implement a master-detail relation between data blocks based on object tables. How would you do this? ()
第7题:
You design a Business Intelligence (BI) solution by using SQL Server 2008. The solution includes a SQL Server 2008 Analysis Services (SSAS) database. The database contains a data mining structure that uses a SQL Server 2008 table as a data source. A table named OrderDetails contains detailed information on product sales. The OrderDetails table includes a column named Markup. You build a data mining model by using the Microsoft Decision Trees algorithm. You classify Markup as discretized content. The algorithm produces a large number of branches for Markup and results in low confidence ratings on predictable columns. You need to verify whether the Markup values include inaccurate data. What should you do? ()
第8题:
Choose Tools -> Data Block Wizard, select View as the data source type, and base the block on the columns from the bales.
Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables.
Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually and alter the Query Data Source Columns and Query Data Source Arguments properties to enter the SELECT statement.
Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Table', and enter the SELECT statement in the Query Data Source Name property.
Choose Tools -> Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables.
Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually. Alter the Query Data Source Type to 'FROM' clause query', and enter the SELECT statement in the Query Data Source Name property.
第9题:
Create a data source view named DsvContoso that is associated with the two data sources and add the tables to the data source view.
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.
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.
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.
第10题:
Use Data Pump to transfer the existing data to a new encrypted tablespace
Use ALTER TABLE MOVE to transfer the existing data to a new encrypted tablespace
Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace
Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace
Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted
第11题:
Updating
Viewing
Deleting
Inserting
Truncating
第12题:
MERGE
INSERT
UPDATE
ADD
ENTER
You cannot enter the phone numbers for the existing employee records.
第13题:
You are the network administrator for You manage a Windows 2003computer named TestKing3 that functions as a file server.The data volume on TestKing3 is mirrored. Each physical disk is on a separate controller. One of the hard disks that contains the data volume fails. You discover that the failure was caused by a faulty SCSI controller. You replace the SCSI controller.You need to restore the data volume to its previous state. You want to achieve this goal by using the minimum amount of administrative effort.What should you do?()
A. Run the diskpart active command on the failed volume
B. Convert both disks to basic disks, and then restore the data.
C. Break the mirror, and then re-create the mirror.
D. Select a disk in the mirror, and then reactivate the volume.
第14题:
You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?()
第15题:
Which two chart base types can you select using the Chart Wizard?()
第16题:
From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for ().
第17题:
USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methodswould you use to achieve this?()
第18题:
You are the network administrator for You manage a Windows 2003 computer named TestKing3 that functions as a file server. The data volume on TestKing3 is mirrored. Each physical disk is on a separate controller. One of the hard disks that contains the data volume fails. You discover that the failure was caused by a faulty SCSI controller. You replace the SCSI controller. You need to restore the data volume to its previous state. You want to achieve this goal by using the minimum amount of administrative effort. What should you do?()
第19题:
Create the relation manually and coordinate the blocks using triggers.
Base the relation on a REF pointer using the Data Block Wizard.
Base the relation on a foreign key using the Data Block Wizard.
This task is not possible because master-detail relations can be implemented only for blocks based on relation tables.
第20题:
Invoke the Chart Wizard and create a chart based on the ORDER block.
Create a chart using Graphics Builder and then select File Import Chart in Form Builder, positioning the new chart with the text items in the ORDER block.
Invoke the Data Block Wizard in reentrant mode, select the Charts tab, and specify the chart type and column sources for the X and Y axes.
Select the Chart node in the Object Navigator, Click the Create icon, and specify the details of the chart in the chart's Property Palette.
第21题:
Modify the content type of Markup as Continuous.
Create a data mining dimension in the SSAS database from OrderDetails.
Create a data profile by using SQL Server 2008 Integration Services (SSIS).
Create a cube in SSAS. Use OrderDetails as a measure group. Recreate the data mining structure and mining model from the cube data.
第22题:
table
transactional trigger
stored procedure
FROM clause query
第23题:
Line
Column
Bubble
Flowchart
OHLC candle stock