IBM C2090-558 Free Practice Questions

NEW QUESTION 1
Which two commands would create a table t1 with page level locking assuming default configuration parameter settings? (Choose two.)

• A. create table t1 (c1 int)
• B. create table t1 (c1 int) locking page
• C. create table t1 (c1 int) lock level page
• D. create table t1 (c1 int) lock mode page
• E. create table t1 (c1 int) locking mode page

Answer: AD

NEW QUESTION 2
Which document describes new Informix features?

• A. oncofig.std file
• B. Release Notes
• C. Machine Notes
• D. Quick Start Guide

Answer: B

NEW QUESTION 3
Which two statements about oninit are correct? (Choose two.)

• A. oninit can be used to initialize an Informix instance.
• B. oninit -m starts an Informix instance in multi-user mode.
• C. oninit -j starts an Informix instance in administration mode.
• D. oninit has a functionally equivalent Administration API command string.
• E. oninit can be used to change an instance from quiescent mode to online mode.

Answer: AC

NEW QUESTION 4
Which technology can be used to execute Data Definition Language (DDL) command across multiple instances?

• A. Flexible Grid
• B. Enterprise Replication
• C. High Availability Cluster
• D. High Availability Data Replication

Answer: A

NEW QUESTION 5
You received an error, "Chunk is not empty", while trying to remove a chunk. How do you verify which objects still occupy space in the chunk?

• A. onspaces
• B. onmonitor
• C. oncheck -pe
• D. SELECT * from SYSTABLES

Answer: C

NEW QUESTION 6
Which two column definitions can store whole numbers from -(2^63-1) to (2^63-1)? (Choose two.)

• A. INT
• B. INT8
• C. BIGINT
• D. DOUBLE
• E. LARGEINT

Answer: BC

NEW QUESTION 7
Under which of the following conditions does the LAST COMMITTED option have an effect on the COMMITTED READ isolation level?

• A. Row level lock
• B. Page level locking
• C. RAW or unlogged tables
• D. Tables containing complex data types

Answer: A

NEW QUESTION 8
Which one of the following is most suitable for scheduling the periodic collection of data
about an instance?

• A. Sensor
• B. Trigger
• C. Stored Procedure
• D. User Defined Routine

Answer: A

NEW QUESTION 9
Given the query shown below:

What will happen?

• A. All rows will be retrieved in which item_desc contains the characters 'pencil'.
• B. All rows will be retrieved in which item_desc does not contain the characters 'pencil'.
• C. All rows will be retrieved in which item_desc contains the letters 'p', 'e', 'n', 'c', 'i' and 'l' in any order.
• D. All rows will be retrieved in which item_desc contains the letters "P', 'E', 'N, C', I' and 'L' in any order.

Answer: A

NEW QUESTION 10
Which one of the following will generate a typical Decision Support System (DSS) type of workload?

• A. Ordering a book from an online retailer
• B. Inquiring usage data for a particular mobile phone user
• C. Bank operation involving transfer of money between two accounts
• D. Generating of a report by a large global retail company to find top selling items by country

Answer: D

NEW QUESTION 11
Which configuration parameters are used by ontape logical log backup?

• A. LOGFILES, LOGSIZE, TAPEDEV
• B. LTAPEBLK, TAPEDEV, TAPESIZE
• C. LTAPESIZE, LTAPEDEV, LTAPEBLK
• D. TAPEDEV, BAR_ACT_LOG, BACKUP_FILTER

Answer: C

NEW QUESTION 12
Which document provides details on preparing an operating system to run Informix?

• A. Machine Notes
• B. System User's Guide
• C. Operating System Guide
• D. Informix Migration Guide

Answer: A

NEW QUESTION 13
Click the Exhibit button.

In the exhibit, which statement is true regarding the update statement of Client 2 if both of the clients are connected to the same logged database?

• A. Client 2 will update col2 of the rows having col1=20.
• B. Client 2 will return successfully without updating any rows.
• C. Client 2 will keep waiting for client 1 to finish its transaction.
• D. Client 2 will get an error that the "record is locked" or the "table is locked".

Answer: D

NEW QUESTION 14
Which two statements are true about the COMMIT WORK statement? (Choose two.)

• A. The keyword WORK is optional.
• B. A single COMMIT WORK can end several BEGIN WORK statements.
• C. The COMMIT WORK statement releases all row locks but not table locks.
• D. All of the successful modifications that the transaction makes are saved to disk when you issue a COMMIT WORK statement.
• E. A new transaction automatically starts after each COMMIT WORK or ROLLBACK WORK statement in a nonlogged database.

Answer: AD

NEW QUESTION 15
In what way is Enterprise Replication (ER) replication different from High-Availability Cluster (HAC) replication?

• A. All data types are replicated.
• B. The data to be replicated is defined at an instance level of granularity.
• C. The data to be replicated can be defined at a column level of granularity.
• D. The data to be replicated can not include simple blobs stored in simple blobspaces.

Answer: C

NEW QUESTION 16
Which of the following modes is NOT supported by Informix?

• A. On-Line
• B. Quiescent
• C. Replication
• D. Administration

Answer: C

NEW QUESTION 17
Which two SQL commands can be used to invoke a stored procedure? (Choose two.)

• A. RUN function
• B. CALL function
• C. CALL procedure
• D. EXECUTE function
• E. EXECUTE procedure

Answer: DE

NEW QUESTION 18
Which two tasks can be accomplished using the OpenAdmin Tool (OAT)? (Choose two.)

• A. Manage Virtual Processors (VP).
• B. Automate the update statistics process.
• C. Perform installation of an Informix server.
• D. Run the High Performance Loader (HPL) GUI tool.
• E. Remove an instance's orphaned shared memory segment.

Answer: AB

NEW QUESTION 19
Which two installation modes are available for Informix? (Choose two.)

• A. Full
• B. Typical
• C. Custom
• D. Compact
• E. Complete

Answer: BC

NEW QUESTION 20
Which database contains the system-monitoring interface (SMI) tables which provide information about the state of the database server?

• A. sysutils
• B. sysstate
• C. sysmaster
• D. sysmonitor

Answer: C

NEW QUESTION 21
Which phase of Fast Recovery rolls forward (restores) all transactions since the last checkpoint and rolls back any uncommitted transactions?

• A. Logical Recovery
• B. Physical Recovery
• C. Dbspace Recovery
• D. Transactional Recovery

Answer: A

NEW QUESTION 22
Which Informix utility listed below will allow an administrator to run ad hoc SQL against the instance?

• A. onsql
• B. onadmin
• C. dbaccess
• D. dbschema

Answer: C

NEW QUESTION 23
What are two ways to create table t1 with row level locking? (Choose two.)

• A. Execute the command "create table t1 (c1 int) locking row".
• B. Execute the command "create table t1 (c1 int) lock level row".
• C. Execute the command "create table t1 (c1 int) lock mode row".
• D. Set DEF_TABLE_LOCKMODE to ROW in ONCONFIG before executing "create table t1(c1 int)".
• E. Set the environment variable DEF_TABLE_LOCKMODE to ROW before executing "create table t1(c1 int)".

Answer: CD

NEW QUESTION 24
Which utility can be used to relocate the physical log to a new dbspace?

• A. onlog
• B. ontape
• C. onspaces
• D. onparams

Answer: D

NEW QUESTION 25
What is the default isolation level on a database with unbuffered logging?

• A. Dirty Read
• B. Cursor Stability
• C. Committed Read
• D. Repeatable Read

Answer: C

NEW QUESTION 26
......