The following tables (Table 2 and Table 3) with the following values are stored in Oracle database. PROD CODE PROD_QOH 205 PART CODE PART_QOH АВС A 567 DEF 234 98 Table 2: PRODUCT 549 Table 3: PART (a) The following transaction in Figure 2 is executed: Transaction 1 UPDATE PRODUCT SET PROD_QOH = PROD_OQH+1 WHERE PROD_CODE='ABC'; UPDATE PART SET PART_QOH = PART_OQH - 1 WHERE PART_CODE= 'A'; UPDATE PART SET PART_QOH = PART_OQH - 1 WHERE PART_CODE= 'B'; UPDATE PART SET PART_QOH = PART_OQH - 1 WHERE PART_CODE= 'C'; Figure 2: A Transaction in Oracle Database (i) Assume transaction logs are recorded when Transaction 1 is executed. State the steps for the database recovery according to the logs if a ROLLBACK command was issued at the end of the transaction. State and explain ONE property of transactions that is observed with the rollback action in (i) of this question. (ii)

The following tables (Table 2 and Table 3) with the following values are stored in Oracle database. PROD CODE PROD_QOH 205 PART CODE PART_QOH АВС A 567 DEF 234 98 Table 2: PRODUCT 549 Table 3: PART (a) The following transaction in Figure 2 is executed: Transaction 1 UPDATE PRODUCT SET PROD_QOH = PROD_OQH+1 WHERE PROD_CODE='ABC'; UPDATE PART SET PART_QOH = PART_OQH - 1 WHERE PART_CODE= 'A'; UPDATE PART SET PART_QOH = PART_OQH - 1 WHERE PART_CODE= 'B'; UPDATE PART SET PART_QOH = PART_OQH - 1 WHERE PART_CODE= 'C'; Figure 2: A Transaction in Oracle Database (i) Assume transaction logs are recorded when Transaction 1 is executed. State the steps for the database recovery according to the logs if a ROLLBACK command was issued at the end of the transaction. State and explain ONE property of transactions that is observed with the rollback action in (i) of this question. (ii)

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

||| > 4G Students table Write a SQL statement to create the following tow tables: 23 STD_ID STD_NAME COURSE_NO LEV 21 15 33 12 11 Bandar Khalid Naif 102 Ims.kku.edu.sa Yasser Ziyad Courses table 101 231 271 Assignments 231 102 271 101 Mohammad 101 4 Data Science 4 3 6 COURSE NO COURSE_NAME COURSE_TEAC Programming Abdulaziz Computing Abdulaziz Database Mohammad 5 4 ۱۰:۲۲ - Query1: Display all Student names who already registered in a course. - Query2: Display students names and course names from both students and courses tables for only students whose level is higher than 4. Ĵ
Provide all the SQL statements that are required for the following transactions to be executed. Transaction 01: A residential customer (Bob Builder) of 53 Drip Drive, Dripwater (post code: 1267) has an account with the water company at the same address. The meter was installed on 30th October 2019 and has the serial number DDWC4763. This customer does not have any outstanding balance for the service at this address. Transaction 02: On 23rd July, 2020, the meter at 53 Drip Drive, Dripwater was read by Karen Karpenter (a meter reader). The reading the last time this meter was read was 123580 kL, at this reading it was 123683 kL. The bill was created and sent on the same day. Transaction 03: On 2nd August 2020, Bob Builder settled the account in full for consumption at 53 Drip Drive, Dripwater using PayPal.
The following database will be used in this question: SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles Balance 500 350 SalesRepNo 345 434 654 345 800 100
Integrate Python Database Connectors with SQLite3 For this assignment, I will like you to do the following. Create a database called employees. The table should contain first name, last name, age, date of hire, and salary of the employees. You should run various SQL statement using SQLite3. I am looking for the following. 1) Create table 2) Insert employee 3) Update employee 4) Delete employee 5) Delete table.
By skipping columns that don't fit certain requirements, a select operation may drastically shrink a table's footprint in a relational database.Could it be real or false?
Develop recurrence relations for the last 3 columns of table 1. Use the recurrence relation you developed to complete the table for these months: • Month 59 • Month 60 • Month 61 • Month119 • Month 120 • Month 121 Show your calculations and completed table.
write SQL statement to search for employees who is the manager of the department specified by the cboDept
List all products with their highest unit price, i.e. not discounted.the database is
Based on the following tables, write appropriate SQL statements to carry out the following tasks: CLIENT CLIENT_NAME LOCATION SAM LEE MELAKA LEE MEI TENG PENANG ΚΙΚΟ ΤΑΝ KL ADAM ALI KL EVA KUMAR MELAKA SALESPERSON SALES_NAME POSITION AREA JAMES ANG JUNIOR MELAKA MARCUS TEO SENIOR PENANG LILY TAY JUNIOR KL (a) Add the following record into the SALESPERSON table. SALES_NAME POSITION AREA JOYCE SENIOR MELAKA (b) Show how all junior salesperson can be removed from SALESPERSON. (c) Change Lily's position as she has been promoted from junior to senior level. (d) Retrieve all clients who are located in Melaka. Sort the result in ascending order by location. (e) Display the number of clients in each location. (f) Display those clients with the surname “Lee". (g) List the salesperson name and position for all senior salesperson from Penang. (h) List the salesperson and client names who are located in the same area.
Write the appropriate SQL DDL statements to declare the relational libraryDatabase. Diagram of Figure 4.6. Select the keys and reference actions that are triggered.
In Oracle database, if we have any field such as Job_Title field in any of our table then we can use DECODE function to sort the result based on our own numerical value. This can be done by including the following in ORDER BY clause: 1: ORDER BY DECODE(job-title,'Manager',3,Assistant',2,'Sales Rep', 1) DESC II: ORDER BY DECODE(job-title,'Manager', 3,'Assistant',2, Sales Rep', 1) ASC III I and II are correct IV I and II are incorrect ||| IV || 1
4. In the OrderItems table, display a count of the number of products, grouped by prod_id, but only for those groups having 3 or more of a given prod_id. Display the count with the alias shown. Sort by prod_id in ascending order. BNBG01 BNBG02 BNBG03 BR03 4 rows returned in 0.00 seconds PROD_ID Download 3 3 3 4 NUM_PROD_ID