| Q 1: | Embedded SQL means |
| (1) | Using the EMBED key word in a SQL statement |
| (2) | Writing a SQL statement to retrieve data from more than one relation |
| (3) | Writing SQL statements within codes written in a general programming language |
| (4) | Specifying a condition and action to be taken in case the given condition is satisfied in a trigger |
| Correct Answer: Writing SQL statements within codes written in a general programming language | |
| Q 2: | An index is clustered, if |
| (1) | It is on a set of fields that include the primary key. |
| (2) | It is on a set of fields that form a candidate key. |
| (3) | The data record of the file are organized in the same order as the date entries of the index |
| (4) | The data records of the file are organized not in the same order as the data entries of the index |
| Correct Answer: The data record of the file are organized in the same order as the date entries of the index | |
| Q 3: | An IP router with a Maximum Transmission Unit (MTU) of 1500 bytes has received an IP packet of size 4404 bytes with an IP header of length 20 bytes. The values of the relevant fields in the header of the third IP fragment generated by the router for this packet are |
| (1) | MF bit: 0, Datagram Length: 1444; Offset: 370 |
| (2) | MF bit: 1, Datagram Length: 1424; Offset: 185 |
| (3) | MF bit: 1, Datagram Length: 1500; Offset: 370 |
| (4) | MF bit: 0, Datagram Length: 1424; Offset: 2960 |
| Correct Answer: MF bit: 1, Datagram Length: 1500; Offset: 370 | |
| Q 4: | Which is the correct statement related to Ethernet based network |
| (1) | Ethernet packet should be at least 64 bytes long for longest allowed segment and Max packet size can be 1500 bytes |
| (2) | Ethernet packet should be at least 32 bytes long for longest allowed segment and Max packet size can be 1024 bytes |
| (3) | Ethernet packet should be at least 16 bytes long for longest allowed segment and Max packet size can be 64 bytes |
| (4) | Ethernet packet should be at least 48 bytes long for longest allowed segment and Max packet size can be 1482 bytes |
| Correct Answer: Ethernet packet should be at least 64 bytes long for longest allowed segment and Max packet size can be 1500 bytes | |
| Q 5: | An Internet Service Provider (ISP) has following chunk of CIDR-based IP addresses available with it: 245.248.128.0/20. The ISP want to give half of this chunk of addresses to organization A and a quarter to Organization B while retaining the remaining with itself. Which of the following is a valid allocation of addresses to A and B? |
| (1) | 245.248.132.0/22 and 245.248.132.0/21 |
| (2) | 245.248.136.0/21 and 245.248.128.0/22 |
| (3) | 245.248.136.0/24 and 245.248.132.0/21 |
| (4) | 245.248.128.0/21 and 245.248.128.0/22 |
| Correct Answer: 245.248.136.0/21 and 245.248.128.0/22 | |
| Q 6: | We can take internet service by |
| (1) | Dial up and leased line |
| (2) | Leased line |
| (3) | Dial up |
| (4) | None |
| Correct Answer: Dial up and leased line | |
| Q 7: | Which of the following are used to generate a message digest by the network security protocols? 1. RSA 2. QHA-1 3. DES 4. MD5 |
| (1) | 1 and 3 |
| (2) | 2 and 3 |
| (3) | 2 and 4 |
| (4) | 3 and 4 |
| Correct Answer: 2 and 4 | |
| Q 8: | In a .............. ATM LAN, an ATM switch connects stations. |
| (1) | pure |
| (2) | legacy |
| (3) | mixed architecture |
| (4) | none |
| Correct Answer: pure | |
| Q 9: | In SONET, for each byte, the bits are transmitted..................... |
| (1) | from least significant to the most significant |
| (2) | from most significant to the least significatn |
| (3) | two at a time |
| (4) | three at a time |
| Correct Answer: from most significant to the least significatn | |
| Q 10: | In PPP ................ is a simple authentication procedure with a two-step process |
| (1) | NCP |
| (2) | LCP |
| (3) | CHAP |
| (4) | PAP |
| Correct Answer: PAP | |