The option for referential integrity between the Owner table and the Pet table is restrict and an attempt is made to update the row for owner 005 (OwnerNum = 005) in the Owner table to become 500 (OwnerNum = 500). What is the result? (Use only the data in the question. Do not assume other data exists if it is not present in the tables below.) The primary keys are underlined. These are the OwnerNum column in the Owner table and the PetNumber in the Pet table. The foreign key is italicized. This is the OwnerNum column in the Pet table. Owner Table OwnerNum LastName FirstName Address City State Zip 005 Smith Jim 100 Main Dune FL 37465 009 Jones Jane 3245 West Sanford FL 32773 012 Johnson Frank 2 Century Easton FL 37256 020 Doe Sally 101 Basel Orange FL 30998 Pet Table PetNumber PetName DOB Species OwnerNum 100 Fido 1/1/2005 Canine 009 200 Ajax 12/3/2003 Canine 020 300 Sunshine 6./12/2004 Feline 009 400 King 8/15/2007 Canine 009 500 Rex 3/23/2008 Equine 012 600 Slimy 9/21/2005 Reptile 012 700 June Bug 10/9/2001 Equine 009 800 Frisky 12/31/2002 Feline 020 Group of answer choices That row (OwnerNum = 005) will not be updated in the Owner table but the related row(s) in the Pet table will be updated to have a OwnerNum of 500. That row (OwnerNum = 005) in the Owner table will be updated to have a OwnerNum of 500 and so will the related row(s) in the Pet table that refer to it Nothing will be updated in the Owner table and nothing will be updated in the Pet table. Just that row (OwnerNum = 005) in the Owner table will be updated. Its OwnerNum will change from 005 to 500. There are no related rows in the Pet table.
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
The option for referential integrity between the Owner table and the Pet table is restrict and an attempt is made to update the row for owner 005 (OwnerNum = 005) in the Owner table to become 500 (OwnerNum = 500). What is the result? (Use only the data in the question. Do not assume other data exists if it is not present in the tables below.) The primary keys are underlined. These are the OwnerNum column in the Owner table and the PetNumber in the Pet table. The foreign key is italicized. This is the OwnerNum column in the Pet table.
Owner TableOwnerNum | LastName | FirstName | Address | City | State | Zip |
---|---|---|---|---|---|---|
005 |
Smith |
Jim |
100 Main |
Dune |
FL |
37465 |
009 |
Jones |
Jane |
3245 West |
Sanford |
FL |
32773 |
012 |
Johnson |
Frank |
2 Century |
Easton |
FL |
37256 |
020 |
Doe |
Sally |
101 Basel |
Orange |
FL |
30998 |
PetNumber | PetName | DOB | Species | OwnerNum |
---|---|---|---|---|
100 |
Fido |
1/1/2005 |
Canine |
009 |
200 |
Ajax |
12/3/2003 |
Canine |
020 |
300 |
Sunshine |
6./12/2004 |
Feline |
009 |
400 |
King |
8/15/2007 |
Canine |
009 |
500 |
Rex |
3/23/2008 |
Equine |
012 |
600 |
Slimy |
9/21/2005 |
Reptile |
012 |
700 |
June Bug |
10/9/2001 |
Equine |
009 |
800 |
Frisky |
12/31/2002 |
Feline |
020 |
Step by step
Solved in 3 steps