IBM C2090-730 Exam Questions & Answers

Which of the following is NOT a characteristic of a data warehouse?

A. Summarized queries that perform aggregations and joins

B. Heterogeneous data sources

C. Voluminous historical data

D. Sub-second response time

In which of the following scenarios would a stored procedure be beneficial?

A. An application running on a remote client needs to be able to convert degrees Celsius to degrees Fahrenheit and vice versa

B. An application running on a remote client needs to collect three input values, perform a calculation using the values provided, and store the input data, along with the results of the calculation in two different base tables

C. An application running on a remote client needs to track every modification made to a table that contains sensitive data

D. An application running on a remote client needs to ensure that every new employee that joins the company is assigned a unique, sequential employee number

Given the statement:

CREATE TABLE tablea (col1 INTEGER NOT NULL, CONSTRAINT const1 CHECK (col1 in (100, 200, 300)) Which of the following can be inserted into TABLEA?

A. 0

B. NULL

C. 100

D. '100'