menu
  • Register

Which of the following does not violate the referential integrity of a database?

0 votes
168 views

Problem:

Can anyone guide me with the right solution as I am new and learning database?

Which of the following does not violate the referential integrity of a database?

  • Inserting a new row into a table with a foreign key that doesn't match a primary key in the related table
  • Updating a foreign key with a value that doesn't match a primary key in the related table
  • Updating a primary key in a primary key table without also updating the foreign keys for the related rows in all related tables
  • Deleting a row in a foreign key table without deleting the related row in the related primary key table
●7 ●5 ●3
5,380 points

Please log in or register to answer this question.

1 Answer

0 votes

Solution:

The correct answer is : deleting a row in a foreign key table without deleting the related row in the related primary key table

This might help you.

●8 ●6 ●2
10,530 points

Related questions

0 votes
1 answer 95 views
95 views
Microsoft Access can't create this relationship and enforce referential integrity
Problem : I am facing the below error : “Microsoft access can't create this relationship and enforce referential integrity” I have already checked everything for the errors: primary key, uniqueness, and type. But the Access is just unable to link the 2 fields which I have in my database. can someone please let me know the solution if any?
asked Dec 24, 2019 alecxe 7.5k points
1 vote
1 answer 81 views
81 views
Which of the following allows users to add, change, delete, or retrieve data in a database?
Problem: Which of the following allows users to add, change, delete, or retrieve data in a database? a) Attribute generation b) Report generation tools c) Data dictionary d) Query wizard tool e) Data manipulation language
asked Mar 23, 2020 ArifulIslam 7.5k points
0 votes
1 answer 39 views
39 views
Which of the following consists of rules and standards that define how a database organizes data?
Problem: I am new, I need help, can anyone help me? Which of the following consists of rules and standards that define how a database organises data? Data handling Data model Attribute OODB
asked Feb 18, 2020 maddi86 5.4k points
0 votes
1 answer 569 views
569 views
Which of the following are the advantages of a dbms (database management system)?
Problem: Can anyone help it was actually asked in exam as following: Which of the following are the advantages of a DBMS (database management system)? A) Effective database administration helps ensure that standards for data names, formats, and documentation are followed ... processing systems. D) A DBMS is scalable which makes it easier to meet the rapidly changing needs of a business enterprise.
asked Feb 18, 2020 maddi86 5.4k points
0 votes
1 answer 77 views
77 views
In a relational dbms, a user may create a database structure that contains which of the following?
Problem: While creating database in relational DBMS, what we need? In a relational DBMS, a user may create a database structure that contains which of the following? A) Data,fields, and table relationships B) Symbols, numbers, and tables C) Numbers, tables, and fields D) Fields, tables, and table relationships
asked Feb 17, 2020 maddi86 5.4k points
0 votes
1 answer 66 views
66 views
Which of the following is an international standard language for processing a database?
Problem: Can anyone brief the right solution? Which of the following is an international standard language for processing a database? A) VBA B) C++ C) Visual Basic D) Standard Query Language E) Structured Query Language
asked Feb 17, 2020 maddi86 5.4k points
0 votes
1 answer 52 views
52 views
SQL: Which of the following terms refers to commands that are used to create or modify database tables?
Problem: Hi there! I am learning SQL. Somewhere I saw a multiple choice question in which a list of terms was given and I had to choose the terms that refer to the commands used to create or modify database tables and columns. Following is the list of keywords: ... of most of these commands. I have learned only basics yet. If someone could explain all these commands, I would be grateful. Thanks!
asked Jan 16 Code Learner 9.8k points
0 votes
2 answers 143 views
143 views
Which of the following is true about the database approach?
Problem: Can anyone help it was actually asked in exam as following and I need to know whether my answer was right or not? Which of the following is true about the database approach? Data in a database is less vulnerable than data in file processing systems. Elimination of data redundancy Ability of associate deleted data Increased security and program/data independence
asked Feb 21, 2020 maddi86 5.4k points
0 votes
2 answers 3 views
3 views
In which form does the data gets stored in the database?
Problem: As I previously stated in my question, I am having difficulty learning. Could someone help assist me in completing my project?
asked Mar 29 tuhin1 48.9k points
0 votes
1 answer 5 views
5 views
When you code a union that combines two result sets, which of the following is not true?
Problem: I want to do a Full Outer Join in MySQL. Is this possible? Is a Full Outer Join supported by MySQL?
asked Apr 25 sumaiya simi 43.9k points
Dark theme