Q1. If every non-key attribute is functionally dependent on the primary key, the relation will be in
(A) First Normal Form
(B) Second Normal Form
(C) Third Normal Form
(D) Second or Third Formal Form

Q2. A relation is in which if every field contains only atomic values that is, no lists or sets.
(A) First Normal Form
(B) Second Normal Form
(C) Third Normal Form
(D) Fourth Normal Form

Q3. Which normal form is considered adequate for normal relational database design?
(A) First Normal Form
(B) Second Normal Form
(C) Third Normal Form
(D) Fourth Normal Form

Q4. Which normal form is related to the concept of multi-valued dependency?
(A) First Normal Form
(B) Second Normal Form
(C) Third Normal Form
(D) Fourth Normal Form

Q5. Which of the following is not an aggregate function in SQL?
(A) First()
(B) Sum()
(C) Average()
(D) Min()

Q6. A functional dependency between two or more non-key attributes is called
(A) Functional dependency
(B) Transitive dependency
(C) Partial dependency
(D) Partial functional dependency

Q7. Which of the following indicates the maximum number of entities that can be involved in a relationship?
(A) Greater Entity Count
(B) Minimum cardinality
(C) Maximum cardinality
(D) None of these

Q8. Which one of the following cannot be taken as a primary key?
(A) Id
(B) Register number
(C) Dept_id
(D) College

Q9. Which of the join operations do not preserve non matched tuples.
(A) Inner join
(B) Left outer join
(C) Right outer join
(D) Natural join

Q10. Which of the following is an Aggregate function?
(A) Min
(B) Where
(C) Select
(D) All of these

Related Multiple choice questions:
computer hardware objective questions and answers part1
computer hardware objective questions and answers part2
computer hardware objective questions and answers part3
computer hardware objective questions and answers part4
computer hardware objective questions and answers part5

computer networking objective questions and answers part1
computer networking objective questions and answers part2
computer networking objective questions and answers part3
computer networking objective questions and answers part4
computer networking objective questions and answers part5

computer programming objective questions and answers part1
computer programming objective questions and answers part2
computer programming objective questions and answers part3
computer programming objective questions and answers part4
computer programming objective questions and answers part5

basics of computer science objective questions and answers part1
basics of computer science objective questions and answers part2
basics of computer science objective questions and answers part3
basics of computer science objective questions and answers part4
basics of computer science objective questions and answers part5
basics of computer science objective questions and answers part6
basics of computer science objective questions and answers part7
basics of computer science objective questions and answers part8
basics of computer science objective questions and answers part9
basics of computer science objective questions and answers part10
basics of computer science objective questions and answers part11
basics of computer science objective questions and answers part12
basics of computer science objective questions and answers part13
basics of computer science objective questions and answers part14
basics of computer science objective questions and answers part15
basics of computer science objective questions and answers part16
basics of computer science objective questions and answers part17

Database management system multiple choice questions and answers part1
Database management system multiple choice questions and answers part2
Database management system multiple choice questions and answers part3
Database management system multiple choice questions and answers part4
Database management system multiple choice questions and answers part5

Operating system multiple choice questions and answers part1
Operating system multiple choice questions and answers part2
Operating system multiple choice questions and answers part3

MS Office multiple choice questions and answers part1
MS Office multiple choice questions and answers part2
MS Office multiple choice questions and answers part3
MS Office multiple choice questions and answers part4
MS Office multiple choice questions and answers part5

More Multiple choice questions:
Computer Science multiple choice questions and answers
Computer Science multiple choice questions and answers
Computer Science multiple choice questions and answers