Page: 1
/ 5
Total 69 questions
We want to increase the salary for each employee (EMP) in the department (WORKDEPT) D11 and we want to see the new salaries(SALARY) for each of them.
Which single SQL statement will do this?
A.
B.
C.
D.
Answer : D
You want to limit the access of a table to allow users to only see certain columns and/or rows.
Which of the following options CANNOT be used to accomplish this?
- A. A view
- B. Multilevel security
- C. An MQT (Materialized Query Table)
- D. A combination of row permissions and column masks
Answer : C
Which of the following tables can be used to set the default of the special register CURRENT APPLICATION COMPATIBILITY for remote users?
- A. The resource limit facility table authid.DSNRLMTxx
- B. The DB2 catalog table SYSIBM.SYSENVIRONMENT
- C. The profile table SYSIBM.DSN_PROFILE_ATTRIBUTES
- D. The communications database table SYSIBM.USERNAMES
Answer : C
Which statement is TRUE regarding catalog table SYSIBM.SYSROUTINES?
- A. Contains scheduled tasks for the administrative scheduler
- B. Contains information about UDFs, BIFs and stored procedures
- C. Contains information about bound packages
- D. Contains information about UDFs and stored procedures
Answer : D
Reference:
https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/cattab/src/tpc/db2z_sysibmsysroutinestable.html
Which SQL statement can be used to provide diagnostic information about the last SQL statement that was executed?
- A. GET DIAGNOSTICS
- B. DESCRIBE OUTPUT
- C. DECLARE STATEMENT
- D. SET CURRENT DEBUG MODE
Answer : A
Reference:
https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/db2z_sql_getdiagnostics.html
Consider the following question: "What is the average salary by sex within education level?" An occasional uncommitted record can be tolerated in the average.
Which of the following is the most appropriate isolation level for this?
- A. UR
- B. RR
- C. CS
- D. RS
Answer : A
Reference:
https://vdocuments.net/db2-app-dba-module-i.html
Which component of the program preparation produces a DBRM (Database request Module)?
- A. Compiler
- B. Linkage Editor
- C. Bind command
- D. Precompiler/Coprocessor
Answer : D
Reference:
https://www.ibm.com/support/knowledgecenter/en/SSGMGV_3.1.0/com.ibm.cics.ts31.doc/dfhtk/dfhtk20.htm
Which catalog tables are populated by RTS? (Choose two.)
- A. SYSIBM.SYSTABLES
- B. SYSIBM.SYSINDEXES
- C. SYSIBM.SYSINDEXPART
- D. SYSIBM.SYSINDEXSPACESTATS
- E. SYSIBM.SYSTABLESPACESTATS
Answer : DE
A clone table can only be created in which of the following?
- A. A simple table space
- B. A universal table space
- C. An auxiliary table space
- D. A classic segmented table space
Answer : B
Reference:
https://community.toadworld.com/platforms/ibmdb2/w/wiki/6841.clone-tables
Which privilege or authority is required to use the DSN command?
- A. None
- B. SYSADM
- C. SECADM
- D. EXECUTE
Answer : B
Reference:
https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/comref/src/tpc/db2z_cmd_bindplan.html
A summary table can be easily maintained using which of the following?
- A. An auxiliary table
- B. A partitioned table
- C. A bi-temporal table
- D. A materialized query table
Answer : D
Reference:
http://www.informit.com/articles/article.aspx?p=2755707&seqNum=3
In the parent table of a referential constraint, a parent key must be which of the following? (Choose two.)
- A. A unique key
- B. A foreign key
- C. A primary key
- D. A duplicate key
- E. A secondary key
Answer : AC
Reference:
https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0020153.html
How can a stored procedure be invoked?
- A. Via an SQL SELECT statement
- B. Via a CALL statement using SPUFI
- C. Directly via a RUN PROGRAM command
- D. Via a CALL statement from within an application program
Answer : D
Reference:
https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/db2z_sql_call.html
Consider the following scenario:
User1 creates table USER1.TABLE1 in DATABASE1
User1 grants ALL PRIVILEGES on TABLE1 to User2
User2 grants ALL PRIVILEGES on TABLE1 to User3
User1 revokes ALL PRIVILEGES on TABLE1 to User2
User3 has DBCTRL authority on DATABASE1
Is User3 able to retrieve rows from TABLE1?
- A. No
- B. Yes
- C. No, if the revoke used INCLUDING DEPENDENT PRIVILEGES
- D. Yes, if User3 was granted DBCTRL prior to the creation of table USER1.TABLE1
Answer : B
Given the following INDEX definition, which attributes apply to this index? (Choose two.)
- A. The index is partitioned
- B. The index data sets are user-managed
- C. The index data sets are DB2-managed
- D. The index is unique and in ascending order
- E. The maximum total size of the index is 1 GB
Answer : AB
30 days access 