|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/practice-exam-oracle-sql-certification/
课程评论：没有评论
本课程是针对 Oracle Database SQL 1Z0-071 认证考试的模拟练习。 **课程概览：** * 提供两套模拟试题， format 与真实考试一致。 * **建议练习方式：** 模拟真实考试环境，找一个网络稳定、不受打扰的地方，在 2 小时内完成一套试题。之后分析错题类型和耗时较多的题目，进行针对性复习，并计划跳过某些题目以节省时间。然后进行第二套试题练习。 **Oracle Database SQL 1Z0-071 认证介绍：** * 成为 Oracle Database SQL Certified Associate，证明您掌握基础 SQL 概念，可应用于任何数据库项目。 * 通过考试表明您深入了解 SQL 及其在 Oracle Database 服务器上的应用。 * 涵盖查询、插入、更新、删除 SQL 语句，部分数据定义语言 (DDL) 和数据控制语言 (DCL)，以及优化器、表、索引、数据建模和规范化。 **1Z0-071 考试形式：** * 多项选择题，共 78 道题。 * 合格分数线为 63%。 * 考试时长为 2 小时（120 分钟）。 * 建议通过大量模拟练习熟悉考试结构，应对可能出现的、包含多个正确答案或情景类问题。 **1Z0-071 认证价值：** * 证明您精通 SQL 语言，深入理解数据建模，并能使用 SQL 在 Oracle 数据库中创建和操作表。 * 合格考生通常具备通用的计算概念知识、命令行接口知识以及命令行操作经验。 **1Z0-071 考试大纲：** * **关系数据库概念：** 讲解关系数据库的理论和物理方面，SQL 子句与 ERD 组件的关系，数据库与 SQL 的关系。 * **使用 SELECT 语句检索数据：** 列别名、连接符、DISTINCT 关键字、算术表达式和 NULL 值、限制和排序数据（操作符优先级、限制行数、Substitution Variables、DEFINE 和 VERIFY 命令）、使用单行函数（字符函数、日期算术、数字函数、日期函数）、转换函数和条件表达式（NVL、NULLIF、COALESCE、隐式/显式数据类型转换、TO_CHAR, TO_NUMBER, TO_DATE）。 * **使用组函数聚合数据：** 限制分组结果、创建数据组、使用组函数。 * **显示来自多个表的数据：** 自连接、各种 JOIN 类型、非等值连接、外连接、笛卡尔积。 * **使用子查询解决查询：** 单行子查询、多行子查询、使用相关子查询更新和删除行。 * **使用集合运算符：** 匹配 SELECT 语句、ORDER BY 子句在集合操作中的使用、INTERSECT、MINUS、UNION 和 UNION ALL 运算符。 * **使用 DML 语句管理表：** 管理数据库事务、控制事务、执行 INSERT、UPDATE、DELETE 操作、多表插入、MERGE 语句。 * **管理索引、同义词和序列：** 索引、同义词、序列。 * **使用 DDL 管理表及其关系：** 描述和操作表、列和数据类型、创建表、删除列和设置 UNUSED 列、截断表、创建和使用临时表、创建和使用外部表、管理约束。 * **管理视图：** 描述和操作视图。 * **控制用户访问：** 系统权限与对象权限的区别、授权给表、授权与角色、数据字典视图的使用、管理不同时区的数据、使用 CURRENT_DATE, CURRENT_TIMESTAMP, LOCALTIMESTAMP、使用 INTERVAL 数据类型。
If you are looking for a practice test for the Oracle Database SQL Exam Number: 1Z0-071, then you are at the right place.This is a set of two practice tests, based on the same format as the actual test. To make the most out of these tests, the following settings are recommended:Try to setup an exam-like environment - find a place with good network connectivity where you can work without distractions for 2 hoursSet the timer - do the practice test in exactly 2 hours i.e. the same duration that you get in the actual examGive one test and analyze your performance - Find out what type of questions were marked wrong, what type of questions took too long to solveRevise - based on your analysis, revise the topics and plan which type of questions you will skip to save timeGive the second testWhat is Oracle Database SQL 1Z0-071 Certification?Become an Oracle Database SQL Certified Associate and demonstrate understanding of fundamental SQL concepts needed to undertake any database project. Passing the exam illustrates depth of knowledge of SQL and its use when working with the Oracle Database server. Gain a working knowledge of queries , insert, update and delete SQL statements as well as some Data Definition language and Data Control Language, the optimizer, tales and indexes, data modeling and normalization. What is the format of the Oracle Database SQL 1Z0-071 exam?The exam is multiple choice type with 78 questions. To pass the exam, a candidate must score more than 63% marks. Candidates get 2 hours/ 120 minutes to attempt these questions. You must go through multiple mock exams to familiarize yourself with the exam structure. Most often, you will face questions that have multiple correct answers; or some scenario-based questions.What is the benefit of Oracle Database SQL 1Z0-071 Certification?By passing this exam, a certified individual proves fluency in and a solid understanding of SQL language, data modeling and using SQL to create and manipulate tables in an Oracle Database. Qualified candidates have knowledge of general computing concepts, knowledge of command line interfaces and experience working in command line.What is the syllabus of Oracle Database SQL 1Z0-071 Certification exam?Below is the list of topics covered in this exam:Relational Database conceptsExplaining the theoretical and physical aspects of a relational databaseRelating clauses in SQL Select Statement to Components of an ERDExplaining the relationship between a database and SQLRetrieving Data using the SQL SELECT StatementUsing Column aliasesUsing The SQL SELECT statementUsing concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keywordUsing Arithmetic expressions and NULL values in the SELECT statementRestricting and Sorting DataApplying Rules of precedence for operators in an expressionLimiting Rows Returned in a SQL StatementUsing Substitution VariablesUsing the DEFINE and VERIFY commandsSorting DataUsing Single-Row Functions to Customize OutputManipulating strings with character functions in SQL SELECT and WHERE clausesPerforming arithmetic with date dataManipulating numbers with the ROUND, TRUNC and MOD functionsManipulating dates with the date functionUsing Conversion Functions and Conditional ExpressionsApplying the NVL, NULLIF, and COALESCE functions to dataUnderstanding implicit and explicit data type conversionUsing the TO_CHAR, TO_NUMBER, and TO_DATE conversion functionsNesting multiple functionsReporting Aggregated Data Using Group FunctionsRestricting Group ResultsCreating Groups of DataUsing Group FunctionsDisplaying Data from Multiple TablesUsing Self-joinsUsing Various Types of JoinsUsing Non equijoinsUsing OUTER joinsUnderstanding and Using Cartesian ProductsUsing Subqueries to Solve QueriesUsing Single Row SubqueriesUsing Multiple Row SubqueriesUpdate and delete rows using correlated subqueriesUsing SET OperatorsMatching the SELECT statementsUsing the ORDER BY clause in set operationsUsing The INTERSECT operatorUsing The MINUS operatorUsing The UNION and UNION ALL operatorsManaging Tables using DML statementsManaging Database TransactionsControlling transactionsPerform Insert, Update and Delete operationsPerforming multi table InsertsPerforming Merge statementsManaging Indexes Synonyms and SequencesManaging IndexesManaging SynonymsManaging SequencesUse DDL to manage tables and their relationshipsDescribing and Working with TablesDescribing and Working with Columns and Data TypesCreating tablesDropping columns and setting column UNUSEDTruncating tablesCreating and using Temporary TablesCreating and using external tablesManaging ConstraintsManaging ViewsManaging ViewsControlling User AccessDifferentiating system privileges from object privilegesGranting privileges on tablesDistinguishing between granting privileges and rolesManaging Objects with Data Dictionary ViewsUsing data dictionary viewsManaging Data in Different Time ZonesWorking with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMPWorking with INTERVAL data types
