1 . దసరాలకు చెందాలనిచ్చే రివాజు ఉంది. (గీత గిసిన పదానికి ఆర్థి
A) లంచం
Bఅలవాటు. సంప్రదాయం అవ్పాటు
Answers
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’.