ExamVeda
Login
Home

Data Models into Database Designs - Database MCQ Questions and answers- Technical Aptitude

Data Models into Database Designs(Database) mcq questions and answers with easy and logical explanations for various competitive examination, interview and entrance test. Database Mcq question are important for technical exam and interview. Page-2 section-1

11
The identifier of an entity will become the ________ of the new table.
Discuss
Answer & Solution
Answer: Option C
No explanation is given for this question. Let's Discuss on Board
12
Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?
Discuss
Answer & Solution
Answer: Option C
No explanation is given for this question. Let's Discuss on Board
13
A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
Discuss
Answer & Solution
Answer: Option D
No explanation is given for this question. Let's Discuss on Board
14
Which is not true about surrogate keys?
Discuss
Answer & Solution
Answer: Option C
No explanation is given for this question. Let's Discuss on Board
15
For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
Discuss
Answer & Solution
Answer: Option D
No explanation is given for this question. Let's Discuss on Board
16
Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
17
Each entity is represented as a(n):
Discuss
Answer & Solution
Answer: Option B
No explanation is given for this question. Let's Discuss on Board
18
For every relationship, how many possible sets of minimum cardinalities are there?
Discuss
Answer & Solution
Answer: Option C
No explanation is given for this question. Let's Discuss on Board
19
If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
Discuss
Answer & Solution
Answer: Option A
No explanation is given for this question. Let's Discuss on Board
20
Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?
Discuss
Answer & Solution
Answer: Option D
No explanation is given for this question. Let's Discuss on Board