搜索博文结果_ChinaUnix博客

博客首页博客专家往日推荐博客文集

热搜： Android JavaScript 网络安全服务器 C# .net 云计算虚拟化

博客首页〉搜索结果

按类别查询搜索结果

操作系统程序设计数据库热点技术综合架构与运维移动开发与应用 Web前端

关于关键词的检测结果，共 2022 条

【Oracle】 OCP认证考试052新加的考题及答案收集整理-21题

unix_5359 | 2018-07-25 11:36:05 | 阅读(990) | 评论(0)

21、Which two are true about roles?A) A role can be password-protected.B) A role can be granted to another role.C) Only one default role can be granted to a user.D) A role can be granted only multiple system privileges not multiple object privileges.E) A role can be created on...【阅读全文】

【Oracle】 OCP 052新加的考试题收集整理-第20题

unix_5359 | 2018-07-25 11:22:13 | 阅读(800) | 评论(0)

20、 Which is true about the SYSTEM and SYSAUX tablespaces?A) The SYSAUX tablespace can be made read-only but the SYSTEM tablespace cannot.B) Both tablespaces can be used for temporary storage if no temporary tablespace is defined.C) Only the SYSTEM tablespace contains data dictionar...【阅读全文】

【Oracle】 OCP考试新题整理-052新加的考题及答案-18

unix_5359 | 2018-07-24 11:43:05 | 阅读(820) | 评论(0)

18、You want to Install Oracle 11g database software and create a database on ASM Immediately after the Install.Your plan is to install both Oracle database and Grid Infrastructure.Which two are true in this scenario?A) Grid Infrastructure must be installed first.B) Both products ...【阅读全文】

【Oracle】 OCP换考题了，052新加的题库及答案整理-第17题

unix_5359 | 2018-07-23 12:05:03 | 阅读(830) | 评论(0)

17、Which two statements are true about tablespaces?A) A database can contain multiple undo tablespaces.B) A database can contain only a single temporary tablespace.C) A database instance stores undo data In the SYSTEM tablespace If no undo tablespace exists.D) A database instance...【阅读全文】

【Oracle】 OCP考试换题库了，052新加的考题及答案整理-第16题

unix_5359 | 2018-07-23 11:57:00 | 阅读(1010) | 评论(0)

16、Your database Is configured In archivelog mode.The USERS01 tablespace Is currently online.You are required to take the tablespace offline.Which clause or clauses ensure that no media recovery is requiredwhen the tablespace Is brought back online?A) either the NORMAL or the ...【阅读全文】

【Oracle】【OCP｜052】052考试题库又变了，052考试新题收集整理-第15题

unix_5359 | 2018-07-17 13:46:21 | 阅读(880) | 评论(0)

15、Which two are true about space management in tablespaces?A) Locally managed tablespaces have either ASSM or manual segment space management (MSSM), and all the segments in these tablespaces are managed one way or the other.B) Locally managed tablespaces track adjacent free space auto...【阅读全文】

【Oracle】 OCP考试调整，052最新题库及答案整理-第12题

unix_5359 | 2018-07-13 10:57:23 | 阅读(720) | 评论(0)

12、Which two types of Information can be found in the alert log?A) instance recovery detailsB) a record of all DDL statements performed by non-DBA usersC) a record of all actions performed by SYS and SYSTEMD) critical errors encountered by background processesE) values of all ...【阅读全文】

【Oracle】 OCP 052题库全变了，052最新考试题整理-第11题

unix_5359 | 2018-07-13 10:12:02 | 阅读(690) | 评论(0)

11、Which three are true about UNDO data?A) It is used to roll back failed transactions.B) It is used to rewind a database by using FLASHBACK DATABASE.C) It is used to recover dropped tables by using FLASHBACK TABLE … TO BEFORE DROP.D) It is used to enable ROLLBACK statements to ...【阅读全文】

【Oracle】 duplicate from active database(目录结构不相同)

hxl | 2018-07-12 14:11:29 | 阅读(0) | 评论(0)

1 环境情况主库:Oracle_sid:slnngkggDb_name:slnngk数据库版本:11.2.0.4辅助库:Oracle_sid:slnngkggDb_name:slnngk数据库版本:11.2.0.4目录新库目录/u01/app/oracle/oradata/slnngk/u01/app/oracle/orad...【阅读全文】

【Oracle】【OCP|052】OCP换题库，052新加考题整理-第10题

unix_5359 | 2018-07-12 10:13:47 | 阅读(890) | 评论(0)

10、Which two are true about consistent database backups?A) They can only be taken when a RECOVERY CATALOG is used.B) They can only be taken if the database Is in ARCHIVELOG mode.C) They can only be taken If shutdown NORMAL, TRANSACTIONAL, or IMMEDIATE shutdown has been performed and ...【阅读全文】

【Oracle】【OCP|052】 052换题库，新考题整理-第9题

unix_5359 | 2018-07-12 09:46:55 | 阅读(610) | 评论(0)

9、Which is true about the Automatic Diagnostic Repository (ADR)?A) It includes diagnostic data for critical errors for each server and background process.B) Its location is always set by the ORACLE_BASE variable.C) It is used only if the DIAGNOSTIC_DEST parameter is manually configu...【阅读全文】

【Oracle】 2018 OCP换题库，052最新题库收集整理-第7题

unix_5359 | 2018-07-11 09:37:06 | 阅读(620) | 评论(0)

7、Which is true about external tables?A) The ORACLE_DATAPUMP access driver can be used to write data to external tables.B) Segments are allocated for external tables.C) They do not support partitioning.D) They may have Indexes.E) DML operations may be performed on external ta...【阅读全文】

【Oracle】 duplicate from active database(目录结构相同)

hxl | 2018-07-02 15:38:44 | 阅读(0) | 评论(0)

1. 环境情况主库:Oracle_sid:slnngkDb_name:slnngk数据库版本:11.2.0.4辅助库:Oracle_sid:slnngkDb_name:slnngk数据库版本:11.2.0.42.确保主库是运行在归档模式SQL> connect / as sysdbaConnected.SQL> archive log listDatabase log mode &n...【阅读全文】

【Oracle】 Oracle备份与恢复介绍（物理备份与逻辑备份）

小崔Orcler | 2018-04-24 14:06:43 | 阅读(720) | 评论(0)

一、Oracle备份方式分类：Oracle有两类备份方式：（1）物理备份：是将实际组成数据库的操作系统文件从一处拷贝到另一处的备份过程，通常是从磁盘到磁带。物理备份又分为冷备份、热备份；（2）逻辑备份：是利用SQL语言从数据库中抽取数据并存于二进制文件的过程。逻辑备份使用导入导出工具：EXPDP/IMPDP...【阅读全文】

【Oracle】 11G设置内存手工管理

hxl | 2018-03-14 09:22:03 | 阅读(0) | 评论(0)

默认情况下下,11G内存是自动管理,但是想要手工管理，想要将memory_target和memory_max_target设置为01.设置memory_target和memory_max_target设置为0alter system set memory_target=0 scope=spfile;alter system reset memory_max_target;SQL> show parameters memory;NAME TYPE VALUE------...【阅读全文】

【Oracle】整理的Oracle中SQLCODE

Moonecho | 2018-02-26 15:50:37 | 阅读(10250) | 评论(0)

Oracle 的 SQLCODE整理ORA-0:表示最近一次sql语句执行成功sqlcode=-1：表示最近一次sql语句执行失败ORA-00001: 违反唯一约束条件 (.) ORA-00017: 请求会话以设置跟踪事件 ORA-00018: 超出最大会话数 ORA-00019: 超出最大会话许可数 ORA-00020: 超出最大进程数...【阅读全文】

【Oracle】 Oracle 12c：单实例下rman整库备份与异机同目录恢复

canway01 | 2017-12-28 13:49:54 | 阅读(1720) | 评论(0)

【摘要】昨晚，笔者做了个oracle 12c的整库迁移，用的是rman工具，因为目标库只安装了数据库软件，所以在备份恢复完成后还遇到了一些问题，经过逐一解决，数据库服务现已恢复正常，在此记录相关过程。学领未来直播【正文】一源库全备在源库用rman进行压缩全备，...【阅读全文】

【Oracle】 Oracle学习15-用户权限及角色管理

Just_Du_IT | 2017-12-20 11:01:31 | 阅读(2030) | 评论(0)

oracle权限及角色管理【阅读全文】

【Oracle】 Oracle Undo段工作原理

canway01 | 2017-12-19 17:30:13 | 阅读(1800) | 评论(0)

【前言】Undo表空间是Oracle数据库尤为重要的表空间。其中存储的还原段用作支持Oracle数据库的回滚，一致性查询，闪回表，闪回查询的操作。那么Undo段具体的工作行为是怎么样的呢，我们来研究一下。一、回滚段块的使用：1.1 Seq序列值：步骤1：在每个回滚块的块头，有一个SEQ值，当事务延伸到新区时...【阅读全文】

【Oracle】 Oracle学习8-表的创建与管理

Just_Du_IT | 2017-11-23 16:56:30 | 阅读(1400) | 评论(0)

表的创建，数据字典，表空间【阅读全文】

首页
<<
2
3
4
5
6
7
8
9
10
11
>>
末页

网络110 报警服务