Computer Science 083 Term – II Answer Key
Answer Key
SECTION – A
Question 1 – Answer
LIFO, pop(), List.pop()
Question 2 – Answer
(i) VOiP = Voice Over Internet Protocol, PPP – Point-to-Point Protocol
(ii) PAN
Question 3 – Answer
Attribute – the columns of a relation are the attributes that are also referred to as fields.
Domain – It is a set of values from which an attribute can take a value in each row a data type is used to specify the domain for an attribute.
Question 4 – Answer
M1002#Pratik
M1004#Rakesh
Question 5 – Answer
SQL Output
(a)
| Name | Age |
| Harjot | 55 |
| Srikanth | 43 |
(b)
| CITY | COUNT(*) |
| Delhi | 2 |
| Mumbai | 2 |
| Kolkata | 1 |
(c)
| DISTINCT City |
| Delhi |
| Mumbai |
| Kolkata |
(d)
| MAX(Dose1) | MIN(Dose2) |
| 2022-01-01 | 2021-07-20 |
Question 6 – Answer
SQL Output
(a)
| DNAME | PNAME |
| AMITABH | NOOR |
| AMITABH | HARMEET |
| ANIKET | ANNIE |
(b)
| PNAME | ADMDATE | FEES |
| NOOR | 2021-12-25 | 1500 |
| HARMEET | 2019-12-20 | 1500 |
Question 7 – Answer
Candidate keys – attributes that can be used to uniquely identify the tuples in the relation, are called candidate keys.
Primary Keys – Out of one or more candidate keys, the attribute chosen to uniquely identify the tuples in a relation is called the primary key.
OR
(a) Primary Key : PNO
(b) Degree – number of columns / attributes / fields in a relation, is called degree of table. Degree of table PLAYER is 3.
SECTION – B
Question 8 – Answer
OR
Question 9 – Answer
(i) ALTER TABLE ITEMS DROP DISCOUNT;
(ii) DDL – CREATE, DROP
DML – UPDATE, INSERT
Question 10 – Answer .
(a) USE LIBRARY;
(b) SHOW TABLES;
(c) DESC BOOKS; OR DESCRIBE BOOKS;
SECTION – C
Question 11 – Answer
(a) UPDATE FLIGHT SET FARE = 6000 WHERE FNO = ‘F104’ ;
(b) SELECT GENDER, COUNT(*) FROM PASSENGER GROUP BY GENDER;
(c) SELECT NAME, FARE, F_DATE FROM FLIGHT F , PASSENGER P WHERE P.FNO = F.FNO AND START = ‘DELHI’ ;
(d) DELETE FROM FLIGHT WHERE END = ‘MUMBAI;
Question 12 – Answer
(i) Tree Topology vs Bus Topology
| TREE TOPOLOGY | BUS TOPOLOGY |
| The nodes are organized in the form of a tree. Tree topology provides high security | Each included node is connected to a single cable which is known as the backbone. Security is very low in bus topology |
Advantages of Bus Topology
- All the nodes are connected directly, so a very short cable length is required.
- The architecture is very simple, reliable, and linear.
- Bus topology can be extended easily on either side.
Advantages of Tree Topology
- The tree topology simulates the hierarchical flow of data. So, it is suitable for applications, where a hierarchical flow of data and control is required.
- We can easily extend the network.
- Faulty nodes can easily be isolated from the rest of the network.
OR
HTML vs XML
HTML stands for HyperText Markup Language which is a language used to describe the structure of a web page. It consists of various HTML element which is composed of HTML tags and their content. In HTML, closing tags are not necessary.
XML stands for eXtensible Markup Language which is a language used to transfer data not to structure data. Closing tags are necessary.
Question 12 – Answer
(ii) Web browser is application software, which is use to open web pages or websites. It is a client application, which fetches the information from the web server.
Two commonly used web browsers are:-
Google Chrome, Mozilla Firefox, Internet Edge, Opera Mini.
Question 13 – Answer
(i) REPEATER
(ii) SWITCH
(iii) VOiP
(iv) Star Topology
