IBM C2090-610 Online Practice Questions and Exam Preparation

IBM C2090-610 Online Questions & Answers

• Question 91:

  Which SQL statement will create a DB2 object that can be used to store numerical data as Canadian currency?

  A. CREATE DISTINCT ALIAS canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS
  B. CREATE DISTINCT TYPE canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS
  C. CREATE DISTINCT PROCEDURE canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS
  D. CREATE DISTINCT FUNCTION canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS
  B. CREATE DISTINCT TYPE canadian_dollar AS DECIMAL (9,3) WITH COMPARISONS

• Question 92:

  Which type of table is best suited for recording results from application data manipulation that is not required to be persistent?

  A. Base Table
  B. Temporal Table
  C. Transition Table
  D. Temporary Table
  D. Temporary Table

• Question 93:

  Which statement about large object (LOB) locators is true?

  A. A LOB locator is a data type that is used to store LOB data in binary files.
  B. A LOB locator is a data type that is used to store LOB data in a database.
  C. A LOB locator represents a value for a LOB resource that is stored in a database.
  D. A LOB locator represents a value for a LOB resource that is stored in a binary file.
  C. A LOB locator represents a value for a LOB resource that is stored in a database.

• Question 94:

  Which DB2 product is a database cluster solution for non-mainframe platforms and is best suited for Online Transaction Processing (OLTP) workloads?

  A. DB2 Connect
  B. DB2 pureScale
  C. Workload Manager
  D. High Availability Disaster Recovery
  B. DB2 pureScale

• Question 95:

  Which object is a stored procedure defined into?

  A. Table
  B. Schema
  C. Package
  D. Database
  B. Schema

• Question 96:

  A table named SALES contains a record for every sales transaction a company processes. A user wishes to see the number of transactions that are made by each salesman. Which SQL statement will produce the desired results?

  A. SELECT name, COUNT(*) AS transactions FROM sales
  B. SELECT name, COUNT(DISTINCT name) AS transactions FROM sales
  C. SELECT name, COUNT(*) AS transactions FROM sales GROUP BY name
  D. SELECT DISTINCT name, COUNT(*) AS transactions FROM sales GROUP BY transactions
  C. SELECT name, COUNT(*) AS transactions FROM sales GROUP BY name

• Question 97:

  A new user named USER1 needs to retrieve information from a database named MYDB. What authority must be granted to user USER1?

  A. DBCTRL authority
  B. SQLADM authority
  C. DATAACCESS authority
  D. ACCESSCTRL authority
  C. DATAACCESS authority

• Question 98:

  Which platform supports DB2 pureScale environments?

  A. AIX
  B. iOS
  C. z/OS
  D. Windows
  A. AIX

• Question 99:

  Which operation normally does NOT require an exclusive lock?

  A. BIND
  B. DROP
  C. GRANT
  D. SELECT
  D. SELECT

• Question 100:

  The WITH CHECK OPTION clause of the CREATE VIEW statement allows you to do which of the following?

  A. Define a view on one or more tables or views.
  B. Revalidate all invalid objects that are referenced on a view's fullselect.
  C. Ensure that any inserted or updated rows conform to the definition of the view.
  D. Define a view that only consists of columns that have check constraints defined.
  C. Ensure that any inserted or updated rows conform to the definition of the view.