Cause all that matters here is passing the IBM C2090-611 exam. Cause all that you need is a high score of C2090-611 DB2 10.1 DBA for Linux, UNIX, and Windows exam. The only one thing you need to do is downloading Examcollection C2090-611 exam study guides now. We will not let you down with our money-back guarantee.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for IBM C2090-611 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW C2090-611 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/C2090-611-exam-dumps.html
Q61. What authorization is needed to use the AUDIT statement to create an audit policy?
A. DBADM
B. SYSADM
C. SECADM
D. SYSMAINT
Answer: C
Q62. What are two types of security label components that can be used with Label-Based Access
Control (LBAC)? (Choose two).
A. Set
B. Tree
C. Group
D. Range
E. Hierarchy
Answer: A,B
Q63. What is the FLUSH PACKAGE CACHE statement used for?
A. It saves dynamic SQL stored in the package cache to an external file.
B. To remove all cached static SQL statements from the package cache.
C. To remove all cached dynamic SQL statements from the package cache.
D. It causes all SQL statements in the package cache that are currently in use to be recompiled.
Answer: C
Q64. Which is the suggested way to restore a database with a subset of its original table spaces?
A. Execute the RESTORE DATABASE command with the REBUILD WITH option and specify the set of table spaces that are needed.
B. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES option and specify the set of table spaces that areneeded.
C. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES
IN IMAGE option and specify the set of table spacesthat are needed.
D. Execute the RESTORE DATABASE command with the REBUILD WITH ALL TABLESPACES
IN DATABASE option and specify the set of tablespaces that are needed.
Answer: A
Q65. What authority must be held to create a trusted context?
A. DBADM
B. SQLADM
C. SECADM
D. CONNECT
Answer: C
Q66. If the following statement is executed:
What indexes will be created for table TAB1?
A. 1 dimension-block index and 1 composite-block index
B. 1 dimension-block index and 3 composite-block indexes
C. 3 dimension-block indexes and 1 composite-block index
D. 3 dimension-block indexes and 3 composite-block indexes
Answer: C
Q67. If the following statements are executed in the order shown:
Which statement is true?
A. Insert, update, and delete operations can be performed against table TAB2.
B. Data stored in table TAB1 is automatically copied to table TAB2 immediately after table TAB2 is created.
C. Insert, update, and delete operations performed against table TAB1 are automatically cascaded to table TAB2.
D. The REFRESH TABLE statement must be executed before insert, update, and delete operations performed against table TAB1 will be seen intable TAB2.
Answer: C
Q68. Which authority is required to revoke SECADM authority?
A. DBADM
B. SECADM
C. SYSADM
D. SQLADM
Answer: B
Q69. If the following statement is executed: REORGCHK UPDATE STATISTICS ON TABLE ALL What will happen?
A. RUNSTATS will be executed on all user tables and a REORGCHK report will be generated.
B. RUNSTATS will be executed on all user and system tables and a REORGCHK report will be generated.
C. RUNSTATS will be executed on all user tables only if statistics have not been collected and a REORGCHK report will be generated.
D. RUNSTATS will be executed on all system tables only if statistics have not been collected and a REORGCHK report will be generated.
Answer: B
Q70. Which SQL/XML publishing function can be used to convert XML data into other formats, including other XML schemas?
A. XSLPARSE
B. XSLELEMENT
C. XSLCONVERT
D. XSLTRANSFORM
Answer: D