c) Baud rate is used to measure the modulation rate i.e. the number of discrete signaling events per second. d) E-mail stands for Electronic Mail. It is a network address provided by a portal offering e-mail services. This address is same as our postal address. E-mail address is used to send or receive the mails. The format of an e-mail address is “username@hostname” Example: amit@extramarks.com Here the username is amit and the host name is extramarks.com. e) (i) To transfer a file from your computer to your home directory on the host system is called uploading a file. FTP software is used for it. (ii) The WWW(world wide web) is a set of protocols that allow you to access any document on the internet througj a naming system based on the WWW. MODEL PAPER 3 a) What is UPDATE command? Explain. b) Expand DDL and DML. c) Write SQL commands: DOCTOR ID NAME DEPT SEX SHIFT 1 VIBHA AGGARWAL GYN F MOR 12 2 VISHAL GOYAL ENT M MOR 10 3 PRANAV BANSAL ENT M EVE 09 4 MOHINI GUPTA ORT F EVE 09 5 ROHINI GARG ORT F EVE 12 6 ASTHA SINGHAL ENT F MOR 14 7 RICHA GUPTA GYN F EVE 10 8 MRIDUL BANSAL SKIN M MOR 05 i) To show all the records from GYN DEPT. ii) To show the record of all doctors visiting in morning shift. iii) To show all the records of male doctors. iv) To show the records of female gynaecologists. v) To show the records of doctors having more than 12 years of experience. [2+1+5 = 8] Marks:8
c) Baud rate is used to measure the modulation rate i.e. the number of discrete signaling events per second. d) E-mail stands for Electronic Mail. It is a network address provided by a portal offering e-mail services. This address is same as our postal address. E-mail address is used to send or receive the mails. The format of an e-mail address is “username@hostname” Example: amit@extramarks.com Here the username is amit and the host name is extramarks.com. e) (i) To transfer a file from your computer to your home directory on the host system is called uploading a file. FTP software is used for it. (ii) The WWW(world wide web) is a set of protocols that allow you to access any document on the internet througj a naming system based on the WWW. MODEL PAPER 3 a) What is UPDATE command? Explain. b) Expand DDL and DML. c) Write SQL commands: DOCTOR ID NAME DEPT SEX SHIFT 1 VIBHA AGGARWAL GYN F MOR 12 2 VISHAL GOYAL ENT M MOR 10 3 PRANAV BANSAL ENT M EVE 09 4 MOHINI GUPTA ORT F EVE 09 5 ROHINI GARG ORT F EVE 12 6 ASTHA SINGHAL ENT F MOR 14 7 RICHA GUPTA GYN F EVE 10 8 MRIDUL BANSAL SKIN M MOR 05 i) To show all the records from GYN DEPT. ii) To show the record of all doctors visiting in morning shift. iii) To show all the records of male doctors. iv) To show the records of female gynaecologists. v) To show the records of doctors having more than 12 years of experience. [2+1+5 = 8] Marks:8
1329804769qno_5,6,7.docx