Passing C2090-320 exam is a first step for you to get the IBM Certified Database Administrator certification. With studying all of DB2 11 Fundamentals for z/OS exam C2090-320 exam prep questions dumps, you can test your skills to check if you have a good understanding of the exam topics or not. All the IBM C2090-320 exam prep questions are collected from the real test by our certified experts, who update the C2090-320 questions frequently according to the changes at the testing center.
Your current authorization ID is DBA. Only one of your secondary authorization IDs, DB2, has the privilege to create an index DB2.AAA on a table. The appropriate SQL statement starts with “CREATE INDEX AAA...
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?A . CLIB . JDBCC . DRDAD . ODBCView AnswerAnswer:...
Which of the following are contained in the PLAN_TABLE? (Choose two.)A . RUNSTATS recommendationsB . Access to LOB values, which are stored separately from the base tableC . Access to parent or dependent tables...
Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?A . SQLCAB . SQLDAC . SQLCODED . SQLSTATEView AnswerAnswer: B
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,...
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?A . MSTRB . DBM1C ....
Given the following CREATE TABLE statement, and a unique index on column EMPID, which set of SQL statements is valid? A . B . C . D . View AnswerAnswer: D
Which two of the following functions are synonyms of one another? (Choose two.)A . CLOBB . VALUEC . IFNULLD . DBCLOBE . COALESCEView AnswerAnswer: BE Explanation: Reference: https://www.techagilist.com/mainframe/coalesce-scalar-function-db2-queries/
Which of the following utilities CANNOT be executed from the DB2 utilities panel in DB2I?A . COPYB . REORGC . STOSPACED . BACKUP SYSTEMView AnswerAnswer: D Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/ugref/src/tpc/ db2z_useutilitiespaneldb2i.html
Which type of lock is obtained when using a ‘WITH UR’ clause on an SQL SELECT statement in a data-sharing environment?A . U-lockB . S-lockC . P-lockD . No lock is obtainedView AnswerAnswer: D
