Question

26
'धरणी' एतस्य अर्थः अस्ति--
(1 Point)
● भूमि
भूरी
भवनम्​

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’.