1116 お客様のコメント
質問 1：
Which authority is required to revoke SECADM authority?
A. SYSADM
B. SQLADM
C. SECADM
D. DBADM
正解：C
質問 2：
Which statement is NOT true about a database restore operation?
A. A table space is not usable until the restore operation completes successfully.
B. A user can restore a database from a backup image on a 32-bit level into a 64-bit level, but not vice versa.
C. A database restore operation requires an exclusive connection. No applications can run against the database while the operation is inprogress.
D. A table space restore operation must be done offline.
正解：D
質問 3：
Which statement about triggers is FALSE?
A. A row-level trigger fires once for each row that is affected by a triggering event.
B. A statement-level trigger fires only once for each SQL statement.
C. A table-level trigger fires once for each table that is affected by a triggering event.
D. A trigger's code block can be executed either before or after a triggering event.
正解：C
質問 4：
Which is a valid statement about the Row and Column Access Control (RCAC) feature?
A. Users with SECADM authority are exempt from RCAC rules.
B. When a result set is restricted due to the RCAC rules defined on a table, no warnings or errors are returned.
C. RCAC is a more powerful security mechanism than Label Based Access Control (LBAC).
D. The RCAC feature uses a subset of Label Based Access Control (LBAC) functionality.
正解：B
質問 5：
What is the purpose of specifying the RESTART CONTINUE option in an INGEST command?
A. To terminate a failed INGEST command.
B. To clean up the log records of a failed INGEST command.
C. To restart a failed INGEST command from the last commit point.
D. To restart a failed INGEST command from the beginning.
正解：C
質問 6：
What authorization is needed to use the AUDIT statement to create an audit policy?
A. SYSADM
B. SYSMAINT
C. SECADM
D. DBADM
正解：C
質問 7：
If the following command is executed:
Which statement is true?
A. If using a remote database connection, the file "/mnt/datafile.del" must be accessible to the database server host.
B. Any indexes defined on table SCHEMA6.T1 will be marked invalid upon completion of the Load.
C. Rejected records will be inserted into the table SCHEMA2.E1
D. While the Load is executing, other transactions can both read and write into table SCHEMA6.T1
正解：C
Which authority is required to revoke SECADM authority?
A. SYSADM
B. SQLADM
C. SECADM
D. DBADM
正解：C
質問 2：
Which statement is NOT true about a database restore operation?
A. A table space is not usable until the restore operation completes successfully.
B. A user can restore a database from a backup image on a 32-bit level into a 64-bit level, but not vice versa.
C. A database restore operation requires an exclusive connection. No applications can run against the database while the operation is inprogress.
D. A table space restore operation must be done offline.
正解：D
質問 3：
Which statement about triggers is FALSE?
A. A row-level trigger fires once for each row that is affected by a triggering event.
B. A statement-level trigger fires only once for each SQL statement.
C. A table-level trigger fires once for each table that is affected by a triggering event.
D. A trigger's code block can be executed either before or after a triggering event.
正解：C
質問 4：
Which is a valid statement about the Row and Column Access Control (RCAC) feature?
A. Users with SECADM authority are exempt from RCAC rules.
B. When a result set is restricted due to the RCAC rules defined on a table, no warnings or errors are returned.
C. RCAC is a more powerful security mechanism than Label Based Access Control (LBAC).
D. The RCAC feature uses a subset of Label Based Access Control (LBAC) functionality.
正解：B
質問 5：
What is the purpose of specifying the RESTART CONTINUE option in an INGEST command?
A. To terminate a failed INGEST command.
B. To clean up the log records of a failed INGEST command.
C. To restart a failed INGEST command from the last commit point.
D. To restart a failed INGEST command from the beginning.
正解：C
質問 6：
What authorization is needed to use the AUDIT statement to create an audit policy?
A. SYSADM
B. SYSMAINT
C. SECADM
D. DBADM
正解：C
質問 7：
If the following command is executed:
Which statement is true?
A. If using a remote database connection, the file "/mnt/datafile.del" must be accessible to the database server host.
B. Any indexes defined on table SCHEMA6.T1 will be marked invalid upon completion of the Load.
C. Rejected records will be inserted into the table SCHEMA2.E1
D. While the Load is executing, other transactions can both read and write into table SCHEMA6.T1
正解：C
小田** -
先日、C2090-611認定資格を取りました。収録問題は9割程度、出題されました。
貴社の保証どおりですよね。信頼できます。これからもし更新があれば送付してください。
引き継ぎよろしくお願いします。