Exam# 1Z0-007: Introduction to Oracle9i: SQL®
Writing Basic SQL Select Statements [撰写简单的 SQL Select 叙述]
[ ] List the capabilities of SQL SELECT statements 描述一个 SQL SELECT 叙述
[ ] Execute a basic SELECT statement 执行一个简单的 SELECT 叙述
[ ] Differentiate between SQL statements and iSQL*Plus commands 了解 SQL 与 iSQL*Plus 命令间的差异
Restricting and Sorting Data [限制及排序资料]
[ ] Limit the rows retrieved by a query 限制请求取回的列资料
[ ] Sort the rows retrieved by a query 排序请求取回的列资料
Single-Row Functions [单列函数]
[ ] Describe various types of functions available in SQL 说明 SQL 中各种有用的函数类型
[ ] Use character, number, and date functions in SELECT statement 在 SELECT 叙述中使用字符,数字,日期函数
[ ] Use conversion functions 使用转换函数
Displaying Data from Multiple Tables [从多窗体中显示资料]
[ ] Write SELECT statements to access data from more than one table using equality and nonequality joins
[ ] View data that generally does not meet a join condition by using outer joins
[ ] Join a table to itself using a self-join
Aggregating Data using Group Functions [使用群组函数来统计数据]
[ ] Identify the available group functions 分辨使用群组函数的时机
[ ] Use group functions 使用群组函数
[ ] Group data using the GROUP BY clause 使用 GROUP BY 子句来群组资料
[ ] Include or exclude grouped rows by using the HAVING clause
Subqueries [子查询]
[ ] Describe the types of problems that subqueries can solve [描写「次查询」能够解决的问题]
[ ] Define subqueries [撰写「次查询」指令]
[ ] List the types of subqueries [辨识不同种类的「次查询」]
[ ] Write single-row and multiple-row subqueries [撰写「单列次查询」与「多列次查询」]
Producing Readable Output with iSQL*Plus [在 SQL*Plus 产生美观的输出报表]
[ ] Produce queries that require a substitution variable [使用替代变量撰写 SQL 叙述句]
[ ] Produce more readable output [产生可读性较高的输出结果]
[ ] Create and execute script files [建立与执行指令]
Manipulating Data [数据处理动作]
[ ] Describe each DML statement [熟悉各种 DML 叙述句]
[ ] Insert rows into a table [将资料新增至表格]
[ ] Update rows in a table [更改表格既有资料]
[ ] Delete rows from a table [删除表格资料]
[ ] Merge rows in a table [合并表格资料]
[ ] Control transactions [控制数据库交易]
Creating and Managing Tables [建立与维护表格]
[ ] Describe the main database objects [描述主要的数据库对象]
[ ] Create tables [定义表格字段时可使用的资料型别]
[ ] Describe the datatypes that can be used when specifying column definition
[定义表格字段时可使用的资料型别]
[ ] Alter table definitions [更改表格定义]
[ ] Drop, rename and truncate tables [删除、更名与截断表格]
Including Constraints [加入约束条件]
[ ] Describe constraints [了解「约束条件」contraints 的用途]
[ ] Create and maintain constraints [建立与维护约束条件]
Creating Views [建立视观表]
第 页
1
评论0