Free IBM A2090-730 Exam Dumps Questions & Answers

Which of the following is NOT a characteristic of a declared temporary table?

• A.  Once the application that created a global temporary table is terminated, any records in the table are deleted and the table is automatically destroyed Data Concurrency
• B.  Declared temporary tables are created by executing a CREATE TABLE statement with the DECLARED GLOBAL TEMPORARY clause specified
• C.  Declared temporary tables are not persistent and can only be used by the application that creates them
• D.  It is possible for many applications to create declared temporary tables that have the same name

Application A currently holds an exclusive lock on a single row and application B tries to access that row. If lock timeout is set to -1 and both applications are using isolation level RS, which of the following will occur?

• A.  Application B will read the row and see uncommitted changes made by application A.
• B.  Applications A and B will cause a deadlock situation.
• C.  Application B will be placed in a lock-wait state until applicationA releases its lock.
• D.  Application B will read the previous version of the row.

Which of the following is the main feature of an OLTP application?

• A.  Voluminous historical data
• B.  Granular transactions
• C.  Heterogeneous data sources
• D.  Summarized queries

Which of the following commands is used to retrieve database names from the local catalog for DRDA host databases on System i and System z?

• A.  LIST DCS DIRECTORY
• B.  LIST ACTIVE DATABASES
• C.  LIST NODE DIRECTORY
• D.  LIST DB DIRECTORY

Which of the following is a NOT a valid reason for defining a view on a table?

• A.  Provide users with an alternate view of table data
• B.  Restrict users' access to a subset of table data
• C.  Produce an action as a result of a change to a table
• D.  Ensure that rows inserted remain within the scope of a definition