• Register
0 votes
42 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 5 2
10,530 points

Related questions

1 vote
1 answer 44 views
44 views
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 5.6k points
0 votes
1 answer 23 views
23 views
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 28 views
28 views
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 37 views
37 views
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 38 views
38 views
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
2 answers 73 views
73 views
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 197 views
197 views
Problem: In what type of attack does the attacker send unauthorized commands directly to a database?
asked Apr 12, 2020 ArifulIslam 5.6k points
0 votes
1 answer 71 views
71 views
Problem: Which of the following will open a file named MyFile.txt and allow you to read data from it? a. File file = new File("MyFile.txt"); b. Scanner inputFile = new Scanner("MyFile.txt"); c. File file = new File("MyFile.txt"); Scanner inputFile = new Scanner(file); d. PrintWriter inputFile = new PrintWriter("MyFile.txt"); Does any one know correct file name?
asked Feb 22, 2020 maddi86 5.4k points
0 votes
1 answer 64 views
64 views
Problems: I am new to programming, I need help, can anyone help me? Which of the following is a valid C++ array definition? A) int array[0]; B) float $payments[10]; C) void numbers[5]; D) int array[10]; E) None of these
asked Feb 14, 2020 maddi86 5.4k points
0 votes
1 answer 9 views
9 views
Problem: Hello! I just recently had an exam of the operating systems in which there was a multiple-choice question. The question was: which of the following does not interrupt a running process? A) Timer B) Power Failure C) A device D) Scheduler I chose “Timer” as an answer. I want to know whether my answer was correct or not? Why and why not?
asked Dec 21, 2020 Code Learner 5.1k points