oracle
聆雨落
这个作者很懒,什么都没留下…
展开
-
14.4 Using Index-Organized Tables forPerformance 使用索引组织的表
原文:An index-organized table differs from an ordinarytable in that the data for the table is held in its associated index. Changesto the table data, such as adding new rows, updating rows, or deleting rows,result only in updating the index. 译文:索引组织的表与普通翻译 2015-10-26 17:46:18 · 551 阅读 · 0 评论 -
053第401题
401.Which of the following are correct about block media recovery? (Choose all that apply.)A. Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_CORRUPTION.B.原创 2015-07-18 12:15:58 · 1283 阅读 · 0 评论 -
053第484题
484.Which steps are mandatory to enable Direct NFS?1. Mount all required file systems using the kernel NFS driver.2. Create an oranfstab file containing the attributes for each NFS server to be ac原创 2015-07-18 11:48:27 · 1353 阅读 · 1 评论 -
053第279题
279.Identify the activities performed as part of the Automatic SQL Tuning process in the maintenancewindow? (Choose all that apply.)A. generating the SQL profileThe safer , easier way to help yo原创 2015-07-17 10:45:06 · 1359 阅读 · 0 评论 -
053第450题
450.Which of the following are valid program types for a lightweight job? (Choose all that apply.)A. PLSQL_BLOCKB. EXECUTABLEC. JAVA_STORED_PROCEDURED. STORED_PROCEDUREE. EXTERNALAnswer: A原创 2015-07-18 13:18:39 · 679 阅读 · 0 评论 -
053第449题
449.Which of the following objects can be directly referenced by a window object? (Choose all that apply.)A. Schedule objectB. Program objectC. Job objectD. Resource planE. Resource consumer原创 2015-07-16 12:41:33 · 713 阅读 · 0 评论 -
053第5
5.Examine the section of the Health Check report given below:DBMS_HM.GET_RUN_REPORT('HM_RUN_1061')Run Name : HM_RUN_1061 Run Id : 1061 Check Name : Data Block Integrity Check Mode :REA原创 2015-07-16 11:03:09 · 788 阅读 · 0 评论 -
053第455题
455.When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?(Choose all that apply.)A. The job will be dropped automatically if the value of the AUTO_DR原创 2015-07-15 10:05:00 · 790 阅读 · 0 评论 -
ocp 053 第461题
461.The NLS_SORT parameter sets the default sort method for which of the followingoperations?(Choose all that apply.)A. WHERE clauseB. ORDER BY clauseC. BETWEEN clauseD. NLSSORT functionE.原创 2015-07-05 12:02:11 · 784 阅读 · 0 评论 -
053第256题
256.Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data isadded to the table daily. To save disk space, you issued the following command:ALTER TABLE sal原创 2015-07-17 20:38:23 · 641 阅读 · 0 评论 -
053第478题
478.Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.(Choose two.)A. Cursor cacheB. Stored outlineC. SQL Tuning SetD. Automatic Workload Reposit原创 2015-07-18 13:07:32 · 816 阅读 · 0 评论 -
14.3 Using Partitioned Indexes for Performance 使用分区索引
原文:Similar to partitioned tables, partitioned indexesimprove manageability, availability, performance, and scalability. They caneither be partitioned independently (global indexes) or automaticall翻译 2015-10-26 12:13:51 · 544 阅读 · 0 评论 -
14.2 Using Function-based Indexes for Performance 使用基于函数的索引
原文:A function-based index includescolumns that are either transformed by a function, such as the UPPER function, or included in an expression, such as col1 +col2. With afunction-based index, you翻译 2015-10-26 12:10:49 · 554 阅读 · 0 评论 -
oracle lead()和lag()
这两个函数,是偏移量函数,其用途是:可以查出同一字段下一个值或上一个值,并作为新列存在表中。1。 select * from tache_columns TCH_ID COL_NAME_CN COL_VALUE------------- -----------转载 2015-09-10 16:16:48 · 402 阅读 · 0 评论 -
AWR报告分析
今晚来分析一下awr报告,首先说一下什么是awr报告,它能给我们带来什么。* 定义:awr报告是oracle 10g下提供的一种性能收集和分析工具,它能提供一个时间段内整个系统资源使用情况的报告,通过这个报告,我们就可以了解一个系统的整个运行情况,这就像一个人全面的体检报告。如何分析:* 在看awr报告的时候,我们并不需要知道所有性能指标的含义,就可以判断出问题的所在,这些转载 2015-09-02 10:59:36 · 558 阅读 · 0 评论 -
053第42题
42.You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL TuningSet as a part of the workload capturing. What information is captured as part of this process? (Choos原创 2015-07-23 11:42:51 · 750 阅读 · 0 评论 -
053第482
482.USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want toconvert all existing data in the USER_DATA tablespace and the new data into the encrypted format.Whic原创 2015-07-20 17:38:29 · 810 阅读 · 0 评论 -
053第18
8.You create a new Automatic Database Diagnostic Monitor (ADDM) task:instance_analysis_mode_task. To view the ADDM report, you use the following command:SQL> SELECT dbms_addm.get_report('my_instan原创 2015-07-20 11:12:46 · 768 阅读 · 0 评论 -
053第502题
502.A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each grouphas one member.A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In th原创 2015-07-19 11:19:38 · 662 阅读 · 0 评论 -
053第244题
224.You need to create a partitioned table to store historical data and you issued the following command:CREATE TABLE purchase_interval PARTITION BY RANGE (time_id) INTERVAL(NUMTOYMINTERVAL(1,'mon原创 2015-07-15 12:14:28 · 632 阅读 · 0 评论 -
14.1 Understanding Index Performance 了解索引性能
14.1.1 Tuning the Logical Structure(优化逻辑结构) 不管查询是否使用,SQL引擎必须继续维护一个表上定义的所有索引,在写操作比较频繁的应用中,索引维护工作可能会占用大量的CPU和I/O资源,所以,不要建立不必要的索引。为了最优化性能,删除不必要的索引。在你的数据库执行有代表性的工作量时,使用ALTER INDEX MO翻译 2015-08-07 16:41:38 · 718 阅读 · 0 评论 -
053 第500题
500.You opened the encryption wallet and then issued the following command:SQL>CREATE TABLESPACE securespaceDATAFILE '/home/user/oradata/secure01.dbf'SIZE 150MENCRYPTION USING '3DES168'DEFAU原创 2015-07-14 12:14:02 · 1023 阅读 · 0 评论 -
ocp 053第448题
448.Which of the following tasks is not performed by the job coordinator?A. Update job log when a job completesB. Spawn and remove job slavesC. Write/read job info to/from memory cacheD. Que原创 2015-07-05 11:33:59 · 486 阅读 · 0 评论 -
ocp053第411题
411.Which is true concerning Database Replay in an Oracle Real Application Cluster (RAC) database?A. Workload capture is per instance.B. You only need to restart one instance to begin workload cap原创 2015-07-05 12:24:07 · 951 阅读 · 0 评论 -
053第246题
246.The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates aplan for a SQL statement but does not find a matching plan in the SQL plan baseline.Which two operations are原创 2015-07-12 12:34:34 · 905 阅读 · 0 评论 -
053第85题
85.You executed the following command to drop a user:DROP USER scott CASCADE;Which two statements regarding the above command are correct? (Choose two.)A. All the objects of scott are moved to t原创 2015-07-10 10:55:39 · 862 阅读 · 0 评论 -
053第170题
170.ASM supports all but which of the following file types? (Choose all that apply.)A. Database filesB. SpfilesC. Redo-log filesD. Archived log filesE. RMAN backup setsF. Password filesG原创 2015-07-10 11:04:32 · 543 阅读 · 0 评论 -
053第471题
471.Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?A. All objects in the databaseB. Tables owned by SYS and SYSTEMC. Data dictionary tablesD. NCHAR columnsE. C原创 2015-07-09 10:54:28 · 548 阅读 · 0 评论 -
windows系统卸载oracle(简单步骤,完全卸载)
1、 删除Path 环境变量中oracle 主目录,如E: \oracle11g\product\11.2.0\dbhome_1\bin2、 删除注册表中相关键值1)使用regedit命令进入注册表2)删除 HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE目录3)删除HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\原创 2015-06-30 17:49:50 · 539 阅读 · 0 评论 -
关于053第470题
470.Which NLS parameter can be used to change the default Oracle sort method from binary to linguisticfor the SQL SELECT statement?A. NLS_LANGB. NLS_COMPC. NLS_SORTD. None of the aboveAnsw原创 2015-06-30 12:03:45 · 830 阅读 · 0 评论 -
053第521题
521.You notice that a job in a chain has not completed on a nonconstrained RAC database. Which ofthese are valid reasons why that might occur?A. The job priority is 1 and the resource consumer gro原创 2015-07-12 13:05:00 · 939 阅读 · 0 评论 -
关于resetlogs
You must specify RESETLOGS:After performing incomplete media recovery or media recovery using a backup control file .....原创 2015-07-05 11:21:34 · 396 阅读 · 0 评论 -
053第383题
383.At the request of a user, you issue the following command to restore a dropped table: flashback table"BIN$F2JFfMq8Q5unbC0ceE9eJg==$0" to before drop; Later, the user notifies you that the data i原创 2015-07-14 10:26:24 · 1077 阅读 · 0 评论 -
053第423题
423.Which of the following describes how a distributed resumable transaction behaves?A. The resumable setting on the initiating session determines the resumable conditions for the entiredistribute原创 2015-07-14 11:03:10 · 960 阅读 · 0 评论 -
053 第561题
561.If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode,what will be the result when you issue the command alter database archivelog?A. The alter databas原创 2015-07-14 10:35:04 · 888 阅读 · 0 评论 -
关于053 第66题
66.Which two initialization parameters would you set to enable Automatic Shared Memory Management?(Choose two.)A. set SHARED_POOL_SIZE to zeroB. set STATISTICS_LEVEL to BASICC. set SGA_TARGET原创 2015-07-06 10:57:29 · 533 阅读 · 0 评论 -
053第495题
495.Which statement is true regarding the VALIDATE DATABASE command?A. It checks the database for intrablock corruptions only.B. It checks for block corruption in the valid backups of the database原创 2015-07-13 12:59:16 · 1003 阅读 · 1 评论 -
053第425题
425.Which of the following are included in a transportable tablespace set? (Choose all that apply.)A. The datafiles that make up a self-contained group of tablespaces required for copyB. The syste原创 2015-07-13 13:16:33 · 814 阅读 · 0 评论 -
051知识点整理
任何数据与null值运算结果为null定义clob类型时不需要加size表名不能够以数字开头,要么加上双引号,要么以字母开头。字符型默认值不用双引号,用单引号表名只能由字母,数字,下划线,&,#等字符,没有星号不能用保留字作为列名表名的长度为1~30个字符表的列最多有1000个有default值的列也可以存空值表和同义词在相同的schema里名称可以相同在同一个数据库里,在不同的schema,可以原创 2015-06-26 19:06:38 · 433 阅读 · 0 评论 -
053第386题
386.You have just performed a FLASHBACK TABLE operation using the following command:flashback table employees to scn 123456;The employees table has triggers associated with it. Which of the follow原创 2015-07-11 13:26:50 · 1172 阅读 · 0 评论