单选题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 procedu

题目
单选题
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

相似考题

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.

2.ou need to create a data block for query operations in the RETIRED_EMPLOYEES form module. Which three data sources can you use for this block?（）A、vector B、database view C、database table D、transactional trigger E、PL/SQL table of records F、multi-dimensional array

3.You need to create a data block for DML operations in the NEW_EMPLOYEE form module. Which data source can you use for this block?（）A、REF cursor query. B、Stored function. C、From clause query. D、Transactional trigger.

4.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.

更多“单选题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 procedu”相关问题

  • 第1题：

    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?（）

    • A、Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. 
    • B、Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 
    • C、Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. 
    • D、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 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. 
    • E、Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.

    正确答案:E

  • 第2题：

    You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）

    • A、BFILE 
    • B、REF column 
    • C、Object table 
    • D、Column object 
    • E、INSTEAD-OF trigger

    正确答案:B,C,D

  • 第3题：

    You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）

    • A、MERGE
    • B、SELECT …CROSS JOIN
    • C、INSERT ALL …SELECT
    • D、CREATE VIEW …CONSTRAINT

    正确答案:A

  • 第4题：

    You need to display a very large single-record data block. Since it will be so large, a convenient means of navigation is needed between items. Which type of canvas would you use to display the data block? （）

    • A、Tab canvas. 
    • B、Pop up canvas. 
    • C、Spread table canvas. 
    • D、Vertical toolbar canvas.

    正确答案:A

  • 第5题：

    An application uses Windows Azure Table storage. The application uses five tables.  One table used by the application is approaching the limit for storage requests per second.  You need to recommend an approach for avoiding data access throttling.  What should you recommend？（）

    • A、 Use a single partition key for the table.
    • B、 Compress data before storing it in the table.
    • C、 Create additional partition keys for the table.
    • D、 Continually remove unnecessary data from the table.

    正确答案:C

  • 第6题：

    单选题
    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 found code entered. The values needed to generate this summary data are stored in multiple tables. Which data source type can you assign to the data block for this form without having the DBA create a database object?（）
    A

    database table 

    B

    transactional trigger 

    C

    stored procedure 

    D

    FROM clause query 

    E

    client-side procedure


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

  • 第7题：

    单选题
    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? （）
    A

    Choose Tools -> Data Block Wizard, select View as the data source type, and base the block on the columns from the bales. 

    B

    Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 

    C

    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. 

    D

    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. 

    E

    Choose Tools -> Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables. 

    F

    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.


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

  • 第8题：

    多选题
    ou need to create a data block for query operations in the RETIRED_EMPLOYEES form module. Which three data sources can you use for this block?（）
    A

    vector

    B

    database view

    C

    database table

    D

    transactional trigger

    E

    PL/SQL table of records

    F

    multi-dimensional array


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

  • 第9题：

    单选题
    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
    解析： 暂无解析

  • 第10题：

    单选题
    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


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

  • 第11题：

    单选题
    You need to display a very large single-record data block. Since it will be so large, a convenient means of navigation is needed between items. Which type of canvas would you use to display the data block? （）
    A

    Tab canvas. 

    B

    Pop up canvas. 

    C

    Spread table canvas. 

    D

    Vertical toolbar canvas.


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

  • 第12题：

    单选题
    You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this.  Which data type would you use for the new column（）
    A

    CLOB

    B

    BLOB

    C

    BFILE

    D

    LONG RAW


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

  • 第13题：

    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 found code entered. The values needed to generate this summary data are stored in multiple tables. Which data source type can you assign to the data block for this form without having the DBA create a database object?（）

    • A、database table 
    • B、transactional trigger 
    • C、stored procedure 
    • D、FROM clause query 
    • E、client-side procedure

    正确答案:D

  • 第14题：

    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

  • 第15题：

    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? （）

    • A、Choose Tools -> Data Block Wizard, select View as the data source type, and base the block on the columns from the bales. 
    • B、Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 
    • C、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. 
    • D、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. 
    • E、Choose Tools -> Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables. 
    • F、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.

    正确答案:F

  • 第16题：

    You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add anew column to the EMPLOYEE table to achieve this.  Which data type would you use for the new column（）

    • A、CLOB
    • B、BLOB
    • C、BFILE
    • D、LONG RAW

    正确答案:C

  • 第17题：

    Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）

    • A、 Create a FOR trigger. 
    • B、 Create an INSTEAD OF trigger. 
    • C、 Create an AFTER trigger. 
    • D、 Create a DDL trigger.

    正确答案:B

  • 第18题：

    单选题
    You need to create a data block for DML operations in the NEW_EMPLOYEE form module. Which data source can you use for this block?（）
    A

    REF cursor query. 

    B

    Stored function. 

    C

    From clause query. 

    D

    Transactional trigger.


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

  • 第19题：

    单选题
    You are creating the SAL_INFO data block on the EMP_QUERY form. The SALARY field should only be populated if the logged-on user is a manager. Since this query could potentially return a large amount of records, you have created a stored procedure which uses a ref cursor on which to base the data block. How would you create the data block?（）
    A

    Click the Data Blocks node in the Object Navigator and click the create button. Choose to build the data block manually. Enter the procedure name in the Query Data Source Columns property and the procedure code in the Query Data Source Arguments property. 

    B

    Choose Tools -> Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure. 

    C

    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 'Ref cursor', and enter the name of the procedure in the Query Data Source Name property. 

    D

    Select the Data Blocks node in the Object Navigator and click the Create button. Alter the Query Data Source Name, Query Data Source Columns, and Query Data Source Arguments properties to create a stored procedure that uses a ref cursor. 

    E

    Launch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure.


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

  • 第20题：

    单选题
    Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）
    A

     Create a FOR trigger. 

    B

     Create an INSTEAD OF trigger. 

    C

     Create an AFTER trigger. 

    D

     Create a DDL trigger.


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

  • 第21题：

    单选题
    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?（）
    A

    Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. 

    B

    Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 

    C

    Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. 

    D

    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 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. 

    E

    Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.


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

  • 第22题：

    单选题
    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? （）
    A

    Select the block that contains the data to appear in the pie chart. 

    B

    Select the table that contains the data to appear in the pie chart. 

    C

    Select the view that contains the data to appear in the pie chart. 

    D

    Nothing. The wizard will automatically create the pie chart based on the highlighted data.


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

  • 第23题：

    单选题
    While designing the database for one of your online transaction processing （OLTP） applications， you want to achieve the following：  a） high availability of data  b） faster primary key access to the table data  c） compact storage for the table  Which type of tables would you use to achieve these objectives？（）
    A

    heap tables

    B

    object tables

    C

    partitioned tables

    D

    index-organized tables （IOTs）


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

  • 第24题：

    单选题
    An application uses Windows Azure Table storage. The application uses five tables.  One table used by the application is approaching the limit for storage requests per second.  You need to recommend an approach for avoiding data access throttling.  What should you recommend？（）
    A

     Use a single partition key for the table.

    B

     Compress data before storing it in the table.

    C

     Create additional partition keys for the table.

    D

     Continually remove unnecessary data from the table.


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

相关内容