| Q 1: | Which one among the following is false?
|
| (1) | If a relation is in 3 NF, then it is also in 2 NF |
|
| (2) | A relation in which every key has single attribute is in 2 nF |
|
| (3) | An FD :non prime attribute -> Non prime attribute is valid in 2NF |
|
| (4) | An FD :Non prime trribute -> Non prime attribute is valid in 3 NF |
|
| Correct Answer: An FD :Non prime trribute -> Non prime attribute is valid in 3 NF |
|
| Q 2: | Which command is used to delete all tuples of a table along with structure
|
| (1) | Truncate |
|
| (2) | Drop |
|
| (3) | Delete |
|
| (4) | Alter |
|
| Correct Answer: Drop |
|
| Q 3: | The.... database is the most widely used database structure
|
| (1) | General |
|
| (2) | Hierarchical |
|
| (3) | Standard |
|
| (4) | Relational |
|
| Correct Answer: Relational |
|
| Q 4: | An Entity relationship diagram is a tool to represent
|
| (1) | Data model |
|
| (2) | Event model |
|
| (3) | Process model |
|
| (4) | Customer model |
|
| Correct Answer: Data model |
|
| Q 5: | How many 8 bit characters can be transmitted per second over a 9600 baud serial communication link using a synchronous mode of transmission with one start bit, eight data bits and one parity bit?
|
| (1) | 600 |
|
| (2) | 800 |
|
| (3) | 876 |
|
| (4) | 1200 |
|
| Correct Answer: 800 |
|
| Q 6: | The speed of modem is measured in which unit?
|
| (1) | BPS |
|
| (2) | GPS |
|
| (3) | CPS |
|
| (4) | None |
|
| Correct Answer: BPS |
|
| Q 7: | The internet uses which protocol?
|
| (1) | TCP/IP |
|
| (2) | CSMA |
|
| (3) | S 25 |
|
| (4) | None |
|
| Correct Answer: TCP/IP |
|
| Q 8: | BSC is a
|
| (1) | Character-oriented protocol |
|
| (2) | Full-duplex protocol |
|
| (3) | Bit-oriented protocol |
|
| (4) | None |
|
| Correct Answer: Character-oriented protocol |
|
| Q 9: | FDM devices can operate
|
| (1) | On multipoint along data channels |
|
| (2) | More efficiently than dumb TDMs |
|
| (3) | More efficiently than smart TDMs |
|
| (4) | Like modem sharing devices |
|
| Correct Answer: On multipoint along data channels |
|
| Q 10: | Public key encryption makes use of
|
| (1) | Hash function |
|
| (2) | Two key |
|
| (3) | One key |
|
| (4) | All |
|
| Correct Answer: Two key |
|