CLASS XII INFORMATION TECHNOLOGY
UNIT 1:DATABASE CONCEPTS
CHAPTER WISE WORKSHEET
I. MULTIPLE CHOICE QUESTIONS:
1. Data is a collection of facts which have not been processed to
reveal useful information.
a. Raw b. Facts c. Process d. None of the above
2. What are the benefits of databases .
[Link] Redundancy b. Data Inconsistency
c. Lack of Data Integration d. All of the above
3. A is a collection of programs that enables users to rate, maintain and use a
database.
a. Database management system b. Database manageable system
c. Database updation system d. None of the above
4. Which of the following is not a valid SQL type?
[Link] b. NUMERICc. DECIMAL d. CHARACTER
5. Which of the following is not a DDL command?
[Link] b. ALTER c. CREATE d. UPDATE
12. How many Primary keys can there be in a table?
a. Only 1 b. Only 2
c. Depends on no of Columns d. Depends on DBA
[Link] of the following is not Constraint in SQL?
a. Primary Key b. Not Null c. Check d. Union
[Link] operator tests column for absence of data
a. NOT Operator b. Exists Operator
c. IS NULL Operator d. None of the above
15. A row is also called a .
a. Field c. Both a) and b)
b. Tuple d. None of the above
16. A column is also called .
a. Attribute b. Relation
c. Domain d. Degree
[Link] data types of values in each column are called .
a. Attribute c. Domain
b. Relation d. Degree
[Link] number of attributes in a relation is called the of a relation.
a. Attribute c. Domain
b. Relation d. Degree
[Link] number of rows in a relation is called the of a relation.
a. Cardinality c. Domain
b. Relation d. Degree
[Link] of the examples of databases are .
a. IBM DB2 c. MySQL
b. Oracle d. All of the above
21. are restrictions on the values, stored in a database based on the
requirements.
a. Method c. Properties
b. Constraints d. None of the above
[Link] are examples of constraints in relational models?
a. Domain constraint b. Key constraint
c. Entity Integrity constraint d. All of the above
[Link] are the examples of key constraints?
a. Super key c. Primary key
b. Candidate key d. All of the above
24. is a set of attributes in a relation, for which no two tuples in a relation
state have the same combination of values.
a. Super key c. Primary key
b. Candidate key d. All of the above
25. key helps to protect duplication in the table.
a. Super key c. Primary key
b. Candidate key d. All of the above
26. is a language that is used to manage data stored in a RDBMS.
[Link] c. SQL
b. DML d. None of the above
[Link] Stands for .
[Link] Query Language c. Social Query Language
b. Structured Query Language d. None of the above
[Link] datatype belongs to numerical type.
a. Integer c. Decimal
b. . Number d. All of the above
29. What data type has a fixed length in the database.
a. Varchar(n) c. Longvarchar(n)
b. Char(n) d. None of the above
30. A foreign key constraints can reference columns within
the same table. These tables are called .
a. Self-referencing tables c. Default Constraint
b. Key Constraint d. None of the above
31. The command is used
to delete tables from a database .
a. Delete Table
b. Remove Table
c. Drop Table
d. None of the above
32. command is used to modify the base table definition. The
modifications that can be done using this command.
a. Update Table c. Modify Table
b. Alter Table d. None of the above
33. A column can be dropped using this command but one must
specify the options for the drop behavior.
a. Restrict c. Both a) and b)
b. Cascade d. None of the above
34. If the reference is given
in another table then command is not allowed
to drop the table.
a. Restrict c. Both a) and b)
b. Cascade d. None of the above
35. If the reference is
given in another table then command is allowed
to drop the table.
a. Restrict c. Both a) and b)
b. Cascade [Link] of the above
36. Command is used to update the attribute values of one or more
tuples in a table.
a. Insert table c. Alter table
b. Update table d. None of the above
37. In order to delete one or more tuples, command is used.
a. Drop command c. Remove command
b. Delete command d. Erase command
38. The Command is used to retrieve information from a
database.
a. Select command
b. Display command
c. Show command
d. None of the above
II. SHORT ANSWERS:
1. Define aggregate functions with example
2. Write any four constraints with example
3. Write any three properties of database
4. What is a relational Database
5. What is the referential integrity constraint?
6. Give an example of DDL & DML commands?
[Link] ANSWERS:
1. What are the different advantages and disadvantages of Database?
2. What are the various operations performed by Database?
3. What are the different types of users of DBMS?
4. Consider the following Employee table – Table Name–
Employee
a) Write the query to create the table employee with the above columns
Note: The primary key of this table is Employee_ID and Manager_ID is a foreign key that
references Employee_ID.
b) Write the query to insert this value (1217, “Mohit”, “Salesman”, 16000, NULL, 22,
1205);
c) Delete the Employee having Employee_ID 1217.
d) Update the salary of “Amyra” to 40000.
e) Alter the table Employee so that NULL values are not allowed for Age column.
f) Write a query to display names and salaries of those employees whose salary are
greater than 20000.
g) Write a query to display details of employees who are not getting any bonus.
h) Write a query to display the names of employees whose name contains “a” as the
last alphabet.
i) Write a query to display the name and Job title of those employees whose
Manager_ID is 1201.
j) Write a query to display the name and Job title of those employees whose Manager
is “Amyra”
k) Write a query to display the name and Job title of those employees aged between 26
years and 30 years