Oracle 1Z0-116 study guide
Oracle 1Z0-116 · Work through your exam, one topic at a time.
Oracle Database 12c: SQL Fundamentals (exam code 1Z0-116) is an entry-level Oracle certification exam that tests whether you can read and write SQL against an Oracle database: querying one or more tables, filtering and sorting rows, applying single-row and group functions, converting data types, writing conditional logic, joining tables, using subqueries and set operators, and changing data and schema objects with DML and DDL. It suits people starting a database career - developers, report writers, QA and support staff, students - and anyone who wants a verifiable checkpoint on SQL skills before moving on to administration or PL/SQL. The Oracle 1Z0-116 study guide has 12 sections and about 3,698 words.
01Introduction to Oracle Database
This domain checks whether you understand the Oracle Database environment before writing queries: the difference between a database and an instance, users and schemas, tables and rows, and the SQL statement families. It also tests basic metadata knowledge, including DUAL and DESCRIBE.
316 words, about 2 min02Retrieve Data using the SQL SELECT Statement
This domain tests the SELECT statement as the foundation of Oracle SQL: choosing columns, creating expressions, naming output columns, eliminating duplicate rows, and understanding NULL behavior in arithmetic and concatenation. The logical clause order is SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.
302 words, about 2 min03Restrict and Sort Data
This domain tests restricting rows with WHERE and ordering with ORDER BY. It covers comparison operators, logical operators, BETWEEN, IN, LIKE, NULL tests, and null ordering.
298 words, about 1 min04Single-Row Functions
Single-row functions transform one row and return one result per row. This domain tests character, numeric, and date functions, including nesting.
269 words, about 1 min05Conversion Functions and Conditional Expressions
Conversion functions change data types explicitly; conditional functions replace nulls or choose values. This domain tests TO CHAR, TO DATE, TO NUMBER, NVL, NVL2, NULLIF, COALESCE, CASE, and DECODE.
283 words, about 1 min06Group Functions
Group functions aggregate many rows into one result. This domain tests COUNT, SUM, AVG, MIN, MAX, GROUP BY, HAVING, and null handling.
284 words, about 1 min07Joins
Joins combine rows from two or more tables using related columns. This domain tests inner joins, outer joins, self joins, cross joins, and join syntax.
339 words, about 2 min08Subqueries
Subqueries are queries nested inside another SQL statement. This domain tests single-row and multiple-row subqueries, IN, ANY, ALL, EXISTS, correlated subqueries, and scalar subqueries.
308 words, about 2 min09Set Operators
Set operators combine result sets from two or more SELECT statements. This domain tests UNION, UNION ALL, INTERSECT, MINUS, column rules, and ordering.
316 words, about 2 min10Manipulating Data
DML changes table data: INSERT, UPDATE, DELETE, and MERGE. This domain tests transaction control, row locks, and safe predicates.
295 words, about 1 min11Using DDL Statements to Create and Manage Tables
DDL creates and manages tables. This domain tests CREATE TABLE, data types, constraints, ALTER TABLE, DROP, TRUNCATE, and defaults.
345 words, about 2 min12Creating Other Schema Objects
Other schema objects support queries and data generation: views, sequences, indexes, and synonyms. This domain tests CREATE statements, options, and behavior.
343 words, about 2 min