Data integrity constraints are used to:(a) Control who is allowed access to the data(b) Ensure that duplicate records are not entered into the table(c) Improve the quality of data entered for a specific property(d) Prevent users from changing the values stored in the tableI had been asked this question in homework.This intriguing question originated from Constraints topic in chapter Database Systems Design and Implementation of Database Management

Data integrity constraints are used to:(a) Control who is allowed acce

1.	Data integrity constraints are used to:(a) Control who is allowed access to the data(b) Ensure that duplicate records are not entered into the table(c) Improve the quality of data entered for a specific property(d) Prevent users from changing the values stored in the tableI had been asked this question in homework.This intriguing question originated from Constraints topic in chapter Database Systems Design and Implementation of Database Management
Answer» The correct choice is (c) IMPROVE the QUALITY of data entered for a SPECIFIC property Best EXPLANATION: The data entered will be in a particular CELL (i.e., table column).

Discussion

No Comment Found

Related InterviewSolutions

Functional dependencies are a generalization of(a) Key dependencies(b) Relation dependencies(c) Database dependencies(d) None of the mentionedThis question was addressed to me during an online exam.Asked question is from Extended E-R Features in section Database Systems Design and Implementation of Database Management
There are similarities between the instructor entity set and the secretary entity set in the sense that they have several attributes that are conceptually the same across the two entity sets: namely, the identifier, name, and salary attributes. This process is called(a) Commonality(b) Specialization(c) Generalization(d) SimilarityThis question was posed to me in an international level competition.I'd like to ask this question from Extended E-R Features in chapter Database Systems Design and Implementation of Database Management
Which of the following can be used as a primary key entry of the instructor relation.(a) DEPT_NAME(b) NAME(c) ID(d) All of the mentionedI had been asked this question in semester exam.This is a very interesting question from Querying database part-1 DDL in section Database Systems Design and Implementation of Database Management
Identify the error in the section relation(a) No error(b) Year numeric (4,0)(c) Building varchar (15)(d) Sec_id varchar (8)I got this question in semester exam.This question is from Querying database part-1 DDL topic in portion Database Systems Design and Implementation of Database Management
If an entity set is a lower-level entity set in more than one ISA relationship, then the entity set has(a) Hierarchy(b) Multilevel inheritance(c) Single inheritance(d) Multiple inheritanceThe question was asked in unit test.Question is taken from Extended E-R Features in section Database Systems Design and Implementation of Database Management
A _____________ constraint requires that an entity belong to no more than one lower-level entity set.(a) Disjointness(b) Uniqueness(c) Special(d) RelationalI got this question in a job interview.This intriguing question originated from Extended E-R Features topic in chapter Database Systems Design and Implementation of Database Management
The refinement from an initial entity set into successive levels of entity subgroupings represents a ________ design process in which distinctions are made explicit.(a) Hierarchy(b) Bottom-up(c) Top-down(d) RadicalI got this question in an interview for internship.My question comes from Extended E-R Features topic in portion Database Systems Design and Implementation of Database Management
Which of the following command is used to display the departments of the instructor relation?(a) Select * from instructor where Dept_name = Finance;(b) Select * from instructor ;(c) Select dept_name from instructor;(d) Select dept_name for instructor where Name=Jackson;This question was posed to me in homework.The above asked question is from Querying database part-2 DML in chapter Database Systems Design and Implementation of Database Management
Which relationship is used to represent a specialization entity?(a) ISA(b) AIS(c) ONIS(d) WHOISI got this question in unit test.I need to ask this question from Extended E-R Features in section Database Systems Design and Implementation of Database Management
If an attribute of a composite key is dependent on an attribute of the other composite key, a normalizationcalled _____ is needed.(a) DKNF(b) BCNF(c) Fourth(d) ThirdThe question was asked in class test.The question is from Atomic Domains in chapter Database Systems Design and Implementation of Database Management

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment