CBSE Class-12 Exam 2017 : Marking Scheme, Multimedia and Web Technology

Class 12 papers

CBSE Class-12 Exam 2017 : Marking Scheme

Question Paper, Multimedia and Web Technology

CBSE Class-12 Exam 2017 :  Multimedia and Web Technology (Delhi)

CBSE AISSE 2017 Multimedia and Web Technology (Subject Code 067 Paper Code No. 89/1) Delhi Marking Scheme

 

Important Note:

  • All answers provided in the Marking scheme are SUGGESTIVE.
  • Examiners are requested to accept all possible alternative correct answer(s).
  • Wherever HTML Tags are asked – ignore the format/additional arguments if so given in the answer(s)
  • Wherever multiple answers are suggested, they are in order of appropriateness

1.

(a)

Define RDBMS. Give any two examples of RDBMS.

2

 

Ans

A relational database management system (RDBMS) is a database management system

(DBMS) that is based on the Relational Model. Examples:

MySQL Oracle

MS SQL Server

SyBase

IBM DB2

 

 

 

(1 mark for the correct definition)

+   (½ mark for each correct RDBMS example - any two from the above or any other valid RDBMS)

 

 

(b)

Define Candidate Key and Alternate Key.

1

 

Ans

All those attributes/group of attributes, which can uniquely identify a tuple are known as

Candidate Keys.

 

Candidate Key(s), which is/are not primary key is/are alternate key

 

 

 

(½ mark for the correct Definition of Candidate Key)

+   (½ mark for the correct Definition of Alternate Key)

 

Note:

Explanation of the concept of Candidate Key and Alternate using example should also be acceptable.

 

 

(c)

Study the following data and answer the questions given below:

up-tourism-to-develop-uttar-pradesh-1st-ropeway-in-vindhyachal-and-chitrakoot-img.jpg

 

 

 

(i)

Name the fields, which can act as the primary key of this table:

1

 

Ans

City_code

 

 

 

(1 mark for the correct identification of Column/Field name) Note:

(½ mark to be awarded if City_name is mentioned)

 

 

(ii)

What is the degree and cardinality of this table?

1

 

Ans

Degree: 3

Cardinality: 7

 

 

 

(½ mark for the correct Degree)

+    (½ mark for the correct Cardinality)

 

  

Click Here to Download

CBSE Class-12 Exam 2017 : Multimedia and Web Technology (Outside)

CBSE AISSE 2017 Multimedia and Web Technology (Subject Code 067 Paper Code No. 89) Outside Delhi Marking Scheme

 

Important Note:

  • All answers provided in the Marking scheme are SUGGESTIVE.
  • Examiners are requested to accept all possible alternative correct answer(s).
  • Wherever HTML Tags are asked – ignore the format/additional arguments if so given in the answer(s)
  • Wherever multiple answers are suggested, they are in order of appropriateness

1

(a)

Write any two advantages of using DBMS

1

 

Ans

  • Data Redundancy is controlled.
  • Data inconsistency is controlled.
  • Unauthorised access is restricted.
  • Provide backup and recovery.
  • Enforces integrity constraints.
  • Proving multiple user interface.

 

 

 

(½ mark each for any two correct advantages) (Full marks for any other correct answer)

 

 

(b)

MySQL is a RDBMS. Is this statement true or false ?

1

 

Ans

True

 

 

 

(1 mark for correct answer)

 

 

(c)

Study the following data and answer the questions given below

up-tourism-to-develop-uttar-pradesh-1st-ropeway-in-vindhyachal-and-chitrakoot-img.jpg

 

 

(i)

What is the degree and the cardinality of CITY table ?

1

 

Ans

Degree - 3

Cardinality - 7

 

 

 

(½ mark for each correct answer)

 

 

(ii)

Name the fields, which can act as the primary key in STATE table.

1

 

Ans

State_Code

 

 

 

(1 mark for the correct identification of Column/Field name)

 

 

(iii)

What type of relationship exists between these two tables?

1

 

Ans

ONE TO MANY

 

 

 

(1 mark for correct answer)

 

 

(d)

Give the full form of GIF.

1

 

Ans

Graphical Interchange Format

 

 

 

(1 mark for correct answer) NOTE:

(½ mark to be awarded for expanding any two characters)

 

 

(e)

Name any two popular sound formats that are mostly used while designing web pages.

1

                                                        

Courtesy: CBSE