Question

which of the following tells the spreadsheet to subtract the value in the cell A4 from the value in the cell A3
a4-a3=
a3-a4=
=a4-a3
=a3-a4 ​

Answer 1

Answer:

consider the following table and answer the following :

ID Department OPD_DAYS Doctor_Name

H201 ENT MWF Akaash Arora

H308 Oncology TTS Dharma Sharma

H907 Paediatrics MWF Sanjay Singh

(a)

Identify suitable Primary Key from the above table.

(b)

Add a new record with the following data :

(‘H608’, ‘Cardiology’, ‘TTS’, ‘Vinita Wahi’)

(c)

Write a select query to display records of those Doctors whose OPD_DAYS are

‘MWF’.

Explanation:

consider the following table and answer the following :

ID Department OPD_DAYS Doctor_Name

H201 ENT MWF Akaash Arora

H308 Oncology TTS Dharma Sharma

H907 Paediatrics MWF Sanjay Singh

(a)

Identify suitable Primary Key from the above table.

(b)

Add a new record with the following data :

(‘H608’, ‘Cardiology’, ‘TTS’, ‘Vinita Wahi’)

(c)

Write a select query to display records of those Doctors whose OPD_DAYS are

‘MWF’.