Answered: write a trigger that will be activated…

write a trigger that will be activated after a DELETE activity. The trigger will INSERT all deleted data to a backup table having same attributes as original table

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter5: Data Manipulation And Transaction Control

Section: Chapter Questions

Problem 1RQ: Which command should you use to copy data from one table and have it added to an existing table?

See similar textbooks

Related questions

Q: can tell how the restriction on ‘cSalary’ is violated. Whenever the value of ‘cSalary’ is beyond the…

A: Given : Create table Cleaner(cNo varchar2(5), cName varchar2(20), cSalary number(6,2), dNo…

Q: What happens to the data displayed by a view when the view is deleted?

A: Nothing will happen to the data displayed by a view, if the view is deleted.

Q: If you wanted to update another table with new records for every row updated, deleted, or inserted…

A: Introduction: In a database management system, a trigger is a set of instructions that the system…

Q: The Developers team also wants you to ensure that emails are converted to lowercase after an update…

A: A collected information or structured data in the form of table that are stored electronically which…

Q: Write a trigger that whenever a record is inserted into the Salary_List table it will print out the…

A: syntax for trigger to print when an value is inserted CREATE TRIGGER <Trigger Name>ON…

Q: Write a stored procedure that accepts two parameters: A starting date The number of the consecutive…

A: The required stored procedure statement is given in the next step.

Q: A create view statement creates a new table with its on data using the view select query. True False

A: A view is the data set of a data storage query that database clients can query much like a constant…

Q: 2. Create a trigger that will maintain the correct value in the membership balance in the MEMBERSHIP…

A: the code is given below :

Q: Design two stored procedures as the following (4 marks) Create a PARAMETER based SELECT QUERY stored…

A: Q: Write query based on given values Note: Please ensure to update correct field names as they are…

Q: CREATE TABLE keyvalue ( id SERIAL, key VARCHAR(128) UNIQUE, value VARCHAR(128) UNIQUE,…

A: The required stored procedure is given below CREATE PROCEDURE dbo.keyValue AS BEGIN UPDATE…

Q: triggers. Triggers should be meaningful.

A: According to the question we need to write the 5 Triggers:

Q: 9. Write a trigger that prohibits duplicate values except for nulls in the NoDupName column of the…

A: Note: As triggers are not supported by online compilers, you can test them yourself. Given table:…

Q: Error Functions What type of error occurs with a VLOOKUP) function when there is no corresponding…

A: The objective of the question is to identify the type of error that occurs when a VLOOKUP function…

Q: What happens if a user attempts to add data to a table, and the addition would cause the record to…

A: NOTE: -The explanation is done as per the Oracle database. If any attempt is being made to add data…

Q: 1. Create a package named EMP_PS which has a function named findEmpByID which takes employee number…

A: Given: Create a package named EMP_PS which has a function named findEmpByID which takes employee…

Q: Write a SELECT statement that returns all rows with salary, last name, street address and ZIP code…

A: Command:- CREATE TABLE EMPLOYEE(Employee_Id integer PRIMARY KEY, Last_Name text, Salary integer);…

Q: If you add a record to the wrong table, what’s the simplest way to remove the record from the table?

A: To solve this question let us first take an example of the following database and analyze it to…

Q: write Command to insert data into this tables create table patients ( patient_id VARCHAR(255),…

A: Hi Student Warm Welcome from my side. Hope you are doing great. Here's your required answer.

Q: Create a trigger for the Invoices table that automatically inserts the vendor name and address for a…

A: Trigger When an event occurs, the trigger runs automatically which is a stored procedure. The…

Q: What is the difference between the delete and drop table commands?

Q: The Car Maintenance team also wants to store the actual maintenance operations in the database. The…

A: SQL CODE FOR TABLE CREATION OF TABLE MAINTENANCES:- CREATE TABLE MAINTENANCES( CAR_ID CHAR(5),…

Q: I am stuck on a question. Please assist with writing this code: Create a trigger for the EMPLOYEES…

A: Answer in step 2

Q: Task 5: The Developers team also wants you to ensure that emails are converted to lowercase after an…

A: Given Data : Table named: USERS The attributes of the table are : USER_ID USER_FIRST_NAME…

Q: What happens to the data that was shown when a view is removed?

A: Given: What happens to the data that was shown when a view is removed?

Q: Create a trigger that will insert new emp_no, salary, from_date and to_date into salaries table…

A: Please upvote me please. I need it badly. Answer 1) CREATE TRIGGER update_salary_tableAFTER INSERT…

Q: Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the…

A: The following answer is solved using SQL query

Q: What are the INSERT TRIGGER, DELETE TRIGGER and UPDATE TRIGGER. Explain with examples.

A: We have to explain INSERT TRIGGER, DELETE TRIGGER and UPDATE TRIGGER

Q: What is the most efficient way to write a trigger that updates a large number of rows? Specify…

A: Explanation: Once “for each row” clause is specified, then the trigger fires once for all rows of…

Q: The Car Maintenance team also wants to store the actual maintenance operations in the database. The…

A: According to the Question below the Solution:

Q: The Developers team also wants you to ensure that emails are converted to lowercase after an update…

A: We need to create a TRIGGER function which will update the USER_EMAIL to upper case. Hence the…

Q: Create Trigger for When a student marks are being inserted, if the marks that are inserted are…

A: Here, we are supposed to write the syntax for creation of trigger and we are checking if the values…

Q: which key is used Link records of one type with those of another type.

A: Given: which key is used Link records of one type with those of another type.

Concept explainers

Procedures in SQL

A pre-compiled stored procedure is a logical unit made up of one/more SQL statements (SQL stands for Structured Query Language). The database server saves it as an object. An SQL procedure is a collection of SQL statements and logic that is written and saved to accomplish a specified goal. An SQL procedure consists of a name, a parameter list, and a set of Transact-SQL statements. Stored procedures are stored as named objects in SQL Database Server.

Question

write a trigger that will be activated after a DELETE activity. The trigger will INSERT all deleted data to a backup table having same attributes as original table

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Solution

VIEW

Explanation

VIEW

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

If you wanted to update another table with new records for every row updated, deleted, or inserted entered into a given table, you'd include the keywords in your trigger creation statement.
Views in SQL are kind of virtual tables. A view also has rows and columns as they are in a real table in the database. We can create a view by selecting fields from one or more tables present in the database. A View can either have all the rows of a table or specific rows based on certain conditions. Under what circumstances would you create a View?
What is the difference between the delete and drop table commands?
Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENACNE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys. Answer in MYSQL please
A social media application stored information about each registered user in the table create table user (id int primary key auto_increment, name varchar(100) not null) A user can have many "friends" and can also be a "friend" to many other users. Specify how this relationship would be implemented by coding the create table statement(s) for the tables.
The Driver Relationship team realized that maintaining driver IDs is difficult and requested an automatic way of incrementing the value when a new driver is added. You need to make the changes on the table to automatically increment the DRIVER_ID. After the change, you need to insert the following driver: First Name: Nursin Last Name: Yilmaz Driving License ID: 4141447 Start Date: 2021-12-28 Driving License Checked: True Rating: 4.0
What are the INSERT TRIGGER, DELETE TRIGGER and UPDATE TRIGGER. Explain with examples.
Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the database. The team wants to start with a table to store CAR_ID (CHAR(5)), MAINTENANCE_TYPE_ID (CHAR(5)) and MAINTENANCE_DUE (DATE) date for the operation. Create a new table named MAINTENANCES. The PRIMARY_KEY should be the combination of the three fields. The CAR_ID and MAINTENANCE_TYPE_ID should be foreign keys to their original tables. Cascade update and cascade delete the foreign keys. Create a new table to store maintenance operations Test Query DESCRIBE MAINTENANCES Expected Results Field Type Null Key Default Extra CAR_ID char(5) NO PRI NULL MAINTENANCE_TYPE_ID char(5) NO PRI NULL MAINTENANCE_DUE date NO PRI NULL
Error Functions What type of error occurs with a VLOOKUP) function when there is no corresponding match between a source table and a lookup table? OPTIONS: No matching values #N/A Error #DIV/0
Create an MVC web application having the index view given below. Given view will be populated from the model book having data members (Id, Title). Write only the code for the model class with the action Submitlmg() to submit the data in database table book(id, title). Use suitable data annotations attributes to perform empty field validation also. No need to write view code. Book Form Book Id Book Title Save
write Command to insert data into this tables create table patients ( patient_id VARCHAR(255),`name` VARCHAR(255),`insurance` DECIMAL(15,2),`date_admitted` DATE,`date_checked_out` DATE,PRIMARY KEY(`patient_id`)); create table doctor (doctor_id VARCHAR(255),name VARCHAR(255),specialization VARCHAR(255),PRIMARY KEY (doctor_id) ); create table `test` (`test_id` VARCHAR(255),`test_name` VARCHAR(255),`test_date` DATE,`test_time` TIME,`result` VARCHAR(255),PRIMARY KEY(`test_id`)); create table doctor_patient( patient_id VARCHAR(255), doctor_id VARCHAR(255),PRIMARY KEY(`patient_id`),FOREIGN KEY(`doctor_id`) REFERENCES doctor(`doctor_id`) ); create table test_log (`test_log_id` varchar(255),`patient_id` VARCHAR(255),`test_id` VARCHAR(255),`doctor_id` VARCHAR(255),`comments` VARCHAR(255),PRIMARY KEY(`test_log_id`),FOREIGN KEY(`test_id`) REFERENCES `test`(`test_id`),FOREIGN KEY(`patient_id`) REFERENCES doctor_patient(`patient_id`),FOREIGN KEY(`doctor_id`) REFERENCES doctor(`doctor_id`));
Create a set of lookup tables.