IBM Informix Database Administrator Professional (C1000-210) Certification Sample Questions

Informix Database Administrator Professional Dumps, C1000-210 Dumps, C1000-210 PDF, Informix Database Administrator Professional VCE, IBM C1000-210 VCE, IBM Informix Database Administrator Professional PDF 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.

These sample questions are simple and basic questions that represent likeness to the real IBM C1000-210 exam questions. To assess your readiness and performance with real time scenario based questions, we suggest you prepare with our Premium IBM Informix Database Administrator Professional Certification Practice Exam. When you solve real time scenario based questions practically, you come across many difficulties that give you an opportunity to improve.

IBM C1000-210 Sample Questions:

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

Answers:

Question: 01 Answer: b	Question: 02 Answer: d	Question: 03 Answer: c	Question: 04 Answer: a	Question: 05 Answer: d
Question: 06 Answer: a	Question: 07 Answer: b	Question: 08 Answer: d	Question: 09 Answer: c	Question: 10 Answer: c, e

Note: For any error in IBM Certified Informix v15.0 Database Administrator - Professional (C1000-210) certification exam sample questions, please update us by writing an email on feedback@edusum.com.