Free DB2 11 Fundamentals for z/OS C2090-320 Exam Practice Test

Which of the following describes OLTP workload rather than an analytics workload?

• Extreme data volume
  
• Temporary or intermediate staging of data
  
• Set-oriented processing and bulk operations
  
• A large number of short, discrete, atomic transactions
  

Which catalog table provides information about the validity of a bound package?

• SYSIBM.SYSPACKLIST
  
• SYSIBM.SYSPACKAGE
  
• SYSIBM.SYSPACKDEP
  
• SYSIBM.SYSPACKAUTH
  

Which SQL statement can be used to provide diagnostic information about the last SQL statement that was executed?

• GET DIAGNOSTICS
  
• DESCRIBE OUTPUT
  
• DECLARE STATEMENT
  
• SET CURRENT DEBUG MODE
  

Which catalog table would you query in order to determine the relevant statistics for an index?

• SYSIBM.SYSKEYS
  
• SYSIBM.SYSFIELDS
  
• SYSIBM.SYSCOLUMNS
  
• SYSIBM.SYSINDEXSTATS1
  

In which address space would a native SQL stored procedure run?

• WLM
  
• DIST
  
• DBM1
  
• The address space of the calling program
  

Which of the following are valid objects created using DDL? (Choose two)

• PLAN
  
• PACKAGE
  
• DATABASE
  
• SEQUENCE
  
• COLLECTION
  

You need to add the employee picture to the employee table. Which of the following is the appropriate built-in data type for storing images?

• BLOB
  
• CLOB
  
• DBCLOB
  
• VARGRAPHIC
  

Which protocol provides applications the ability to connect to a server at another location and execute packages that have been previously bound at that server?

• CLI
  
• JDBC
  
• DRDA
  
• ODBC
  

Why would an SQL statement receive an SQLCODE of +100? (Choose two)

• The result of a SELECT INTO statement was an empty table
  
• A rowset FETCH statement encountered one or more error conditions
  
• The statement references an object that is not defined in the DB2 subsystem
  
• An error occurred during the insertion of a row into an optional explanation table
  
• A FETCH statement was executed when the cursor was positioned after the last row of the result table
  

Which SQL statement supports an insert or an update in a single SQL statement?

• MERGE
  
• UPSERT
  
• UPDATE or INSERT INTO....
  
• INSERT INTO table... ON DUPLICATE KEY ....