01. Which command can be used to report the history of the most recent full-system backup performed with ontape?
a) ontape -s -v
b) oncheck -pr
c) systat pages
d) onstat -L -0
02. Which utility can be used to export data from a single table for use by another application?
a) dbload
b) dbexport
c) onunload
d) dbaccess
03. Which file informs Informix tools where to find the keystore for encrypted connections?
a) $INFORMIXDIR/etc/onconfig
b) $INFORMIXDIR/etc/sqlhosts
c) $INFORMIXDIR/etc/conssl.cfg
d) $INFORMIXDIR/ssl/client.p12
04. Which statement is a best practice when generating table statistics for the optimizer to use?
a) It is recommended to run UPDATE STATISTICS LOW for each table, HIGH only for specific columns, and MEDIUM for the remaining columns in each table.
b) It is recommended to run UPDATE STATISTICS HIGH for the whole database.
c) It is recommended to run UPDATE STATISTICS LOW for each table and MEDIUM only for specific columns.
d) It is only necessary to run UPDATE STATISTICS LOW for each table.
05. The database server runs the following threads:
$ onstat -g ath|egrep 'lst|poll'
8 45fe1028 0 1 running 9soc* soctcppoll
9 45fe19b0 0 1 running 1cpu* ipcstrpoll
10 4601a028 0 2 sleeping forever 1cpu* soctcplst
11 46047a90 0 2 sleeping forever 1cpu* ipcstrl
What is the correct setting of NETTYPE configuration parameters for this server?
a) NETTYPE ipcstr,1,150,NET
NETTYPE soctcp,1,150,CPU
b) NETTYPE ipcstr,1,150,CPU
NETTYPE soctcp,1,150,CPU
c) NETTYPE ipcstr,1,150,CPU
NETTYPE soctcp,1,150,SOC
d) NETTYPE ipcstr,1,150,CPU
NETTYPE soctcp,1,150,NET
06. Which statement is true about using external smartblob spaces ?
a) Smart large objects can be stored externally in user-specified directories.
b) Smartblobs in external smartblob spaces cannot be backed up externally.
c) Smartblob directories are created with owner root and permission 700.
d) A traditional smartblob space is not required.
07. Which SQL administration API storage optimization operation returns unused extent pages to the chunk free list?
a) repack
b) shrink
c) reshrink
d) compress
08. The Informix Connection Manager Server has the following sqlhosts:
server_grp10 group - - e=server_3
# HDR Primary
server_1 onsoctcp my_host_1 9088 g=server_grp10
# HDR Secondary
server_2 onsoctcp my_host_2 9088 g=server_grp10
# HDR RSS
server_3 onsoctcp my_host_2 9088 g=server_grp10
If the connection manager SLA has:
CLUSTER my_cluster
{
INFORMIXSERVER server_grp10
SLA sla_1 DBSERVERS=(server_1,server_3) \
POLICY=WORKLOAD
SLA sla_2 DBSERVERS=(server_1,server_2,server_3) \
POLICY=ROUNDROBIN
SLA sla_3 DBSERVERS=ANY
FOC ORDER=ENABLED PRIORITY=1
}
If a client connects to sla_1, where will it connect?
a) server_1
b) Any server in the server_grp10 list
c) Whichever of server_1 and server_3 is next up in the queue
d) Whichever of server_1 and server_3 has the current lowest usage
09. Which statement about smart triggers is true?
a) They cannot be used with sharded queries
b) They are used to synchronize GRID queries
c) They execute asynchronously relative to the triggering event
d) They use AI to determine the final data updates
10. A heavily used table is experiencing performance degradation due to frequent extent allocations and disk fragmentation.
Which two options will provide a long-term solution?
(Choose two)
a) Add new chunk to dbspace
b) Increase the logical log size
c) Reorganize extents using admin task
d) Restart the Informix server to reorganize storage
e) Redefine the table with larger EXTENT SIZE and NEXT SIZE values
The purpose of this Sample Question Set is to provide you with information about the IBM Informix v15.0 Database Administrator - Professional exam. These sample questions will make you very familiar with both the type and the difficulty level of the questions on the C1000-210 certification test. To get familiar with real exam environment, we suggest you try our Sample IBM Informix Database Administrator Professional Certification Practice Exam. This sample practice exam gives you the feeling of reality and is a clue to the questions asked in the actual IBM Certified Informix v15.0 Database Administrator - Professional certification exam.
