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: | 000-730 (replaced by C2090-730) |
| Available Languages: | English |
| Certificate Validity Period: | Lifetime (no expiration) |
| Passing Score: | 590 / 1000 (59%) |
| Exam Price: | Approx. $200 USD (varies by region) |
| Related Certifications: | IBM Certified Database Administrator - DB2 9 for z/OS IBM Certified Application Developer - DB2 9 IBM Certified Database Administrator - DB2 9 |
| Exam Duration: | 90 minutes |
| Exam Format: | Linear / Adaptive, Multiple Choice |
| Real Exam Qty: | 64 |
| Recommended Training: | IBM DB2 9 Fundamentals Certification Study Guide IBM DB2 9 Fundamentals Training |
| Exam Registration: | Pearson VUE Registration IBM Certification Portal |
| Sample Questions: | IBM A2090-730 Sample Questions |
| Exam Way: | In-person at Pearson VUE test centers / Online proctored |
| Pre Condition: | No formal prerequisites; recommended basic database knowledge and 6+ months of DB2 experience |
| Official Syllabus URL: | https://www.ibm.com/certify |
IBM A2090-730 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Working with DB2 Tables, Views and Indexes | 23.5% | - Table structure and constraints - Views, materialized query tables - Data integrity and constraints - Index types and usage |
| Topic 2: Working with Databases and Database Objects | 17% | - Storage structures: tablespaces, containers - DDL statements: create, alter, drop objects - Instance and database connections - Schemas, tables, views, nicknames |
| Topic 3: Security | 11% | - Data and network encryption - Authorities, privileges, roles - Access control and authentication - GRANT / REVOKE statements |
| Topic 4: Working with DB2 Data using SQL and XQuery | 23.5% | - Transactions and concurrency control - DML statements: SELECT, INSERT, UPDATE, DELETE - XML and XQuery basics - Sorting, grouping, filtering data - Joins, subqueries, common table expressions |
| Topic 5: Planning | 14% | - Workload types: OLTP, OLAP, Data Warehousing - Non-relational and XML data concepts - DB2 tools and utilities - DB2 product family and editions |
IBM Assessment: DB2 9 Family Fundamentals Sample Questions:
A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet this requirement?
- A. Sequence
- B. INSTEAD OF Trigger
- C. Identity Column
- D. Table Function
If a unique constraint is defined on column COL1 of table TAB1, what are the characteristics of COL1?
- A. COL1 will accept NULL values and can be referenced in another table's foreign key specification.
- B. COL1 will not accept NULL values and can be referenced in anothertables foreign key specification.
- C. COL1 will accept NULL values and cannot be referenced in anothertables foreign key specification.
- D. COL1 will not accept NULL values and cannot be referenced in anothertables foreign key specification.
Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?
- A. Unique
- B. Referential
- C. Informational
- D. Check
Given the following table definitions:
EMPLOYEES
EMPID INTEGER
NAME CHAR(20)
DEPTID CHAR(3)
SALARY DECIMAL(10,2)
COMMISSION DECIMAL(8,2)
DEPARTMENTS
DEPTNO INTEGER DEPTNAME CHAR(20)
Which of the following statements will produce a result data set that satisfies all of these conditions:
> Displays the total number of employees in each department >> Displays the corresponding department name for each department ID >> Sorted by department employee count, from greatest to least
- A. SELECTdeptname, COUNT(empno) FROM departments, employees WHERE deptid = deptno GROUP BY deptname ORDER BY 2 DESC
- B. SELECTdeptname, COUNT(empno) FROM departments, employees WHERE deptid = deptno GROUP BY deptname ORDER BY 2 ASC
- C. SELECTdeptname, COUNT(*) FROM departments, employees WHERE deptid = deptno GROUP BY deptname ORDER BY 2
- D. SELECT *,COUNT(empno) FROM departments, employees WHERE deptid = deptno GROUP BY deptname ORDER BY 2 DESC
User USER1 has the privileges needed to invoke a stored procedure named GEN_RESUME. User USER2 needs to be able to call the procedure - user USER1 and all members of the group PUBLIC should no longer be allowed to call the procedure. Which of the following statement(s) can be used to accomplish this?
- A. GRANT EXECUTE ON ROUTINEgen_resume TO user2 EXCLUDE user1, PUBLIC
- B. GRANT CALL ON ROUTINEgen_resume TO user2 EXCLUDE user1 PUBLIC
- C. GRANT CALL ON PROCEDUREgen_resume TO user2;
REVOKE CALL ON PROCEDURE gen_resume FROM user1, PUBLIC; - D. GRANT EXECUTE ON PROCEDUREgen_resume TO user2;
REVOKE EXECUTE ON PROCEDURE gen_resume FROM user1, PUBLIC;
By Adela
