上海財(cái)經(jīng)大學(xué)《數(shù)據(jù)庫系統(tǒng)》期末試卷和答案

1、專業(yè)課復(fù)習(xí)資料（最新版） 專業(yè)課復(fù)習(xí)資料（最新版）封面progress at the time the checkpoint was taken.If transaction A holds an S lock on tuple t, then a request from somedistinct transaction B for a X lock on t will be denied.Breaking the deadlock

2、involves choosing one of the deadlockedtransactions and commit it.20). If all transactions obey the “two-phase locking protocol,“ allpossible interleaved schedules are serializable.2. Choose the right answer of the follo

3、wing exercises.(30 points)1). Given the tables:Customer AccountCustomerNo AccountNo AccountNo BalanceC001 A101 A101 100C002 A105 A105 170C002 A107The statement:SELECT * FROM Customer, Accountwill return how many rows?A.

4、2 B. 3 C. 5 D. 62). Given the tables:EMP INCOMEEmpid Name Empid MonthNo Income1 JOE 1 1 50002 BOB 1 2 55003 SMITH 2 1 100002 2 8000INCOME was defined as follows:CREATE TABLE INCOME(Empid CHAR(3),MonthNo CHAR(3),Income DE

5、CIMAL(6,2),CONSTRAINT const1 FOREIGN KEY (Empid)REFERENCES EMP(Empid) ON DELETE CASCADE);How many rows would be deleted from INCOME if the following command is issued ?DELETE FROM EMP WHERE Empid = '2';A. 0 B. 1