Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

Multiple choice technology programming languages

You want to create a PL/SQL block of code that calculates discounts on customer orders. This code will be invoked from several places, but only within the program unit ORDERTOTAL. What is the most appropriate location to store the code that calculates the discounts?

  1. a) A stored procedure on the server

  2. b) A block of code in a PL/SQL library.

  3. e) A local subprogram defined within the program unit ORDERTOTAL

  4. d) A block of code in the body of the program unit ORDERTOTAL
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation
Multiple choice technology

Which of the following statement is/are incorrect? 1) With a normal join, the Integration Service discards all rows of data from the master and detail source that do not match, based on the condition. 2) A master outer join keeps all rows of data from the master source and the matching rows from the detail source. It discards the unmatched rows from the detail source. 3) A detail outer join keeps all rows of data from the detail source and the matching rows from the master source. It discards the unmatched rows from the master source. 4)A full outer join discards all rows of data from both the master and detail sources.

  1. Only 1 is incorrect

  2. All are correct

  3. Except 1, all are incorrect

  4. Only 2 and 3 are incorrect
Reveal answer Fill a bubble to check yourself
C Correct answer