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.

题目

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.
相似考题

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

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

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

4.You create a data block based on a relation table containing a REF column. You select the REF column for your form module. Which statement about the REF column is true?（）A、It is created as a nondisplay item. B、The Lock Record property is set to Yes. C、It cannot be referenced in item level triggers. D、It is placed on the canvas with the highest sequence number.

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

  • 第1题：

    You create a master-detail form. The users need to be able to exit the form quickly, adhering to default transaction processing, regardless of the cursor location. You believe you can achieve this using a Key-Exit trigger. What do you need to do to implement this request? （）

    • A、Define a Key-Exit trigger for all the blocks in the form.  
    • B、In the Object Navigator, highlight all the items and define a Key-Exit trigger. 
    • C、Define a Key-Exit trigger on the primary key item in the master block.
    • D、No additional key-trigger definition is necessary.

    正确答案:D

  • 第2题：

    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

  • 第3题：

    he data blocks in your form module are based on object tables. How would you create a master-detail relationship between two of these blocks?（）

    • A、Use the Data Block Wizard and base the relation on a REF pointer. 
    • B、In the Object Navigator, select the Relation node under the master block and click the Create icon. Build the relation manually and coordinate the blocks using triggers.
    • C、Use the Data Block Wizard, and base the relation on the primary key-foreign key relationship in the database. 
    • D、This task is not possible because master-detail relations can be implemented only for blocks based on relational tables. 

    正确答案:A

  • 第4题：

    The EMP_DEPT block in your EMPLOYEE form is based on a view in an Oracle8 database. The items in this block have the Update Allowed property set to Yes. Which database feature makes it possible to permanently modify the underlying view?（）

    • A、REF cursor. 
    • B、Instead Of trigger. 
    • C、Stored procedure that returns object values. 
    • D、The underlying view cannot be modified because DML on a view is not supported.

    正确答案:B

  • 第5题：

    What are three uses for record groups?（）

    • A、To pass data to a pop-up menu. 
    • B、To populate a base table block. 
    • C、To pass data to other form modules. 
    • D、To pass data to other Oracle products. 
    • E、To dynamically construct SELECT statements. 
    • F、To server as the source for a FROM clause query. 

    正确答案:C,D,E

  • 第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 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
    解析： 暂无解析

  • 第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 create a data block based on a relation table containing a REF column. You select the REF column for your form module. Which statement about the REF column is true?（）
    A

    It is created as a nondisplay item. 

    B

    The Lock Record property is set to Yes. 

    C

    It cannot be referenced in item level triggers. 

    D

    It is placed on the canvas with the highest sequence number.


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

  • 第12题：

    多选题
    What are three uses for record groups?（）
    A

    To pass data to a pop-up menu.

    B

    To populate a base table block.

    C

    To pass data to other form modules.

    D

    To pass data to other Oracle products.

    E

    To dynamically construct SELECT statements.

    F

    To server as the source for a FROM clause query.


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

  • 第13题：

    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

  • 第14题：

    You create a data block based on a relational table containing a REF column. You select the REF column for your form module. What is true about the items based on the REF column attributes?（）

    • A、The Query Only property is set to Yes. 
    • B、The Conceal Data property is set to Yes. 
    • C、The Insert Allowed property is set to Yes. 
    • D、The Update Allowed property is set to Yes.

    正确答案:A

  • 第15题：

    You are creating the CUST_PREMIUM data block in the AUTO_INSURANCE form. A new state law requires that premiums be lowered for drivers with a good driving history. Because this could potentially affect a large number of records, you want to base the data block on a stored procedure returning a table of records. Which statement supports this approach?（）

    • A、A table of records is efficient in terms of network traffic. 
    • B、A table of records improves developer productivity because the database administrator does not have to create a server side view. 
    • C、A table of records is efficient because the number of records fetched depends on the Array Fetch property value.
    • D、Your coding effort is simplified since DML operations are handles by setting form module properties.

    正确答案:A

  • 第16题：

    You are maintaining a database of credit card transactions. You want the data to be returned automatically in the chronological order of the credit card numbers without using the ORDER BY clause in the query. Which type of cluster will you use to obtain the desired result？（）  

    • A、 Hash cluster
    • B、 Index cluster
    • C、 Sorted hash cluster
    • D、 Real Application cluster

    正确答案:C

  • 第17题：

    You need to ensure the Order Control team is able to track the number of orders that reach the production department. What should you do?（）

    • A、Create a new Time dimension based on the Holiday table. Use derived columns for the month and the year.
    • B、Create a Server Time dimension. Within this dimension， enable the time periods year， month， and date. Select the Additional Manufacturing calendar option.
    • C、Create a new Time dimension based on the date values within the ProductOrderStatus table. Flag those days on which no orders were received as Holiday.
    • D、Create a new Time dimension based on a data source view named query. Derive the data for this data source view from unique dates within the ProductOrderStatus table. Use a subquery to identify the holidays and derived columns for the month and the year.

    正确答案:D

  • 第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题：

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

  • 第21题：

    单选题
    You are creating the CUST_PREMIUM data block in the AUTO_INSURANCE form. A new state law requires that premiums be lowered for drivers with a good driving history. Because this could potentially affect a large number of records, you want to base the data block on a stored procedure returning a table of records. Which statement supports this approach?（）
    A

    A table of records is efficient in terms of network traffic. 

    B

    A table of records improves developer productivity because the database administrator does not have to create a server side view. 

    C

    A table of records is efficient because the number of records fetched depends on the Array Fetch property value.

    D

    Your coding effort is simplified since DML operations are handles by setting form module properties.


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

  • 第22题：

    单选题
    You create a data block based on a relational table containing a REF column. You select the REF column for your form module. What is true about the items based on the REF column attributes?（）
    A

    The Query Only property is set to Yes. 

    B

    The Conceal Data property is set to Yes. 

    C

    The Insert Allowed property is set to Yes. 

    D

    The Update Allowed property is set to Yes.


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

  • 第23题：

    单选题
    You create a master-detail form. The users need to be able to exit the form quickly, adhering to default transaction processing, regardless of the cursor location. You believe you can achieve this using a Key-Exit trigger. What do you need to do to implement this request? （）
    A

    Define a Key-Exit trigger for all the blocks in the form.  

    B

    In the Object Navigator, highlight all the items and define a Key-Exit trigger. 

    C

    Define a Key-Exit trigger on the primary key item in the master block.

    D

    No additional key-trigger definition is necessary.


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

相关内容