E-Content Delhi 2011

Class XI IP : Assignments(DBMS CONCEPTS & INTRODUCTION TO MYSQL )

DBMS CONCEPTS

TYPE A : VERY SHORT  ANSWER QUESTIONS

1.   What is data redundancy? What are the problems associated with it?

2.   How do data base management systems overcome the problems associated with data

redundancy?

3.   How do database management systems ensure data security and privacy?

4.   What is data model? Name various data model?

5.   Define the following terms:

(I) DBMS (vi) domain

(ii) View (vii) tuple

(iii) data security (viii) attribute

(iv) data integrity (ix) Degree

(v) Relation (x) cardinality

6.   What are views? How are they useful? 7.   What do you mean by referential Integrity? How it is enforced in DBMS? 8.   What is Key? Define the following keys-

(I) Primary key

(ii) Candidate key

(iii) Alternate key

(IV) Foreign key.

TYPE B : SHORT  ANSWER QUESTIONS 1.   What is Database Management System? Discuss its functions? 2.   Why DBMS is mostly used in IT applications. Discuss its advantages. 3.   What is Data Abstraction? Draw a diagram explaining various levels of data abstraction. 4.   What is meant by "Data independence"? Explain difference between Logical and Physical data independence. 5.   What do you mean by data model? Discuss various data model with their major characteristics.

INTRODUCTION TO MYSQL TYPE A : VERY SHORT  ANSWER QUESTIONS 1.   What is MySQL? By which company was MySQL developed? 2.   Who is chief developer of MySQL? What is name of dolphin logo of MySQL? 3.   What LAMP stands for? Write the use of its element applications. 4.   What types of commands are used in the following categories?

1. DDL 3. TCL

2. DML 4. System control commands

5.   What do you mean by Data dictionary? What it consist of? TYPE B : SHORT  ANSWER QUESTIONS 1.   What is MySQL? Describe its features? 2.   What is the use of SQL and MySQL? 3.   Differentiate between DDL and DML commands? 4.   What do you understand by client server architecture of MySQL? 5.   What is SQL? Discuss the different categories of commands of SQL? SIMPLE QUERIES IN SQL TYPE A: VERY SHORT ANSWER QUESTION 1.   What is data type? Name some data types available in MySQL. 2.   What are fixed length fields? What are variable length fields? 3.   Compare Char and Varchar data types? 4.   What is null value in MySQL database? Can you use nulls in arithmetic expressions? 5.   Which keyword eliminates the redundant data from a query result? 6.   Which keyword retains duplicate output rows in a query result? 7.   How would you display system date as the result of a query? 8.   How would you calculate 13*15 in SQL? 9.   Which function is used to substitute Null values in a query result? 10. Which operator concatenates two strings in a query result? 11. What command is used for- 1. To change/open a database           2. To view the table structure. 12. Which comparison operator is used for comparing? (i) Patterns          (ii) character value       (iii) null values      (iv) ranges        (v) list of values