| Q 1: | Minimum number of record movements required to merge five files A (with 10 records), B (with 20 records), C (with 15 records), D (with 5 records) and E (with 25 records) is |
| (1) | 165 |
| (2) | 90 |
| (3) | 75 |
| (4) | 65 |
| Correct Answer: 65 | |
| Q 2: | Using relational algebra, the query that finds customers, who have a balance of over 3000 is
|
| (1) | a |
| (2) | b |
| (3) | c |
| (4) | d |
| Correct Answer: a | |
| Q 3: | A database management software (DBMS) includes |
| (1) | Automated tools (CASE) used to design databases and application programs |
| (2) | A software application that is used to define, create, maintain and provide controlled access to user databases |
| (3) | Application programs that are used to provide information to users |
| (4) | Database that contains occurrences of logically organised data or information |
| Correct Answer: A software application that is used to define, create, maintain and provide controlled access to user databases | |
| Q 4: | Out of the following activities, which is the one that normally performed by DBMS, without the interference of the DBA? |
| (1) | Integrity |
| (2) | Retention |
| (3) | Security |
| (4) | Recovery |
| Correct Answer: Recovery | |
| Q 5: | Horizontal Fragmentation is |
| (1) | Divide the data up by logical groups of records |
| (2) | Divide the data up by logical groups of attributes |
| (3) | Divide the data up by logical groups of entities |
| (4) | Divide the data up by logical groups of files |
| Correct Answer: Divide the data up by logical groups of records | |
| Q 6: | The network capacity of a wireless network can be improved by |
| (1) | increasing the number of cells |
| (2) | decreasing the number of cells |
| (3) | increasing the size of cells |
| (4) | increasing the number of mobile user in a cell |
| Correct Answer: increasing the size of cells | |
| Q 7: | The total delay in datagram networks is calculated as |
| (1) | total transmisison time + total propagation delay + total waiting time |
| (2) | total transmission time + total waiting time |
| (3) | total propagation delay + total waiting time |
| (4) | total transmission time + total propagation delay |
| Correct Answer: total transmisison time + total propagation delay + total waiting time | |
| Q 8: | Number of bit used for host id in IPv4 Class A addressing is |
| (1) | 8 bits |
| (2) | 12 bits |
| (3) | 16 bits |
| (4) | 24 bits |
| Correct Answer: 24 bits | |
| Q 9: | 10 Base 2 and 10 Base 5 have different ... |
| (1) | signal band types |
| (2) | fields on the 802.3 frame |
| (3) | maximum segment lengths |
| (4) | maximum data rates |
| Correct Answer: maximum segment lengths | |
| Q 10: | Which IPv4 address class has few Net ID per network? |
| (1) | Class A |
| (2) | Class B |
| (3) | Class C |
| (4) | Class D |
| Correct Answer: Class A | |
