CBSE Class-12 Exam 2017 : Marking Scheme, Multimedia and Web Technology
Disclaimer: This website is NOT associated with CBSE, for official website of CBSE visit - www.cbse.gov.in
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:
|
|
|
|
(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 |
|
|
|
|
|
(½ 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
|
|
|
|
(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 |
