| Q 1: | The functional dependency, if A-> B, then A, C-> B, C is referred to as |
| (1) | Reflexivity |
| (2) | Transitivity |
| (3) | Augmentation |
| (4) | Union |
| Correct Answer: Augmentation | |
| Q 2: | The way a particular application views the data from the database that the application uses is a |
| (1) | module |
| (2) | relational model |
| (3) | schema |
| (4) | sub schema |
| Correct Answer: sub schema | |
| Q 3: | Consider a database table T containing two columns X and Y each of type integer. After the creation of the table, one record (X= 1, Y=1) is inserted in the table. Let MX and MY denote the respective maximum values of X and Y among all records in the table at any point in time. Using MX and MY, new records are inserted in the table 128 times with X and Y values being MX+1, 2*MY+1 respectively. It may be noted that each time after the insertion, values of MX and MY change. What will be the output of the following SQL query after the steps mentioned above are carried out? SELECT Y FROM T WHERE X=7; |
| (1) | 127 |
| (2) | 255 |
| (3) | 129 |
| (4) | 257 |
| Correct Answer: 127 | |
| Q 4: | 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,D |
| (2) | A,B,C |
| (3) | A,B,C,D,E,F |
| (4) | A,B,C,D,E |
| Correct Answer: A,B,C,D,E | |
| Q 5: | Which of the following is the full form of URL |
| (1) | Uniform Request Location |
| (2) | Unicore Resource Locator |
| (3) | Uniform Resource Locator |
| (4) | Unified Request Locator |
| Correct Answer: Uniform Resource Locator | |
| Q 6: | The period of a signal is 100 ms. Its frequency is............... |
| (1) | 100^3 Hertz |
| (2) | 10^-2 KHz |
| (3) | 10^-3 KHz |
| (4) | 10^5 Hertz |
| Correct Answer: 10^-2 KHz | |
| Q 7: | What is the maximum length of an SSID |
| (1) | Thirty - two characters |
| (2) | Sixteen characters |
| (3) | Sisty-four characters |
| (4) | Eight characters |
| Correct Answer: Thirty - two characters | |
| Q 8: | A proxy firewall filters at the ............. layers |
| (1) | network |
| (2) | application |
| (3) | transport |
| (4) | none |
| Correct Answer: application | |
| Q 9: | RPF eliminates the ........................ in the flooding process |
| (1) | forwarding |
| (2) | backwarding |
| (3) | flooding |
| (4) | none |
| Correct Answer: none | |
| Q 10: | Prototyping is used to |
| (1) | Expand design details |
| (2) | Test the software as an end product |
| (3) | Refine and establish requirements gathering |
| (4) | none |
| Correct Answer: Refine and establish requirements gathering | |