DB2 10.1 Fundamentals is created for the IT professionals that need
the basics information to pass the exam. The content and exam details of this
exam are provided in this article.
C2090-610: DB2 10.1 Fundamentals has been created for the entry
level professionals. The contents of this exam are as follows:
The first section is planning
covering ten percent of the course in which the applicants gain knowledge about
DB2 products such as z/OS vs LUW vs pureScale - at a high-level; different
products, awareness of database workloads which consists of DB2 product to use
- OLTP vs warehousing and non-relational data concepts. Second section is
Security which covers fifteen percent of the course that consists of scenarios
which those applicants have to decipher and gain the awareness of restricting
data right of entry, poles apart privileges and authorities, DCL SQL
announcement, results for statements, Row and Column Access Control (RCAC) and
Roles furthermore Trusted Contexts.
The C2090-610: DB2 10.1 Fundamentals third section is Working with
Databases and Database Objects which covers twenty percent of the exam where
the important objectives are attach to DB2 servers and databases, make out DB2
objects, fundamental characteristics and properties of DB2 objects, identify
results, System-period, Application-period, and Bi-temporal.
Working with DB2 Data using
SQL covers twenty percent of the exam hence is very important, the objects it
comprise are to make use of SQL to SELECT data from tables, SQL to SORT or
GROUP data, SQL to UPDATE, DELETE, or INSERT data, Knowledge of transactions
for example commit/rollback and transaction boundaries, an SQL supported modus
operandi defined occupation parameters and results, XQuery statement, knowledge
to identify results, Knowledge of Temporal (Time Travel) Tables.
Working with DB2 Tables, Views
and Indexes that covers twenty two percent of the C2090-610:
DB2 10.1 Fundamentals exam and consists of usage of DB2 data types such as
XML data types, Oracle compatibility data types, ability to create a temporary
table, identify when referential integrity should be, identify methods of data
constrain, characteristics of a table, view or index, make out when triggers
should be used and Knowledge of schemas.
The sixth section is Data
Concurrency which covers thirteen percent of the course in addition to includes
factors that influence locking, objects locks can be obtained; identify
characteristics of DB2 locks, the isolation levels that should be used in a
scene which is already given.
C2090-610: DB2 10.1 Fundamentals exam is of great benefits as it
provides a number of certification to the exam takers that have succeeded in
passing the exam, these are IBM Certified Application Developer - DB2 9.7 for
Linux, UNIX and Windows, IBM Certified Database Administrator - DB2 10 for
z/OS, IBM Certified Database 9.7 for Linux, UNIX and Windows IBM Certified
Advanced Database Administrator - DB2 10.1 for Linux, UNIX, and Windows, IBM
Certified Database Administrator - DB2 11 DBA for z/OS, IBM Certified Database
Administrator - DB2 10.5 DBA for LUW Upgrade from DB2 10.1, IBM Certified
System Administrator - DB2 10 for z/OS and IBM Certified System Administrator -
DB2 11 for z/OS.
No comments:
Post a Comment