Page 182 - IT-802_class_12
P. 182
Solved Exercise
Section A
(Objective Type Questions)
A. Choose the correct option.
1. What is the full form of DBMS?
i. Data of Binary Management System ii. Database Management System
iii. Database Management Service iv. Data Backup Management System
2. Which of the following is a component of the DBMS?
i. Data ii. Data Languages
iii. Data Manager iv. All of these
3. What does an RDBMS consist of?
i. Collection of Records ii. Collection of Keys
iii. Collection of Tables iv. Collection of Fields
4. Which of the following commands is used to create a new table in SQL?
i. CREATE TABLE ii. BUILD TABLE
iii. GENERATE TABLE iv. None of these
5. Which SQL constraint do we use to set some value to a field whose value has not been added explicitly?
i. UNIQUE ii. NOT NULL
iii. DEFAULT iv. CHECK
6. The rows of a relation is known as ................................ .
i. Degree ii. Entity
iii. Tuple iv. None
7. Which of the following is not a Constraint in SQL?
i. Primary Key ii. Not Null
iii. Check iv. None of these
8. Which command is used to change the definition of a table in SQL?
i. CREATE ii. UPDATE
iii. ALTER iv. SELECT
9. ................................ is used to establish an association between related tables.
i. Line ii. Relationship
iii. Primary Key iv. Records
10. In which of the following formats data is stored in the database management system?
i. Image ii. Text
iii. Table iv. Graph
11. Which of the following is true for self-referencing table? [CBSE Sample Paper 2023]
i. A foreign key constraint can reference columns within the same table.
ii. A primary key constraint can be null.
iii. You cannot delete this table.
iv. You cannot update or delete this table.
12. Identify the operator that performs pattern searching in MYSQL. [CBSE Sample Paper 2023]
i. EXISTS operator ii. BETWEEN operator
iii. LIKE operator iv. SEARCH operator
13. Cardinality of a table is four and degree is three. If two columns and four rows are added to this table, what will be the new
degree and cardinality of the given table? [CBSE Sample Paper 2023]
i. 5,8 ii. 3,4
iii. 8,5 iv. 4,3
180 Touchpad Information Technology-XII

