3. You want to create a new optimized database for yourtransactional productionenvironmentto be used by a financial application. While creating the database, you want theOraclesoftware to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
A) Use the CREATE DATABASE.. command to create the database with Oracle-managed files.
B) Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files.
C) Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option.
D) Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template.
E) Use the CREATE DATABASE.. command to create the database with Automatic Storage
Management (ASM) file system.
Editor’s note:the key of this question is transactional production environment(交易生产环境).It seems to me that OLTP is needed. So ,you must create the OLTP db.
Answer A/B/E does not meet the requirement of the question.
Answer C is wrong.OEM cann’t create db.
5. A constraint in a table is defined with theINITIALLY IMMEDIATEclause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled. What are the two effects of this command? (Choose two.)
A) It fails if any existing rowviolates the constraint.
B) It does not validate the existingdatain the table. --alidate let oracle to check the existing data
C) It enables the constraint to be enforced at the end of each transaction.
D) It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled.
Editor’s note:The constraint of INITIALLY IMMEDIATE want oracle to check the contracint before and after thesql.
The constraint of enable validate want oracle to validate the data whitch may violates the constraint.
So the answer is A/D
http://sns.linuxpk.com/space.php?uid=52196&do=blog&id=16032
http://space.itpub.net/21340813/viewspace-614897
http://www.itpub.net/viewthread.php?tid=4902
6. You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance?
A) run Segment Advisor
B) run SQL Tuning Advisor on top SQL statements
C) run the Automatic Workload Repository (AWR) report
D) run the Automatic Database Diagnostic Monitor (ADDM) on top SQL statements
Editor’s note: ADDM is like awr,it is using for monitor sql for system.not for top sql.
B14211-- 12Automatic SQL Tuning (Database Performance Tuning Guide) will tell you how to use the sql tuning advisor and sql profiles.
Web site associated:
http://space.itpub.net/15720542/viewspace-631799 sql tunning adsivor的使用
http://www.hellodba.com/doc/oracle%2010g_addm_advisor.htm
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:61313086268493
10. Which statement regarding the contents of the V$PARAMETER view is true?
A) displays only the list of default values
B) displays only the list of all basic parameters
C) displays the currently in effect parameter values
D) displays only the list of all advanced parameters
E) displays the list of all the parameter files of a database
Editor’s note:V$PARAMETER displays information about the initialization parameters that are currently in effect for the session. A new session inherits parameter values from the instance-wide values displayed by the V$SYSTEM_PARAMETER view.
So,what’s the difference between v$parameter and v$system_parameter. If you execute the sql like that ‘alter session set parameter_name value.’ . You will see the difference with them by querying these two views.
16. You notice this warning in the alert log file:
ORA-19815: WARNING: db_recovery_file_dest_size of 3221225472 bytes is 100.00% used, and has 0 remaining bytes available.
What would you do to reclaim the used space in the Flash Recovery Area?
A) Back up the Flash Recovery Area.
B) Increase the retention time for the files.
C) Decrease the retention time for the files.
D) Manually delete all the archived log files from the Flash Recovery Area by using operating system (OS) commands.
Editor’s note:you can see the deail description of this error:
Cause: DB_RECOVERY_FILE_DEST is running out of disk space.
Action: One of the following:
1. Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE.
2. Backup files to tertiary device usingRMAN.
3. Consider changing RMAN retention policy.
4. Consider changing RMAN archivelog deletion policy.
5. Delete files from recovery area using RMAN.
When you see the step 3,you will know why answer C is right.
18. Which two operations require undo data? (Choose two.)
A) committing a transaction
B) rolling back a transaction
C) recovering from failed transactions
D) recording a transaction to redo log files
E) rolling forward during instance recovery
Editor’s notes:answer C puzzle me. Transaction recover often happen when user cancel the transaction by manual, then smon have to be reclaimed unto segment.
57. Your database is configured with the following parameters related to SGA)
SGA_TARGET=256MB
SHARED_POOL_SIZE=32MB
DB_CACHE_SIZE=100MB
LARGE_POOL_SIZE=0
JAVA_POOL_SIZE=0
STREAMS_POOL_SIZE=0
Which two statements are true about the configuration? (Choose two.)
A) The SGA_TARGET value cannot be sized smaller than 100 MB.
B) The shared pool and the default buffer pool will not be sized bigger than 32 MB and 100 MB, respectively.
C) The shared pool and the default buffer pool will not be sized smaller than 32 MB and 100 MB, respectively.
D) 124 MB (256 minus 132) of memory is available for use by all the manually sized components.
E) 124 MB (256 minus 132) of memory is available for use by all the manually and automatically sized components.
Editor’s notes:the parameter of shared_pool_size and db_cache_size defined the smallest value of shared pool and buffer cache.When you define the sga_target’s value,shared pool size and buffer cache size will larger than the parameter defined.You can see it though v$sgainfo.
65. You executed the following command to start the database:
SQL> STARTUP
ORACLE instance started.
Total System Global Area 281018368 bytes
Fixed Size 789000 bytes
Variable Size 229635576 bytes
Database Buffers 50331648 bytes
Redo Buffers 262144 bytes
ORA-00205: error in identifying controlfile, check alert log for more info
Which view would you query at this stage to investigate this missing control file?
A) V$INSTANCE
B) V$CONTROLFILE
C) DBA_CONTROL_FILES
D) V$DATABASE_PROPERTIES
E) V$CONTROLFILE_RECORD_SECTION
Editor’s notes:v$controlfile lists the names of the control files.You can confirm whether the control files have broken by v$controlfile.status. INVALID if the name cannot be determined, which should not occur. Null if the name can be determined
V$CONTROLFILE_RECORD_SECTION displays information about the control file record sections.If control file grows too large,may be this view is very important.
69. You backed up the control file to trace. Which statement is true about the trace file generated?
A) The trace file is in binary format.
B) The trace file has a SQL script. to re-create the control file.
C) The trace file is a backup set created during the backup of the control file.
D) The trace file contains the instructions to manually re-create the control file.
E) The trace file is an image copy of the control file created during the backup of the control file.
Editor’s notes:There are two different ways to backup controlfiles.
One is:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE (as filename);
This statement is used to create a trace file include sql statement for creating controlfile
Another is :
ALTER DATABASE BACKUP CONTROLFILE TO filename;
This statement is used to create binary file.it’s a backup controlfile for current controlfile.
78. Which two operations can be flashed back using the Flashback technology? (Choose two.)
A) DROP USER SMITH;
B) DROP TABLE EMPLOYEES;
C) DROP TABLESPACE USERS;
D) ALTER TABLE SALES_REP DROP PARTITION P1;
E) ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID;
Editor’s notes:The model answer must be wrong.flashback technology contains flashback query/flashback table/flashback database.A/B/D/E all can be flashback by using flashback technology.
发表评论
-
转:1Z0-042记录(二)
2011-01-15 22:30 195081. You want to refer the emp ... -
oracle undo 表空间
2011-01-15 22:24 1760一、undo表空间的作用: Oracle 使用undo来保存 ... -
oracle 文件
2011-01-15 22:23 779oracle数据库的结构 数据库的文件有:pfile或者sp ... -
Oracle数据库体系结构总结
2011-01-15 22:23 718一、数据库的架构数据 ... -
oracle数据库的启动方式、顺序
2011-01-15 22:22 1062Oracle的启动方式有两种,分别是NoMount(不挂载)和 ...
相关推荐
1Z0-042是Oracle认证考试中的一个科目,旨在测试考生在Oracle数据库管理基础方面的技能和理解。 Oracle 10g是Oracle公司的一个重要数据库产品,其"10g"代表了"网格计算"(Grid Computing),强调在大规模分布式计算...
《OCA:Oracle 10g管理I学习指南:1Z0-042》是一部专为准备Oracle Certified Associate(OCA)认证考试1Z0-042的考生所编写的教材。这本书全面覆盖了Oracle数据库10g的基础管理和维护知识,旨在帮助读者掌握Oracle...
OCA:Oracle 10g管理I学习指南:1Z0-042.pdf
OCA:Oracle 10g管理I学习指南:1Z0-042_0.part5.rar
OCA:Oracle 10g管理I学习指南:1Z0-042_0.part4.rar
OCA:Oracle 10g管理I学习指南:1Z0-042_0.part3.rar
OCA:Oracle 10g管理I学习指南:1Z0-042_0.part8.rar
OCA:Oracle 10g管理I学习指南:1Z0-042_0.part7.rar
OCA:Oracle 10g管理I学习指南:1Z0-042_0.part6.rar
OCA:Oracle 10g管理I学习指南:1Z0-042_0.part2(中文版)
【标题】"好用的1Z0-042"所指的,是Oracle数据库认证考试中的一个科目,即Oracle Database 11g: Administration II(1Z0-042)。这个考试对于IT专业人士,尤其是数据库管理员(DBA)而言,具有极高的价值和重要性。...
1z0-042 中文版 pdf格式 第一部分,共两部分
Oracle10g OCP学习指南,sybex出版!很好的资料,想考OCP的朋友可以看下!
OCA 1z0-042 中文版 第二部分(共两部分)
"最新ORACLE OCA&OCP 题库 1z0-007 1Z0-042 1Z0-043" 提供的是备考这些认证考试的资源,涵盖了Oracle数据库管理员相关的知识领域。 1z0-007是Oracle Database Foundations Certified Junior Associate认证的考试...
根据提供的信息,我们可以总结出与1z0-042相关的几个重要知识点: ### 1. 决定UNDO表空间大小的因素 在决定数据库中UNDO表空间大小时,需要考虑以下三个因素: - **选项A:一个UNDO块的大小**(The size of an ...
042考试,全称为Oracle Database 12c: Administration II(1Z0-042),是获得Oracle 12c OCP认证所必需的考试之一。这个"TestInside1Z0-042V3.23"可能是针对该考试的一个模拟题库,版本号V3.23表示这是该题库的第323...
每一章的最后附有20道复习题,这些复习题专门设计用来帮助读者巩固在这一章中所学过的知识。 本考试属于数据库管理员系列中的Oracle认证助理工程师认证。因此,本书适合准备报考该认证考试的考生阅读,也可以作为...