Page 41 - IP

i. Are these tags part of HTML code or XML code?
ii. Identify the root element.
iii. Mention any two child elements.
iv. Mention any two attributes.
OR
Mention any two main differences between HTML and XML. Also mention
any two main features of XML for which it’s used extensively now a days.

Ans: XML code
i. Company
ii. name, dept
iii. eid, deptid

(1 Mark for each correct answer)

OR

Two main differences between HTML and XML:
 HTML is used to display data and to focus on formatting of data, whereas XML
is used to describe data and focus on what data is.
 HTML tags are predefined, whereas XML tags are not predefined. We create
our own tags in XML as per the requirement.

(1 Mark for each correct difference point)

Two main features of XML for which it’s used extensively now a days:
 XML is used to store data.
 XML is used to exchange data.

(1 Mark for each correct feature)

3. (a) What is the purpose of SQL? 1
Ans: SQL is structured query language. It is a standard language of all the RDBMS.

(1 Mark for correct answer)

(b) Mr. Manav, a database administrator in “Global Educational and Training
Institute” has created following table named “Training” for the upcoming
training schedule:
Training

Traini Name Email_Id Topic City Fee
ng_Id
ND01 Mr. Rajan raj@gmail.com Cyber New 10000
Security Delhi 4
GU01 Ms. urv@yahoo.co ICT in Gurugram 15000
Urvashi m Education
FD01 Ms. Neena neenarediff.com Cyber Faridabad 12000
Security
ND02 Mr. Vinay NULL ICT in New 13000
Education Delhi
GU02 Mr. nav@gmail.co Cyber Gurugram NULL
Naveen m Security

4