C2090-320

Which package level privileges does the user smith have when the following statement is executed? GRANT ALL ON PACKAGE clct1.pkg1 TO smith;A . GRANT, COPY, BIND, RUNB . BIND, EXECUTE, COPY, RUNC . CREATE, COPY, RUN, EXECUTED . COPY, BINDADD, SQL, EXECUTEView AnswerAnswer: B Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/ db2z_sql_grantpackageprivileges.html

If a scrollable cursor is INSENSITIVE, which of the following applies?A . The cursor is read onlyB . WITH ROWSET POSITIONING is not allowedC . The select-statement must not contain an SQL data change statementD . The cursor has sensitivity to changes that are made to the database after the...

Which types of user-defined data types are supported? (Choose two.)A . CHARB . ARRAYC . NUMERICD . DISTINCTE . TIMESTAMPView AnswerAnswer: BD Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/ db2z_userdefineddatatypes.html

Which statement is TRUE regarding catalog table SYSIBM.SYSROUTINES?A . Contains scheduled tasks for the administrative schedulerB . Contains information about UDFs, BIFs and stored proceduresC . Contains information about bound packagesD . Contains information about UDFs and stored proceduresView AnswerAnswer: D Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/cattab/src/tpc/ db2z_sysibmsysroutinestable.html

Which of the following describes OLTP workload rather than an analytics workload?A . Extreme data volumeB . Temporary or intermediate staging of dataC . Set-oriented processing and bulk operationsD . A large number of short, discrete, atomic transactionsView AnswerAnswer: D Explanation: Reference: http://www.ibmbigdatahub.com/sites/default/files/document/IBM-Netezza-Understanding-Analytic-Workloads-eBook.pdf

Which of the following locking scenarios requires the least amount of real storage in the IRLM address space?A . 10 row locksB . 200 page locksC . A single table space lockD . 6 partition locks (given a table space with a total of 10 partitions)View AnswerAnswer: C

Which of the following are advantages of DB2 for z/OS data sharing over a standalone DB2 subsystem implementation? (Choose two.)A . Reduced active logsB . Reduced storage useC . Higher transaction ratesD . Reduced lock contentionE . Increased data availabilityView AnswerAnswer: CE

Which statement is TRUE regarding ROLLBACK processing?A . It only reads active logsB . It always needs archive logsC . It can never be processed just from memoryD . It uses output buffers, active and archive logsView AnswerAnswer: D

Given the tables: Which SQL statement would join the tables on product number (prod#) and provide a table of what products (product), if any, the parts (part) are used? Limit the result to only parts where suppliers (supplier) do not start with the letter A. A. B. C. D. View...

What is preserved by enabling graceful Routing Engine switchover ( GRES)?A . interface and kernel informationB . link-state protocol adjacenciesC . control-plane stateD . BGP peering relationshipsView AnswerAnswer: A