Users will be able to insert update delete and query

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: table. A sequence called Orders_Seq has been created for order ID numbers. You are designing a form that performs transactions on the ORDERS table. Users will be able to insert, update, delete, and query records using this form. Gaps in order ID numbers in the ORDERS table should be kept to a minimum. After the order ID number is assigned to a newly created record, it should be displayed in the form without requerying the data. What is the best way to use the Orders_Seq sequence to assign order ID numbers so that these requirements are met? A. Set the Initial Value for the Orders.Order_Id item to: SEQUENCE.ORDERS_SEQ.NEXTVAL. B. Put the following code into a Pre-Inserted trigger: :Orders.Order:Id : = : SEQUENCE.ORDERS_SEQ_NEXTVAL; C. Put the following code into a Pre-Inserted trigger: SELECT orders_seq.NEXTVAL INTO :Orders.Order_Id FROM sys.dual, D. Put the following code into a When-Create-Record trigger: :Orders.Order:Id : = : SEQUENCE.ORDERS_SEQ_NEXTVAL; E. Put the following code into a When-Create-Record trigger: SELECT orders_seq.NEXTVAL INTO :Orders.Order_Id FROM sys.dual, Answer: C QUESTION 142: You have been asked to define a data block based on a JOIN of multiple tables. The read-only data will be used for calculations and lookups. The DBA is on holiday and is unable to define a view on the database server. What is the simplest way for you to continue to build the form? A. Define a data block based on a Ref Cursor. B. Define a data block based on a Table of Records. C. Define a data block based in a From Clause query. D. Define a data block based on a combination of Ref Cursor and a Table of Records. E. Define a data block based on a Ref Cursor and define Transactional triggers for controlling DML statements. Actualtests.com - The Power of Knowing 1Z0-141 Answer: C QUESTION 143: You have been asked to correct a problem with a form that was created by another developer. Users complain that they are unable to query on the employee Hire Date, which is a base table it...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online