- All Exams Instant Download
Which of the following SQL statements will remove all rows from the table T1? (Choose two.)
Which of the following SQL statements will remove all rows from the table T1? (Choose two.)A . DELETE FROM t1B . DELETE* FROM t1C . DELETE* TABLE t1D . TRUNCATE TABLE t1 IMMEDIATEE . TRUNCATE TABLE t1View AnswerAnswer: AB
neither application can continue executing?
Which locking event occurs when two applications lock rows that are needed by the other, such that neither application can continue executing?A . DeadlockB . Lock timeoutC . Lock escalationD . Lock conversionView AnswerAnswer: A Explanation:https://www.ibm.com/developerworks/data/library/techarticle/dm-0406whitlark/index.html
Which database object can be locked explicitly?
Which database object can be locked explicitly?A . RowB . ViewC . IndexD . TableView AnswerAnswer: D Explanation:https://www.ibm.com/support/knowledgecenter/hr/SSEPGG_9.7.0/ com.ibm.db2.luw.admin.perf.doc/doc/c0005270.html
