Question

In SQL, Integrity Control on DELETE CASCADE means: a) To make users unable to delete a...

In SQL, Integrity Control on DELETE CASCADE means:

a) To make users unable to delete a parent row if there are matching dependent rows

b) When a parent row is deleted, all dependent rows will be deleted

c) When a parent row is deleted, set the foreign key value to null in all the dependent rows

d) All of the above

Engineering   Computer-Science   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Answer:option b

When a parent row is deleted ,all dependent rows will be deleted

This is correct beacuse in the SQL, integrity control on the delete cascade makes us to delete the child rows deleted which are dependent on the parents rows ,when parent rows are deleted.

So this is the correct option

And rest of the options are wrong because

It can delete the parents rows ,if there are matching dependent rows also

And when parent row is deleted it doesn't set foriegn key to null in the dependent rows,it just deletes the dependent rows

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A Guide to SQL Questions 1. How do you create a table using SQL? 2. How...
A Guide to SQL Questions 1. How do you create a table using SQL? 2. How do you delete a table using SQL? 3. What are the common data types used to define columns using SQL? 4. Identify the best data type to use to store the following data in Oracle, in SQL Server, and in Access:    a. The month, day, and year that an employee was hired    b. An employee’s Social Security number    c. The department...
/* myCompany.SQL Introduction to SQL Script file for ORACLE DBMS This script file creates the following...
/* myCompany.SQL Introduction to SQL Script file for ORACLE DBMS This script file creates the following tables: VENDOR, PRODUCT, CUSTOMER, INVOICE, LINE EMPLOYEE and loads the default data rows */ set echo on; set serveroutput on; select systimestamp from dual; show user; ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY'; DROP TABLE LINE CASCADE CONSTRAINTS; DROP TABLE INVOICE CASCADE CONSTRAINTS; DROP TABLE CUSTOMER CASCADE CONSTRAINTS; DROP TABLE PRODUCT CASCADE CONSTRAINTS; DROP TABLE VENDOR CASCADE CONSTRAINTS; DROP TABLE EMPLOYEE CASCADE CONSTRAINTS; CREATE TABLE...
/* myCompany.SQL Introduction to SQL Script file for ORACLE DBMS This script file creates the following...
/* myCompany.SQL Introduction to SQL Script file for ORACLE DBMS This script file creates the following tables: VENDOR, PRODUCT, CUSTOMER, INVOICE, LINE EMPLOYEE and loads the default data rows */ set echo on; set serveroutput on; select systimestamp from dual; show user; ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY'; DROP TABLE LINE CASCADE CONSTRAINTS; DROP TABLE INVOICE CASCADE CONSTRAINTS; DROP TABLE CUSTOMER CASCADE CONSTRAINTS; DROP TABLE PRODUCT CASCADE CONSTRAINTS; DROP TABLE VENDOR CASCADE CONSTRAINTS; DROP TABLE EMPLOYEE CASCADE CONSTRAINTS; CREATE TABLE...
1. When conducting a t test for differences between means, increasing sample size impacts the a....
1. When conducting a t test for differences between means, increasing sample size impacts the a. standard deviation of the sampling distribution b. degrees of freedom c. t score d. all of the above 2. In terms of finding importance vs. statistics a. researchers can analyze importance as well as significance b. there is no difference between importance and significance c. the distinction is entirely dependent upon data d. researchers cannot formally assess importance 3. When finding significance involving two...
Practice using EXCEL – Part of your Orientation Assignment to prepare for class on the first...
Practice using EXCEL – Part of your Orientation Assignment to prepare for class on the first day. Step by Step instructions on completing PR1-5B. BEFORE STARTING TO WORK THE PROBLEM YOU NEED TO WRITE ALL BALANCE FORMULAS. To do so do the following in order. Click on Cell D39. In D39 you will write a formula to add rows D37 and D38. To do so do the following: a)    Start in Cell D39 and press = sign b)    Highlight cell...
6. Tinder is a dating app that allows users to meet potential romantic partners based on...
6. Tinder is a dating app that allows users to meet potential romantic partners based on geographical proximity. To use Tinder, an individual merely swipes to the right to “like” a potential partner or swipes to the left to “pass” on a potential partner. If two users both like each other, it’s considered a “match,” and they are then able to chat through the app. It’s been claimed that 90% of Tinder users meet their matches within one week, but...
Summary The Ch08_ConstructCo database stores data for a consulting company that tracks all charges to projects....
Summary The Ch08_ConstructCo database stores data for a consulting company that tracks all charges to projects. The charges are based on the hours each employee works on each project. The structure and contents of the Ch08_ConstructCo database are shown in Figure P8.1. Use this database to answer the following problems. Database Schema The schema for the Ch08_ConstructCo database is shown below and should be used to answer the next several problems. Click this image to view it in its own...
T F 1. A p-value of .008 in hypothesis testing means there is only a .8%...
T F 1. A p-value of .008 in hypothesis testing means there is only a .8% chance we could get such sample statistics from the population if the null hypothesis is as stated. Such an event is considered unlikely and we would reject the null hypothesis. T F 2. As a general rule in hypothesis testing, it is always safer to set up your alternate hypothesis with a greater-than or less-than orientation. _____3. If the level of significance is .02...
1.The sample mean is an unbiased estimator for the population mean. This means: The sample mean...
1.The sample mean is an unbiased estimator for the population mean. This means: The sample mean always equals the population mean. The average sample mean, over all possible samples, equals the population mean. The sample mean will only vary a little from the population mean. The sample mean has a normal distribution. 2.Which of the following statements is CORRECTabout the sampling distribution of the sample mean: The standard error of the sample mean will decrease as the sample size increases....
1) What are some indicators that there are assignable causes for variation in a process? I.Process...
1) What are some indicators that there are assignable causes for variation in a process? I.Process capability. II. Data patters outside of the control limits. III. Data patters within the control limits. IV. Points randomly falling above and below the control chart center line. a. II and III b. II, III, IV c. I, II, IV d. I, II, III, IV 2) The best quantitative tool to determine the cause for variation in a process is: a. ANOVA b. Correllation...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT