Home
10th Grade
11th And 12th
11th Grade
12th Grade
3rd Grade
4th Grade
5th Grade
6th Grade
7th Grade
8th Grade
9th Grade
Advance Accountancy
Auditing
Computer Aptitude
Direct And Indirect Taxation
Exams
General Hindi
Indian Finance System
Information Technology And Application In Business
Macro Economics
Town Planning
Aerospace And Aeronautical
Analytical Instrumentation
Banking Awareness
Banking Exam
Biochemistry
Bioinformatics
Biology
Biotechnology
Business Statistics
C Program
C Programming
C++ Programming
Career Aptitude Test
Cell Biology
Central Superior Service (css)
Chemical Engineering
Chemistry
Civil Engineering
Commerce
Computer
Computer Fundamentals
Computer Science
Cost Accounting
Css
Database
Drug And Pharmaceutical Biotechnology
Ecat And Mcat Entry Test
Economics
Electrical Engineering
Electrical Engineering Questions
Electrical Measurement And Instrumentation
Engineering
English
English Literature
Environment Management
Environmental Biotechnology
Enzyme Technology
Financial Management And Financial Markets
Gate
General Knowledge
Graduate Assessment Test (gat)
Health And Physical
Heat Transfer
Html
Human Anatomy And Physiology
Human And Cultural Diversity
Human Resource Management
Ias
Indian Economy
Indian Economy
Indian General Awareness
Indian Geography
Indian Geography
Indian History
Indian History
Indian Polity
Instrumentation Transducers
International Relations
Java Program
Javascript
Judiciary And Law
Life Sciences
Management
Marketing And Marketing Management
Mass Transfer
Mechanical Engineering
Mechanics Of Materials
Medical Subjects
Microbiology
Networking
Php
Placement Tests
Professional Communication
Quantitative Aptitude
Reasoning Aptitude
Renewable Energy
Science
Sociology
Sql
Surveying
Total Quality Management
Uidai Aadhaar Supervisor Certification
Virology
Notificatin
Exam
Blog
Contact Us
Logical Database Design(Engineering > Computer Science And Engineering > Database System ) Questions and Answers
Home
Topic
Engineering
Computer Science And Engineering
Database System
Logical Database Design
Question 1.
A transitive dependency is which of the following?
A functional dependency between two or more key attributes.
A relation that is in first normal form.
A relation that is in second normal form.
A functional dependency between two or more nonkey attributes.
Explanation:-
Answer: Option D. ->
A functional dependency between two or more nonkey attributes.
Question 2.
A foreign key is which of the following?
The same thing as a primary key
An attribute that serves no purpose
An attribute that serves as the primary key of another relation
Any attribute
Explanation:-
Answer: Option C. ->
An attribute that serves as the primary key of another relation
Question 3.
The entity integrity rule states that:
no primary key attribute may be null.
no primary key may be equal to a value in a foreign key.
no primary key may be unique.
no primary key can be composite.
Explanation:-
Answer: Option A. ->
no primary key attribute may be null.
Question 4.
If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?
First normal form
Third normal form
Second normal form
Fourth normal form
Explanation:-
Answer: Option C. ->
Second normal form
Question 5.
When mapping a many-to-many unary relationship into a relation which of the following is true?
Four relations are created.
Two relations are created.
Three relations are created.
One relation is created.
Explanation:-
Answer: Option B. ->
Two relations are created.
Question 6.
If no multivalued attributes exist in a relation, then the relation is in what normal form?
Fourth normal form
Third normal form
Second normal form
First normal form
Explanation:-
Answer: Option C. ->
Second normal form
Question 7.
When mapping a binary many-to-many relationship into a relation which of the following is true?
Four relations are created.
Two relations are created.
Three relations are created.
One relation is created.
Explanation:-
Answer: Option C. ->
Three relations are created.
Question 8.
A primary key is which of the following?
An attribute that uniquely identifies each column
A derived attribute
An attribute that uniquely identifies each row
Any attribute
Explanation:-
Answer: Option C. ->
An attribute that uniquely identifies each row
Question 9.
When mapping a multivalued attribute into a relation which of the following is true?
Four relations are created.
Two relations are created.
One relation is created.
Three relations are created.
Explanation:-
Answer: Option B. ->
Two relations are created.
Question 10.
The relational model consists of:
data redundancy.
operations using non-SQL languages.
data in the form of tables.
unorganized data.
Explanation:-
Answer: Option C. ->
data in the form of tables.
1
2
3
Next →
One click Login
Login With Google
Old way of Login
Login With Email