Consider the following log sequence of two transactions on a bank account, with initial balance 12000, that transfer 2000 to a mortgage payment and then apply a 5% interest.1. T1 start2. T1 B old=1200 new=100003. T1 M old=0 new=20004. T1 commit5. T2 start6. T2 B old=10000 new=105007. T2 commitSuppose the database system crashes just before log record 7 is written. When the system is restarted, which one statement is true of the recovery procedure?(A) We must redo log record 6 to set B to 10500(B) We must undo log record 6 to set B to 10000 and then redo log records 2 and 3(C) We need not redo log records 2 and 3 because transaction T1 has committed(D) We can apply redo and undo operations in arbitrary order because they are idempotent.

Consider the following log sequence of two transactions on a bank acco

1.	Consider the following log sequence of two transactions on a bank account, with initial balance 12000, that transfer 2000 to a mortgage payment and then apply a 5% interest.1. T1 start2. T1 B old=1200 new=100003. T1 M old=0 new=20004. T1 commit5. T2 start6. T2 B old=10000 new=105007. T2 commitSuppose the database system crashes just before log record 7 is written. When the system is restarted, which one statement is true of the recovery procedure?(A) We must redo log record 6 to set B to 10500(B) We must undo log record 6 to set B to 10000 and then redo log records 2 and 3(C) We need not redo log records 2 and 3 because transaction T1 has committed(D) We can apply redo and undo operations in arbitrary order because they are idempotent.
Answer»

Discussion

No Comment Found

Related InterviewSolutions

Consider the following statements#define hypotenuse (a, b) sqrt (a*a+b*b); The macro call hypotenuse(a+2,b+3);(A) Finds the hypotenuse of a triangle with sides a+2 and b+3(B) Finds the square root of (a+2)2 and (b+3)2(C) Is invalid(D) Find the square root of 3*a + 4*b + 5
An ACK number of 1000 in TCP always means that(A) 999 bytes have been successfully received(B) 1000 bytes have been successfully received(C) 1001 bytes have been successfully received(D) None of the above
In CRC if the data unit is 100111001 and the divisor is 1011 then what is dividend at the receiver?(A) 100111001101(B) 100111001011(C) 100111001(D) 100111001110
How many characters per sec (7 bits + 1 parity) can be transmitted over a 2400 bps line if the transfer is synchronous ( 1 start and 1 stop bit)?(A) 300(B) 240(C) 250(D) 275
A machine needs a minimum of 100 sec to sort 1000 names by quick sort. The minimum time needed to sort 100 names will be approximately(A) 50.2 sec(B) 6.7 sec(C) 72.7 sec(D) 11.2 sec
Given the following expression grammar:E → E ∗ F ∣ F + E ∣ FF → F − F ∣ idWhich of the following is true?(A) * has higher precedence than +(B) – has higher precedence than *(C) + and – have same precedence(D) + has higher precedence than *
Consider the following schema:Emp (Empcode, Name, Sex, Salary, Deptt)A simple SQL query is executed as follows:SELECT Deptt FROM EmpWHERE sex = 'M'GROUP by DeptHaving avg (Salary) > {select avg (Salary) from Emp}The output will be(A) Average salary of male employee is the average salary of the organization(B) Average salary of male employee is less than the average salary of the organization(C) Average salary of male employee is equal to the average salary of the organization(D) Average salary of male employee is more than the average salary of the organization
Which statement is true?(A) LALR parser is more powerful and costly as compare to other parsers(B) All CFG’s are LP and not all grammars are uniquely defined(C) Every SLR grammar is unambiguous but not every unambiguous grammar is SLR(D) LR(K) is the most general back tracking shift reduce parsing method
Consider the following relational schema:Suppliers(sid:integer, sname:string, city:string, street:string)Parts(pid:integer, pname:string, color:string)Catalog(sid:integer, pid:integer, cost:real)Consider the following relational query on the above database:SELECT S.sname FROM Suppliers S WHERE S.sid NOT IN (SELECT C.sid FROM Catalog C WHERE C.pid NOT IN (SELECT P.pid FROM Parts P WHERE P.color<> 'blue'))Assume that relations corresponding to the above schema are not empty. Which one of the following is the correct interpretation of the above query?(A) Find the names of all suppliers who have supplied a non-blue part.(B) Find the names of all suppliers who have not supplied a non-blue part(C) Find the names of all suppliers who have supplied only non blue parts.(D) Find the names of all suppliers who have not supplied only non-blue parts.
A certain population of ALOHA users manages to generate 70 request/sec. If the time is slotted in units of 50 msec, then channel load would be(A) 4.25(B) 3.5(C) 350(D) 450

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment