1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
sammy [17]
3 years ago
15

Four actions that can be implemented on a database to autocorrect violations of referential integrity, and the outcomes of the a

ctions are listed below. Match the violation with the corrective action Instructions: Choose your responses from the drop-down menus below. Response options cannot be used more than once.
a. Sets invalid foreign keys to a default primary key value, specified in SQL
b. Propagates primary key changes to foreign keys
c. Rejects an insert, update, or delete
d. Sets invalid foreign keys to NULL
1. Restrict
2. Set Null
3. Set Default
4. Cascade
Computers and Technology
1 answer:
Paraphin [41]3 years ago
6 0

Answer:

Follows are the matching to this question:

Option \ a \to \ Option \ 3\\\\Option \ b \to \ Option \ 4\\\\Option \ c \to \ Option \ 1\\\\Option \ d \to \ Option \ 2\\

Explanation:

While time-consuming or prone to errors mechanical adjustments to both the referential, databases could be configured with four measures to engine violations. The restricted action causes the insert, update, and removes to only be denied. Set Null to NULL sets the invalid external key, whereas Set Default to a specific core consideration specified in SQL sets a default foreign key. Its Cascade operation spreads the main changes in external keys.

You might be interested in
5 disadvantage of assembly<br> level language​
Sauron [17]

Disadvantages Of Assembly Language

  1. Long programs written in such languages cannot be executed on small sized computers.
  2. It takes lot of time to code or write the program, as it is more complex in nature.
  3. Difficult to remember the syntax.
  4. Lack of portability of program between computers of different makes.
  5. No SDKs (System Development Kit).

6 0
3 years ago
Why do nonprofit agencies include blogs on there website?
Katarina [22]
It might be non profit, but they are still getting views and paid for doing what they need to. It's simply called advertising.
3 0
4 years ago
In this lab, you declare and initialize variables in a Java program. The program file named NewAge.java, calculates your age in
Romashka-Z-Leto [24]

Answer:

import java.util.Calendar;

import java.util.Date;

import java.util.Scanner;

public class Main {

   public static void main(String[] args) {

       System.out.print("Insert Date of Birth: ");

       String[] dateofbirth = new String[3];

       Scanner s1 = new Scanner(System.in);

       int a=0;

       while (a<=2) {

           dateofbirth[a] = s1.next();

           a++;

       }

       System.out.print("Insert future date: ");

       String[] futuredate = new String[3];

       Scanner t1 = new Scanner(System.in);

       a=0;

       while (a<=2) {

           futuredate[a] = t1.next();

           a++;

       }

       Calendar cal1 = Calendar.getInstance();

       cal1.set(Calendar.DAY_OF_MONTH, Integer.parseInt(dateofbirth[0]));

       cal1.set(Calendar.MONTH, Integer.parseInt(dateofbirth[1]));

       cal1.set(Calendar.YEAR, Integer.parseInt(dateofbirth[2]));

       Date first_Date = cal1.getTime();

       cal1.set(Calendar.DAY_OF_MONTH, Integer.parseInt(futuredate[0]));

       cal1.set(Calendar.MONTH, Integer.parseInt(futuredate[1]));

       cal1.set(Calendar.YEAR, Integer.parseInt(futuredate[2]));

       Date second_Date = cal1.getTime();

       long diff = second_Date.getTime() - first_Date.getTime();

       System.out.println ("Age in Days: " + diff / 1000 / 60 / 60 / 24/365);

   }

}

Explanation:

Please check the answer section. In this program we have created two strings, and inpit two dates through them. And then we parse the string items, and store the days, months and years in the calander instance, and we create two such instance. And finally, we find the differene and print the age in days.

3 0
3 years ago
A certain social media Web site allows users to post messages and to comment on other messages that have been posted. When a use
garri49 [273]

Answer:

A or S most likely (I think)

7 0
3 years ago
My friend has a battery of 9000mah and loses 10 every day how many days well it take to go to zero
forsale [732]
I think it's 900 but I can't be sure.
8 0
3 years ago
Other questions:
  • Poems Roses are red,
    15·1 answer
  • Word processing programs have different view options that you can use depending on the tasks you’re performing. Which option hel
    11·1 answer
  • In many cases, a subquery can be restated as a/an ______________.
    13·1 answer
  • 14. What is the simplest way to permanently get rid of an unwanted file?
    9·1 answer
  • To create bold shadows, which lighting choice would work best.
    7·1 answer
  • A network resource is masquerading as a network server and is causing hosts on the network to send requests to the attacker rath
    11·1 answer
  • What is a secondary storage medium that uses magnetic techniques to store and retrieve data on disks or tapes coated with magnet
    6·1 answer
  • How does porter’s competitive forces model help companies develop competitive strategies using information systems?
    13·1 answer
  • What report provides data on how specific sections of a website performed?
    6·1 answer
  • Complete the code to create a new file.
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!