DELHI PUBLIC SCHOOL – BOPAL
MCQ TEST
CLASS – XII
COMPUTER SCIENCE
TOPIC: RDBMS and SQL
1. A relational database consists of a collection of
a. Tuples b. Attributes c. Relations d. Keys
2. A _________ is a property of the entire relation, which ensures through its value that each tuple is unique
in a relation.
a. Rows b. Key c. Attributes d. Fields
3. Which of the following attributes can be considered as a choice of Primary key?
a. Name b. Street c. RollNo d. Subject
4. An attribute in a relation is a foreign key if it is the ________ key in any other relation.
a. Candidate b. Primary c. Super d. Sub
5. What is the full form of SQL?
a. Structured Query Language b. Structured Query List
c. Simple Query Language d. None of these
6. Consider following SQL, statement. What type of statement is this?
CREATE TABLE employee (name VARCHAR, id INTEGER);
a. DML b. DDL c. DCL d. Integrity constraint
7. Consider following SQL, statement. What type of statement is this?
SELECT * FROM employee;
a. DML b. DDL c. DCL d. Integrity constraint
8. Which operator performs pattern matching?
a. BETWEEN operator b. EXISTS operator
c. LIKE operator d. None of these
9. Which of the following functions is not an aggregate function?
a. Round() b. Sum() c. Count() d. Avg()
10. Which of the following functions is used to find the largest value from the given data in MYSQL?
a. MAX() b. MAXIMUM() c. LARGE() d. LARGEST()
