Logical Database Design - Database MCQ Questions and answers- Technical Aptitude

Home

Competitive Exams

Aptitude English Verbal Reasoning Non Verbal Reasoning General Knowledge(GK) General Science(GS) Data Interpretation(DI) Banking Awareness Current Affairs

Computer & Programming

Computer Fundamentals Networking SQL Database C Programming C++ Programming Java Python

Other Subjects

Commerce Management Law Political Science Psychology Agriculture

Exam Categories

SSC Exams Railway Exams All Exams

SSC Exams

SSC CGL SSC CHSL SSC MTS SSC CPO SSC GD SSC JHT SSC Selection Post SSC Stenographer SSC JE

Railway Exams

RRB ALP RRB Technician RRB Section Controller RRB JE RRB Paramedical RRB Group D

Popular Exams

SSC CGL SSC CHSL SSC MTS RRB Group D RRB ALP RRB Technician RRB Section Controller

Engineering Subjects

Computer Science Electronics & Communication Mechanical Engineering Civil Engineering Electrical Engineering

More Engineering

Chemical Engineering Automobile Engineering Biotechnology Mining Engineering Geological Engineering

Engineering Core

Engineering Mathematics Engineering Physics Engineering Chemistry Metallurgical Engineering

Computer Fundamentals

Computer Fundamentals Networking Database SQL MySQL

Programming

C Programming C++ Programming Java Python PHP JavaScript

Advanced

Artificial Intelligence Machine Learning Data Science Cloud Computing Hadoop IoT

Graduation & PG

Commerce Management Law Mass Communication Political Science Psychology

Resources

Current Affairs Interview Blog

A relation has which of the following properties?

A) Each row is not unique. B) Attributes can have the same name within a given table. C) Each relation has a unique name. D) The order of the columns is significant.

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

When mapping a ternary relationship with an associative entity into a relation which of the following is true?

A) One relation is created. B) Two relations are created. C) Three relations are created. D) Four relations are created.

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

When mapping a regular entity into a relation which of the following is true?

A) One relation is created. B) Two relations are created. C) Three relations are created. D) Four relations are created.

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

When mapping a supertype/subtype relationship which of the following is true?

A) The supertype primary key is assigned to each subtype. B) The subtype primary key is assigned to each supertype. C) There is no link between the supertype/subtype entities. D) There is no primary key/foreign key relationship between a supertype/subtype.

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

Relations are:

A) two-dimensional tables. B) three-dimensional tables. C) four-dimensional tables. D) five-dimensional tables.

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

An enterprise key is a primary key whose value is unique for a given relation.

A) True B) False

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

A composite attribute does not get mapped into a relation.

A) True B) False

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

A relation is a two-dimensional table.

A) True B) False

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

Weak entities do not get mapped into a relation.

A) True B) False

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

A primary key may be null.

A) True B) False

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

1 2 3