THEORY: QUESTION 1
Explain to Top Management the various program categories that will enable you to operate a database in Oracle. Discuss at least three of these program categories.
THEORY: Question 2 (Marks: 10)
Identify and briefly explain the five features of PL/SQL that allow the developer to write effective code to manipulate a database.
Implement the below function to print the count of numeric characters (0-9) in a given string and also print the count of remaining characters. (Ignore the character cases, it can be lower or upper case)
The function will take 1 parameter which will be a String (or a character array). You do not have to write code to get the input parameter from the user.
int frequencyOfNumericChars(String input) {
// TODO: Add code here
}
Example:
Input: raja1123labs Output:=’1’=2, ‘2’=1, ‘3’=1, others=8
Input: Buffet101 Output: ‘1’=2, ‘0’=1, others=6
Write a function that takes an input parameter as a String. The function should replace the alternate words in it with “xyz” and print it. Words are separated by dots. (Avoid using inbuilt functions)
If input is “i.like.this.program.very.much”
Output will be “i.xyz.this.xyz.very.xyz
: India is a country with moderate weather. So, people here measure temperature in Celsius scale. America is country with cold weather. So, people there measure temperature in Fahrenheit scale. Some students of LPU are going for an international exposure visit to America. Since it is the first time for them, they find it very difficult to follow their temperature readings. Write a program to help them understand the American temperature readings easier, based on their Indian way of understanding. [10]
2.1) What are the two ways to pass arguments to a function? (2) 2.2. Write a PHP script for an array containing 5 elements (Lerato, Thabo, Mbali, Sipho, Buhle) and prints out the following : (4) 2.3. Given the PHP script in 2.2. Print out one element at a time. (2) 2.4. Write a PHP script that checks which category a student belongs to based on the average mark of test 1 and test 2. If the student’s average is greater than 50, it should print out pass and if the student’s average is less than 50, it should print out fail. (5) 2.5. Given the PHP code below. Write a PHP code that will do the following: 2.5.1. Write the HTML code that will display the form. (5) 2.5.2. The form should take input from the user using POST method and display the values in the browser.
1.In solving the given problem above, implement the algorithm you have written in
Activity Sheet 01 using Java as the programming language.
2. In writing your program, create methods to implement the operations identified
in the previous activity. Also, add a constructor that will display a greeting to the
user of the system.
Continuation of this:
https://www.assignmentexpert.com/homework-answers/programming-and-computer-science/algorithms/question-246742
Continuation of this:
https://www.assignmentexpert.com/homework-answers/programming-and-computer-science/algorithms/question-246742
1.In solving the given problem above, implement the algorithm you have written in
Activity Sheet 01 using Java as the programming language.
2.In writing your program, create methods to implement the operations identified
in the previous activity. Also, add a constructor that will display a greeting to the
user of the system.
Write a Java program that displays at least four (4) lines of your favorite song