Computer Science - Informatics Practices Class XI/XII MySQL Test Series Part 2

Q1. What do you mean by data redundancy?

Q2. What do you mean by data inconsistency?

Q3. Define the term data model.

Q4. Name 3 types of data models.

Q5. A ___________ is a collection of logically related data.

Q6. Answer the following questions on the basis the given table.

a. How many attributes are there in above table?

b. How many tuples are there in above table?

c. What is the degree of above table?

d. What is the cardinality of above table?

e. Name the primary key in the table.

Q7. Write any five attributes of book entity.

Q8. Write any two advantages of database.

Q9. What is the purpose of creating primary key in table.

Q10. Which field you choose as primary key out of following in "Employee" table

1. Emp_id
2. Emp_name
3. Emp_salary
4. Emp_desig

Ans 1.