| Q 1: | Which of the following is used to store movie and image files in the database |
| (1) | Clob |
| (2) | Blob |
| (3) | Binary |
| (4) | Image |
| Correct Answer: Blob | |
| Q 2: | A join in which the joining condition is based on equality between values in the common columns is called |
| (1) | Equi-join |
| (2) | Natural Join |
| (3) | Equi-join and Natural Join |
| (4) | None |
| Correct Answer: Equi-join and Natural Join | |
| Q 3: | A set of FDs is given for relation R(A,B,C,D,E,F,G) { A-> B BC -> DE AEF -> G } What is the closure of { A,C}+ under this set? |
| (1) | {A,B,C} |
| (2) | {A,B,C,D,E} |
| (3) | {C,D,E,F,G} |
| (4) | {A,B,E,F,G} |
| Correct Answer: {A,B,C,D,E} | |
| Q 4: | Which of the following relational algebraic operation is not a commutative operation? |
| (1) | Union |
| (2) | Intersection |
| (3) | Selection |
| (4) | Projection |
| Correct Answer: Projection | |
| Q 5: | The two wire connections between each subscriber's telephone and the end office are known as: |
| (1) | Switches |
| (2) | Local central office |
| (3) | Local loop |
| (4) | Toll office |
| Correct Answer: Local loop | |
| Q 6: | You have an interface on a router with the IP address of 192.168.192.10/29. What is the broadcast address the hosts will use on the LAN? |
| (1) | 192.168.192.15 |
| (2) | 192.168.192.31 |
| (3) | 192.168.192.127 |
| (4) | 192.168.192.63 |
| Correct Answer: 192.168.192.15 | |
| Q 7: | Signature of a method specifies |
| (1) | Authentication process |
| (2) | Return type, name and number of arguments |
| (3) | Inheritance |
| (4) | About method body |
| Correct Answer: Return type, name and number of arguments | |
| Q 8: | The............... technique expands the bandwidth of a signal by replacing each data bit with n bits. |
| (1) | FDM |
| (2) | DSSS |
| (3) | FHSS |
| (4) | TDM |
| Correct Answer: DSSS | |
| Q 9: | The software equation can be used to show that by extending the project deadline slightly |
| (1) | Fewer people are required |
| (2) | Your are guaranteed to meet the deadline |
| (3) | More lines of code can be produced |
| (4) | None |
| Correct Answer: Fewer people are required | |
| Q 10: | The relationship of data elements in a module is called |
| (1) | Coupling |
| (2) | Granularity |
| (3) | Cohesion |
| (4) | Modularity |
| Correct Answer: Cohesion | |