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

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

相似考题

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

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

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

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.

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

  • 第1题：

    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

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

    You need to change the text of a pop-up menu that appears when a user right clicks the mouse in the EMP_DATA data block. Where could you find the node for the pop-up menu in the Object Navigator?（）

    • A、Built-in Packages 
    • B、Menus 
    • C、PL/SQL Libraries 
    • D、Object Libraries 
    • E、Form Module

    正确答案:E

  • 第5题：

    In the COURSE_ENROLLMENT form module, you define a master-detail relation between the COURSES_OFFERED data block and the STUDENT data block, respectively. To implement block coordination, which statement must be true?（）

    • A、 The Enforce Primary Key property on the STUDENT block is set to Yes. 
    • B、 The Alias property on the COURSES_OFFERED block is set to Student. 
    • C、 The Copy Value from item property on the foreign key item in the STUDENT blocks is set to the primary key item of the COURSES_OFFERED block. 
    • D、 The Synchronize with item property on the foreign key item in the STUDENT block is set to the primary key item of the COURSES_OFFERED block.

    正确答案: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题：

    单选题
    You are developing a Hotel Booking application for a travel company. The users request a wizard-style interface for this application. How could you satisfy this requirement?（）
    A

    Reference the Object Iron packages in your form module. 

    B

    Write an HTML interface, and invoke it from your form module. 

    C

    Include the Wizard class reusable component in your application. 

    D

    Build a customized wizard using tab canvases and a horizontal toolbar canvas.


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

  • 第8题：

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

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

    单选题
    Matthew has recently joined NetFx Corporation as a junior-level Database Administrator （DBA）. He is asked by his supervisor to verify the database for data block corruptions. He uses the DBVERIFY utility and finds that two data blocks are corrupted in the database.   What should Matthew use to identify the corrupted blocks as well as datafiles containing these blocks？（）
    A

     datafile

    B

     alert log

    C

     dynamic views

    D

     control file script


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

  • 第11题：

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

  • 第12题：

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

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

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

    • A、Invoke the Chart Wizard and create a chart based on the ORDER block. 
    • B、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. 
    • C、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. 
    • D、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.

    正确答案:A

  • 第16题：

    You want to implement a master-detail relation between data blocks based on object tables. How would you do this? （）

    • A、Create the relation manually and coordinate the blocks using triggers. 
    • B、Base the relation on a REF pointer using the Data Block Wizard. 
    • C、Base the relation on a foreign key using the Data Block Wizard. 
    • D、This task is not possible because master-detail relations can be implemented only for blocks based on relation tables.

    正确答案:B

  • 第17题：

    单选题
    You want to implement a master-detail relation between data blocks based on object tables. How would you do this? （）
    A

    Create the relation manually and coordinate the blocks using triggers. 

    B

    Base the relation on a REF pointer using the Data Block Wizard. 

    C

    Base the relation on a foreign key using the Data Block Wizard. 

    D

    This task is not possible because master-detail relations can be implemented only for blocks based on relation tables.


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

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

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

  • 第20题：

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

    Invoke the Chart Wizard and create a chart based on the ORDER block. 

    B

    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. 

    C

    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. 

    D

    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.


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

  • 第21题：

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

  • 第22题：

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


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

  • 第23题：

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

  • 第24题：

    单选题
    In the COURSE_ENROLLMENT form module, you define a master-detail relation between the COURSES_OFFERED data block and the STUDENT data block, respectively. To implement block coordination, which statement must be true?（）
    A

     The Enforce Primary Key property on the STUDENT block is set to Yes. 

    B

     The Alias property on the COURSES_OFFERED block is set to Student. 

    C

     The Copy Value from item property on the foreign key item in the STUDENT blocks is set to the primary key item of the COURSES_OFFERED block. 

    D

     The Synchronize with item property on the foreign key item in the STUDENT block is set to the primary key item of the COURSES_OFFERED block.


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

相关内容