Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

JDA SQL PLSQL Interview Questions
Questions Answers Views Company eMail

What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?

2 13097

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 5477

What is difference between select statement and cursor

3 16071

Post New JDA SQL PLSQL Interview Questions






Un-Answered Questions

What are the different types of parts used in xsl?

89


What does an ami include?

1


For which purpose Redshift is used for ?

1


Is reverse saturation current of a diode is independent of reverse bias voltage?

129


How do you capture an element loading after the page load?

104






As a system administrator can you make backup and recovery of data ?

84


Explain the different ways of initiating transaction in cics?

81


A solar collection has been installed to heat water. A large water tank has a volume of 5.0 x 105 cm3. The area of the solar collectors is 8m2. (2 meters by 3 meters). If the water in the tank starts out with a temperature of 30°C in the morning, what is its temperature in the evening after the sun has set?

1068


what is mean by Ratio analysis in the orgnations?

1437


What is the use of systime function?

650


develop a breakfast order booking system using Functions, Structures and Arrays. The system is to support the operations shown to the user in the following system’s menu: Welcome to Asim's Restaurant Select an operation? 1 Make a breakfast order 2 Modify existing order 3 Cancel existing order 4 Print Bill 5 Exit Type in your selection (1, 2, 3, 4 or 5): The program will include an array of structures. The structure type is called MenuItem, and the array of structures should be declared as menu[50] to store upto 50 breakfast menu items. The MenuItem structure must have the following 4 data fields (i.e. members): Code, description, unitprice, and quantity. Your program must define at least the following functions:  Function LoadData(…) that loads the data of breakfast menu items from an input file menu.txt into the array menu.  Five separate functions to handle the program main menu five tasks shown above. In general, function main() should load the data into the array menu and display the main menu of the above mentioned tasks. Based on the option selected, the corresponding function should be called. Users must make an order before requesting modify, cancel or print order bill (See the given sample run). Here is a more detailed explanation on the above tasks and functions. LoadData(…) Opens the input file menu.txt (you will create it) containing breakfast menu items data (See below) and assign these values to the corresponding array menu structure fields. Assign zero to the quantity field of the loaded menu items. Welcome to Asim's Restaurant Select an operation? 1 Make a breakfast order 2 Modify existing order 3 Cancel existing order 4 Print Bill 5 Exit Type in your selection (1, 2, 3, 4 or 5): MakeOrder(…) This function is called when the user selects option 1 from the main menu. It first displays the breakfast menu items to the user (stored in the array menu) along with all the necessary information (item code, description and unit price). It then requests the user to select an item using the item code (see the sample run). When the user enters an item code number the program should verify the code number and increment the quantity of the selected item in the array menu. Your program should reject invalid item codes and request the user to re-enter the item code or stop the entry. PrintBill(…) This function is called when the user selects option 4 from the main menu. The function displays the breakfast menu items in the breakfast order by printing the values of all MenuItem members of the array menu that have quantity value above zero. Print a nicely formatted bill (See the sample run). CancelOrder(…) This function is called when the user selects option 3 from the main menu. It will cancel the breakfast order by setting the quantity value of all the array menu structures to zero. ModifyOrder(….) This function is called when the user selects option 2 from the main menu. The task of this function is to allow the user to edit an existing breakfast order with two operations: Adding more breakfast items and/or altering the breakfast item that were ordered before (examine the sample program run). Handling Errors and Invalid Input Your program should reply safely to any erroneous situation or input with appropriate message to the user and flow nicely and correctly to the next operation (Examine the sample program run). Additional functions Use of functions is highly recommended for any additional special tasks needed by your solution. Global variables are not allowed except for max array menu size 50. You must pass the needed parameters through functions parameter lists.

1408


which is the latest version of dos? & what is the command to copy windows files (i386) without formatting OS?

1099


How to calculation of residual solvent methanol (3000 ppm) standard solution, and how many quantity used of test sample

1566


What are stateful and stateless microservices for Service Fabric?

1


sap question.. i want to call a text module through the program which i have created with the help of so10 . how can i do this.

1582