You are designing a payroll table that will contain a salary column. Which of the following is the appropriate built-in data type for a salary column?
Answer(s): C
https://www.ibm.com/support/knowledgecenter/en/SS6NHC/com.ibm.swg.im.dashdb.sql.ref.doc/ doc/r0000791.html
Which package level privileges does the user smith have when the following statement is executed? GRANT ALL ON PACKAGE clct1.pkg1 TO smith;
Answer(s): B
https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/ db2z_sql_grantpackageprivileges.html
Which of the following can activate a trigger?
Answer(s): D
https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/intro/src/tpc/db2z_triggers.html
In which address space would a native SQL stored procedure run?
http://www.ibmbigdatahub.com/blog/db2-native-sql-procedures-future-computing
You want to see all messages that were generated by one specific DB2 subsystem such as log switches and timeout messages. Which job log would show all of these?
Answer(s): A
Post your Comments and Discuss IBM C2090-320 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the C2090-320 content, but please register or login to continue.