IBM C2090-611 - DB2 10.1 DBA for Linux, UNIX, and Windows Exam
Page: 2 / 24
Total 116 questions
Question #6 (Topic: Topic 1)
Whichstatement is correct when describing trusted contexts?
A. A trusted context defines a trust relationship for a connection between the database and an external entity.
B. A trusted context promotes the authorization level of the connection initiator and grants them DBADM authority.
C. A trusted context defines a trust relationship between a user and a table allowing that user additional capabilities.
D. A trusted context gives the database connection the ability to bypass auditing since authentication has already occurred.
Answer: A
Question #7 (Topic: Topic 1)
Which system command can beused to locate and return only ADM4500W messages from
the DB2 diagnostics log file?
the DB2 diagnostics log file?
A. db2pd
B. db2diag
C. db2trace
D. db2fmtdiag
Answer: B
Question #8 (Topic: Topic 1)
Which statement about the ADMIN_MOVE_TABLE procedureis true?
A. The ADMIN_MOVE_TABLE procedure immediately applies all changes that occur to data in the active (source) table during the move operation to 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-supplied staging 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, the target 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 thetarget table is to be created automatically, a name that is different from that of the active table must be specified for the target table.
Answer: C
Question #9 (Topic: Topic 1)
You have just converted an existing database to an automatic storage database. What can
you use to move data from an existing DMS table space to an automatic storage table
space, while the data remains online and available for access?
you use to move data from an existing DMS table space to an automatic storage table
space, while the data remains online and available for access?
A. The db2move command
B. The db2relocatedb command
C. The ADMIN_MOVE_TABLE procedure
D. The ADMIN_MOVE_TABLE_UTIL procedure
Answer: C
Question #10 (Topic: Topic 1)
Which statement regarding snapshot administrative views and snapshot monitor table
functions is true?
functions is true?
A. Snapshot administrative views cannot be used with monitor switches or monitor reset commands while snapshot table functions have no such restrictions.
B. Snapshot table functions cannot be used with monitor switches or monitor reset commands while snapshot administrative views have no such restrictions.
C. Snapshot administrative views provide the option to choose between data from a single database partition or a data subset from across all database 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 choose between data from a single database partition or a data subset from across all database partitions.
Answer: D
