{"EXAM_SERIES_CODE":"C1000-122","EXAM_STATUS_ID":"1","EXAM_REVIEW_APPROVAL_STATUS_OPS":false,"EXAM_REVIEW_APPROVAL_STATUS_OTHER":null,"EXAM_REVIEW_APPROVAL_STATUS_PUBLISH":null,"EXAM_TITLE":"Db2 12 for z/OS DBA Fundamentals","WITHDRAWAL_DATE":null,"CREATED_BY_EMAIL":"jessfern@us.ibm.com","CREATED_BY_DATE":"2021-06-09 00:00:00.000000","OWNER_NAME":null,"OWNER_EMAIL":null,"LAST_MODIFIED_BY_EMAIL":"kwall@cr.ibm.com","LAST_MODIFIED_BY_DATE":"2024-08-01 00:00:00.000000","EXAM_BUSINESS":"IBM Data and AI","EXAM_BRAND":"Analytics","EXAM_REPLACED_FLAG":false,"REPLACE_BY_EXAM_SERIES_CODE":null,"PREREQUISITE_EXAM_SERIES_CODE":null,"OVERVIEW_JOB_ROLE":null,"OVERVIEW_JOB_SKILL":null,"EXAM_TIME_LIMIT":90,"EXAM_PASSING_SCORE":69,"EXAM_NUMBER_OF_QUESTIONS":63,"EXAM_NUMBER_OF_QUESTIONS_TO_PASS":44,"EXAM_PRICE_DEVELOPED":null,"EXAM_PRICE_EMERGING":null,"EXAM_PRICE_JAPAN":null,"AVAILABLE_FOR_PROCTOR_FLAG":true,"WITHDRAWAL_WARNING_DAYS":30,"BADGE_REPLACED_FLAG":null,"REPLACE_BY_BADGE_ID":null,"EDUCATION_OVERVIEW":"All IBM certification tests presume a certain amount of \"on-the-job\" experience which is not present in any classroom or Web presentation. The recommended courses and links will help you gain the skill and product knowledge represented in the test objectives. They do not teach the answers to the test questions and are not intended to do so. This information may not cover all subject areas in the certification test or may contain more recent information than is present in the certification test. Taking these or any classes will not guarantee that you will achieve certification.","JTA_OBJECTIVE_UPLOAD_PATH":null,"JTA_SURVEY_FLAG":true,"JTA_JOB_ROLE_DESCRIPTION":"This Associate DBA certification is an entry level exam for a user of Db2 12 for z/OS. This individual is knowledgeable about the fundamental concepts of Db2 12 for z/OS through either hands-on experience or formal and informal education. The database associate should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.","BLUEPRINT_UPLOAD_PATH":null,"SURVEY_FROM_JTA_COUNT":20,"PLANNED_ASSESSMENT_EXAM_FLAG":true,"PLANNED_SAMPLE_QUESTIONS_FLAG":true,"NUMBER_OF_LIVE_FORMS":2,"NUMBER_OF_ITEMS_PER_FORM":63,"MINIMALLY_COMPETENT_CANDIDATE":"This Associate DBA certification is an entry level exam for a user of Db2 12 for z/OS. This individual is knowledgeable about the fundamental concepts of Db2 12 for z/OS through either hands-on experience or formal and informal education. The database associate should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.","ITEMTYPE_MULTIPLE_CHOICE":true,"ITEMTYPE_DOMC":false,"ITEMTYPE_BUILD_LIST":true,"ITEMTYPE_HOT_AREA":true,"ITEM_WRITING_TOOL_OTHER":null,"ITEM_WRITING_BEST_PRACTICE":true,"ITEM_WRITING_BEST_PRACTICE_OTHER":null,"ITEM_WRITING_TYPES":2,"ITEM_WRITING_GRAMMAR_CHECK_FLAG":true,"ITEM_WRITING_TECHNICAL_CHECK_FLAG":true,"PSYCHO_REVIEWED_ALL_FLAG":false,"PSYCHO_EVALUATE_TEN_PERCENT_FLAG":false,"PSYCHOMETRIC_REVIEWER_NAME":null,"PSYCHOMETRIC_REVIEWER_EMAIL":null,"STANDARDS_TWO_STEP_METHOD_FLAG":true,"STANDARDS_OTHER":null,"STANDARDS_OTHER_WHO":null,"STANDARDS_OTHER_DATE":null,"STANDARDS_OTHER_COMMENTS":null,"STANDARDS_SUPPORTING_FILES_UPLOAD_PATH":null,"CUTSCORE_RATING_FILE_UPLOAD_PATH":null,"FORMS_ASSESSMENT":true,"FORMS_SAMPLE_QUESTIONS":true,"FORMS_ITEMS_PER_FORM":63,"FORMS_ANCHOR_ITEMS_PER_FORM":9,"SAMPLE_EXAM_COS_KEY":null,"STUDY_GUIDE_COS_KEY":null,"TINSERTTS":"2021-06-09 11:42:24.989912","TLASTUPDTS":"2025-03-03 15:08:01.446488","FINANCE_BUSINESS_UNIT":"IBM Data and AI","FINANCE_BRAND":"Data and AI","EXAM_TYPE_ID":0,"DIVERSE_COUNTRY_BACKGROUND_FLAG":null,"EXAM_TYPE_DEVELOPING":"New version of an existing exam","STANDARDS_JOB_ROLE_DESC":"This Associate DBA certification is an entry level exam for a user of Db2 12 for z/OS. This individual is knowledgeable about the fundamental concepts of Db2 12 for z/OS through either hands-on experience or formal and informal education. The database associate should have an in-depth knowledge of the basic to intermediate tasks required in day-to-day administration, basic SQL (Structured Query Language), understand how to create databases and database objects, and have a basic knowledge of database security and transaction isolation.","ITEMTYPE_OTHER":null,"TARGET_PUBLICATION_DATE":"2021-06-16","PEARSONVUE_START_DATE":"2021-06-16 00:00:00.000000","ACTUAL_START_DATE":"2021-06-16 00:00:00.000000","FORMS_PSYCHOMETRICIAN_NAME":"Isaac Pfleger","FORMS_PSYCHOMETRICIAN_EMAIL":"isaac@cms.itemexperts.com","PEARSONVUE_SELECTION":"PearsonVue start date","ASSESSMENT_FLAG":true,"PARENT_FORMS":"Form A,Form B","GOVERNANCE_COMPLETED_FLAG":false,"WITHDRAWAL_REASON":null,"WITHDRAWAL_REASON_COMMENT":null,"PV_PUBLISH_DATE":null,"READY_FOR_LIVE_DATE":null,"UUID":"17d1ddbd-9540-47c4-957e-4f8c10f370ef","GO_LIVE_DATE":null,"MKTGCATEGORY":"MBDA1","EXAM_STATUS":"Live","MKTGCATEGORY_NAME":"Data, Analytics, and AI","OBJECTIVES":[{"EXAM_SERIES_CODE":"C1000-122","EXAM_OBJECTIVE_ID":0,"EXAM_OBJECTIVE_TITLE":"Planning","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"11","EXAM_OBJECTIVE_DESCRIPTION":"
  1. Connect to DB2 servers  
  2. Understand Db2 databases and the different types of tables and table spaces 
  3. Demonstrate knowledge of subsystem parameters
  4. Understand DB2 architecture 
  5. Understand data sharing concepts 
","EXAM_OBJECTIVE_ORDER":0,"TINSERTTS":"2024-08-01 18:53:43.049298","TLASTUPDTS":"2024-08-01 18:53:43.049298"},{"EXAM_SERIES_CODE":"C1000-122","EXAM_OBJECTIVE_ID":1,"EXAM_OBJECTIVE_TITLE":"Working with SQL and XML","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"21","EXAM_OBJECTIVE_DESCRIPTION":"
  1. Understand DML SQL statement
  2. Demonstrate knowledge of the most commonly used special registers, global variables and session variables 
  3. Demonstrate knowledge of built-in functions
","EXAM_OBJECTIVE_ORDER":1,"TINSERTTS":"2024-08-01 18:53:43.054459","TLASTUPDTS":"2024-08-01 18:53:43.054459"},{"EXAM_SERIES_CODE":"C1000-122","EXAM_OBJECTIVE_ID":2,"EXAM_OBJECTIVE_TITLE":"Security","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"8","EXAM_OBJECTIVE_DESCRIPTION":"
  1. Demonstrate an understanding of restricting data access
  2. Understand Data Control Language (DCL) SQL statement
","EXAM_OBJECTIVE_ORDER":2,"TINSERTTS":"2024-08-01 18:53:43.059770","TLASTUPDTS":"2024-08-01 18:53:43.059770"},{"EXAM_SERIES_CODE":"C1000-122","EXAM_OBJECTIVE_ID":3,"EXAM_OBJECTIVE_TITLE":"Operations","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"16","EXAM_OBJECTIVE_DESCRIPTION":"
  1. Demonstrate a basic knowledge of DB2 and DSN 
  2. Understand the basics of Db2 utilities 
  3. Demonstrate a basic knowledge of troubleshooting 
  4. Understand continuous delivery and function levels
","EXAM_OBJECTIVE_ORDER":3,"TINSERTTS":"2024-08-01 18:53:43.064607","TLASTUPDTS":"2024-08-01 18:53:43.064607"},{"EXAM_SERIES_CODE":"C1000-122","EXAM_OBJECTIVE_ID":4,"EXAM_OBJECTIVE_TITLE":"Data Concurrency","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"11","EXAM_OBJECTIVE_DESCRIPTION":"
  1. Understand transaction management 
  2. Demonstrate knowledge of locking and isolation levels
","EXAM_OBJECTIVE_ORDER":4,"TINSERTTS":"2024-08-01 18:53:43.069532","TLASTUPDTS":"2024-08-01 18:53:43.069532"},{"EXAM_SERIES_CODE":"C1000-122","EXAM_OBJECTIVE_ID":5,"EXAM_OBJECTIVE_TITLE":"Application Design","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"21","EXAM_OBJECTIVE_DESCRIPTION":"
  1. Demonstrate knowledge of stored procedures and user defined functions 
  2. Understand the use of temporary tables 
  3. Demonstrate knowledge of triggers and how to use them 
  4. Demonstrate knowledge of program preparation and BIND options
  5. Understand the basics of referential integrity and constraints
  6. Demonstrate knowledge of non-relational data concepts 
  7. Demonstrate knowledge of Temporal (Time Travel) and Archive Tables
  8. Understand the basic differences between writing static and dynamic SQL
","EXAM_OBJECTIVE_ORDER":5,"TINSERTTS":"2024-08-01 18:53:43.075299","TLASTUPDTS":"2024-08-01 18:53:43.075299"},{"EXAM_SERIES_CODE":"C1000-122","EXAM_OBJECTIVE_ID":6,"EXAM_OBJECTIVE_TITLE":"Working with Database Objects","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"12","EXAM_OBJECTIVE_DESCRIPTION":"
  1. Understand DDL SQL statements
  2. Demonstrate the ability to look up information in the Db2 Catalog
","EXAM_OBJECTIVE_ORDER":6,"TINSERTTS":"2024-08-01 18:53:43.080115","TLASTUPDTS":"2024-08-01 18:53:43.080115"}],"RESOURCES":[],"RELATED_CERTS":[{"PARTNERWORLD_CODE":"C8003803","CREDENTIAL_TITLE":"IBM Associate Certified DBA - Db2 12 for z/OS Fundamentals"}],"PREREQS":[],"ASSOC_COURSES":[{"COURSE_CODE":"CV844G","CSEMSTRNAME":"Db2 12 for z/OS Basic Database Administration"}],"ASSOC_NON":[],"ASSOC_PATHS":[],"ASSESSMENT":"A1000-122","LANGUAGES":"English","PRICE":200,"STUDY_GUIDE_URL":"https://s3-api.us-geo.objectstorage.softlayer.net/credman-prod/exam/C1000-122_STU_C1000122STU.pdf?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=88673a689335411dbbef07d4969c34c2%2F20260926%2Fus-geo%2Fs3%2Faws4_request&X-Amz-Date=20260926T183927Z&X-Amz-Expires=86400&X-Amz-SignedHeaders=host&response-content-disposition=inline%3B%20%3B%20filename%3D%22C1000-122_STU_C1000122STU.pdf%22&X-Amz-Signature=4a5e35946b34c13b3fafa0a711f2241bee9b22684f2e2fb935d22933c703c032","SAMPLE_EXAM_URL":"https://s3-api.us-geo.objectstorage.softlayer.net/credman-prod/exam/C1000-122_SAM_C1000122SAM.pdf?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=88673a689335411dbbef07d4969c34c2%2F20260926%2Fus-geo%2Fs3%2Faws4_request&X-Amz-Date=20260926T183927Z&X-Amz-Expires=86400&X-Amz-SignedHeaders=host&response-content-disposition=inline%3B%20%3B%20filename%3D%22C1000-122_SAM_C1000122SAM.pdf%22&X-Amz-Signature=ddfb135e0bb1b28ac73950c2af5daddd5fbb59df6572a59bcfe01ff1c8e45e14"}