Mike is a database administrator who has recently joined an online car rental company who captured and
Question:
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.
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi