C2090-320

Consider the following code: Intent i = new Intent(this, MainActivity.class); i.addFlags(Intent.FLAG_ACTIVITY_CLEAR_TOP); startActivity(i); What best explains the code above?A . The activity being launched is already running in the current task, then instead of launching a new instance of that activity, all of the other activities on top of it will...

You want to reduce lock contention that results from uncommitted insert and delete operations by enabling transactions that read data to access only the currently committed data rather than waiting for the uncommitted changes to be resolved. How can you accomplish this?A . Bind your application with ISOLATION(UR)B . Bind...

Which of the following is a characteristic of a stand-alone utility?A . It can only be executed using JCLB . It can only be executed by a user with SYSADMC . It can only be executed if no other utilities are runningD . It can only be executed in a...

The metadata for which of the following objects is NOT stored in the DB2 catalog table SYSIBM.SYSTABLES?A . A viewB . A temporal tableC . A created global temporary tableD . A declared global temporary tableView AnswerAnswer: B

Assume DELETE triggers exist on the employee table. Which of the following statements will delete all the rows in the employee table and ignore any DELETE triggers?A . TRUNCATE employee;B . DELETE FROM employee;C . DELETE FROM employee WHERE…;D . TRUNCATE employee RESTRICT WHEN DELETE TRIGGERS;View AnswerAnswer: B Explanation: Reference:...

Which of the following statements about a table with a LOB column is TRUE?A . It doesn’t need an auxiliary table if it has an inline LOBB . It must also have a ROWID column and an auxiliary tableC . It doesn’t need a ROWID column (implicit or explicit) if...

Assume DELETE triggers exist on the employee table. Which of the following statements will delete all the rows in the employee table and ignore any DELETE triggers?A . TRUNCATE employee;B . DELETE FROM employee;C . DELETE FROM employee WHERE…;D . TRUNCATE employee RESTRICT WHEN DELETE TRIGGERS;View AnswerAnswer: B Explanation: Reference:...

Which privilege will user smith be able to grant to another user on table emp when the following SQL is executed? GRANT ALL ON TABLE emp TO smith WITH GRANT OPTION;A . BINDB . REORGC . TRIGGERD . EXECUTEView AnswerAnswer: D

Which catalog table provides information about the validity of a bound package?A . SYSIBB . SYSPACKLISTC . SYSIBD . SYSPACKAGEE . SYSIBF . SYSPACKDEPG . SYSIBH . SYSPACKAUTHView AnswerAnswer: A Explanation: Reference: https://books.google.com.pk/books?id=QH3JAgAAQBAJ&pg=PA256&lpg=PA256&dq=db2+11 +catalog+table+provides+information+about+the+validity+of+a+bound +package&source=bl&ots=4G_RwWpnUF&sig=Lm-LaNpt_SRiZcdhGxiX7ehVIfY&hl=en&sa=X&ved=0ahUKEwjLmPz66drZAhUO6aQKHW_2C9UQ6AEITjAF# v=onepage&q=db2%2011%20catalog%20table%20provides%20information%20about%20the%20validity %20of%20a%20bound%20package&f=false

Given the following CREATE VIEW statement and sample data; your login id is “ROGER”. What will be the result for this query?A . 6B . 5C . 4D . 2View AnswerAnswer: C