Exam Study Guide
Saturday, September 10, 2016
Oracle 11g SQL Exam 02
The majority of operations performed on
JustLee Books has become the exclusive distributor for a number of books. The company now needs to
assign sales representatives to retail bookstores to handle the new distribution duties. For these
assignments, create new tables to su
Chapter 1 Hands-On Assignments
To perform assignments 1 to 5, refer to the table structures in Figure 1-5 and the table listings in
1. Which tables and fields would you access to determine which book titles have be
Chapter 3 Hands-On Assignments
1. Create a new table containing the category code and description for the categories of
books sold by JustLee Books. The table should be called CATEGORY, and the columns
should be CatCode and CatDesc. The CatCode column sho
Chapter 5 Hands-On Assignments
To perform the following assignments, refer to the tables created in the JLDB_Build_5.sql script at the
beginning of the chapter.
1. Add a new row in the ORDERS table with the following data: Ord
Chapter 2 Hands-On Assignments
1. Display a list of all data contained in the BOOKS table.
2. List the title only of all books available in inventory, using the BOOKS table.
3. List the title and publication date for each book