873 お客様のコメント
質問 1：
Given the following customer table:
A. 4
B. 1
C. 3
D. 2
正解：D
質問 2：
Given the following SQL command where the DBSPACETEMP onconfig and environment variables are set to valid dbspaces:
create temp table mytemp (columns) with no log;
in what order will the instance evaluate where to place this table?
A. DBSPACETEMP onconfig parameter variable, root dbspace, dbspace where the database was created, DBSPACETEMP environment variable.
B. DBSPACETEMP onconfig parameter variable, DBSPACETEMP environment variable,
root dbspace, dbspace where the database was created.
C. DBSPACETEMP environment variable, root dbspace, dbspace where the database was created, DBSPACETEMP onconfig parameter.
D. DBSPACETEMP environment variable, DBSPACETEMP onconfig parameter, dbspace where the database was created, root dbspace.
正解：D
質問 3：
Which SQL Administration API command will merge non-contiguous table extents?
A. shrink
B. table repack
C. defragment
D. merge extents
正解：C
質問 4：
Which two objects are NOT included in a backup? (Choose two.)
A. External tables
B. Basic text search indexes stored in external dbspaces
C. Indexes
D. Simple blob data stored in simple blobspaces
E. Tables
正解：A,B
質問 5：
Which statement about temporary dbspaces is FALSE?
A. Temporary dbspaces are not backed up.
B. A raw table can be created in a temporary dbspace.
C. Temporary dbspaces can have non-default page sizes.
D. Tables stored in temporary dbspaces are not logged.
正解：B
質問 6：
Which of the following gives a good initial estimate for the physical log size?
A. 110% of combined buffer pool.
B. 110% the default buffer pool.
C. 110% of the logical log space.
D. 110% of rootdbs.
正解：A
質問 7：
Given the following SQL statement:
What does the merge statement do?
A. Deletes rows from tab2 and updates rows in tab1 that match the condition col1 = c1 by adding the c2 column value to the col2 column value of corresponding rows in tab1.
B. For each row that matches the condition col1 = c1, it inserts a new row in tab1 with the sum of corresponding c2 and col2 column values.
C. For the rows that match the condition, col1 = c1, it adds the col2 column value to the c2 column value and updates corresponding rows in tab2.
D. For the rows that match the condition col1 = c1, it adds the the c2 column value to the col2 column value and updates corresponding rows in tab1.
正解：D
質問 8：
Why do automatic checkpoints cause the database server to trigger more frequent checkpoints?
A. To avoid LRU flushes.
B. To avoid transaction blocking during checkpoints.
C. To ensure the onstat -g ckp report is accurate.
D. To ensure the buffer pool is always available.
正解：B
Given the following customer table:
A. 4
B. 1
C. 3
D. 2
正解：D
質問 2：
Given the following SQL command where the DBSPACETEMP onconfig and environment variables are set to valid dbspaces:
create temp table mytemp (columns) with no log;
in what order will the instance evaluate where to place this table?
A. DBSPACETEMP onconfig parameter variable, root dbspace, dbspace where the database was created, DBSPACETEMP environment variable.
B. DBSPACETEMP onconfig parameter variable, DBSPACETEMP environment variable,
root dbspace, dbspace where the database was created.
C. DBSPACETEMP environment variable, root dbspace, dbspace where the database was created, DBSPACETEMP onconfig parameter.
D. DBSPACETEMP environment variable, DBSPACETEMP onconfig parameter, dbspace where the database was created, root dbspace.
正解：D
質問 3：
Which SQL Administration API command will merge non-contiguous table extents?
A. shrink
B. table repack
C. defragment
D. merge extents
正解：C
質問 4：
Which two objects are NOT included in a backup? (Choose two.)
A. External tables
B. Basic text search indexes stored in external dbspaces
C. Indexes
D. Simple blob data stored in simple blobspaces
E. Tables
正解：A,B
質問 5：
Which statement about temporary dbspaces is FALSE?
A. Temporary dbspaces are not backed up.
B. A raw table can be created in a temporary dbspace.
C. Temporary dbspaces can have non-default page sizes.
D. Tables stored in temporary dbspaces are not logged.
正解：B
質問 6：
Which of the following gives a good initial estimate for the physical log size?
A. 110% of combined buffer pool.
B. 110% the default buffer pool.
C. 110% of the logical log space.
D. 110% of rootdbs.
正解：A
質問 7：
Given the following SQL statement:
What does the merge statement do?
A. Deletes rows from tab2 and updates rows in tab1 that match the condition col1 = c1 by adding the c2 column value to the col2 column value of corresponding rows in tab1.
B. For each row that matches the condition col1 = c1, it inserts a new row in tab1 with the sum of corresponding c2 and col2 column values.
C. For the rows that match the condition, col1 = c1, it adds the col2 column value to the c2 column value and updates corresponding rows in tab2.
D. For the rows that match the condition col1 = c1, it adds the the c2 column value to the col2 column value and updates corresponding rows in tab1.
正解：D
質問 8：
Why do automatic checkpoints cause the database server to trigger more frequent checkpoints?
A. To avoid LRU flushes.
B. To avoid transaction blocking during checkpoints.
C. To ensure the onstat -g ckp report is accurate.
D. To ensure the buffer pool is always available.
正解：B
吉野** -
A2090-919無事合格しました。模擬問題の画面と実際のテストの画面がほとんど同じで、いつもの練習通り試験を受けられました。PCで模擬問題を繰り返し、自分の不得意項目を復習しました。この問題集お勧めです。