C2090-558 Online Practice Questions and Answers

Which command option should be used to resume an interrupted onbar restore?

A. -RETRY

B. -RESTART

C. -REINTIIALZE

D. -BEGIN_AGAIN

Which isolation level is appropriate if you do not want your query to place any locks?

A. Dirty Read

B. Cursor Stability

C. Committed Read

D. Repeatable Read

Which two of the following are required for creating a dbspace? (Choose two.)

A. a mirror chunk

B. two or more chunks

C. a cooked file or raw device

D. a file owned by root or administrator

E. dbspace name containing only letters, digits, underscores, or $ characters.

In which database does Informix store the information when a new task is created in OpenAdmin Tool's Task Scheduler?

A. sysutils

B. sysusers

C. sysadmin

D. sysmaster

How does an administrator allocate a new dbspace from the storagepool?

A. Use the SQL Admin API

B. Use the oninit command

C. Use the onadmin command

D. Use the onspaces command.

Which of the following statements can be used to prevent duplicate values in an indexed column?

A. CREATE HASH INDEX

B. CREATE UNIQUE INDEX

C. CREATE DISTINCT TYPE

D. CREATE CLUSTER INDEX

You are about to create and load a table that will initially have a size of 50,000 KB. Once the table has been loaded, there will be very few additional inserts or updates to the table. When you create the table, which of the following extent size definitions would make the most effective use of disk space over time?

A. EXTENT SIZE 75000 NEXT SIZE 0

B. EXTENT SIZE 1000 NEXT SIZE 50000

C. EXTENT SIZE 50000 NEXT SIZE 1000 D. EXTENT SIZE 50000 NEXT SIZE 50000

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

Which two SQL API commands can be used to create a 10 MB dbspace? (Choose two.)

A. task ( )

B. admin ( )

C. oncmd ( )

D. ifxcreate ( )

E. oncreate ( )

Which of the following Informix server modes disable execution of SQL statements for all users while allowing administrative users to perform maintenance tasks?

A. Offline

B. On-Line

C. Quiescent

D. Administrative