NEW! CBSE Papers PDF: Class-X, Class-XII
Disclaimer: This website is not at associated with CBSE, For official website of CBSE visit - www.cbse.nic.in
CBSE AISSE 2017 Multimedia and Web Technology (Subject Code 067 Paper Code No. 89/1) Delhi Marking Scheme
Define RDBMS. Give any two examples of RDBMS.
A relational database management system (RDBMS) is a database management system
(DBMS) that is based on the Relational Model. Examples:
MS SQL Server
(1 mark for the correct definition)
+ (½ mark for each correct RDBMS example - any two from the above or any other valid RDBMS)
Define Candidate Key and Alternate Key.
All those attributes/group of attributes, which can uniquely identify a tuple are known as
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)
Explanation of the concept of Candidate Key and Alternate using example should also be acceptable.
Study the following data and answer the questions given below:
Name the fields, which can act as the primary key of this table:
(1 mark for the correct identification of Column/Field name) Note:
(½ mark to be awarded if City_name is mentioned)
What is the degree and cardinality of this table?
(½ mark for the correct Degree)
+ (½ mark for the correct Cardinality)
CBSE AISSE 2017 Multimedia and Web Technology (Subject Code 067 Paper Code No. 89) Outside Delhi Marking Scheme
Write any two advantages of using DBMS
(½ mark each for any two correct advantages) (Full marks for any other correct answer)
MySQL is a RDBMS. Is this statement true or false ?
(1 mark for correct answer)
Study the following data and answer the questions given below
What is the degree and the cardinality of CITY table ?
Degree - 3
Cardinality - 7
(½ mark for each correct answer)
Name the fields, which can act as the primary key in STATE table.
(1 mark for the correct identification of Column/Field name)
What type of relationship exists between these two tables?
ONE TO MANY
Give the full form of GIF.
Graphical Interchange Format
(1 mark for correct answer) NOTE:
(½ mark to be awarded for expanding any two characters)
Name any two popular sound formats that are mostly used while designing web pages.
NEW! GET EMAIL ALERTS
CBSE Sample Papers
Home | CBSE-X | CBSE-XII | Papers | E-Books |
© 2020 - CBSEPORTAL.COM - India's First Online Community Website For CBSE Students.
CBSE X, CBSE XII, AIEEE, AIPMT - Papers, Mock Exams, Books, Results and More...
Disclaimer: cbseportal.com is not at associated with CBSE, For official website of CBSE visit - www.cbse.nic.in