oracle知识点(1all)
<div>一、<span class="Apple-tab-span" style="white-space:pre"> </span>SQL知识点</div><div>1）<span class="Apple-tab-span" style="white-space:pre"> </span>关系</div><div>2）<span class="Apple-tab-span" style="white-space:pre"> </span>表</div><div>3）<span class="Apple-tab-span" style="white-space:pre"> </span>列</div><div>4）<span class="Apple-tab-span" style="white-space:pre"> </span>SQL</div><div>5）<span class="Apple-tab-span" style="white-space:pre"> </span>SQL语言的分类</div><div>6）<span class="Apple-tab-span" style="white-space:pre"> </span>SQLPLUS</div><div>7）<span class="Apple-tab-span" style="white-space:pre"> </span>SQL语句</div><div>8）<span class="Apple-tab-span" style="white-space:pre"> </span>子句</div><div>9）<span class="Apple-tab-span" style="white-space:pre"> </span>算术表达式</div><div>10）<span class="Apple-tab-span" style="white-space:pre"> </span>列别名</div><div>11）<span class="Apple-tab-span" style="white-space:pre"> </span>空值</div><div>12）<span class="Apple-tab-span" style="white-space:pre"> </span>连接字符串</div><div>13）<span class="Apple-tab-span" style="white-space:pre"> </span>直接量</div><div>14）<span class="Apple-tab-span" style="white-space:pre"> </span>条件</div><div>15）<span class="Apple-tab-span" style="white-space:pre"> </span>比较运算符</div><div>16）<span class="Apple-tab-span" style="white-space:pre"> </span>SQL函数</div><div>17）<span class="Apple-tab-span" style="white-space:pre"> </span>单行函数</div><div>18）<span class="Apple-tab-span" style="white-space:pre"> </span>DUAL表</div><div>19）<span class="Apple-tab-span" style="white-space:pre"> </span>连接查询</div><div>20）<span class="Apple-tab-span" style="white-space:pre"> </span>相等连接</div><div>21）<span class="Apple-tab-span" style="white-space:pre"> </span>不等连接</div><div>22）<span class="Apple-tab-span" style="white-space:pre"> </span>自连接</div><div>23）<span class="Apple-tab-span" style="white-space:pre"> </span>外连接</div><div>24）<span class="Apple-tab-span" style="white-space:pre"> </span>表别名</div><div>25）<span class="Apple-tab-span" style="white-space:pre"> </span>笛卡儿积</div><div>26）<span class="Apple-tab-span" style="white-space:pre"> </span>数据分组</div><div>27）<span class="Apple-tab-span" style="white-space:pre"> </span>分组函数</div><div>28）<span class="Apple-tab-span" style="white-space:pre"> </span>子查询</div><div>29）<span class="Apple-tab-span" style="white-space:pre"> </span>主查询</div><div>30）<span class="Apple-tab-span" style="white-space:pre"> </span>单行子查询</div><div>31）<span class="Apple-tab-span" style="white-space:pre"> </span>多行子查询</div><div>32）<span class="Apple-tab-span" style="white-space:pre"> </span>伪列</div><div>33）<span class="Apple-tab-span" style="white-space:pre"> </span>ROWNUM</div><div>34）<span class="Apple-tab-span" style="white-space:pre"> </span>DML语言</div><div>35）<span class="Apple-tab-span" style="white-space:pre"> </span>事务</div><div>36）<span class="Apple-tab-span" style="white-space:pre"> </span>提交事务</div><div>37）<span class="Apple-tab-span" style="white-space:pre"> </span>回滚事务</div><div>38）<span class="Apple-tab-span" style="white-space:pre"> </span>DDL语言</div><div>39）<span class="Apple-tab-span" style="white-space:pre"> </span>用户表</div><div>40）<span class="Apple-tab-span" style="white-space:pre"> </span>系统表</div><div>41）<span class="Apple-tab-span" style="white-space:pre"> </span>表和列的命名</div><div>42）<span class="Apple-tab-span" style="white-space:pre"> </span>数据类型</div><div>43）<span class="Apple-tab-span" style="white-space:pre"> </span>缺省值</div><div>44）<span class="Apple-tab-span" style="white-space:pre"> </span>表的截断</div><div>45）<span class="Apple-tab-span" style="white-space:pre"> </span>约束</div><div>46）<span class="Apple-tab-span" style="white-space:pre"> </span>非空约束</div><div>47）<span class="Apple-tab-span" style="white-space:pre"> </span>惟一约束</div><div>48）<span class="Apple-tab-span" style="white-space:pre"> </span>主键约束</div><div>49）<span class="Apple-tab-span" style="white-space:pre"> </span>外约束</div><div>50）<span class="Apple-tab-span" style="white-space:pre"> </span>条件约束</div><div>51）<span class="Apple-tab-span" style="white-space:pre"> </span>视图</div><div>52）<span class="Apple-tab-span" style="white-space:pre"> </span>内联视图</div><div>53）<span class="Apple-tab-span" style="white-space:pre"> </span>序列</div><div>54）<span class="Apple-tab-span" style="white-space:pre"> </span>序列的两个伪列</div><div>55）<span class="Apple-tab-span" style="white-space:pre"> </span>索引</div><div>56）<span class="Apple-tab-span" style="white-space:pre"> </span>同义词</div><div>57）<span class="Apple-tab-span" style="white-space:pre"> </span>用户</div><div>58）<span class="Apple-tab-span" style="white-space:pre"> </span>权限的分类</div><div>59）<span class="Apple-tab-span" style="white-space:pre"> </span>系统权限</div><div>60）<span class="Apple-tab-span" style="white-space:pre"> </span>对象权限</div><div>61）<span class="Apple-tab-span" style="white-space:pre"> </span>角色</div><div>62）<span class="Apple-tab-span" style="white-space:pre"> </span>集合运算</div><div>63）<span class="Apple-tab-span" style="white-space:pre"> </span>相关子查询</div><div>64）<span class="Apple-tab-span" style="white-space:pre"> </span>标量子查询</div><div>65）<span class="Apple-tab-span" style="white-space:pre"> </span>层次查询</div><div><br></div><div>二、<span class="Apple-tab-span" style="white-space:pre"> </span>ORACLE体系结构知识点</div><div>1）<span class="Apple-tab-span" style="white-space:pre"> </span>数据库</div><div>2）<span class="Apple-tab-span" style="white-space:pre"> </span>实例</div><div>3）<span class="Apple-tab-span" style="white-space:pre"> </span>系统全局区（SGA）</div><div>4）<span class="Apple-tab-span" style="white-space:pre"> </span>共享池</div><div>5）<span class="Apple-tab-span" style="white-space:pre"> </span>数据高速缓存</div><div>6）<span class="Apple-tab-span" style="white-space:pre"> </span>重做日志缓冲区</div><div>7）<span class="Apple-tab-span" style="white-space:pre"> </span>大池</div><div>8）<span class="Apple-tab-span" style="white-space:pre"> </span>Java池</div><div>9）<span class="Apple-tab-span" style="white-space:pre"> </span>程序全局区（PGA）</div><div>10）<span class="Apple-tab-span" style="white-space:pre"> </span>用户进程</div><div>11）<span class="Apple-tab-span" style="white-space:pre"> </span>服务器进程</div><div>12）<span class="Apple-tab-span" style="white-space:pre"> </span>后台进程</div><div>13）<span class="Apple-tab-span" style="white-space:pre"> </span>DBWR</div><div>14）<span class="Apple-tab-span" style="white-space:pre"> </span>LGWR</div><div>15）<span class="Apple-tab-span" style="white-space:pre"> </span>PMON</div><div>16）<span class="Apple-tab-span" style="white-space:pre"> </span>SMON</div><div>17）<span class="Apple-tab-span" style="white-space:pre"> </span>CKPT</div><div>18）<span class="Apple-tab-span" style="white-space:pre"> </span>ARCH</div><div>19）<span class="Apple-tab-span" style="white-space:pre"> </span>物理结构</div><div>20）<span class="Apple-tab-span" style="white-space:pre"> </span>数据文件</div><div>21）<span class="Apple-tab-span" style="white-space:pre"> </span>控制文件</div><div>22）<span class="Apple-tab-span" style="white-space:pre"> </span>重做日志文件</div><div>23）<span class="Apple-tab-span" style="white-space:pre"> </span>参数文件</div><div>24）<span class="Apple-tab-span" style="white-space:pre"> </span>口令文件</div><div>25）<span class="Apple-tab-span" style="white-space:pre"> </span>警告文件</div><div>26）<span class="Apple-tab-span" style="white-space:pre"> </span>逻辑结构</div><div>27）<span class="Apple-tab-span" style="white-space:pre"> </span>表空间</div><div>28）<span class="Apple-tab-span" style="white-space:pre"> </span>段</div><div>29）<span class="Apple-tab-span" style="white-space:pre"> </span>区</div><div>30）<span class="Apple-tab-span" style="white-space:pre"> </span>数据块</div><div>31）<span class="Apple-tab-span" style="white-space:pre"> </span>PFILE</div><div>32）<span class="Apple-tab-span" style="white-space:pre"> </span>SPFILE</div><div>33）<span class="Apple-tab-span" style="white-space:pre"> </span>NOMOUNT</div><div>34）<span class="Apple-tab-span" style="white-space:pre"> </span>MOUNT</div><div>35）<span class="Apple-tab-span" style="white-space:pre"> </span>数据字典</div><div>36）<span class="Apple-tab-span" style="white-space:pre"> </span>动态性能视图</div><div>37）<span class="Apple-tab-span" style="white-space:pre"> </span>表空间和数据文件的关系</div><div>38）<span class="Apple-tab-span" style="white-space:pre"> </span>表空间的类型</div><div>39）<span class="Apple-tab-span" style="white-space:pre"> </span>表空间的内容</div><div>40）<span class="Apple-tab-span" style="white-space:pre"> </span>本地管理的表空间</div><div>41）<span class="Apple-tab-span" style="white-space:pre"> </span>字典管理的表空间</div><div>42）<span class="Apple-tab-span" style="white-space:pre"> </span>临时表空间</div><div>43）<span class="Apple-tab-span" style="white-space:pre"> </span>UNDO表空间</div><div>44）<span class="Apple-tab-span" style="white-space:pre"> </span>非标准块表空间</div><div>45）<span class="Apple-tab-span" style="white-space:pre"> </span>段的类型</div><div>46）<span class="Apple-tab-span" style="white-space:pre"> </span>自动段空间管理</div><div>47）<span class="Apple-tab-span" style="white-space:pre"> </span>块的内容</div><div>48）<span class="Apple-tab-span" style="white-space:pre"> </span>UNDO的目的</div><div>49）<span class="Apple-tab-span" style="white-space:pre"> </span>ROWID</div><div>50）<span class="Apple-tab-span" style="white-space:pre"> </span>分析表</div><div>51）<span class="Apple-tab-span" style="white-space:pre"> </span>外部表</div><div>52）<span class="Apple-tab-span" style="white-space:pre"> </span>全局临时表</div><div>53）<span class="Apple-tab-span" style="white-space:pre"> </span>行迁移</div><div>54）<span class="Apple-tab-span" style="white-space:pre"> </span>行连接</div><div>55）<span class="Apple-tab-span" style="white-space:pre"> </span>B-tree索引</div><div>56）<span class="Apple-tab-span" style="white-space:pre"> </span>BITMAP索引</div><div>57）<span class="Apple-tab-span" style="white-space:pre"> </span>组合索引</div><div>58）<span class="Apple-tab-span" style="white-space:pre"> </span>反健索引</div><div>59）<span class="Apple-tab-span" style="white-space:pre"> </span>概要文件</div><div>60）<span class="Apple-tab-span" style="white-space:pre"> </span>密码管理</div><div>61）<span class="Apple-tab-span" style="white-space:pre"> </span>资源管理</div><div>62）<span class="Apple-tab-span" style="white-space:pre"> </span>模式（schema）</div><div>63）<span class="Apple-tab-span" style="white-space:pre"> </span>模式对象</div><div>64）<span class="Apple-tab-span" style="white-space:pre"> </span>OS认证</div><div>65）<span class="Apple-tab-span" style="white-space:pre"> </span>空间配额</div><div><br></div><div>三、<span class="Apple-tab-span" style="white-space:pre"> </span>ORACLE网络知识点</div><div>1）<span class="Apple-tab-span" style="white-space:pre"> </span>ORACLE NET</div><div>2）<span class="Apple-tab-span" style="white-space:pre"> </span>连接模式</div><div>3）<span class="Apple-tab-span" style="white-space:pre"> </span>数据库服务</div><div>4）<span class="Apple-tab-span" style="white-space:pre"> </span>服务名</div><div>5）<span class="Apple-tab-span" style="white-space:pre"> </span>专用服务器</div><div>6）<span class="Apple-tab-span" style="white-space:pre"> </span>监听器</div><div>7）<span class="Apple-tab-span" style="white-space:pre"> </span>动态服务注册</div><div>8）<span class="Apple-tab-span" style="white-space:pre"> </span>静态服务注册</div><div>9）<span class="Apple-tab-span" style="white-space:pre"> </span>端口</div><div>10）<span class="Apple-tab-span" style="white-space:pre"> </span>主机</div><div>11）<span class="Apple-tab-span" style="white-space:pre"> </span>网络服务名</div><div>12）<span class="Apple-tab-span" style="white-space:pre"> </span>本地命名方法</div><div>13）<span class="Apple-tab-span" style="white-space:pre"> </span>共享服务器</div><div>14）<span class="Apple-tab-span" style="white-space:pre"> </span>调度器</div><div><br></div><div>四、<span class="Apple-tab-span" style="white-space:pre"> </span>备份和恢复知识点</div><div>1）<span class="Apple-tab-span" style="white-space:pre"> </span>语句错误</div><div>2）<span class="Apple-tab-span" style="white-space:pre"> </span>进程错误</div><div>3）<span class="Apple-tab-span" style="white-space:pre"> </span>用户错误</div><div>4）<span class="Apple-tab-span" style="white-space:pre"> </span>实例错误</div><div>5）<span class="Apple-tab-span" style="white-space:pre"> </span>介质错误</div><div>6）<span class="Apple-tab-span" style="white-space:pre"> </span>网络错误</div><div>7）<span class="Apple-tab-span" style="white-space:pre"> </span>系统改变号（SCN）</div><div>8）<span class="Apple-tab-span" style="white-space:pre"> </span>归档模式</div><div>9）<span class="Apple-tab-span" style="white-space:pre"> </span>物理备份</div><div>10）<span class="Apple-tab-span" style="white-space:pre"> </span>逻辑备份</div><div>11）<span class="Apple-tab-span" style="white-space:pre"> </span>用户管理的备份</div><div>12）<span class="Apple-tab-span" style="white-space:pre"> </span>RMAN管理的备份</div><div>13）<span class="Apple-tab-span" style="white-space:pre"> </span>完全备份</div><div>14）<span class="Apple-tab-span" style="white-space:pre"> </span>表空间备份</div><div>15）<span class="Apple-tab-span" style="white-space:pre"> </span>控制文件备份</div><div>16）<span class="Apple-tab-span" style="white-space:pre"> </span>一致性备份</div><div>17）<span class="Apple-tab-span" style="white-space:pre"> </span>非一致性备份</div><div>18）<span class="Apple-tab-span" style="white-space:pre"> </span>联机备份</div><div>19）<span class="Apple-tab-span" style="white-space:pre"> </span>脱机备份</div><div>20）<span class="Apple-tab-span" style="white-space:pre"> </span>热备份</div><div>21）<span class="Apple-tab-span" style="white-space:pre"> </span>冷备份</div><div>22）<span class="Apple-tab-span" style="white-space:pre"> </span>恢复管理器</div><div>23）<span class="Apple-tab-span" style="white-space:pre"> </span>RMAN资料库</div><div>24）<span class="Apple-tab-span" style="white-space:pre"> </span>RMAN通道</div><div>25）<span class="Apple-tab-span" style="white-space:pre"> </span>目标数据库</div><div>26）<span class="Apple-tab-span" style="white-space:pre"> </span>备份集</div><div>27）<span class="Apple-tab-span" style="white-space:pre"> </span>备份片</div><div>28）<span class="Apple-tab-span" style="white-space:pre"> </span>影像复制</div><div>29）<span class="Apple-tab-span" style="white-space:pre"> </span>完全备份</div><div>30）<span class="Apple-tab-span" style="white-space:pre"> </span>增量备份</div><div>31）<span class="Apple-tab-span" style="white-space:pre"> </span>块改变跟踪</div><div>32）<span class="Apple-tab-span" style="white-space:pre"> </span>打开备份</div><div>33）<span class="Apple-tab-span" style="white-space:pre"> </span>关闭备份</div><div>34）<span class="Apple-tab-span" style="white-space:pre"> </span>介质恢复</div><div>35）<span class="Apple-tab-span" style="white-space:pre"> </span>完全恢复</div><div>36）<span class="Apple-tab-span" style="white-space:pre"> </span>还原</div><div>37）<span class="Apple-tab-span" style="white-space:pre"> </span>不完全恢复</div><div>38）<span class="Apple-tab-span" style="white-space:pre"> </span>导入</div><div>39）<span class="Apple-tab-span" style="white-space:pre"> </span>导出</div><div>40）<span class="Apple-tab-span" style="white-space:pre"> </span>数据泵</div><div>41）<span class="Apple-tab-span" style="white-space:pre"> </span>闪回查询</div><div>42）<span class="Apple-tab-span" style="white-space:pre"> </span>闪回版本查询</div><div>43）<span class="Apple-tab-span" style="white-space:pre"> </span>闪回事务查询</div><div>44）<span class="Apple-tab-span" style="white-space:pre"> </span>闪回表</div><div>45）<span class="Apple-tab-span" style="white-space:pre"> </span>闪回删除</div><div>46）<span class="Apple-tab-span" style="white-space:pre"> </span>回收站</div><div>47）<span class="Apple-tab-span" style="white-space:pre"> </span>闪回数据库</div><div>48）<span class="Apple-tab-span" style="white-space:pre"> </span>自动存储管理</div><div>49）<span class="Apple-tab-span" style="white-space:pre"> </span>ASM磁盘</div><div>50）<span class="Apple-tab-span" style="white-space:pre"> </span>磁盘组</div><div>51）<span class="Apple-tab-span" style="white-space:pre"> </span>失败组</div><div>52）<span class="Apple-tab-span" style="white-space:pre"> </span>ASM文件</div><div>53）<span class="Apple-tab-span" style="white-space:pre"> </span>ASM实例</div><div>54）<span class="Apple-tab-span" style="white-space:pre"> </span>重平衡</div><div><br></div><div>五、<span class="Apple-tab-span" style="white-space:pre"> </span>性能优化知识点</div><div>1）<span class="Apple-tab-span" style="white-space:pre"> </span>可伸缩性</div><div>2）<span class="Apple-tab-span" style="white-space:pre"> </span>吞吐量</div><div>3）<span class="Apple-tab-span" style="white-space:pre"> </span>跟踪</div><div>4）<span class="Apple-tab-span" style="white-space:pre"> </span>告警文件</div><div>5）<span class="Apple-tab-span" style="white-space:pre"> </span>后台跟踪文件</div><div>6）<span class="Apple-tab-span" style="white-space:pre"> </span>服务器生成的跟踪</div><div>7）<span class="Apple-tab-span" style="white-space:pre"> </span>用户跟踪文件</div><div>8）<span class="Apple-tab-span" style="white-space:pre"> </span>动态性能视图</div><div>9）<span class="Apple-tab-span" style="white-space:pre"> </span>跟踪文件</div><div>10）<span class="Apple-tab-span" style="white-space:pre"> </span>STATSPACK</div><div>11）<span class="Apple-tab-span" style="white-space:pre"> </span>ORACLE企业管理器</div><div>12）<span class="Apple-tab-span" style="white-space:pre"> </span>AWR</div><div>13）<span class="Apple-tab-span" style="white-space:pre"> </span>ADDM</div><div>14）<span class="Apple-tab-span" style="white-space:pre"> </span>顾问程序</div><div>15）<span class="Apple-tab-span" style="white-space:pre"> </span>语法分析（PARSE）</div><div>16）<span class="Apple-tab-span" style="white-space:pre"> </span>自动跟踪</div><div>17）<span class="Apple-tab-span" style="white-space:pre"> </span>执行计划</div><div>18）<span class="Apple-tab-span" style="white-space:pre"> </span>基于成本的优化器</div><div>19）<span class="Apple-tab-span" style="white-space:pre"> </span>基于规则的优化器</div><div>20）<span class="Apple-tab-span" style="white-space:pre"> </span>优化器统计量</div><div>21）<span class="Apple-tab-span" style="white-space:pre"> </span>统计量收集</div><div>22）<span class="Apple-tab-span" style="white-space:pre"> </span>绑定变量</div><div>23）<span class="Apple-tab-span" style="white-space:pre"> </span>LRU</div><div>24）<span class="Apple-tab-span" style="white-space:pre"> </span>高水位标记</div><div>25）<span class="Apple-tab-span" style="white-space:pre"> </span>ASSM</div><div>26）<span class="Apple-tab-span" style="white-space:pre"> </span>数据并发性</div><div>27）<span class="Apple-tab-span" style="white-space:pre"> </span>数据一致性</div><div>28）<span class="Apple-tab-span" style="white-space:pre"> </span>LOCK</div><div>29）<span class="Apple-tab-span" style="white-space:pre"> </span>DEADLOCK</div><div>30）<span class="Apple-tab-span" style="white-space:pre"> </span>存取路径</div><div>31）<span class="Apple-tab-span" style="white-space:pre"> </span>全表扫描</div><div>32）<span class="Apple-tab-span" style="white-space:pre"> </span>ROWID</div><div>33）<span class="Apple-tab-span" style="white-space:pre"> </span>索引唯一扫描</div><div>34）<span class="Apple-tab-span" style="white-space:pre"> </span>索引范围扫描</div><div>35）<span class="Apple-tab-span" style="white-space:pre"> </span>Index skip scan</div><div>36）<span class="Apple-tab-span" style="white-space:pre"> </span>Index full scan</div><div>37）<span class="Apple-tab-span" style="white-space:pre"> </span>Fast-full index scan</div><div>38）<span class="Apple-tab-span" style="white-space:pre"> </span>Nested loop join</div><div>39）<span class="Apple-tab-span" style="white-space:pre"> </span>Hash join</div><div>40）<span class="Apple-tab-span" style="white-space:pre"> </span>Sort-merge join</div><div> </div><div><br></div>
页:
[1]