A ________ is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence...
A ________ is procedural SQL code that is automatically invoked
by the RDBMS upon the occurrence of a given data manipulation
event.
a. stored procedure
b. stored function
c. index
d. trigger
Homework Answers
Answer: Option D: trigger
Explanation:
Trigger is a procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event.
Add Answer to:
A ________ is procedural SQL code that is automatically invoked
by the RDBMS upon the occurrence...
SQL Each of the following statements about triggers is true except for one. Which one is...
SQL
Each of the following statements about triggers is true except for one. Which one is it? a A trigger can't be directly called or invoked O b A trigger can't raise errors C. A trigger doesn't accept input or return output parameters. O d. The code of a trigger can execute in place of the statement to which it's assigned.
Which object is not a PL/SQL object? a. function b. trigger c. view d. procedure
Which object is not a PL/SQL object? a. function b. trigger c. view d. procedure
You're building a database that tracks inventory & sales at the company you work for. Every...
You're building a database that tracks inventory & sales at the company you work for. Every time a row is INSERTed into the OrderLines table, you need a process to be invoked that checks the inventory table to make sure the particular Product is in stock.if the product is out of stock, the Quantity on the row should be changed to 0 indicating there were non in stock for the Product. You have chosen not to put this logic into...
Array manipulation (a) Write Java code for a method exchange (int [] a, int i, int...
Array manipulation (a) Write Java code for a method exchange (int [] a, int i, int j) that exchanges the values stored at indices i and j in the array a. You do not need to worry about cases where either i or j is an invalid index. Give the best estimate you can for its time complexity (b) In an ordered array of n items, how can we determine whether or not an item belongs to the list using...
SQL QUERIES 1) Using the Product and PC relations, create both tables in your database and...
SQL QUERIES
1) Using the Product and PC relations, create both tables in
your database and insert all the data. Show the SQL statements to
create each table and show a representative SQL insert statement
for the data in each table (i.e. you do not need to show insert
statements for all the data).
– For the remaining questions, assume that your SQL is part of
a program function and the function provides the input needed for
your SQL query....
Match the proper SQL Functions with the description that best fits its purpose. 1. SELECT...
Match the proper SQL Functions with the description that best fits its purpose. 1. SELECT 2. INSERT 3. CREATE 4. ORDER BY 5. WHERE 6. DISTINCT ============================================================================== A. Allows users to look at portions of data through querying. B. Allows users to enter a new record (row) into a table. C. Allows users to build a new object in a database (IE A database or table). D. Allows users to sort their query results upon a given column. E. ...
1.Buttons that can automatically be created using the type attribute are __________. A. submit B. reset...
1.Buttons that can automatically be created using the type attribute are __________. A. submit B. reset C. submit and reset D. All buttons require the type attribute. 2. Which of the following are ways to submit form data? A. email B. to a server C. to a JavaScript program D. All of these are ways to submit form data. 3. When using a set of radio buttons, which attribute must be the same for all buttons in the set? A....
Building Each Exercise Driver Download the drivers (ExerciseX.java) and start by reading the code. Notice in...
Building Each Exercise Driver Download the drivers (ExerciseX.java) and start by reading the code. Notice in Exercise1.java’s main how each method for the problems below have already been invoked for you (Skeleton Level: Strong). As you complete additional exercises, notice the comments in each file. As exercises progress, you’ll be required to uncomment lines in main or even build parts of the main driver yourself. We’ll start with skeleton files that are almost complete, and then look at drivers where...
Q2 Given the following emp_tbl: (CLOI) 6 Marks first name Ahmad last name Salah Ali Hassan salary 10,000 9,000 ,000 empID Amira 200 300 Saeed (i) Write a P/SQL procedure that: a. Declares two variabl...
Q2 Given the following emp_tbl: (CLOI) 6 Marks first name Ahmad last name Salah Ali Hassan salary 10,000 9,000 ,000 empID Amira 200 300 Saeed (i) Write a P/SQL procedure that: a. Declares two variables of type first_name and salary columns, respectively. b. Declares a cursor that includes the first_name and salary columns. c. Fetches the values in the cursor into the declared variables. d. Prints these values in the following form: First name Salary Ahmad 10,000 Amira 9,000 7,000...
1. a. Upon a risk analysis on a company's site network, some threats are identified. These include threats from malicious code (i.e. virus, worms and Trojan horse) and threats from denial of...
1. a. Upon a risk analysis on a company's site network, some threats are identified. These include threats from malicious code (i.e. virus, worms and Trojan horse) and threats from denial of service (DoS) attacks. To address these threats, an administrator in the company, Bob, has suggested using a firewall to control the access of the site network from the Internet. i. Contrast the three types of malicious code, virus, worms and Trojan horse. ii. There are three types of...
SQL
Each of the following statements about triggers is true except for one. Which one is it? a A trigger can't be directly called or invoked O b A trigger can't raise errors C. A trigger doesn't accept input or return output parameters. O d. The code of a trigger can execute in place of the statement to which it's assigned.
Array manipulation (a) Write Java code for a method exchange (int [] a, int i, int j) that exchanges the values stored at indices i and j in the array a. You do not need to worry about cases where either i or j is an invalid index. Give the best estimate you can for its time complexity (b) In an ordered array of n items, how can we determine whether or not an item belongs to the list using...
SQL QUERIES
1) Using the Product and PC relations, create both tables in
your database and insert all the data. Show the SQL statements to
create each table and show a representative SQL insert statement
for the data in each table (i.e. you do not need to show insert
statements for all the data).
– For the remaining questions, assume that your SQL is part of
a program function and the function provides the input needed for
your SQL query....
Q2 Given the following emp_tbl: (CLOI) 6 Marks first name Ahmad last name Salah Ali Hassan salary 10,000 9,000 ,000 empID Amira 200 300 Saeed (i) Write a P/SQL procedure that: a. Declares two variables of type first_name and salary columns, respectively. b. Declares a cursor that includes the first_name and salary columns. c. Fetches the values in the cursor into the declared variables. d. Prints these values in the following form: First name Salary Ahmad 10,000 Amira 9,000 7,000...
1. a. Upon a risk analysis on a company's site network, some threats are identified. These include threats from malicious code (i.e. virus, worms and Trojan horse) and threats from denial of service (DoS) attacks. To address these threats, an administrator in the company, Bob, has suggested using a firewall to control the access of the site network from the Internet. i. Contrast the three types of malicious code, virus, worms and Trojan horse. ii. There are three types of...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago