Limited Time Discount Offer 30% Off - Ends in 02:00:00

×

IBM C2090-919 Exam - Informix 11.70 System Administrator

Questions & Answers for IBM C2090-919

Showing 1-15 of 123 Questions

Question #1 - Topic 1

What output is NOT reported by the dbschema utility?

A. The database logging mode.

B. The schemas of remote databases.

C. The table definitions without owner names.

D. The onspaces commands to re-create your systems' dbspaces.

Question #2 - Topic 1

Which sbspaces statement is FALSE?

A. Sbspaces may be recoverable.

B. Sbspaces can be of varying page size.

C. Sbspaces may be part of round robin fragmentation.

D. Sbspaces have read, write and seek properties similar to UNIX functions.

Question #3 - Topic 1

Which statement about automatic space management is true?

A. Spaces cannot be extended manually.

B. Only unmirrored spaces can be extended.

C. Mirrored and unmirrored spaces can be extended.

D. The time interval for low storage space checks is not user configurable.

Question #4 - Topic 1

Assuming you have a table with a replicate defined. A Flexible Grid procedure is executed
changing data in that table. What statement about replication of the changes is true?

A. The changes cannot be replicated.

B. The changes are replicated by default.

C. You have to call ifx_set_erstate( ) to replicate changes.

D. Only changes to primary key columns can be replicated.

Question #5 - Topic 1

Which two objects are NOT included in a backup? (Choose two.)

A. Tables

B. Indexes

C. External tables

D. Simple blob data stored in simple blobspaces

E. Basic text search indexes stored in external dbspaces

Question #6 - Topic 1

Which statement about auditing is NOT true?

A. You can enable auditing row updates for all rows in the table.

B. You can enable auditing row updates just for a subset of rows in the table.

C. You can enable auditing row updates for all rows from all tables in the database except for system catalog tables.

D. You can enable auditing row updates for all rows from all tables in the database and for the system catalog tables.

Question #7 - Topic 1

Which object can be defragmented?

A. index

B. external table

C. temporary table

D. system catalog table

Question #8 - Topic 1

How is the DBSSO group determined on a Unix system with role separation?

A. It is always the group informix.

B. It is set using the onsecurity command line tool.

C. It is the group that owns $INFORMIXDIR/dbssodir.

D. It is the group specified in the DBSSO onconfig parameter.

Question #9 - Topic 1

How many paging files are required for SD secondary instances?

A. There should always be two.

B. It depends on how many CPU VPs you have.

C. It depends on how many data dbspaces you have.

D. It depends on how many temporary dbspaces you have.

Question #10 - Topic 1

Which environment option can rollback transactions using a table involved in an ALTER
FRAGMENT ON TABLE operation?

A. FORCE_DML_EXEC

B. FORCE_DDL_EXEC

C. ROLLBACK_DML_EXEC

D. ROLLBACK_DDL_EXEC

Question #11 - Topic 1

Which of the following gives a good initial estimate for the physical log size?

A. 110% of rootdbs.

B. 110% the default buffer pool.

C. 110% of the logical log space.

D. 110% of combined buffer pool.

Question #12 - Topic 1

Which statement about mapped user functionality is true?

A. Mapped users cannot execute distributed operations.

B. Mapped users are allowed to run with multiple names.

C. The DBSA can control the access to tables at a row level using security labels.

D. The DBSA can grant database server access to externally authenticated users with no local account.

Question #13 - Topic 1

Which $ONCONFIG parameter triggers an automatic increase to a chunk or space based
on remaining free space?

A. SP_AUTOGROW

B. SP_THRESHOLD

C. SP_AUTOEXPAND

D. SP_CHUNKEXTEND

Question #14 - Topic 1

What is used during Fast Recovery to return pages to the original state?

A. Logical Log

B. Physical Log

C. External Tables

D. Temporary DBSpaces

Question #15 - Topic 1

Which option would be used with "cdr define replicate" to create a shadow replicate?

A. --backup

B. --mirrors

C. --shadow

D. --synchronize

WINTER SALE: 30% DISCOUNT
This is ONE TIME OFFER

You save
30%

Enter Your Email Address to Receive Your 30% Discount Code

WINTER SALE: 30% DISCOUNT

You save
30%

Use Discount Code:

A confirmation link was sent to your e-mail.

Please check your mailbox for a message from support@exam-labs.com and follow the directions.

Download Free Demo of VCE Exam Simulator

Experience Avanset VCE Exam Simulator for yourself.

Simply submit your e-mail address below to get started with our interactive software demo of your free trial.

  • Realistic exam simulation and exam editor with preview functions
  • Whole exam in a single file with several different question types
  • Customizable exam-taking mode & detailed score reports