| Q 1: | In SQL, which command is used to display data from two or multiple tables? | ||||||||
| (1) | LIST | ||||||||
| (2) | SELECT | ||||||||
| (3) | SHOW | ||||||||
| (4) | MULTIPLY | ||||||||
| Correct Answer: SELECT | |||||||||
| Q 2: | Data independence means | ||||||||
| (1) | data is defined sseparately and not included in programs. | ||||||||
| (2) | programs are not dependent on the physical attributes of data | ||||||||
| (3) | programs are not dependent on the logical attributes of data | ||||||||
| (4) | Both 2 and 3 | ||||||||
| Correct Answer: Both 2 and 3 | |||||||||
| Q 3: | Match the following?
| ||||||||
| (1) | 1-D,2-B,3-A,4-C | ||||||||
| (2) | 2-D,4-B,3-A,1-C | ||||||||
| (3) | 1-D,4-B,3-A,2-C | ||||||||
| (4) | 3-D,2-B,1-A,4-C | ||||||||
| Correct Answer: 1-D,2-B,3-A,4-C | |||||||||
| Q 4: |
| ||||||||
| (1) | The database system is both deadlock-free and starvation-free | ||||||||
| (2) | The database system is deadlock-free but not starvation-free | ||||||||
| (3) | The database system is starvation-free but not deadlock-free | ||||||||
| (4) | The database system is neither deadlock-free nor starvation-free | ||||||||
| Correct Answer: The database system is both deadlock-free and starvation-free | |||||||||
| Q 5: | Which of the following is a character oriented protocol? | ||||||||
| (1) | BISYNC | ||||||||
| (2) | SDLC | ||||||||
| (3) | HDLC | ||||||||
| (4) | TCP | ||||||||
| Correct Answer: BISYNC | |||||||||
| Q 6: | The address of a class B host is to be split into subnets with a 6 - bit subnet number. What is the maximum number of subnets and maximum number of hosts in each subnet | ||||||||
| (1) | 62 subnets and 1022 hosts | ||||||||
| (2) | 64 subnets and 1024 hosts | ||||||||
| (3) | 62 subnets and 254 hosts | ||||||||
| (4) | 64 subnets and 256 hosts | ||||||||
| Correct Answer: 62 subnets and 1022 hosts | |||||||||
| Q 7: | The Internet Control Message Protocol (ICMP)- | ||||||||
| (1) | Reports error condtion to the original source | ||||||||
| (2) | The source must relate errors to individual application programs | ||||||||
| (3) | Provides communication between the Internet Protocol Software on one machine and the Internet Protocol Software on another | ||||||||
| (4) | All of the above | ||||||||
| Correct Answer: All of the above | |||||||||
| Q 8: | IPSec requires a logical connection between two hosts using a signaling protocol called........... | ||||||||
| (1) | AS | ||||||||
| (2) | SA | ||||||||
| (3) | Both 1 and 2 | ||||||||
| (4) | None of the above | ||||||||
| Correct Answer: SA | |||||||||
| Q 9: | Which one is expensive and impractical without automated support? | ||||||||
| (1) | Release testing | ||||||||
| (2) | Regression testing | ||||||||
| (3) | Interface testing | ||||||||
| (4) | Component testing | ||||||||
| Correct Answer: Regression testing | |||||||||
| Q 10: | Halstead's source code metrics are based on the number of | ||||||||
| (1) | Modules in the program | ||||||||
| (2) | Operands in the program | ||||||||
| (3) | Operators in the program | ||||||||
| (4) | Bothe operators and operands in the Program | ||||||||
| Correct Answer: Bothe operators and operands in the Program | |||||||||
