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 Database Administrator - DB2 9 IBM Certified Application Developer - DB2 9 IBM Certified Solution Developer - 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-choice, Multiple-response |
| 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 |
| Data Concurrency | 13% | - Concurrency Control - Avoiding Lock Contention - Locking Mechanisms - Isolation Levels and Their Impact |
| Planning | 14% | - DB2 Tools and Utilities - Database Workloads: OLTP vs Data Warehousing - Security and Access Control Basics - DB2 Editions and Packaging |
| 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 |
| DB2 Installation and Configuration | 16% | - Connectivity Setup - Configuration Parameters - Installation Requirements and Procedures - Instance and Database Configuration |
| 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 |
IBM Assessment: DB2 9 Family Fundamentals Sample Questions:
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.
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
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)
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
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.
Solutions:
| Question # 1 Answer: D | Question # 2 Answer: D | Question # 3 Answer: A | Question # 4 Answer: B | Question # 5 Answer: C |
By Rock
