1Z0-149 case studies
1Z0-149 · Put your knowledge to work in context.
The Oracle Database SQL 1Z0-149 exam is the certification test behind the Oracle Database SQL Certified Associate credential. It validates that you can write and reason about SQL against an Oracle Database using SQL Plus or SQL Developer: querying one and many tables, filtering and sorting, single-row and conversion functions, conditional logic, aggregate reporting, subqueries, set operators, DML, and the objects around them such as indexes, sequences, synonyms, views, temporary tables, and data dictionary views. The 1Z0-149 case studies are 5 cases and about 4,523 words.
1Regional Order Report: Inflated Counts, Missing Regions, Overstated Revenue
FleetOps runs its order analytics on Oracle 19c. ORDERS has order id (primary key), customer id, order date DATE and status VARCHAR2(1), where 'N' is new, 'S' shipped, 'P' pending and 'X' cancelled.
920 words, about 5 min2Never-Ordered Customers and the Latest-Order Query That Returns Extra Rows
Helio CRM stores CUSTOMERS(customer id NUMBER PRIMARY KEY, email VARCHAR2(120), created date DATE) and ORDERS(order id NUMBER PRIMARY KEY, customer id NUMBER, order total NUMBER(10,2), order ts TIMESTAMP, order status VARCHAR2(12)). ORDERS.customer id is nullable because the storefront accepts guest checkouts: 9% of 2.4 million order rows have NULL there.
903 words, about 5 min3Sequence Wraparound, a Shadowing Synonym and an Unused Index
TicketHub migrated 500,000 tickets from a legacy system last quarter. The application schema is APP, the reporting schema is RPT.
858 words, about 4 min4Grade Banding, NLS-Dependent Date Filters and Sort Order
Nordwind runs HR reporting on Oracle 19c. EMPLOYEES has emp name VARCHAR2(60), sal NUMBER(8,2), hire date DATE, grade code VARCHAR2(3) and commission pct NUMBER(4,2) NULL.
859 words, about 4 min5Union Deduplication, MERGE Instability and a Non-Key-Preserved View
MediTrack's nightly ETL has three defects. STAGING EXTRACT(source system VARCHAR2(3), patient key VARCHAR2(20), updated ts TIMESTAMP, note CLOB) holds 240,000 rows; PATIENT MASTER is keyed by (source system, patient key).
983 words, about 5 min