In trying to delete from the track table, what is the cause of this error? "Query failed because of: error: update or delete on table "track" violates foreign key constraint "invoice_line_track_id_fkey" on table "invoice_line"? O The invoice_id has to be deleted first before the invoice is deleted. O O The invoice_line table has records that reference the track_id that is trying to be deleted. The track_id in the track table doesn't exist. The invoice_line table is missing the track_id.

In trying to delete from the track table, what is the cause of this error? "Query failed because of: error: update or delete on table "track" violates foreign key constraint "invoice_line_track_id_fkey" on table "invoice_line"? O The invoice_id has to be deleted first before the invoice is deleted. O O The invoice_line table has records that reference the track_id that is trying to be deleted. The track_id in the track table doesn't exist. The invoice_line table is missing the track_id.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter4: Constraints

Section: Chapter Questions

Problem 17MC: Suppose you created a PRIMARY KEY constraint at the same time you created a table and later decide...

See similar textbooks

Similar questions

In the initial creation of a table, if a UNIQUE constraint is included for a composite column that requires the combination of entries in the specified columns to be unique, which of the following statements is correct? a. The constraint can be created only with the ALTER TABLE command. b. The constraint can be created only with the table-level approach. c. The constraint can be created only with the column-level approach. d. The constraint can be created only with the ALTER TABLE MODIFY command.
Which of the following keywords allows the user to delete a record from a table, even if rows in another table reference the record through a FOREIGN KEY constraint? a. CASCADE b. CASCADE ON DELETE c. DELETE ON CASCADE d. DROP e. ON DELETE CASCADE
Update the VID_STATUS attribute of the VIDEO table using a subquery to set the VID_STATUS to OUT for all videos that have a null value in the DETAIL_ RETURNDATE attribute of the DETAILRENTAL table.
Add a constraint to make sure the Rep_ID value entered in the BOOK_STORES table is a valid value contained in the STORE_REPS table. The Rep_ID columns of both tables were initially created as different datatypes. Does this cause an error when adding the constraint? Make table modifications as needed so that you can add the required constraint.
Suppose you created a PRIMARY KEY constraint at the same time you created a table and later decide to name the constraint. Which of the following commands can you use to change the constraint’s name? ALTER TABLE … MODIFY ALTER TABLE … ADD ALTER TABLE … DISABLE None of the above commands can be used.
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…
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 012 (OwnerNum = 012) in the Owner table to become 120 (OwnerNum = 120). 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…
Create a Procedure to delete a existing invoice row by accepting INV_NUMBER, CUS_CODE, Whenever you execute the procedure by passing value, it has to delete a particular tuple from the INVOICE table. CREATE TABLE INVOICE (INV_NUMBER integer PRIMARY KEY,CUS_CODE integer,INV_DATE date,FOREIGN KEY (CUS_CODE) REFERENCES CUSTOMER);INSERT INTO INVOICE VALUES('1001','10014','1/16/2016');INSERT INTO INVOICE VALUES('1002','10011','1/16/2016');INSERT INTO INVOICE VALUES('1003','10012','1/16/2016');INSERT INTO INVOICE VALUES('1004','10011','1/17/2016');INSERT INTO INVOICE VALUES('1005','10018','1/17/2016');INSERT INTO INVOICE VALUES('1006','10014','1/17/2016');INSERT INTO INVOICE VALUES('1007','10015','1/17/2016');INSERT INTO INVOICE VALUES('1008','10011','1/17/2016');
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…
First, create (Clone) another version of DEPARTMENTS table with Create table as select command .something like this below. CREATE TABLE new_departments AS SELECT * FROM hr_DEPARTMENTS WHERE 1=2; This unmatcheched WHERE condition will be able to create same table as DEPARTMENT but no data in it. Empty version. Create a PL/SQL block that selects the record which belongs to maximum department ID in the hr_departments table and stores entire record info to composite variable as RECORD. (Lets say cv_dept) Create this composite variable same ROWTYPE of DEPARTMENT table. Declare a variable, v_max_deptno , of type NUMBER in the declarative section. Start the executable section with the BEGIN keyword and include a SELECT statement to retrevive the maximum department_id from the departments table. By using this v_max_deptno use this number in WHERE condition of SELECT statement and make sure you only bring one row from DEPARTMENTS table to composite variable. You will now INSERT this max…
The option for referential integrity between the Owner table and the Pet table is cascade and 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 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…
CREATING TABLES USING oracle APEX CREATE TABLE DEPT ( DEPTNO NUMBER(10) NOT NULL, DNAME VARCHAR2(50) NOT NULL, LOC VARCHAR2(50), CONSTRAINT DEPT_PK PRIMARY KEY (DEPTNO) ); NOTNULL constraint is used it represents cell should not be empty Here NUMBER AND VARCHAR are data types Step 2 Now create emp table CREATE TABLE EMP( EMPNO NUMBER(10) NOT NULL, ENAME VARCHAR2(50) NOT NULL, JOB VARCHAR2(50), MGR VARCHAR2(50), HIREDATE DATE, SAL NUMBER(6), DEPTNO NUMBER(10) NOT NULL, CONSTRAINT EMP_PK PRIMARY KEY(EMPNO), CONSTRAINT EMP_FK FOREIGN KEY (DEPTNO) REFERENCES DEPT (DEPTNO) ); oracle consists of standard DATE formats we have to use that PRIMARY KEY is used to uniquely identify records from the table FOREIGN KEY is used to establish the connection between any two tables Here DEPT is a resultant table of EMP table Step 3 Now SALGRADE TABLE CREATE TABLE SALGRADE ( GRADE NUMBER (10) NOT NULL, LOSAL NUMBER(6), HISAL NUMBER(6), CONSTRAINT SALGRADE_PK PRIMARY KEY…

SEE MORE QUESTIONS

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS