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


Q2. The Primary key must be
(A) Non Null
(B) Unique
(C) Both of these
(D) None of these


Q3. Ranking of queries is done by which of the following?
(A) Order by
(B) Having
(C) Group by
(D) All of these


Q4. The minimal set of super key is called
(A) Primary key
(B) Secondary key
(C) Foreign key
(D) Candidate key


Q5. Which one of the following uniquely identifies the elements in the relation?
(A) Primary key
(B) Secondary Key
(C) Composite key
(D) Foreign key


Q6. Which of the following is Database Language?
(A) Query Language
(B) Data Manipulation Language
(C) Data Definition Language
(D) All of these


Q7. Which of the following is a Data Model?
(A) Relational data model
(B) Entity Relationship model
(C) Object Based data model
(D) All of these


Q8. Which term is not related to database?
(A) SQL
(B) TABLE
(C) Java
(D) Oracle


Q9. Which of the following is not an Aggregate function?
(A) Select
(B) Min
(C) Max
(D) Avg


Q10. Which of the following query will display the table given above?
(A) Select name
(B) Select Student from name
(C) Select name from Student
(D) Select Student


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