| Q 1: |
What is the output of the following query SELECT TRUNC(5234.5678,-2) FROM DUAL;? |
| (1) | 5200 |
| (2) | 5230.00 |
| (3) | 5230 |
| (4) | 5234.5600 |
| Correct Answer: 5200 | |
| Q 2: |
The abstraction level based intermediate schema is referred to as: |
| (1) | Logical schema |
| (2) | Subschema |
| (3) | Physical schema |
| (4) | Conceptual schema |
| Correct Answer: Logical schema | |
| 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: | 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 5: | 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 6: | The process for looking for pattern to document is called |
| (1) | Pattern |
| (2) | Anti-pattern |
| (3) | Frameworks |
| (4) | Pattern mining |
| Correct Answer: Pattern mining | |
| Q 7: | Which of the following is not a field in the Ethernet message packet |
| (1) | Data |
| (2) | Type |
| (3) | Pin-code |
| (4) | Address |
| Correct Answer: Pin-code | |
| Q 8: | An ARP request is normally............ |
| (1) | broadcast |
| (2) | multicast |
| (3) | unicast |
| (4) | none |
| Correct Answer: broadcast | |
| Q 9: | BSC is a |
| (1) | Character-oriented protocol |
| (2) | Full-duplex protocol |
| (3) | Bit-oriented protocol |
| (4) | None |
| Correct Answer: Character-oriented protocol | |
| Q 10: | Which of the definition of elements in system a data dictionary contain? |
| (1) | Data flows |
| (2) | Processes |
| (3) | Data stores |
| (4) | All |
| Correct Answer: All | |