CLASS XII: Unit 3 Question Bank

UNIT III

Chapter-13 EXTENSIBLE MARKUP LANGUAGE

S.No.	Concepts	Degree of Importance	Level	Errors Generally committed
1	Introduction to XML	**	L-1	The definition of HTML,XML,SGML May be Interchange
2	XML vs. Other Languages	****	L-1, L-2	Students Confused in Properties of HTML and XML
3	Feature of XML	**	L-2	Student confused b/w diff language futures
4	Working in XML	**	L-3	Error can occurred in tag writing

Level-I

1. What is a Markup language?

2. What is XML?

3. What is the use of XML?

4. What is meta language?

Level-2

1. Name some markup language based on XML

2. Compare HTML and XML Briefly

3. What is the features of XML

4. Write the name of two important software that validate or process XML document are?

Level-3

1. Create XML markup to represent a massage sent on October 9, 2009 to Rehana and Joseph by Gurpreet. The message is “Project successfully completed”.

2. Consider the following XML document. Check this for well-formed ness.

<email>

<to>Mrs.Gohil

<body> Hello there How are today?</to>

</body>

<sender> Dyan pearl</Sender>

</email>

My SQL Revision tour

SNO	CONCEPT	DEGREE OF IMPORTANCE	LEVEL OF ASSIGNMENT	ERROR
1	Different data models	*	L1	Give proper technical words
2	Relational model terminology	****	L1,2	Confusion about the different terminology. such as candidate key and alternate key.
3	Introduction to MySQL	**	L1	Generally no errors
4	My SQL and SQL	**	L1	Give proper technical words
5	MySQL elements	*	L1	Give proper technical words
6	Assessing Database in MySQL	**	L1,	Do not know how enter in the data base
7	Creating tables in MySQL	***	L1,2	Problem in giving data type and column name
8	Making simple queries through Select Command	*****	L1,2,3	Generally in combining two conditions and pattern matching
9	My SQL Function	**	L1,2
10	Creating table with SQL Constraints	*****	L1,2,3	Check and default constraint
11	Viewing Table structure	*	L1	Generally no errors
12	Modifying Data from table	*****	L1,2,3	Problem in setting the values
13	Altering tables	*****	L1,2,3	Confusion in alter and update command
14	Dropping tables	**	L1	Do not make the table empty while dropping the table

LEVEL - 1

1. Difference between Primary Key and candidate key?

2. Why is Foreign Key required?

3. What is referential Integrity Constraint?

4. Define and differentiate Cardinality and Degree.

5 Define the terms attribute and tuple.

6 What is the significance of using view?

7 What is difference between primary Key and unique key?

8 What is the use of NULL in SQL?

9. Difference between candidate key and alternate key.

10. Write down the syntax of Select query.

LEVEL - 2

1. What are features of MY SQL?

2. What is difference between Char and Varchar?

3. Differentiate between DDL and DML.

4. What is purpose of using MY SQL?

5. Display empno and ename of all employees from table emp.

6. Display Ename,sal and sal added with comm from table emp

7. Write a query to display employee name, salary and department number who are not getting

commission from table empl.

8. List the details of all employees whose salary is between 25000 and 40000.

9. List the details of employees who earn more commission than their salaries.

10. Write a query to display the name of employee whose name contains 'A' as third alphabet.

LEVEL – 3

1. Answer the following questions based on the table CLUB given below:

TABLE :CLUB

Column Name	Data Type	Size	Constraints	Description
Member_No Member_Name Address Age Type Fees	Number Varchar2 Varchar2 Number Varchar2 Number	5 40 30 2 10 6,2	Primary Key Not Null >=18	Member number Name of the member Address of he member Age of the member Type of membership (Temp or Permanent) Membership fees

(a) Write the SQL command to create the table CLUB including the constraints.

(b) Insert two tuples.

(c) Write the SQL command to display the details of all the members whose type is “Permanent” and fees is more than Rs. 5000.

(d) Write SQL query to add a new column called Phno.

(e) Change the fees rate by 10% if the membership is of type “Temp”

(f)Write The SQL command to display all the details of all the members whose age is grater than eighteen.

2. Study the following table and then answer the given questions

TEACHERS

NUMBER	NAME	AGE	DEPARTMENT	DATEOFJOIN	SALARY	SEX
1	JUGAL	34	COMPUTER	10/01/97	12000	M
2	PRATIGYA	31	HISTORY	24/03/98	20000	F
3	SANDEEP	32	MATHS	12/12/96	30000	M
4	SANGEETA	35	HISTORY	01/07/99	40000	F
5	SATTI	42	MATHS	05/09/97	25000	M
6	SHYAM	50	HISTORY	27/06/98	30000	M
7	SHIV OM	44	COMPUTER	25/02/97	21000	M
8	SHALAKHA	33	MATHS	31/07/97	20000	F

Write SQL commands for the following:

To show all the information about the teacher of History department.
To list the names of female teachers who are in Hindi department.
To list the names of the teachers with their date of joining in ascending order.
To list the details of all the teachers who’s salary is between 20000 to 35000.
To list Name, age, department of all teachers. This information should be sorted on Department.
To find out the average salary of all the teachers.
To find out the average salary of all the departments.
To find out the departments for which the total salary is more than 50000.
To find out the average salary given to each sex.
Write command to list structure of above table.

3. Consider the table given just above and write cardinality and degree of that

table.(teacher table)

4. Suppose I have added one more column and 4 more rows in the above given table(teacher table) than what will be the degree and cardinality of that table

5. Study the following table and then answer the given questions:

Table : SchoolBus

Rtno	Area_covered	Capacity	Noofstudents	Distance	Transporter	Charges
1	Vasant kunj	100	120	10	Shivamtravels	100000
2	Hauz Khas	80	80	10	Anand travels	85000
3	Pitampura	60	55	30	Anand travels	60000
4	Rohini	100	90	35	Anand travels	100000
5	Yamuna Vihar	50	60	20	Bhalla Co.	55000
6	Krishna Nagar	70	80	30	Yadav Co.	80000
7	Vasundhara	100	110	20	Yadav Co.	100000
8	Paschim Vihar	40	40	20	Speed travels	55000
9	Saket	120	120	10	Speed travels	100000
10	Jank Puri	100	100	20	Kisan Tours	95000

(a) To show all information of students where capacity is more than the no of student in order of Rtno.

(b) To show area_covered for buses covering more than 20 km., but charges less then 80000.

(d) Add a new record with following data:

(11, “ Moti bagh”,35,32,10,” kisan tours “, 35000)

(e) Give the output considering the original relation as given:

(i) Select sum (distance) from schoolbus where transporter= ‘ Yadav travels’;

(ii) Select min (noofstudents) from schoolbus;

(iii) Select avg(charges) from schoolbus where transporter= ‘Anand travels’;

(iv) Select distinct transporter from schoolbus;

6. Study the following table and then answer the given questions:

TABLE : GRADUATE

S.NO	NAME	STIPEND	SUBJECT	AVERAGE	DIV.
1	KARAN	400	PHYSICS	68	I
2	DIWAKAR	450	COMP. Sc.	68	I
3	DIVYA	300	CHEMISTRY	62	I
4	REKHA	350	PHYSICS	63	I
5	ARJUN	500	MATHS	70	I
6	SABINA	400	CEHMISTRY	55	II
7	JOHN	250	PHYSICS	64	I
8	ROBERT	450	MATHS	68	I
9	RUBINA	500	COMP. Sc.	62	I
10	VIKAS	400	MATHS	57	II

(a) List the names of those students who have obtained I DIV sorted by NAME.

(b) Display a report, listing NAME, STIPEND, SUBJECT and amount of stipend received in a year assuming that the STIPEND is paid every month.

(c) To count the number of students who are either PHYSICS or COMPUTER SC graduates.

(d) To insert a new row in the GRADUATE table:

11,”KAJOL”, 300, “computer sc”, 75, 1

(e) Give the output of following sql statement based on table GRADUATE:

(i) Select MIN(AVERAGE) from GRADUATE where SUBJECT=”PHYSICS”;

(ii) Select SUM(STIPEND) from GRADUATE WHERE div=2;

(iii) Select AVG(STIPEND) from GRADUATE where AVERAGE>=65;

(iv) Select COUNT(distinct SUBDJECT) from GRADUATE;

7. Write a SQL commands for table FURNITURE

Table: FURNITURE

ITEMNO	ITEMNAME	TYPE	DATEOFSTOCK	PRICE	DISCOUNT
INT	VARCHAR	VARCHAR	DATE	INT	INT
5	20	20	-	6	2
Primary Key	Not Null	Reference to TYPE column of item table	Default ’10-03-10’	Price < 40,000	Not Null

a). Write a MYSQL Command to create a furniture table including all

constraints.

b). On the FURNITURE table, ITEMNO is the primary key. TYPE is the ITEM

type of furniture and refers to the TYPE column of ITEM Table. The

DISCOUNT is a NOT NULL column.

c) Evaluate this DELETE statement:

DELETE ITEMNO, TYPE, DISCOUNT FROM FURNITURE WHERE

ITEMNAME=‘CHAIR’;

Why does the DELETE statement fail when you execute it?

8. What is the difference between delete and drop command in SQL.

9. What is the difference between Alter and Update command in SQL

10. Aryan made a table “Employee” with attributes E_No, E_name and Salary. He did not made any primary key at the time of creation. Can you suggest some solution query to this problem.

UNIT-III

CHAPTER-15 Concept of Database Transactions

S.N	Concept	Degree of importance	Level of assignment	Error
1	Transaction execution	***	L2	Definition not well explained
2	Transaction properties	***	L2	Mismanaged meaning of four properties of each transaction
3	Transaction control commands (Begin/start transaction, commit, savepoint, rollback)	***	L2	Syntax written is normally wrong

Level 2

What is a database transaction? What TCL commands are separately by SQl?
What are ACID properties? Explain individual term separately?
Explain commit, rollback and savepoint statements.
Which statement is implicitly committed?
Explain the difference between ROLLBACK and COMMIT.

Practical questions of Level 2:

1. Expain how the following SQL script would affect a table.

START TRANSACTION
UPDATE…
INSERT…
SAVEPOINT S1
INSERT…
SAVEPOINT S2
DELETE….
ROLLBACK WORK TO SAVEPOINT S2
UPDATE…
ROLLBACK WORK TO SAVEPOINT S1
UPDATE….
DELETE…..
COMMIT WORK

2. Given a table emp(empid, name,salary) , determine the which changes will become permanent, and what will be the content of table emp after last statement.

a. BEGIN TRANSACTION

b. INSERT INTO EMP(1001,’AMITA’,40000);

c. DELETE FROM EMP;

d. ROLLBACK

e. BEGIN

f. INSERT INTO EMP(1001,’AKASH’,34000);

g. UPDATE EMP SET SALARY=SALARY*.01+SALARY ;

h. COMMIT

i. BEGIN

j. INSERT INTO EMP(1002,’AKASHY’,24000);

k. ROLLBACK WORK

l. UPDATE EMP SET VALUE=50000WHERE EMPID=1002

m. COMMIT WORK

UNIT-III

Chapter-14 MYSQL REVISION TOUR

Sr. No.	Concepts	Degree of Importance	Level of Assignments	Errors Analysis
1.	Introduction	**	L-1	Definition of data, information, database, DBMS are confusing and not compared properly.
2	DBMS	**	L-2	Advantages and disadvantages of DBMS are not written properly
3	RDBMS	***	L-1	-Confusion in Row, column, - Confusion between cardinality, degree and domain of a relation -Confusion in fields and records of table -Confusion in weak entity, strong entity -Confusion among different keys.
4	Introduction to My SQL	***	L-1, L-2	- Confusion in Full form of SQL -Confusion in comparison of MySQL & SQL
5	Data Types	**	L-2	-Confusion between char or varchar datatypes. -Always mistake when Dates are inserted into table.
6	SQL Commands	*****	L-1, L-2	- Always mistake when queries are written as on of following- Comma, From , Or, and , between, in, “%__”, “__fd” etc

Level-I

1. Write output of the following

(i) SELECT ROUND(29.21), Round(32.76);

(ii) Select Trim(‘ kv pinjore …..’);

2. What are the advantages of using a DBMS?

3. Differentiate Drop table and Drop Database.

4. What is the foreign key?

5. What is MY SQL?

6. What is the difference between Single Row Functions and Aggregate functions?

7. Why to use a Group by clause? Explain with example.

8. Answer the following question based on the given Table

TEACHERS

NUMBER	NAME	AGE	DEPARTMENT	DATEOFJOIN	SALARY	SEX
1	JUGAL	34	COMPUTER	10/01/97	12000	M
2	PRATIGYA	31	HISTORY	24/03/98	20000	F
3	SANDEEP	32	MATHS	12/12/96	30000	M
4	SANGEETA	35	HISTORY	01/07/99	40000	F
5	SATTI	42	MATHS	05/09/97	25000	M
6	SHYAM	50	HISTORY	27/06/98	30000	M
7	SHIV OM	44	COMPUTER	25/02/97	21000	M
8	SHALAKHA	33	MATHS	31/07/97	20000	F

Write SQL commands for the following:

xi. To show all the information about the teacher of History department.

xii. To list the names of female teachers who are in Hindi department.

xiii. To list the names of the teachers with their date of joining in ascending order.

xiv. To list the details of all the teachers who’s salary is between 20000 to 35000.

xv. To list Name, age, department of all teachers in ascending order of department.

xvi. To find out the average salary of all the teachers.

xvii. To find out the average salary department wise.

xviii. To find out the departments for which the total salary is more than 50000.

xix. To find out the average salary given to each sex.

xx. To show the structure of above table.

Level-II

1. What do you mean by referential integrity? How is it enforced in databases?

2. Explain PRIMARY KEY constraint with example.

3. Differentiate between DDL and DML commands?

4. Differentiate between Char and Varchar data types.

Chapter 17

Table and Integrity Constraints

S.No.	Concept	Degree of importance	Levels of Assignment	Errors generally committed
1	Integrity Constraints	****	L-1,L-2,L-3	-Incorrect table definition
2	Creating table with constraints	*****	L-1	-missing datatype or size -improper placement of constraint -difference in table and column constraint
3	Alter table with constraints	***	L-1,L-2	-where to use add and modify in alter -confusion in alter and update
4	Enabling/disabling constraint	*	L-1
5	Dropping table	***	L-1	-confusion in delete and drop

Level 1

What is a constraint?
Name some constraints to enhance database integrity.
What is a primary key? Can you have multiple primary keys in a table?
What is a foreign key constraint? Can you have multiple foreign key constraints in a table?
What is the use of NOT NULL constraint?
When a primary key is included in a table, what other constraints does this imply?
Write the syntax to create table with Primary Key?
What is the use of check constraint?
When the default constraint is used?
How to permanently remove a table from database?

Level 2

While creating a table 'Dept' Anuj forgot to set the primary key for the table. Give the statement which she should write now to set the column 'DeptID' as the primary key of the table.

2. Amit, a student of Class XII created a table 'Book'. Price is a column of that table. To find the details of books whose price has not been entered, he entered the following query

Select * from Book where price=NULL;

Help him to remove the error from the query by rewriting it.

In a student table, out of Roll NUmber, Name, Address which column can be set as Primary Key and why?
What is the difference between table and column constraints?
What is a composite primary key?
What is the meaning of cascade in foreign key?
How to a)add columns to an existing table ,b) modify column definition of table and c) delete columns of table?
Can we add primary key on an already existing table?
Is it possible to remove a primary key from a table? If yes, how?
Write the query to display columns and their constraints.
Do we need to specify NOT NULL integrity constraint for a column defined as primary key in MySQL?
Create table for following relation address (city,state,pin)
Define the reason for defining foreign key

Level 3

1. While defining a constraint, which keyword specifies that if a DELETE or UPDATE operation affects a row from parent table, then set the foreign key column(s) in child table to NULL

2. Which statement about constraint is true?

a. A single can have one constraint applied.

b. UNIQUE constraints are identical to PRIMARY KEY constraints

c. NOT NULL constraints can only be specified at the column level

3. In the following table definition, which line will create error and why?

1. create table part(

2. part_id int,

3. part_name varchar(25),

4. cost float(7,2),

5. constraint cost_cn NOT NULL (cost));

4. Can you disable PRIMARY KEY constraint in MySQL?

5. How to disable/enable foreign key?

6. Delete the foreign key constraint namely fk1 from the table a1.

7. Name the integrity terms that following constraints implement:

a. NOT NULL

b. FOREIGN KEY

8. Which of the following FOREIGN KEY constraint keywords identifies the table and column in the parent table?

a. RESEMBLES

b. ON DELETE CASCADE

c. REFERENCES

9. What must exist on parent table before MySQL allows us to create FOREIGN KEY constraint?

10. What is self referencing table?

UNIT -4

IT APPLICATION

S. No	Concepts	Degree of Importance	Levels of Assignment	Errors generally committed
1.	Introduction to E-Governance, E-Business, E-Learning	*	L 1	Definition of E-Governance, E-Business, E-Learning is not cleared properly, unable to differentiate properly.
2.	GUI and its Importance	*	L 1	Error to differentiate in Front-end and back-end interface, unable to mention the importance of GUI.
3.	Front-end Interface	*******	L 2	Error to identify different controls used in Front-end. Committed error to extract data while interacting with programming
4.	Back-end Database	*******	L 3	Error to define the usage of back-end in case of GUI application.
5.	Front-end and Database Connectivity	**	L 1	Error to make connection in b/w of Front-end and Back-end.

LEVEL-1

1. What is front end application?

2. What is back end application?

3. What is e-Governance?

4. What is e-Learning?

5. What do you mean by E-Business?

6. Data validation is one of the important activities. Justify the statement.

7. In Java and MySQL interfacing, which is used as front end which as back end? Explain.

8. What are different kinds of E-business?

9. What is interface?

10. list Component of data Entry.

LEVEL-2

1. What are the objectives of E Governance?

2. List the advantages of E Governance.

3. Give the social impact of E Governance?

4. How E-learning is useful to organisation.

5. How E-learning is useful to learner.

6. What are the various components for data entry?

7. What is advantage of interfacing?.

8. Why E-learning is preferred?

9. What are the importances of E-business?

10. What are the different methods of data entry?

LEVEL-3

1. What is the front end and back end in Java?

2. Differentiate between front-end testing and backend testing.

3. How E-learning is useful to trainer. Why e-learning is used.

4. How has our society benefited from e-governance? Write 2 points

5. Is E Governance. Better than normal Governance. Explain.

6. How can Java be interfaced with MySql?

7. What advantage does e-learning offers as compared to normal learning?

8. How does e-business improve customer satisfaction- Write one point.

9. Mr. Das is working as a Manager in the Shivam Enterprises. He wants to create a form with following functions. Choose appropriate controls from Text box, Label, Option button, Check box, List box, Combo box, Command button and write in the third column:

10.

Sno	Control used to :	Control
1. 2. 3. 4. 5.	Enter the name, Address, Basic salary Select the Gender (M/F) Select the department from the available list Choose type of employee (Permanent / Regular) Display the picture of the employee

Develop a GUI application to perform data input operation using front-end and back-end tools.

CLASS XII

Tuesday, 31 January 2017

Unit 3 Question Bank

No comments:

Post a Comment