Databases | SQL | Oracle | MS Access Answers

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.

Management of the events have decided to allow a 10% discount on all events that cost over R 250. Create a PL/SQL query to display the event name and price, with or without the applied discount. 

Sample Results Open Air Comedy Festival price: R 270 ------------------------------------------------------- Mountain Side Music Festival price: R 252 ------------------------------------------------------- Beach Music Festival price: R 195 -------------------------------------------------------

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.

2)Identify and briefly explain the five features of PL/SQL that allow the developer to write effective code to manipulate a database.

Write a program to multiply every element of the linked list with 10

Write a program to print the total number of occurrences of a given item in the linked list

WORLD CUP DATA ANALYSIS

1 What player on a team with "ia" in the team name played less than 200 minutes and made more than 100 passes? Print the player surname.

2 How many players on a team with ranking <10 played more than 350 minutes?

TITANIC DATA ANALYSIS

1 Write a loop that asks the user to enter an age, then returns the number of married women over that age who embarked in Cherbourg. Terminate the loop when the user enters a number that is less than 0.

State and explain the challenges to data mining regarding data mining methodology and user interaction issues.

Critically discuss and illustrate using a diagram the steps involved in data mining when viewed as a process of knowledge discovery.

Write a PL/SQL program to check whether a date falls on weekend i.e. SATURDAY or SUNDAY.