We're so confident of our products that we provide no hassle product exchange.
IBM A2090-730 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | DB2 9 Family Fundamentals |
| Exam Number: | C2090-730 |
| Related Certifications: | IBM Certified Application Developer - DB2 9 IBM Certified Solution Developer - DB2 9 IBM Certified Database Administrator - DB2 9 |
| Passing Score: | 59% |
| Real Exam Qty: | 64 |
| Exam Price: | Approx. $200 USD (varies by region) |
| Certificate Validity Period: | Lifetime (no expiration, exam retired 31 Dec 2021) |
| Exam Format: | Multiple-response, Multiple-choice |
| Exam Duration: | 90 minutes |
| Available Languages: | English, Japanese |
| Recommended Training: | IBM DB2 9 Information Center IBM DB2 9 Fundamentals Training |
| Exam Registration: | IBM Certification Portal Pearson VUE IBM Exam Registration |
| Sample Questions: | IBM A2090-730 Sample Questions |
| Exam Way: | In-person at Pearson VUE centers / Online proctored (before retirement) |
| Pre Condition: | No mandatory prerequisites; basic knowledge of databases and SQL recommended |
| Official Syllabus URL: | https://www.ibm.com/certify |
IBM A2090-730 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| DB2 Security | 16.5% | - Role-Based Access Control - Data Protection and Auditing - Authentication and Authorization - Privileges and Authorities |
| Working with DB2 Data Using SQL | 23.5% | - SQL Functions and Expressions - Transaction Isolation Levels - DML Statements: SELECT, INSERT, UPDATE, DELETE - Sorting, Grouping, and Joining Data |
| Data Concurrency | 13% | - Concurrency Control - Avoiding Lock Contention - Locking Mechanisms - Isolation Levels and Their Impact |
| DB2 Installation and Configuration | 16% | - Connectivity Setup - Configuration Parameters - Installation Requirements and Procedures - Instance and Database Configuration |
| Working with Databases and Database Objects | 17% | - DDL Statements - Schemas, Tables, Views, Indexes, Constraints - Data Types and XML Support - Connecting to DB2 Servers and Databases |
| Planning | 14% | - DB2 Tools and Utilities - Database Workloads: OLTP vs Data Warehousing - Security and Access Control Basics - DB2 Editions and Packaging |
IBM Assessment: DB2 9 Family Fundamentals Sample Questions:
Question #1
If application A issues the following SQL statement, which of the following statements about concurrency is true?
SELECT deptno, deptname, mgrno FROM dept WHERE admrdept = 'A00' FOR READ ONLY WITH RS
- A. Rows accessed by application A can be seen by other applications.
- B. Results produced by re-execution of the statement by application A will not be affected by other applications.
- C. Application A can see uncommitted changes made by other applications.
- D. Rows accessed by application A cannot be seen by other applications.
Correct Answer: D 🗳️
Question #2
In which situation is shredding XML data recommended?
- A. When the data is of low volume and requires a complex star-schema topology
- B. When the data by nature has sparse attributes
- C. When thenumber of nodes are volatile
- D. When the data is naturally tabular
Correct Answer: D 🗳️
Question #3
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 (DEFAULT, 'Smith', 10, '11/18/2004', 60250.00)
- B. INSERT INTO employee VALUES (DEFAULT, 'Smith', 2, '10/07/2002', 80250.00)
- C. INSERT INTO employee VALUES (15, 'Smith', 5, '01/22/2004', 92500.00)
- D. INSERT INTO employee VALUES (20, 'Smith', 5, NULL, 65000.00)
Correct Answer: A 🗳️
Question #4
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 DOUBLE
- B. CREATE DISTINCT TYPE currency ASNUMERIC(7,2)
- C. CREATE DISTINCT TYPE currency AS SMALLINT
- D. CREATE DISTINCT TYPE currency AS BIGINT
Correct Answer: B 🗳️
Question #5
What does the following statement do? GRANT ALTER ON SEQUENCE gen_empid TO user1 WITH GRANT OPTION
- A. Gives USER1 the ability to change the comment associated with a sequence named GEN_EMPID, along with the ability to give this CONTROL authority for the sequence to other users and groups.
- B. Gives USER1 the ability to change the values returned by the PREVIOUS_VALUE and NEXT_VALUE expressions associated with a sequence named GEN_EMPID, along with the ability to give this authority to other users and groups.
- C. Gives USER1 the ability to change the comment associated with a sequence named GEN_EMPID, along with the ability to give this authority to other users and groups.
- D. Gives USER1 the ability to change the values returned by the PREVIOUS_VALUE and NEXT_VALUE expressions associated with a sequence named GEN_EMPID, along with the ability to give CONTROL authority for the sequence to other users and groups.
Correct Answer: C 🗳️
By Tim
