Bissoy.com
Doctors Medicines MCQs Q&A

Match the following with respect to RDBMS: A. Entity integrity 1. enforces some specific business rule that do not fall into entity or domain B. Domain integrity 2. Rows can’t be deleted which are used by other records C. Referential integrity 3. enforces valid entries for a column D. User defined integrity 4. No duplicate rows in a table

Match the following with respect to RDBMS: A. Entity integrity 1. enforces some specific business rule that do not fall into entity or domain B. Domain integrity 2. Rows can’t be deleted which are used by other records C. Referential integrity 3. enforces valid entries for a column D. User defined integrity 4. No duplicate rows in a table Correct Answer A - 4, B - 3, C - 2, D - 1

The correct answer is "option 2".

CONCEPT:

Data integrity ensures that data in the database must be consistent and accurate.

  • Entity integrity states that every table must have a primary key column that must be unique & not null.
  • Referential integrity works on the concept of foreign key & follows integrity on insertion, deletion & modification of the database table.
  • It states that foreign key value must be either primary key value or null value.
  • Domain integrity specifies that all columns must be declared upon a defined domain & must be valid in the relational database.
  • User-defined integrity enforces specific business rules that do not fall into entity or domain.

​​Hence, the correct options are A - 4, B - 3, C - 2, D - 1​. 

Related Questions

A, B and C are employed in a data entry job, such that A can fill 32 entries in 48 minutes, while B can fill 54 entries in 1. 5 hours. When a data entry work of filling 1000 entries was assigned to A, B and C together, 32 entries were still left to be filled after 8 hours. How many entries can C alone fill in an hour?
There are two domains on your network. The DESIGN domain trusts the SALES domain. A color printer is shared in the DESIGN domain, and print permissions have been granted to the Domain Users and Domain Guests groups in the DESIGN domain. The Guest account has been enabled in the DESIGN domain. User John Y logs on using his account in the SALES domain. What must you do to allow JohnY to access the printer?
Which of the following is not an agreement in restraint of trade?
1. A sells the goodwill of his business with an agreement not to carry on a similar business within specified local limits, so long as the buyer carries on a similar business.
2. A sells the goodwill of his business with an agreement not to carry on a similar business within India, so long as the buyer carries on a similar business.
3. A sells the goodwill of his business with an agreement not to practice the same trade for 25 years.
4. A sells the goodwill of his business with an agreement not to engage in any business competing or liable to compete in any way with the business for the time being carried on by the buyer.
Consider the following Column A and Column B in which the names of microorganisms are given in Column A and the groups to which they belong are given in Column B: Column A Column B (a) Aspergillus (i) Algae (b) Lactobacillus (ii) Bacteria (c) Paramecium (iii) Fungi (d) Spirogyra (iv) Protozoa   (v) Virus The correct match of the items of Column A with that of Column B is
User level threads are threads that are visible to the programmer and are unknown to the kernel. The operating system kernel supports and manages kernel level threads. Three different types of models relate user and kernel level threads. Which of the following statements is/are true ? (a) (i) The Many - to - one model maps many user threads to one kernel thread (ii) The one - to - one model maps one user thread to one kernel thread (iii) The many - to - many model maps many user threads to smaller or equal kernel threads (b) (i) Many - to - one model maps many kernel threads to one user thread (ii) One - to - one model maps one kernel thread to one user thread (iii) Many - to- many model maps many kernel threads to smaller or equal user threads
In the following question, two columns are given containing three phrases each. In the first column, phrases are A, B, and C, and in the second column, the phrases are D, E, and F. A phrase from the first column may or may not connect with a phrase from the second column to make a grammatically and contextually correct sentence. There are five options, four of which display the sequence(s) in which the phrases can be joined to form a grammatically and contextually correct sentence. If none of the options forms a correct sentence after combination, select ‘None of these’ as your answer. Column 1) Column 2) (A) The Consumer Protection Act should be implemented more strictly (D) but there are many dark sides to it once you enter into this (B) The music industry is now saturated with too many singers  (E) so that the businessmen become alert and are compelled to stop the unfair practice C) The showbiz business is not all rosy as it seems (F) and the lifetime of a singer is hence reduced to one or two songs only
In the following question, two columns are given containing incomplete sentences. In the first column, the phrases are (A), (B), and (C), and in the second column the phrases are (D), (E), and (F). You have to match the phrases of column (1) with those of column (2) and make grammatically and contextually correct sentences. If none of the given options form a correct sentence after combination, select ‘None of these’ as your answer.   Column (1) Column (2) A-My father used a dilatory strategy to keep me out of the house D-evolution progresses B-As genes change over time, E-While my mother arranged my surprise birthday party C-When I came into light after emerging from the dark depths of the cave F-I only wanted two things: soap and water.
In the following question, two columns are given containing incomplete sentences. In the first column, the phrases are (A), (B), and (C), and in the second column the phrases are (D), (E), and (F). You have to match the phrases of column (1) with those of column (2) and make grammatically and contextually correct sentences. If none of the options given forms a correct sentence after combination, select ‘None of these’ as your answer. Column 1 Column 2 A-Because of advances in DNA testing, the police can now conduct D- he started a crusade to rid his city of illegal drugs B-When the mayor learned his son was killed by a drug leader E- he bet all his savings on the game C-His football team would pulverize its opponent F- a belated investigation into the unsolved murder
In the following question, two columns are given containing three phrases each. In the first column phrases are A, B, and C and in the second column, the phrases are D, E, and F. A phrase from the first column may or may not connect with phrase from the second column to make grammatically and contextually correct sentence. There are five options, four of which display the sequence(s) in which the phrases can be joined to form a grammatically and contextually correct sentence. If none of the options forms a correct sentence after combination, select ‘None of these’ as your answer.  Column 1  Column 2  A.The campaigners claimed carbon offsetting was not the best way to tackle  D. that it was best to prioritise the reduction of carbon emissions.  B. A rapid transition to the adoption of alternative technologies requires progressive regulation  E. lest a great deal left to understand about this specific species of singing bat.  C. While the latest study has identified a pattern that could be important for many mammals to communicate vocally  F. to decrease the cooling, and in the short term at least, this will equate to rising costs for businesses.
Consider the following columns A and B in which some names of scientists are given in Column A and the discoveries made by them are given in Column B. Column A Column B a. Alexander Fleming i. Bacillus anthracis b. Edward Jenner ii. Fermentation c. Louis Pasteur iii. Lacobacillus d. Robert Koch iv. Penicillin   v. Small pox vaccine   The correct match of the items of Column A with that of Column B is: