質問 1：
Which ONCONFIG parameter would you use to disable the automatic creation or extension of chunks?
A. SP_WAITTIME
B. SP_AUTOEXPAND
C. SP_CHUNKEXTEND
D. SP_THRESHOLD
正解：B
質問 2：
After executing the following commands: onmode -j -U karin,dave onmode -j -U karin,sarah onmode -j -U sarah which user(s) have access to the instance?
A. karin and sarah
B. karin and dave
C. sarah
D. karin, dave and sarah
正解：C
質問 3：
Consider the following Enterprise Replication command: cdr define template temp1 -c g_serv1 -C ignore -a -d testdb. Which statement is TRUE?
A. The command defines a template to exclude database testdb from replication.
B. The command defines a template to be realized on servers serv4 and serv5.
C. The command defines a template to replicate the entire database testdb by defining replicates for each of the views and system tables in
testdb.
D. The command defines a template to replicate the entire database testdb by defining replicates for each of the user defined tables in testdb.
正解：D
質問 4：
Which statement is FALSE?
A. A new index can be created compressed.
B. Attached indexes cannot be compressed.
C. A compressed index cannot be uncompressed.
D. A compressed index can be uncompressed.
正解：D
質問 5：
Which technology does NOT use the Secure Sockets Layer (SSL) protocol for an end-to- end secure connection?
A. Enterprise Replication
B. High-Availability Data Replication
C. On-disk encryption
D. Server-to-server distributed query communication
正解：C
質問 6：
Which statement accurately describes the mapped user functionality in Informix?
A. The DBSA can grant access to the database server to users of the host computer operating system by implementing different authentication mechanisms for each user.
B. The DBSA can control the access to the database at the table level by creating different security labels for each user.
C. The DBSA can configure the server to allow database access by external users who do not have operating system accounts on the host computer.
D. The DBSA can create different roles for each user in order to verify whether the user who is attempting an operation has the necessary privileges.
正解：C
質問 7：
Which configuration parameter can be set to quickly return rows to a user while a query continues processing?
A. OPT_GOAL
B. OPTOFC
C. OPTMSG
D. OPTCOMPIND
正解：A
質問 8：
Which value of DRINTERVAL should be used for HDR_TXN_SCOPE configuration parameter to take effect?
A. 0
B. -1
C. 1
D. 30
正解：A
Which ONCONFIG parameter would you use to disable the automatic creation or extension of chunks?
A. SP_WAITTIME
B. SP_AUTOEXPAND
C. SP_CHUNKEXTEND
D. SP_THRESHOLD
正解：B
質問 2：
After executing the following commands: onmode -j -U karin,dave onmode -j -U karin,sarah onmode -j -U sarah which user(s) have access to the instance?
A. karin and sarah
B. karin and dave
C. sarah
D. karin, dave and sarah
正解：C
質問 3：
Consider the following Enterprise Replication command: cdr define template temp1 -c g_serv1 -C ignore -a -d testdb. Which statement is TRUE?
A. The command defines a template to exclude database testdb from replication.
B. The command defines a template to be realized on servers serv4 and serv5.
C. The command defines a template to replicate the entire database testdb by defining replicates for each of the views and system tables in
testdb.
D. The command defines a template to replicate the entire database testdb by defining replicates for each of the user defined tables in testdb.
正解：D
質問 4：
Which statement is FALSE?
A. A new index can be created compressed.
B. Attached indexes cannot be compressed.
C. A compressed index cannot be uncompressed.
D. A compressed index can be uncompressed.
正解：D
質問 5：
Which technology does NOT use the Secure Sockets Layer (SSL) protocol for an end-to- end secure connection?
A. Enterprise Replication
B. High-Availability Data Replication
C. On-disk encryption
D. Server-to-server distributed query communication
正解：C
質問 6：
Which statement accurately describes the mapped user functionality in Informix?
A. The DBSA can grant access to the database server to users of the host computer operating system by implementing different authentication mechanisms for each user.
B. The DBSA can control the access to the database at the table level by creating different security labels for each user.
C. The DBSA can configure the server to allow database access by external users who do not have operating system accounts on the host computer.
D. The DBSA can create different roles for each user in order to verify whether the user who is attempting an operation has the necessary privileges.
正解：C
質問 7：
Which configuration parameter can be set to quickly return rows to a user while a query continues processing?
A. OPT_GOAL
B. OPTOFC
C. OPTMSG
D. OPTCOMPIND
正解：A
質問 8：
Which value of DRINTERVAL should be used for HDR_TXN_SCOPE configuration parameter to take effect?
A. 0
B. -1
C. 1
D. 30
正解：A
0 お客様のコメント