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

September 25, 2018 No Comments READ MORE +

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

September 5, 2018 No Comments READ MORE +

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

August 30, 2018 No Comments READ MORE +