IBM C2090-615 Exam Details & Actual Exam Questions

  • Exam Code/Number: C2090-615
  • Exam Name/Title: DB2 10.5 Fundamentals for LUW
  • Certification Provider: IBM
  • Corresponding Certification: IBM Certification
  • Certification Level: Associate

IBM DB2 10.5 Fundamentals for LUW Exam Questions

We are already working hard to make C2090-615 exam material available to our valued customers. If you are interested in C2090-615 exam material, provide us your email and we will notify you.

IBM C2090-615 Exam Overview:

Certification Vendor:IBM
Exam Name:DB2 10.5 Fundamentals for LUW
Exam Number:C2090-615
Related Certifications:IBM Certified Database Associate - DB2 10.5 Fundamentals for LUW
Passing Score:61%
Exam Price:$200 USD
Certificate Validity Period:Not specified
Exam Duration:90 minutes
Exam Format:Multiple Response, Multiple Choice
Available Languages:English, Japanese
Real Exam Qty:62
Exam Way:Pearson VUE testing center or authorized IBM testing delivery platform.
Pre Condition:No prerequisite exam required. Intended for entry-level users familiar with DB2 10.5 for Linux, UNIX, and Windows.
Official Syllabus URL:https://www.ibm.com/training/certification/ibm-certified-database-associate-db2-105-fundamentals-for-luw-08003505

IBM C2090-615 Exam Syllabus Topics:

SectionObjectives
Security- Advanced security
  • 1. Trusted Context
  • 2. Label-Based Access Control (LBAC)
  • 3. Row and Column Access Control (RCAC)
- Database security concepts
  • 1. Authorities and privileges
  • 2. Authentication and authorization
Data Concurrency- Concurrency control
  • 1. Locking behavior
  • 2. Deadlocks
  • 3. Isolation levels
Planning- Oracle compatibility
  • 1. Compatibility features
  • 2. Application enablement
- BLU Acceleration
  • 1. Concepts and benefits
  • 2. Implementation requirements
- DB2 product editions and packaging
  • 1. Supported features by edition
  • 2. Database workloads and deployment options
Working with DB2 Data Using SQL and XQuery- Transaction control
  • 1. COMMIT
  • 2. ROLLBACK
  • 3. AUTOCOMMIT
  • 4. SAVEPOINT
- XML support
  • 1. XPath expressions
  • 2. XQuery
- SQL fundamentals
  • 1. DELETE
  • 2. SELECT
  • 3. INSERT
  • 4. UPDATE
- Programmability
  • 1. User-defined functions
  • 2. Triggers
  • 3. Stored procedures
Working with DB2 Tables, Views, and Indexes- Index management
  • 1. Index enhancements in DB2 10.5
  • 2. Index types
- Table management
  • 1. Constraints
  • 2. Table creation and maintenance
- View management
  • 1. View concepts and usage
Working with Databases and Database Objects- Specialized table types
  • 1. MQT tables
  • 2. MDC tables
  • 3. RCT tables
  • 4. Range partitioned tables
  • 5. Temporal tables
  • 6. ITC tables
- Database objects
  • 1. Views
  • 2. Tables
  • 3. Indexes


0
0
0
10