| Q 1: | Which level of database is closest to the user |
| (1) | Physical |
| (2) | Conceptual |
| (3) | Internal |
| (4) | External or View based |
| Correct Answer: External or View based | |
| Q 2: | If K is a foreign key in a relation R1 then |
| (1) | Every tuple of R1 has a distinct value for K |
| (2) | K cannot have a null value for tuples in R1 |
| (3) | K is a key for some other relation |
| (4) | K is a primary key for R1 |
| Correct Answer: K is a key for some other relation | |
| Q 3: | Consider the relations: Supplier (Sno, S_name, city) and Item (Item_no, Item_name, Item_Brand, S_no) Which of the following SQL statement gives suppliers names who have submitted at least one 'Nestle' brand item? |
| (1) | SELECT S_name FROM supplier S, Item I WHERE I. Item_Brand = 'Nestle'; |
| (2) | SELECT S_name FROM Supplier S WHERE S_no IN (SELECT S_no FROM Item WHERE Item_Brand = 'Nestle'); |
| (3) | SELECT S_name FROM Supplier S WHERE Item_Brand = 'Nestle', |
| (4) | SELECT S_name FROM Supplier WHERE S_no EXISTS (SELECT S_no FROM Supplier, Item WHERE Item_Brand = 'Nestle'); |
| Correct Answer: SELECT S_name FROM Supplier S WHERE S_no IN (SELECT S_no FROM Item WHERE Item_Brand = 'Nestle'); | |
| Q 4: | For sliding window of size n-1 (n sequence numbers) there can be maximum of ............... frames sent but unacknowledged. |
| (1) | 0 |
| (2) | n-1 |
| (3) | n |
| (4) | n+1 |
| Correct Answer: n-1 | |
| Q 5: | An ATM cell has the payload field of...... bytes |
| (1) | 53 |
| (2) | 48 |
| (3) | 64 |
| (4) | 56 |
| Correct Answer: 48 | |
| Q 6: | Which protocol is used to configure host computers automatically for obtaining IP? |
| (1) | DNS |
| (2) | HDLC |
| (3) | ICMP |
| (4) | DHCP |
| Correct Answer: DHCP | |
| Q 7: | What protocols are used to configure trunking on a switch |
| (1) | VLAN |
| (2) | 802.1Q |
| (3) | ISL |
| (4) | ISL & 802.1Q |
| Correct Answer: ISL & 802.1Q | |
| Q 8: | When data is encapsulated, which is the correct order? |
| (1) | Data, frame, packet, segment, bit |
| (2) | Segment, data, packet, frame, bit |
| (3) | Data, segment, packet, frame, bit |
| (4) | Data, segment, frame, packet, bit |
| Correct Answer: Data, segment, packet, frame, bit | |
| Q 9: | In TCP, a unique sequence number is assigned to each |
| (1) | Bytes |
| (2) | Message |
| (3) | Segment |
| (4) | Word |
| Correct Answer: Bytes | |
| Q 10: | In a Go-Back-N ARQ, if the window size is 63 what is the range of sequence numbers? |
| (1) | 0 to 63 |
| (2) | 0 to 64 |
| (3) | 1 to 63 |
| (4) | 1 to 64 |
| Correct Answer: 0 to 63 | |