C2090-558 Online Practice Questions and Answers

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

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

Which of the following modes is NOT supported by Informix?

A. On-Line

B. Quiescent

C. Replication

D. Administration

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

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

Adding a row to which one of the following tables is required to create a database scheduler job?

A. ph_task

B. ph_alert

C. ph_sensor

D. ph_scheduler

Given the following table definition: CREATE TABLE t1(col1 BOOLEAN); Which of the following statements will fail to insert a row?

A. INSERT INTO t1 values ('t');

B. INSERT INTO t1 values ('f');

C. INSERT INTO t1 values (1);

D. INSERT INTO t1 values (NULL);

Which of the following can be used in a SELECT statement to set one or more qualifying conditions to a group of records after they are formed?

A. HAVING

B. WHERE

C. GROUP BY

D. ORDER BY

When you execute an INSERT statement, the database server will insert a NULL value into any column that meets which two conditions? (Choose two.)

A. Columns that are used in indexes.

B. Columns that are used in constraints.

C. You provide no value for a specific column.

D. Where a zero is specified in the VALUES clause of a serial column.

E. Where you specify the NULL keyword in the VALUES clause for a specific column.

Click the Exhibit button.

In the exhibit, which ALTER TABLE statement is used to add the foreign key constraint where customer_num column in the orders table is a foreign key that references the customer_num column in the customer table?

A. ALTER TABLE customer ADD CONSTRAINT (FOREIGN KEY (order_num) REFERENCES order );

B. ALTER TABLE orders ADD CONSTRAINT (FOREIGN KEY (order_num) REFERENCES customer );

C. ALTER TABLE customer ADD CONSTRAINT (FOREIGN KEY (customer_num) REFERENCES order );

D. ALTER TABLE orders ADD CONSTRAINT (FOREIGN KEY (customer_num) REFERENCES customer );

Which utility would you use to print out the physical layout of the instance?

A. onstat

B. onmode

C. onspaces

D. dbschema

Which of the following is true of system catalogs?

A. one system catalog per chunk

B. one system catalog per instance

C. one system catalog per database

D. one system catalog per installation

Which of the following statement is true of System Monitoring Interface (SMI) tables?

A. SMI tables store database structures.

B. Contains tasks used by the database scheduler

C. SMI tables are also known as System Catalog tables

D. Contains tables that the database server maintains automatically

Which of the following statement is correct about Shared Disk (SD) secondary servers?

A. SD secondary servers support automatic index repair

B. SD secondary servers use paging files to track pages between checkpoints

C. SD secondary servers require an HDR secondary server to be present in order to function

D. SD secondary servers can become a High-Availability Data Replication (HDR) secondary server

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