Q1. Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
(A) Super key
(B) Candidate key
(C) Sub key
(D) Foreign key
Answer: Super key
Explanation:
Q2. A relational database consists of a collection of
(A) Tables
(B) Fields
(C) Records
(D) Keys
Answer: Tables
Explanation:
Q3. What are the after triggers?
(A) Triggers generated after a particular operation
(B) triggers run after an insert, views, update or delete on a table
(C) triggers run after an insert, update or delete on a table
(D) All of these
Answer: triggers run after an insert, update or delete on a table
Explanation:
Q4. What are the after triggers?
(A) Triggers generated after a particular operation
(B) These triggers run after an insert, update or delete on a table
(C) These triggers run after an insert, views, update or delete on a table
(D) Both a and b
Answer: These triggers run after an insert, update or delete on a table
Explanation:
Q5. Which of the following terms is used to refer to a row?
(A) Tuple
(B) Attribute
(C) Field
(D) Instance
Answer: Tuple
Explanation:
Q6.
Which of the following functions is used to remove spaces at the end of the string?
(A) Upper
(B) String
(C) Trim
(D) Lower
Answer: Trim
Explanation:
Q7. Select count( *) from employee
(A) View
(B) DDL
(C) DML
(D) Integrity constraint
Answer: DML
Explanation:
Q8. Create table Student (name varchar ,id integer)
(A) View
(B) DDL
(C) DML
(D) Integrity constraint
Answer: DDL
Explanation:
Q9. The attribute that can be divided into other attributes is called
(A) key Attribute
(B) Composite Attribute
(C) Derived Attribute
(D) Multi-valued Attribute
Answer: Composite Attribute
Explanation:
Q10. Which of the following operator is used for appending two strings?
(A) ||
(B) &
(C) %
(D) _
Answer: ||
Explanation:
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