Sawaal
  • Home/
  • Searching for referential

 Searching for "referential"

Q:

What are the Referential actions supported by FOREIGN KEY integrity constraint?

Answer

UPDATE and DELETE Restrict - A referential integrity rule that disallows the update or deletion of referenced data. DELETE Cascade - When a referenced row is deleted all associated dependent rows are deleted.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

Q:

 When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:

A) first step. B) second step.
C) third step. D) fourth step.
 
Answer & Explanation Answer: C) third step.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

Q:

Can’t update primary table’s primary key if row being modified has related rows in secondary table once referential integrity is enforced

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

Q:

Breaking of relationships is allowed once referential integrity on a database is enforced

A) TRUE B) FALSE
Answer & Explanation Answer: B) FALSE

Explanation:

Breaking of relationships is prevented once referential integrity on a database is enforced

Report Error

View Answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration