Exam Code: C2090-730 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: DB2 9 Family Fundamentals
Certification Provider: IBM
Free Today! Guaranteed Training- Pass C2090-730 Exam.
2021 May C2090-730 Study Guide Questions:
Q101. 60 Which of the following best describes how locks are used in DB2?
A. To maintain control of updated rows for commit processing
B. To ensure only committed changes are altered by another application
C. To allow two applications to update the same row of data simultaneously
D. To prevent multiple applications from accessing the same data simultaneously
Answer: B
Explanation:
Q102. Which of the following is the best statement to use to create a user-defined data type that can be used to store currency values?
A. CREATE DISTINCT TYPE currency AS NUMERIC(7,2)
B. CREATE DISTINCT TYPE currency AS SMALLINT
C. CREATE DISTINCT TYPE currency AS BIGINT
D. CREATE DISTINCT TYPE currency AS DOUBLE
Answer: A
Explanation:
179. Which of the following DB2 data types can be used to store 1000 MB of single-byte character data?
A. BLOB
B. CLOB
C. DBCLOB
D. GRAPHIC
Answer: B
Explanation:
Q103. Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?
A. View
B. Alias
C. Table
D. Package
Answer: B
Explanation:
Up to the immediate present C2090-730 exam cram:
Q104. Which of the following is NOT true about schemas?
A. If a schema name is not specified, either by qualifying a database object name or by executing the SET CURRENT SCHEMA statement, the authorization ID of the current session user is used as the schema name by default
B. The value assigned to the CURRENT SCHEMA special register is persistent across database restarts
C. A schema enables the creation of multiple objects in a database without encountering namespace collisions
D. When most database objects are created, they are either implicitly or explicitly assigned to a schema
Answer: B
Explanation:
Q105. If the following statement is executed:
CREATE TABLE employee
(empid INT NOT NULL GENERATED BY DEFAULT
AS IDENTITY (START WITH 1, INCREMENT BY 5),
name VARCHAR(20),
dept INT CHECK (dept BETWEEN 1 AND 20),
hiredate DATE WITH DEFAULT CURRENT DATE,
salary DECIMAL(7,2), PRIMARY KEY(empid),
CONSTRAINT cst1 CHECK (YEAR(hiredate) > 2006 OR
Salary > 60500));
Which of the following INSERT statements will fail?
A. INSERT INTO employee VALUES (15, 'Smith', 5, '01/22/2004', 92500.00)
B. INSERT INTO employee VALUES (DEFAULT, 'Smith', 2, '10/07/2002', 80250.00)
C. INSERT INTO employee VALUES (20, 'Smith', 5, NULL, 65000.00)
D. INSERT INTO employee VALUES (DEFAULT, 'Smith', 10, '11/18/2004', 60250.00)
Answer: D
Explanation:
Q106. Given the requirements to store employee names, employee numbers, and when employees were hired, which of the following built-in data types CANNOT be used to store the day an employee was hired?
A. Character Large Object
B. Time
C. Varying-Length Character String
D. Timestamp
Answer: B
Explanation:
Free C2090-730 training materials:
Q107. User USER1 is the owner of TABLE1. Assuming user USER1 only holds privileges for TABLE1, which of the following is the best way to remove all privileges user USER1 holds?
A. REVOKE CONTROL ON table1 FROM user1
B. REVOKE ALL PRIVILEGES ON table1 FROM user1
C. REVOKE CONTROL ON table1 FROM user1; REVOKE ALL PRIVILEGES ON table1 FROM user1;
D. REVOKE CONTROL, ALL PRIVILEGES ON table1 FROM user1
Answer: C
Explanation:
Q108. Which tool must be used to analyze all of the database operations performed by an application against a DB2 for i5/OS database?
A. Visual Explain
B. Activity Monitor
C. SQL Performance Monitor
D. DB2 Performance Monitor
Answer: C
Explanation:
Q109. 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
Answer: D
Explanation:
Q110. Which of the following resources can be explicitly locked?
A. Row
B. Page
C. Table
D. Column
Answer: C
Explanation: