Full Name: Oracle Database SQL
Exam Code: 1Z0-071
Oracle 1Z0-071 Exam Details:
Exam Name
|
Oracle Database SQL
|
Exam Code
|
1Z0-071
|
Exam Price
|
USD $245 (Price may vary by country or by localized currency)
|
Duration
|
120 minutes
|
Number of Questions
|
78
|
Passing Score
|
63%
|
Format
|
Multiple Choice Questions (MCQ)
|
Recommended Training
|
|
Sample Questions
|
|
Recommended Practice
|
Oracle 1Z0-071 Syllabus Topics:
Relational Database concepts | - Explaining the theoretical and physical aspects of a relational database - Relating clauses in SQL Select Statement to Components of an ERD - Explaining the relationship between a database and SQL |
Retrieving Data using the SQL SELECT Statement | - Using Column aliases - Using The SQL SELECT statement - Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword - Using Arithmetic expressions and NULL values in the SELECT statement |
Restricting and Sorting Data | - Applying Rules of precedence for operators in an expression - Limiting Rows Returned in a SQL Statement - Using Substitution Variables - Using the DEFINE and VERIFY commands - Sorting Data |
Using Single-Row Functions to Customize Output | - Manipulating strings with character functions in SQL SELECT and WHERE clauses - Performing arithmetic with date data - Manipulating numbers with the ROUND, TRUNC and MOD functions - Manipulating dates with the date function |
Using Conversion Functions and Conditional Expressions | - Applying the NVL, NULLIF, and COALESCE functions to data - Understanding implicit and explicit data type conversion - Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions - Nesting multiple functions |
Reporting Aggregated Data Using Group Functions | - Restricting Group Results - Creating Groups of Data - Using Group Functions |
Displaying Data from Multiple Tables | - Using Self-joins - Using Various Types of Joins - Using Non equijoins - Using OUTER joins - Understanding and Using Cartesian Products |
Using Subqueries to Solve Queries | - Using Single Row Subqueries - Using Multiple Row Subqueries - Update and delete rows using correlated subqueries |
Using SET Operators | - Matching the SELECT statements - Using the ORDER BY clause in set operations - Using The INTERSECT operator - Using The MINUS operator - Using The UNION and UNION ALL operators |
Managing Tables using DML statements | - Managing Database Transactions - Controlling transactions - Perform Insert, Update and Delete operations - Performing multi table Inserts - Performing Merge statements |
Managing Indexes Synonyms and Sequences | - Managing Indexes - Managing Synonyms - Managing Sequences |
Use DDL to manage tables and their relationships | - Describing and Working with Tables - Describing and Working with Columns and Data Types - Creating tables - Dropping columns and setting column UNUSED - Truncating tables - Creating and using Temporary Tables - Creating and using external tables - Managing Constraints |
Managing Views | - Managing Views |
Controlling User Access | - Differentiating system privileges from object privileges - Granting privileges on tables - Distinguishing between granting privileges and roles |
Managing Objects with Data Dictionary Views | - Using data dictionary views |
Managing Data in Different Time Zones | - Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP - Working with INTERVAL data types |
0 comments:
Post a Comment