niusouti.com

多选题You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）ABFILEBREF columnCObject tableDColumn objectEINSTEAD-OF trigger

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

相似考题

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. Your company uses a SQL Server 2005 database. This database contains a trigger named trg_InsertOrders, which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort.  Which two Transact-SQL statements can you use to achieve this goal?（）A、 ALTER TABLE OrdersDISABLE TRIGGER trg_InsertOrders B、 DROP TRIGGER trg_InsertOrders C、 DISABLE TRIGGER trg_InsertOrders ON Orders D、 ALTER TRIGGER trg_InsertOrders  ON Orders NOT FOR REPLICATION E、 sp_settriggerorder@triggername= 'trg_InsertOrders', @order='None'

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 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 are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）ABFILEBREF columnCObject tableDColumn objectEINSTEAD-OF trigger”相关问题

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

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

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

    You are developing a tax report for the payroll application. You created a before parameter form report trigger to create three temporary tables to store text that are need while the report is executed. Which report trigger would you use to delete these temporary tables?（）

    • A、Before parameter form. 
    • B、After parameter form. 
    • C、Before report. 
    • D、After report.

    正确答案:D

  • 第6题：

    You are building two forms. Each form has a button and a non-base table field. When the button is pressed, a complicated calculation is executed. The calculation is the same for both forms. The calculation code does not query or change the data in the database. When the calculation completes, it returns a single value to the non-base table field. To optimize performance and maintainability, which PL/SQL structure should be used? （）

    • A、A trigger in each form. 
    • B、A subprogram in each form. 
    • C、A stored subprogram in the database. 
    • D、A subprogram in a library that is attached to each form.

    正确答案:D

  • 第7题：

    TestKing.com uses a SQL Server 2005 database. This database contains a trigger named trg InsertOrders， which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal？（）

    • A、ALTER TABLE OrdersDISABLE TRIGGER trg InsertOrders
    • B、DROP TRIGGER trg InsertOrders
    • C、DISABLE TRIGGER trg InsertOrders ON Orders
    • D、ALTER TRIGGER trg InsertOrders ON Orders NOT FOR REPLICATION

    正确答案:A,C

  • 第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 building two forms. Each form has a button and a non-base table field. When the button is pressed, a complicated calculation is executed. The calculation is the same for both forms. The calculation code does not query or change the data in the database. When the calculation completes, it returns a single value to the non-base table field. To optimize performance and maintainability, which PL/SQL structure should be used? （）
    A

    A trigger in each form. 

    B

    A subprogram in each form. 

    C

    A stored subprogram in the database. 

    D

    A subprogram in a library that is attached to each form.


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

  • 第10题：

    多选题
    You are creating a new JSP page and you need to execute some code that acts when the page is firstexecuted， but only once. Which three are possible mechanisms for performing this initialization code？（）
    A

    In the init method.

    B

    In the jspInit method.

    C

    In the constructor of the JSP’s Java code.

    D

    In a JSP declaration， which includes an initializer block.

    E

    In a JSP declaration， which includes a static initializer block.


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

  • 第11题：

    多选题
    Your company uses a SQL Server 2005 database. This database contains a trigger named trg_InsertOrders, which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort.  Which two Transact-SQL statements can you use to achieve this goal?（）
    A

    ALTER TABLE OrdersDISABLE TRIGGER trg_InsertOrders

    B

    DROP TRIGGER trg_InsertOrders

    C

    DISABLE TRIGGER trg_InsertOrders ON Orders

    D

    ALTER TRIGGER trg_InsertOrders  ON Orders NOT FOR REPLICATION

    E

    sp_settriggerorder@triggername= 'trg_InsertOrders', @order='None'


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

  • 第12题：

    多选题
    TestKing.com uses a SQL Server 2005 database. This database contains a trigger named trg InsertOrders， which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal？（）
    A

    ALTER TABLE OrdersDISABLE TRIGGER trg InsertOrders

    B

    DROP TRIGGER trg InsertOrders

    C

    DISABLE TRIGGER trg InsertOrders ON Orders

    D

    ALTER TRIGGER trg InsertOrders ON Orders NOT FOR REPLICATION


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

  • 第13题：

    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

  • 第14题：

    You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze？（）

    • A、 Top SQL
    • B、 snapshots
    • C、 SQL Tuning sets
    • D、 index access path
    • E、 optimizer statistics
    • F、 materialized view logs

    正确答案:A,C,D

  • 第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 performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario？（）

    • A、 You must ensure that the SALES database is mounted or open.
    • B、 You must restore a backup control file to perform a block media recovery.
    • C、 You must take the tools01.dbf data file offline before you start a block media recovery.
    • D、 You must put the database in NOARCHIVELOG mode to perform a block media recovery.
    • E、 You can perform only a complete media recovery of individual blocks， point-in-time recovery of individual data blocks is not supported.

    正确答案:A,E

  • 第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.

    正确答案:B

  • 第18题：

    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. You intend to configure FILESTREAM data, enabling FILESTREAM for file I/O streaming access and allowing remote client computers to have streaming access to FILESTREAM data. You must make sure that FILESTREAM data is enabled. In the options below, which service should you configure? （） 

    • A、You should configure Distributed File System
    • B、You should configure SQL Server
    • C、You should configure SQL Server Full Text
    • D、You should configure SQL Server VSS Writer

    正确答案: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 want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment.   Which three sources can you select for the advisor to analyze？ （）
    A

    Top SQL

    B

    snapshots

    C

    SQL Tuning sets

    D

    index access path

    E

    optimizer statistics

    F

    materialized view logs


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

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

    多选题
    Which three built-ins can you use to navigate between forms invoked with the OPEN_FORM built-in? （）
    A

    CLOSE_FORM

    B

    NEXT_FORM

    C

    GO_FORM

    D

    PREVIOUS_FORM


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

相关内容