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 ...【阅读全文】
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 ...【阅读全文】
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 ...【阅读全文】
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...【阅读全文】
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...【阅读全文】
6、You are installing Oracle Grid Infrastructure by using the Oracle Universal Installer (OUI).You select the "Install and Configure Grid Infrastructure for a Standalone Server" option.Which task is performed by OUI as part of this installation?A) creation and configuration of Enterp...【阅读全文】
博客文章除注明转载外,均为原创。转载请注明出处。本文链接地址:http://blog.chinaunix.net/uid-31396856-id-5784934.htmlOracle视图except SNAP_ID, and INSTANCE_NUMBER等字段dba_hist_active_sess_history视图的详细信息,请见下表列数据类型NULL...【阅读全文】
默认情况下下,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数据库提示:第一行出现错误:ORA-01113:文件19需要介质恢复ORA-01110:数据文件 19 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\TS_SWFZ.DBF'解决办法:打开cmd窗口命令,连接至system用户,Microsoft Windows [版本 6.1.7601]版权所有 (c) 2009 Microsoft Corporation。保留所有权利。C:\Users\...【阅读全文】