Page 189 - IT-802_class_12
P. 189
Previous Years’ Questions
1. ………………………… command displays all the tables created in the current database. [2023]
(a) SHOW DATABASES (b) SHOW TABLES
(c) CREATE TABLES (d) DiSpLAy TABLES
Ans. (b) SHOW TABLES
2. An attribute value may not be permitted to be NULL value with ………………………… constraint. [2023]
Ans. NOT NULL
3. Ranjana has written the following query but it is giving an error. Rectify the error and rewrite the query. [2023]
SELECT * FROm pRODUCT
SORT By pRiCE;
Ans. SELECT * FROm pRODUCT
ORDER By pRiCE;
4. “Database management system could not find any usage in hospital domain.” In the above statements true or false? [2023]
Ans. False
5. Define Referential Integrity. [2023]
Ans. Referential Integrity is a database concept that ensures relationships between tables are maintained. It is typically enforced
through the use of foreign keys and primary keys. In a relational database, the referential integrity constraint requires that
the values in a column (or columns) of one table correspond to the values in a referenced column (usually the primary key)
of another table.
6. Which of the following constraints specifies that the value of every attribute in each tuple must be from the domain of that
attribute? [2023
(a) Domain Constraint (b) Key Constraint
(c) Null Value Constraint (d) Entity Integrity Constraint
Ans. (a) Domain Constraint
7. Database can be removed by using ………………………… command. [2023]
Ans. DROP Command (DROP DATABASE database_name;)
8. Create Table is a ………………………… command. [2023]
Ans. DDL (Data Definition Language)
9. The functions that are used to apply certain mathematical functions on a group of values in a database are called ____.
Ans. aggregate functions or SQL aggregate functions
10. RDBMS packages are widely used as ………………………… (Frontend/Backend) [2023]
Ans. Backend
11. The number of attributes in a relation is called the ………………………… of a relation. [2023]
Ans. degree
12. To avoid repetition in the result of a SELECT Query ………………………… clause is used. [2023]
Ans. DISTINCT
13. Mention any two major significances of Database Management System. [2023]
Ans. Database Management Systems (DBMS) have several significant advantages, but here are two major significances:
(i) Data Integrity and Consistency: DBMS enforces data integrity constraints, ensuring that data in the database follows
predefined rules and constraints. This helps maintain the accuracy and consistency of data, preventing inconsistencies
and errors.
(ii) Data Security and Access Control: DBMS provides robust security features to control access to data. It allows
administrators to define user roles and permissions, limiting who can view, modify, or delete data.
Database Concepts—RDBMS Tool 187

