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. Four servers already belong to one Enterprise Replication domain. The DBA wants to distribute the rows of the orders table across them as a shard cluster.

What must be done on each shard server before cdr define shardCollection is run?

a) Set SHARD_ID to a unique positive integer

b) Set the same SHARD_ID on every server

c) Run SET ENVIRONMENT USE_SHARDING ON

d) Set SHARD_MEM to the number of shard servers

02. The onconfig file of a server contains AUTO_CKPTS 0, and onstat -g ckp shows transactions blocked by checkpoints several times an hour. The DBA does not want to resize any log.

Which onconfig setting lets the server trigger checkpoints earlier to avoid this blocking?

a) LOGFILES 12

b) LTXHWM 60

c) AUTO_CKPTS 1

d) PHYSBUFF 64

03. Queries on the customer table filter on region_of(zip), where region_of is an SPL function that derives the region from the zip string alone, without querying any table. The DBA has written the function but not yet created it in the database, and wants the optimizer to be able to use an index for that filter.

Which sequence achieves this?

a) CREATE FUNCTION region_of, then CREATE INDEX on region_of(zip), then filter on region_of(zip)

b) CREATE FUNCTION region_of declared NOT VARIANT, then CREATE INDEX on zip, then filter on region_of(zip)

c) CREATE INDEX on region_of(zip), then CREATE FUNCTION region_of, then filter on region_of(zip)

d) CREATE FUNCTION region_of declared NOT VARIANT, then CREATE INDEX on region_of(zip), then filter on region_of(zip)

04. Continuous logical-log backup stopped overnight when its tape device went offline. By morning, sessions that update data hang, and onstat -l shows every logical-log file with the U flag and none with the B flag. No long-running transaction is open.

Which statement explains the hang?

a) The server is blocked until the full logs are backed up

b) Fast recovery started because the logs filled and must finish first

c) The longest open transaction is rolling back to free logical-log space

d) The server is overwriting the oldest logs

05. After each nightly ON-Bar backup, the DBA runs onbar -v and treats a clean result as proof that everything backed up can be restored. Which two statements about this verification are true?

(Choose two.)

a) It cannot verify the logical-log backups

b) It also validates blobspace row-to-blob links

c) It repairs any page that fails verification

d) It runs only while the server is offline or quiescent

e) In an sbspace it checks only the smart-large-object extents

06. Session 212 runs a slow report from a packaged application whose code cannot be changed. The DBA wants the optimizer plans for that session's next statements written to explain output, starting now and without disconnecting the session.

Which command meets this need?

a) SET EXPLAIN ON in a DB-Access session

b) onmode -Y 212 1

c) onmode -z 212, then restart the report

d) onstat -g sql 212

07. Before a level-0 backup that will be kept for seven years, the DBA wants to confirm that the data pages and blobpage headers of the salesdb database are consistent, so that the archive does not preserve damaged structures.

Which command should run before the backup?

a) oncheck -cD salesdb

b) oncheck -pt salesdb:orders

c) dbschema -d salesdb -hd

d) onbar -v -w

08. Yesterday a DBA created the dbspace hist_dbs. That night the scheduled job ran onbar -b -L 1 for all storage spaces, as it does every weeknight.

How did ON-Bar handle hist_dbs?

a) It skipped hist_dbs, because a level-1 needs an earlier level-0

b) It backed up hist_dbs at level 0, because it had no level-0 backup yet

c) It stopped the entire job, since a level-1 needs a level-0 of every storage space

d) It took a level-1 of hist_dbs, with its creation as the baseline

09. On an online server, onstat -l shows logical-log file 118 with the flags U------. A developer asks the DBA to display the records in that file with onlog.

Which two statements are true?

(Choose two.)

a) In online mode onlog reads only the log buffers in shared memory, so the file is not touched

b) Waiting until the file is backed up and reading it from the backup avoids the blocking

c) Reading the file from disk now makes the server deny access to the logical-log files

d) An SQL administration API call can read the file without affecting sessions

e) Limiting the read to that file with the -n option avoids blocking other sessions

10. Nightly reporting jobs all run with PDQ enabled. The DBA wants no more than four PDQ queries to run concurrently, with any others waiting their turn.

What should the DBA configure?

a) Set PDQPRIORITY to 4

b) Set DS_MAX_SCANS to 4

c) Set DS_MAX_QUERIES to 4

d) Set VPCLASS cpu,num=4

Answers:

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

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.