| Q 1: | If an attribute of a composite key is dependent on an attribute of the other composite key, normalization called............ is needed. |
| (1) | DKNF |
| (2) | BCNF |
| (3) | Fourth |
| (4) | Third |
| Correct Answer: BCNF | |
| Q 2: | To include integrity constraint in an existing relation use: |
| (1) | Create table |
| (2) | Modify table |
| (3) | Alter Table |
| (4) | Drop Table |
| Correct Answer: Alter Table | |
| Q 3: | The column of a table is referred to as the |
| (1) | Entity |
| (2) | Attribute |
| (3) | Tuple |
| (4) | Degree |
| Correct Answer: Attribute | |
| Q 4: | Consider a CSMA/CD network that transmits data at a rate of 100Mbps (108 bits per second) over a 1km (kilometer) cable with no repeaters. If the minimum frame size required for this network is 1250 bytes, what is the signal speed (km/sec) in the cable? |
| (1) | 8000 |
| (2) | 10000 |
| (3) | 16000 |
| (4) | 20000 |
| Correct Answer: 20000 | |
| Q 5: | Checksum field in TCP header is |
| (1) | one's complement of sum of header and data in bytes |
| (2) | one's complements of sum of header, data and pseudo header in 16 bits words |
| (3) | dropped from IPv6 header format |
| (4) | better than md5 or sh1 methods |
| Correct Answer: one's complements of sum of header, data and pseudo header in 16 bits words | |
| Q 6: | What are the most commonly used transmission speeds in BPS used in data communication? |
| (1) | 300 |
| (2) | 1200 |
| (3) | 2400 |
| (4) | 9600 |
| Correct Answer: 9600 | |
| Q 7: | The first step in software development life cycle |
| (1) | Software Requirement Specification |
| (2) | System Design |
| (3) | System Testing |
| (4) | None of the above |
| Correct Answer: Software Requirement Specification | |
| Q 8: | CASE stands for |
| (1) | Computer applciation system environment |
| (2) | Computer-aided system engineering |
| (3) | Computer application system engineering |
| (4) | Computer-aided system environment |
| Correct Answer: Computer-aided system engineering | |
| Q 9: | The step-by-step instructions that solve a problem are called |
| (1) | A plan |
| (2) | A list |
| (3) | An algorithm |
| (4) | A sequenctial structure |
| Correct Answer: An algorithm | |
| Q 10: | What is the major drawback of CORE? |
| (1) | NFRs are not given enough importance |
| (2) | Requirements are comprehensive |
| (3) | Role of analyst is passive |
| (4) | All of the above |
| Correct Answer: Role of analyst is passive | |