Mike is a database administrator who has recently joined an online car rental company who captured and stored data in Microsoft Excel spreadsheets. He is tasked with creating a database and migrating all the data into a relational database management system. Mike wants to implement an Oracle database, but is unsure of the Oracle 11g edition to use. Explain to Mike the various program categories that will enable him to operate a database in Oracle. Discuss at least three of these program categories.

2.The Database Administrator (DBA) plays the most important and critical role in database

management.

List seven critical tasks performed by the DBA specifically to a database.

2.1. PL/ SQL blocks enable a database developer to solve a specific problem. Describe in

your own words, the two types of PL/ SQL blocks.

2.2. Briefly explain how subprograms can help PL/SQL language.

2.3. Briefly explain why you think it is important to separate error-handling routine from

the rest of the program.

2.4.The IF Statement is the most commonly used control-flow statement. Discuss any

two of the three forms of IF Statements supported by Oracle. Demonstrate your

understanding by giving examples.

 

Q.4.1 Given the following view, named Style View, explain in your own words what the view does. CREATE or REPLACE VIEW Style_View as select c.cust_fname ||' '|| c.cust_sname CUSTOMER, h.style_id, pr.product_price, i.inv_amt from CUSTOMER C, HAIRSTYLE h, PRODUCTS pr, INVOICE i where c.cust_id=i.cust_id and h.style_id=i.style_id and pr.product_id = i.product_id; select * from Style_View; (10)