The option for referential integrity between the Owner table and the Pet table is restrict. An attempt is made to delete the row for owner number 012 in the Owner table. What is the result? (Use only the data in the tables below. 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 Just that row (OwnerNum 012) in the Owner table would be deleted. There are no related rows in the Pet table. Nothing will be deleted from the Owner table and nothing will be deleted from the Pet table. That row (OwnerNum 012) in the Owner table will be deleted and so will the related row(s) from the Pet table that refer to it. That row (OwnerNum 012) from the Owner table will NOT be deleted but any related row(s) in the Pet relation will be deleted.
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. An attempt is made to delete the row for owner number 012 in the Owner table. What is the result? (Use only the data in the tables below. 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 6 steps