Page 32 - IP

(c) 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.

3. (a) What is the purpose of SQL? 1

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

Training

Training_Id Name Email_Id Topic City Fee
ND01 Mr. Rajan raj@gmail.com Cyber New Delhi 10000
Security
GU01 Ms. Urvashi urv@yahoo.com ICT in Gurugram 15000
Education
FD01 Ms. Neena neenarediff.com Cyber Faridabad 12000
Security
ND02 Mr. Vinay NULL ICT in New Delhi 13000
Education
GU02 Mr. Naveen nav@gmail.com Cyber Gurugram NULL
Security
Help him in writing SQL query for the following purpose:
i. To count how many female candidates will be attending the training.
ii. To display list of free trainings.
iii. To display all the cities where Cyber Security training is scheduled along with
its fee.
iv. To add a column feedback with suitable data type.

(c) Observe the table named “Training” given above carefully and predict the output of the 4
following queries:
i. select city from training where topic = 'Cyber Security';
ii. select count(Training_Id) from training where email_id like '%gmail% ';
iii. select AVG (Fee) from training where Topic = 'Cyber Security';
iv. select name from training where INSTR (Email_Id, '@’)=0;

(d) What is the degree and cardinality of the above given table named ‘Training’. 1

4. (a) Shiva has placed two radio button on a payment form designed in NetBeans to accept 1
mode of payment one out of cash or card. To his surprise, during runtime, a customer is
able to select both the options for a single transaction. What went wrong?

OR
(a) Mention any one advantage of jCheckBox control over jRadioButton control.

(b) Prachi is working with following swing controls: 1

jButton, jLabel, jTextField, jCheckBox.
Suggest her any two basic methods commonly available with all the four controls
mentioned above.
OR
(b) How jLabel is different from jTextField control at run time?

3