Practical of C2090-611 practice test materials and free demo for IBM certification for IT professionals, Real Success Guaranteed with Updated C2090-611 pdf dumps vce Materials. 100% PASS DB2 10.1 DBA for Linux, UNIX, and Windows exam Today!
2021 May C2090-611 Study Guide Questions:
Q1. Which statement about the ADMIN_MOVE_TABLE procedure is true?
A. The ADMIN_MOVE_TABLE procedure immediately applies all changes that occur to data in the active (source) table during the move operationto the target table.
B. The ADMIN_MOVE_TABLE procedure stores all changes that occur to data in the active (source) table during the move to a user-suppliedstaging table so they can be replayed against the target table when the move is complete.
C. If the ADMIN_MOVE_TABLE procedure is used to move data in an active (source) table to a target table that was created beforehand, thetarget table is renamed (to the source table name) once the data has been copied into the target table.
D. If the ADMIN_MOVE_TABLE procedure is invoked with the KEEP option specified, the active (source) table will be kept and if the target table isto be created automatically, a name that is different from that of the active table must be specified for the target table.
Answer: C
Q2. You have an High Availability and Disaster Recovery (HADR) environment set up and you want to read from the standby database. What must you do?
A. Assign the value ON to the DB2_HADR_ROS registry variable.
B. Assign the value ON to the DB2_HADR_SNAP registry variable.
C. Execute the STOP HADR command to temporarily break the HADR connection to the standby.
D. Execute the TAKEOVER HADR command to instruct the standby database to takeover as the new primary database.
Answer: A
Q3. Which two server authentication methods are supported by transparent Lightweight Directory Access Protocol (LDAP)? (Choose two.)
A. CLIENT
B. SERVER
C. LDAP_PLUGIN
D. DATA_ENCRYPT
E. KERBEROS_PLUGIN
Answer: B,D
Most recent C2090-611 exam cost:
Q4. What can be used to provide input to the Design Advisor?
A. An XML file.
B. A query workload file.
C. The database configuration file.
D. The database manager configuration file.
Answer: B
Q5. 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
Q6. Which statement regarding snapshot administrative views and snapshot monitor table functions is true?
A. Snapshot administrative views cannot be used with monitor switches or monitor reset commands while snapshot table functions have no suchrestrictions.
B. Snapshot table functions cannot be used with monitor switches or monitor reset commands while snapshot administrative views have no suchrestrictions.
C. Snapshot administrative views provide the option to choose between data from a single database partition or a data subset from across alldatabase partitions while snapshot table functions provide access to data from each database partition.
D. Snapshot administrative views provide access to data from each database partition while snapshot table functions provide the option to choosebetween data from a single database partition or a data subset from across all database partitions.
Answer: D
Tested C2090-611 preparation:
Q7. Which statement about referential constraints is true?
A. A referential constraint can be defined against a catalog table.
B. A referential constraint can be defined on both tables and views.
C. A referential constraint is used to enforce a logical rule about values of one or more columns in one or more tables.
D. A referential constraint is used to enforce a logical rule about how values in one or more columns in a table should be referenced in a query.
Answer: C
Q8. What authority must be held to create a trusted context?
A. DBADM
B. SQLADM
C. SECADM
D. CONNECT
Answer: C
Q9. What unit of measurement is used to represent the cumulative total cost of a node in a Visual Explain access plan diagram?
A. CPU cycles
B. Elapsed time, in milliseconds
C. Processing instructions performed
D. Timerons
Answer: D
Q10. Which command will enable automatic reorg on a database?
A. UPDATE DB CFG USING AUTO_REORG ON
B. UPDATE DB CFG USING AUTO_MAINT ON AUTO_REORG ON
C. UPDATE DB CFG USING AUTO_TBL_MAINT ON AUTO_REORG ON
D. UPDATE DB CFG USING AUTO_MAINT ON AUTO_TBL_MAINT ON AUTO_REORG ON
Answer: D