| Q 1: |
Consider the following sequence of two transactions on a bank account(A) with initial balance 20,000 that transfers 5,000 to another account (B) and then apply 10% interest. (i) T1 start (ii) T1 A old20000 new 15,000 (iii) T1 Bold 12000 new 17000 (iv) TI commit (v) T2 start (vi) T2 A old=15000 new 16500 (vii) T2 commit Suppose the database system crashes out just before log record (vii) is written. When the system is restricted, which one statement is true of the recovery process? |
| (1) | We can apply redo and undo operation in arbitrary order because they are idempotent. |
| (2) | We must redo log record (vi) to set A to 16,500. |
| (3) | We must undo log record (vi) to set A to 16,500 and then redo log record (ii) and (iii) |
| (4) | We need not redo records (ii) and (iii) because transaction T1 has committed |
| Correct Answer: We must undo log record (vi) to set A to 16,500 and then redo log record (ii) and (iii) | |
| Q 2: | In ASP.NET if one wants to maintain session then which of the following is used? |
| (1) | In-process storage |
| (2) | Session State Service |
| (3) | Microsoft SQL Server |
| (4) | All of the above |
| Correct Answer: All of the above | |
| Q 3: | The Function Point (FP) calculated for a software project are often used to obtain an estimate of Lines of Code (LOC) required for that project. Which of the following statements is FALSE in this context. |
| (1) | The relationship between FP and LOC depends on the programming language used to implement the software |
| (2) | LOC requirement for an assembly language implementation will be more for a given FP value, than LOC for implementation in COBOL |
| (3) | On an average, one LOC of C++ provides approximately 1.6 times the functionality of a single LOC of FORTRAN |
| (4) | FP and LOC are not related to each other |
| Correct Answer: FP and LOC are not related to each other | |
| Q 4: | ..................is a type of transmission impairment in which an outside source such as crosstalk corrupts a signal. |
| (1) | Attenuation |
| (2) | Distortion |
| (3) | Noise |
| (4) | Decibel |
| Correct Answer: Noise | |
| Q 5: |
If every non-key attribute functionally depended on the primary key, then the relation will be in |
| (1) | First normal form |
| (2) | Second normal form |
| (3) | Third normal form |
| (4) | Fourth normal form |
| Correct Answer: Third normal form | |
| Q 6: |
In a software project, COCOMO (Constructive Cost Model) is used to estimate |
| (1) | Effort and duration based on the size of the software |
| (2) | Effort and cost based on the duration of the software |
| (3) | Size and duration based on the effort of the software |
| (4) | Size, effort and duration based on the cost of the software |
| Correct Answer: Effort and duration based on the size of the software | |
| Q 7: | Difference between response.redirect and server. transfer. |
| (1) | response redirect will take you to another page with out round trip |
| (2) | server.transfer will take the round trip from server to client |
| (3) | All of the above |
| (4) | None of the above |
| Correct Answer: None of the above | |
| Q 8: | ...... is a method of attacking a challenge-response authentication system that uses the same protocol in both directions |
| (1) | Replay Attack |
| (2) | Denial of Service Attack |
| (3) | Masquerading |
| (4) | Reflection Attack |
| Correct Answer: Reflection Attack | |
| Q 9: |
Let us assume that transaction TI has arrived before transaction T2. Consider the schedule Srl(A); r2(B); w2(A); w1(B) Which of the following is true? |
| (1) | Allowed under basic timestamp protocol |
| (2) | Not allowed under basic timestamp protocols because T1 is rolled back |
| (3) | Not allowed under basic timestamp protocols because T2 is rolled back |
| (4) | None of the above |
| Correct Answer: Not allowed under basic timestamp protocols because T1 is rolled back | |
| Q 10: | Which control would you use if you needed to make sure the values in two different controls matched? |
| (1) | Required Field Validator |
| (2) | Custom Validator control |
| (3) | Compare Validator control |
| (4) | Regular expression validator Control |
| Correct Answer: Compare Validator control | |