IBM C2090-548 問題集

質問 1：
What is the role of the DB2 control center?
A. The DB2 control center allows you to administer all your systems, instances, databases, anddatabase objects.
B. DB2 does not have a DB2 control center.
C. The DB2 control center serves as a collection of command-line entry commands that allow theDBA to administer the DB2 database.
D. The DB2 control center is the main table where all metadata about the database is stored in aDB2 database.
正解：A

質問 2：
What are DB2 wizards?
A. DB2 wizards are DBAs that are considered the top of their field in DB2.
B. DB2 wizards are programs that assist you in completing a single task by stepping you throughthe task.
C. DB2 wizards programs are automated in DB2. They run as background processes of thedatabase and they automatically configure database parameters.
D. DB2 does not have wizard functionality.
正解：B

質問 3：
Which statement about the use of Database Image Copy 2 (IC2) is FALSE?
A. The databases copied by IC2 must be registered to DBRC.
B. The database being copied by IC2 cannot be HISAM.
C. The database being copied by IC2 cannot be an Index database.
D. The control statements used for IC2 are the same as those for Batch Image Copy.
正解：D

質問 4：
What is the role of the XML data type in DB2?
A. The XML data type allows you to store well-formed XML documents in their hierarchical formwithin the columns of a table.
B. The XML data type allows a parser to use the metadata in a table to link to an external XMLdocument stored outside of the columns of a table.
C. The XML data type allows you to link a reference to an XML document stored outside of thecolumns of a table.
D. The XML data type does not exist.
正解：A

質問 5：
Which one of the following statements is true?
A. Each logical record in a HISAM database primary dataset contains the root plus alldependents of the root (in hierarchical sequence) for which there is space. The remainingsegments of the database record are put in the overflow dataset.
B. Each logical record in a HISAM database primary dataset contains the root plus alldependents of the root (in insertion sequence).
C. Each logical record in a HISAM database primary dataset contains the root plus alldependents of the root (in hierarchical sequence).
D. Each logical record in a HISAM database primary dataset contains the root plus alldependents of the root (in insertion sequence) for which there is space. The remainingsegments of the database record are put in the overflow dataset.}
正解：A

質問 6：
What are some of the benefits of DB2 Express?
A. DB2 Express is fastest and most powerful DB2 edition.
B. DB2 Express is designed for development and testing. It is not used as a production database.
C. DB2 Express has affordable licensing terms with all of the core features of the DB2 engine.
D. DB2 Express is a tool that allows DBAs to quickly solve complex database issues.
正解：C

質問 7：
What is the DB2 journal?
A. The DB2 journal is a free newsletter that is published monthly to subscribers and that hasarticles of interest to DBAs.
B. The DB2 journal is a GUI that displays historical information about tasks, database actions andoperations, control center actions, messages, and alerts in your DB2 database.
C. The DB2 journal is a feature that allows for commands in a transaction to be rolled back. Allcommands that have been executed in a particular transaction can be undone using the DB2journal.
D. DB2 does not have a journal.
正解：D

質問 8：
Which one of the following options contains a benefit of the Java Generic Table Functions?
A. Java Generic Table Functions can be implemented in any programming language.
B. Java Generic Table Functions allow you to specify the output of a table function when you create it, rather than when you reference it.
C. Java Generic Table Functions allow you to specify the output of a table function when you reference it, rather than when you create it.
D. Java Generic Table Functions must run on a separate server, thus they don't consume DB2 resources.
正解：C