声明：所有解析均限于本人理解
231. Exhibit, list of privileges.
You work as a database administrator for Supportcenter.cn. The database user, SupportCenter USER07, has the CONNECT role assigned. You want this user to be able to:
A)connect to the database when the database is in restricted mode
B)query the tables created by other users.
Which minimal set of privileges and roles would you select from the list in the exhibit to grant to the user?
A. 1 only
B. 6 only
C.1, 2 and 4
D.3 and 4
E.1 and 6
答案：D
解析：网上都说答案是C
The answer is wrong. Resource role here has nothing usefull here. Sysoper privilege can not see user data. The right answer is C
232. You work as a database administrator for Supportcenter.cn. One of the user sessions was terminated
abnormally in the middle of a transaction. What does Oracle database do to recover it?
A. Uses undo data for roll forward
B. Uses Flashback Log for recovery
C.Uses online redo logs to roll back
D.Uses undo data to roll back the transaction
E.Uses Recovery Manager (RMAN) to roll back
F.Uses the System Monitor (SMON) background process to perform instance recovery
答案：D
解析：通常不需要 DBA 执行任何操作就可解决用户进程故障。实例后台进程会回退未提交的更改并解除锁定。 在恢复过程中，利用undo data进行回滚
233. You work as a database administrator for Supportcenter.cn. You suspect that in one of your applications the
customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries
being executed on the customer table?
A. Monitor thealert.logfile
B. Enable server-side SQL tracing for user sessions
C.Enable fine-grained auditing for the customer table
D.Enable Fine-Grained Access Control (FGAC) for the customer table
E.Write a database trigger on the customer table on the SELECT event
答案：D
解析：对于开放的环境来说，存取控制是十分必要的，必须要防患于未然。
A. Monitor the alert.logfile
B. Enable server-side SQL tracing for user sessions
C.Enable fine-grained auditing for the customer table
--监视日志文件、使用跟踪会话、审计用户表，均为事后诸葛亮，不能有效地阻止别人的误操作或使坏。
E.Write a database trigger on the customer table on the SELECT event
--insert、update、delete才使用trigger,select是不行的。
D.Enable Fine-Grained Access Control (FGAC) for the customer table
--关键是Access Control,如网上银行的三次密码出错当日锁定，取大量现金的报警系统等。
事实上FGAC和FGA是两个不同的概念，FGAC是Control(控制),而一个是审计，FGA可以对访问进行记录，而不能限制访问，但FGAC可以。
234. You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you
execute the following command to open it ALTER DATABASE OPEN;
What two actions are performed as a result of this command? Choose two.
A. All control files are opened
B. All redo files are opened
C.The password file is opened
D.The parameter file is opened
E.All online data files are opened
答案：BE
解析：在open过程中，打开所有redo log和联机数据文件
235. You work as a database administrator for Supportcenter.cn. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding.
How do you achieve this?
A. Enable instance failover
B. Configure shared server
C.Enable database failover
D.Enable connect-time failover
E.Enable Transparent Application Failover (TAF)
答案：D
解析： Listener可以有两种方式配置：
1、静态服务注册
2、动态服务注册，再次方式下，若>1个Listener,则client请求时
一个Listener不通，会自动转到另外的Listener,;或一个Listener多个
instance时，一个instance down掉时，自动连到另一个instance; （connect-time failover）
236. You work as a database administrator for Supportcenter.cn. You added a tablespaceto your database. Because of the changes to the physical structure of your database, you performed a backup of the control file to trace. After this, you lost only the control files and the instance aborted due to a hardware failure.
How would you proceed to recover the database?
A. Start the instance and open the database, instance recovery automatically recovers control files
B. Create a file based on the contents of the trace file and save it to the control file locations and start the database
C.Re-create the database (The recovery of the control file is not possible because you have lost all the control files.)
D.Start the instance, in the NOMOUNTstate,re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
E.Start the instance and MOUNT the database, then re-create the control file using the CREATE CONTROLFILE command stored in the trace file.
答案：D
解析：因为alter database to trace ，所以只要在nomount下恢复控制文件即可
237. You work as a database administrator for Supportcenter.cn. You received the following error while working on your database: ORA-01555: snapshot too old ,In which situation would you receive such an error?
A. You performed rollback after commit.
B. If a log switch occurs in your database.
C.The archiver fails to generate an archived log file.
D.Instance recovery fails to find one of the redo log files.
E.A long-running query is unable to get read-consistent image.
F.If you perform manual undo management operations in auto mode.
答案：Ｅ
解析：
ORA-01555: snapshot too old: rollback segment number string with name "string" too small
Cause: rollback records needed by a reader for consistent read are overwritten by other writers
Action: If in Automatic Undo Management mode, increase undo_retention setting. Otherwise, use larger rollback segments
238. Exhibit #1, structure
You work as a database administrator for Supportcenter.cn. Use exhibit #1 to see the structure of the EMPLOYEES,
DEPARTMENTS and EMP_DEP tables. User SupportCenter C wants to insert rows from EMPLOYEES and
DEPARTMENTS
table into EMP_DEP table by using the code in exhibit #2.
While user SupportCenter C executes the command, it
errors out, displaying the following error message:
ERROR at line 1:
ORA-01653: unable to allocate extent table A. EMP_DEP by 8 intablespaceUSERS
What would have caused the error?
A. The user SupportCenter C does not have space quota.
B. RESOURCE role has not been granted to user SupportCenter C.
C.User SupportCenter C does not have insert privilege on EMP_DEP table.
D.The EMP_DEP table is residing on a temporarytablespace.
E.The defaulttablespaceof user SupportCenter C does not have enough free space.
F.Thetablespacewhere EMP_DEP table resides does not have enough free space.
答案：Ｆ
解析：
ORA-01653: unable to extend table string.string by string in tablespace string
Cause: Failed to allocate an extent of the required number of blocks for a table segment in the tablespace indicated.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
239. Exhibit
You work as a database administrator for Supportcenter.cn. Use the exhibit to see details about existing tablespaces ｉn the Oracle 10g database. You want to add a new tablespace to your database. Which three statements regarding a new tablespaceare true? Choose three.
A. A new tablespace can be a bigfile tablespace.
B. A new tablespace cannot be an undo tablespace.
C.A new tablespace cannot be a temporary tablespace.
D.A new tablespace can be a locally managed tablespace.
E.A new tablespace can be a dictionary-managed tablespace.
F.A new tablespace can use automatic segment space management
答案：BDE
解析：
A. A new tablespace can be a big file tablespace.
给个例子：
CREATE TABLESPACE testdb DATAFILE 'E:\oracle\data\testdb.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 3M;
可知文件大小是可以定义的，同时是可以扩展的，而不是题中所说的肯定是big file。
B. A new tablespace cannot be an undo tablespace.
undo通常用于日志方面，tablespace定义时至少开辟了硬盘空间，要么存在，要么删除，不能被undo,所以是对的。
C.A new tablespace cannot be a temporary tablespace.
可以CREATE temporary TABLESPACE testdb1 ...
D.A new tablespace can be a locally managedtablespace.
A new tablespace 是由服务器端的Oracle来管理的，当表空间用满了或硬盘不够时自动报错。
E.A new tablespace can be a dictionary-managedtablespace.
这个不明白。
F.A new tablespace can use automatic segment space management.
A new tablespace 是被user来寄居和引用的，最小引用单位应该是block,而不是segment space management。
240. Exhibit
You work as a database administrator for Supportcenter.cn. While trying to access Enterprise Manager Database Control by using a browser, you get an error. See exhibit. On further investigation, you find that the Oracle database 10g installation has just finished and your colleague, SupportCenter who installed the software, has not noted down all the port numbers. How do you determine the port number of the HTTP listener that is being used by Enterprise
Manager DatabaseConrol?
A. From thesqlnet.orafile
B. From thetsnames.orafile
C.From thelistener.orafile
D.From theportlist.orafile
E.By using Operating Systemutlities
答案：D
解析：In a default installation, the port number is 1158. If you are unsure of the correct port number to use, look for the following line in theORACLE_BASE\ORACLE_HOME\install\portlist.inifile.Enterprise ManagerConsoleHTTPPort(db_name) = port
241. Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?
A. PMON
B. SMON
C. MMNL
D. MMAN
E. MMON
答案：D
解析：MMAN进程是Oracle 10g引入用于进行内存管理的进程，在进行动态内存调整时，这个进程要发挥其作用。
242. Consider the following scenario: You have a directory, data, under the disk group tdgroup A. You want to create an alias for one of the data files and you execute the following command:
ALTER DISKGROUP tdgroupA
ADD ALIAS '+tdgroupA/data/datafile.dbf'
FOR '+tdgroupA. 231.45678';
Which task would be accomplished by the command?
A. The command drops the file +tdgroupA. 231.45678
B. The command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.
C. The command creates a copy of the +tdgroupA. 231.45678 file and places it in +tdgroupA/data after remaining the file to datafile.dbf.
D. The command creates a synonym, datafile.dbf, and places it in +tdgroupA/data and does not remove the +tdgroupA. 231.45678 file.
E. The command creates a file, datafile.dbf, in +tdgroupA/ data and removes the references for +tdgroupA. 231.45678 from the data dictionary views.
答案：D
解析：
+tdgroupA.231.45678 是数据文件，数字的含义仅仅是不重复
+group.file.incarnation
file.incarnation is the file/incarnation pair, used to ensure uniqueness
'+dgroup3(user_temp)/user_files/user_tbsp'
代表你创建了一个文件，采用了自己定义在dgroup3组上的user_temp模板，并且该文件有一个链接+dgroup3/user_files/user_tbsp
oracle不推荐这么做，因为这样的话表空间在删除后还需要手工删除数据文件
243. Exhibit
One the evening of April 22, you are working on a database created using Oracle Database 10g. This database operates in the ARCHIVELOG mode. You discover that you need crucial data that was dropped from the database at 8:00 a.m. No full backup has been taken after April 15. What would you do?
A. recover the database until April 10
B. recover the database until April 15
C. recover the database until 22 7:59 a.m.
D. recovery is not possible; manually re-create the object
答案:C
解析：因为启动了归档，所以可以flashback database至8点前的时间点
244. You are unable to move the Unified Job Scheduler occupant from the SYSAUX tablespace to the USERS
tablespace. What could be the reason?
A. None of the SYSAUX occupants can be relocated.
B. The USERS tablespace is a bigfile tablespace (BFT).
C. The united Job Scheduler occupant cannot be relocated.
D. The SYSAUX occupants can be relocated to the SYSTEM tablespace only.
答案：C
解析：A - Not true. Same off the occupants can be move
B - Not true. The USERS occupant , isn't , by default a BFT tablespace, and even tought, you should be able to move anything to a BFT tablespace. The point it's about to move, SYSAUX occupant.
C - True answer, as you con check , by the following query : SELECT occupant_name, move_procedure, FROM v$sysaux_occupants;
245. You want to enforce a company's business policy on several objects by using a single policy function. Which two
types of policies can be assigned to the policy_type argument in the dbms_rls.add_policy procedure to achieve the
above objective? (Choose two.)
A. DBMS_RLS.STATIC
B. DBMS_RLS.DYNAMIC
C. DBMS_RLS.SHARED_STATIC
D. DBMS_RLS.CONTEXT_SENSITIVE
E. DBMS_RLS.SHARED_CONTEXT_SENSITIVE
答案：CE
解析：http://blog.csdn.net/firefoxboy/article/details/3009891
246. The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database if facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?
A. Create two custom ADDM tasks.
B. Modify the AWR snapshot time interval to two hours.
C. Create a new scheduler window for a time period of two hours.
D. Modify the time interval by using the DBMS_JOB. INTERVAL procedure.
E. Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.
答案：B
解析：要确保ADDM时间跨度为2小时，则把AWR快照的间隔设为2小时
247. You are connecting to an Oracle database server from a client by using the following connect string:
SQL> CONNECT hr/hr@pdserver.us.oracle.com:1521/proddb
Which naming method is being used in this case?
A. Local Naming
B. Easy Connect
C. External Naming
D. Directory Naming
答案：B
解析：You must watch the oracle10grelease(B14212-02 Configuring Naming Methods)
248. In your database, the users SYS and SYSTEM have been assigned the profiles, ADMIN_PROF1 and
ADMIN_PROF2, respectively. The rest of the database administrators are assigned the profile ADMIN_PROF3. You
create a profile, USER_PROF, and assign it to the application user, Adams. After a week you realize that the profile
is no longer required and you decide to drop it. What will Adam's profile be after the USER_PROF profile has been dropped?
A. no profiles
B. the default profile
C. same as the profile of SYS user
D. same as the profile of SYSTEM user
答案：B
解析：用户的概要文件删除后，会将默认的概要文件分配给用户
249. While setting up the database for your production environment, you want to create a user with following
requirements.
1.The objects created by the user must be stored in a tablespace, TBS1, if the TABLESPACE option is not defined during the object creation.
2.The user should be able to use 10MB of space in the tablespace TBS1.
3.The user must change the password immediately after logging in for the first time.
Which three options of the CREATE USER command would you use to achieve this objective? (Choose three.)
A. profile
B. account lock
C. account unlock
D. password expire
E. quota 10MB on TBS1
F. password never expire
G. default tablespace TBS1
H. quota unlimited on TBS1
I. temporary tablespace TEMP
J. temporary tablespace SYSTEM
答案：DEG
解析：1.G 2.E 3.D
250. You observe that in your PROD database, customer information is being modified by some unauthorized users.
You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL
subprogram or construct would you use to accomplish this task?
A. functions
B. packages
C. procedures
D. database triggers
E. anonymous PL/SQL block
答案：D
解析：在pl/sql subprogram里只有trigger能在transaction happening on table的时候做动作
251. You have been asked to create three users, PUB1, PUB2 and PUB3, for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users, which method can you use for granting the required privileges?
A. grant CONNECT role to all of the three users
B. grant RESOURCE role to all of the three users
C. grant both CONNECT and RESOURCE role to all of the three users
D. execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three users
E. create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users
答案：D
解析：题中问的是当创建完用户后，怎么授予所要求的权限
所以应该选D
252. You have two databases, FINDB and PAYDB, on single operating system and using Optimal Flexible
architecture (OFA). FINDB is functional and is currently being accessed by the users. While starting up the instance
for the PAYDB database you get the following error:
ORA-01081: cannot start - already running ORACLE - shut it down first
Which environmental variable would you set before starting up the PAYDB database to overcome this error?
A. ORA_PATH
B. ORACLE_SID
C. ORACLE_BASE
D. ORACLE_HOME
E. LD_LIBRARY_PATH
答案：B
解析：在启动PAYDB前没有修改oracle_sid，所以oracle_sid=FINDB,FINDB数据库已启动，所以出现错误
253. Your database is in the NOARCHIVELOG mode. Since last night's offline backup, the logs in group 1 have
been written to twice. This morning, the SYSTEM data file has become corrupted. Up to what point can it be recovered?
A. until the last commit
B. cannot be recovered
C. until the last offline backup
D. until the beginning of the last transaction
答案：C
解析：因为不归档，所以只能还原到最后次备份
254. Where do you find information about a missing redo log file?
A. trace file
B. audit trail
C. control file
D. alert log file
E. event viewer
答案：D
解析：http://x0ne.itpub.net/post/151/2129
255. What advantage would you get if you increase the length of time during which the undo information would be stored in the database?
A. roll back of large transactions
B. roll forward to redo a transaction
C. data concurrency for large updates
D. read consistency for long-running transactions
答案：D
解析：修改undo_retention http://www.eygle.com/archives/2006/09/undo_retention_need_change.html
256. One of the users in the PROD database, Adams, complains that his update on the table, TRANS, is taking an
unusually long time to complete. You find that the table gets locked by another database user before Adams starts his
transactions, and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows
in the table, he should get the highest priority. Which method would you use to overcome this problem?
A. execute the command, ALTER SESSION KILL .., to kill the blocking session
B. execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking session
C. execute the command, ALTER SYSTEM KILL SESSION .., to kill the blocking session
D. execute the command, ALTER SESSION UNLOCK .., to release the lock for the blocking session
E. execute the command, ALTER SYSTEM UNLOCK SESSION .., to release the lock for the blocking session
答案：C
解析：题中所说联系不上导致lock的用户，所以身为DBA，就要终止进程，使用ALTER SYSTEM KILL SESSION语句
http://www.eygle.com/faq/Kill_Session.htm
257. Exhibit.
Which two options are used to enable the connect-time failover feature? (Choose two.)
A. Use only the first address.
B. Try one address, selected at random.
C. Try each address, in order, until one succeeds.
D. Try each address, randomly, until one succeeds.
E. Use each address in order until destination reached.
答案：CD
解析：If you set loadblance=on,answer D is right
258. You have created a baseline metric, DISK_IO_BL, for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain
the performance and you decide to remove the baseline metrics. Which method would you use to remove the DISK_IO_BL baseline metrics?
A. The baseline, once created, cannot be removed.
B. Disable the baseline metrics in the Database Control Manage Metrics page.
C. The baseline will be automatically removed once the database performance has been optimized.
D. Drop the baseline metrics by using DBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure.
答案：D
解析：创建和删除基线http://www.jiagulun.com/thread-384-1-1.html
259. Identify the two tablespaces whose data files are so critical that only a closed recovery is possible. (Choose two.)
A. SYSAUX
B. TOOLS
C. UNDO
D. INDEX
E. SYSTEM
F. USERS
G. TEMP
答案:CE
解析：
答案e肯定对那a和c会是哪个呢，通过下面的实验你就明白了
步骤
1,rman bakcup database
2,database open，os rm sysaux tablespace file
3,recovery sysaux
4,database open，os rm undo tablespace file
5,recovery undo try
6,database mount，os rm undo tablespace file
6,recovery undo retry
260. Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all of the data blocks to satisfy the users' queries. Which component of the Oracle Instance would you change to improve performance?
A. Java pool
B. Large pool
C. Shared pool
D. Streams pool
E. Library cache
F. Redo log buffer
G. Data dictionary cache
H. Database buffer cache
答案：H
解析：说是的SQL查询的数据块, 无法全部被缓存, 这一组件是database buffer cache
261. When you try to open your database, you receive the following error:
ORA-00205: error in identifying control file
Where would you find the details required to resolve this error?
A. audit trail
B. alert log file
C. user trace file
D. online trace file
E. background trace file
F. operating system event viewer
答案：B
解析：
ORA-00205: error in identifying control file, check alert log for more info
Cause: The system could not find a control file of the specified name and size.
Action: Check that ALL control files are online and that they are the same files that the system created at cold start time.
262. You started a long transaction. Before committing, you executed a query on one of the tables currently being modified. You received the following error:
ORA-01555: snapshot too old
How would you prevent such an error in the future? (Choose three.)
A. guarantee undo retention
B. add one more redo log group
C. size the redo log files appropriately
D. size the UNDO tablespace appropriately
E. size the SYSTEM tablespace appropriately
F. configure an appropriate undo retention interval
G. change automatic undo management to manual
答案：ADF
解析：
ORA-01555: snapshot too old: rollback segment number string with name "string" too small
Cause: rollback records needed by a reader for consistent read are overwritten by other writers
Action: If in Automatic Undo Management mode, increase undo_retention setting. Otherwise, use larger rollback segments
263. Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode.
Which two statements regarding archive log destinations are true? (Choose two.)
A. The destination must be global only.
B. A maximum of five destinations can be assigned.
C. A maximum of ten different destinations can be assigned.
D. All the destinations are determined by the server automatically.
E. The destination may be local or remote for a Standby Database.
F.The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.
答案：CE
解析：SQL> show parameter archive
log_archive_dest_10 可以看到最大10个目的地
本地或远程数据库都可以
264. You created a new user in your database but missed assigning a default tablespace to that user. The user created a table without specifying the tablespace name. In which tablespace would the table be stored?
A. the INDEX tablespace
B. the USERS tablespace
C. the SYSAUX tablespace
D. the SYSTEM tablespace
E. the default undo tablespace
F. the default temporary tablespace
G. the default permanent tablespace
答案：G
解析：find default permanent tablespace
SQL> SELECT PROPERTY_VALUE FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME = ‘DEFAULT_PERMANENT_TABLESPACE’;
265. You want the size of the tablespace to increase when it is full. Which option would you use?
A. use automatic extent allocation
B. disable threshold for the tablespace
C. use freelists to manage the free space
D. use automatic segment space management
E. create the tablespace as a bigfile tablespace
F. use the RESIZE clause while creating the tablespace
G. enable AUTOEXTEND for at least one of the data files in the tablespace
答案：G
解析：1.启动数据文件自动扩展
2.创建新的数据文件
266. Your database performance has degraded due to frequent checkpointing. What would you do in this scenario?
A. make redo log files smaller
B. increase the size of the checkpoint file
C. make the changes as per the advice given by MTTR Advisor
D. make the changes as per the advice given by Checkpoint Advisor
答案：C
解析：MTTR缩小则checkpoint频率降低
267. As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead?
A. Coalesce the application tables at a regular interval.
B. Export and Import the application tables a regular interval.
C. Drop and recreate the application tables at a regular interval.
D. Move the application tables to a tablespace with less space usage.
E. Distribute the application tables across multiple tablespaces depending on usage.
F. Move the application tables to automatic segment space management tablespace.
答案：F
解析：题中要求减少日常工作，则启用ASSM就可以了
268. In which two cases would you perform only consistent backup? (Choose two.)
A. You are working on a database where downtime is not tolerated.
B. You are working on a database where downtime can be tolerated.
C. You are working on a database that operates in ARCHIVELOG mode.
D. You are working on a database that operates in NOARCHIVELOG mode.
E. You are working on a database where all the tablespaces are locally managed.
F. You are working on a database where control files and redo log files are multiplexed.
G. You are working on a database where control files and redo log files are not multiplexed
答案：BD
解析：B是因为downtime是允许的
D是因为工作在非归档模式下，数据库只能进行一致备份
269. You have a production instance running on your server. UNDO_RETENTION is not long enough to satisfy
read-consistency requirements. How do you change the UNDO_RETENTION value?
A. by executing the ALTER SYSTEM .. command
B. by re-creating the control file with a new value for UNDO_RETENTION
C. by executing the ALTER DATABASE.. command in the MOUNT state
D. by executing UPDATE.. statement on V$PARAMETER to change the value of UNDO_RETENTION
答案：A
解析：修改undo_retension ALTER SYSTEM SET UNDO_RETENTION=900S；
270.You executed the following command in the lsnrctl utility to stop the listener:
lsnrctl> STOP L1
What is the effect of this command if L1 is the only listener configured for your database?
A. It terminates all user sessions.
B. It prevents users from logging in to the database remotely.
C. It halts the server until all user transactions are completed.
D. The server hangs, so users will receive an error asking them to login again.
E. Connected users would get an error with the message "End of communication channel".
答案：B
解析：关闭监听并不会影响实例，影响的是通过该监听所进行的远程登录
271. You have a listener process, L1, currently listening for the connections to the PROD and ADMIN databases. You
create a new database, PAY, using CREATE DATABASE.. command. You have not enabled dynamic instance
registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process.
Which command of Listener control utility (LSNRCTL) would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications?
A. START
B. RELOAD
C. RESTART
D. REFRESH
E. START L1
F. RELOAD L1
G. RESTART L1
H. REFRESH L1
答案：F
解析：
Dynamically register就是不需要修改listener.ora。DB Instance会自动通知listener。
如果在listerer.ora中配置sid_llist，那就是静态注册了。
由于静态注册，参数是手动静态添加，与数据库无关。数据库无法确认监听是否正确配置。因此，lsnrctl中的status显示状态为unkown。即不保证能连通数据库。注意：静态注册监听，客户端在配置tnsnames.ora服务命名时，“（Oracle 8i或更高版本）服务名”里填写内容要与服务端静态注册监听器时的全局数据库名一致。否则，无法连通
reload --重新装入监听器，重新读取listener.ora文件，但不关闭监听器。如果该文件发生了变化，重新刷新监听器。
272. It is a holiday and no transactions are being performed on the database. You took a consistent backup of your
database without using Recovery Manager (RMAN). How would you make use of this consistent backup in RMAN?
A. cannot be used in RMAN
B. by starting up the database again
C. by using the CATALOG command of RMAN
D. by using the RECOVER CATALOG command in RMAN
E. by re-creating the target control file to rebuild the RMAN repository
答案：C
解析：在RMAN中使用用操作系统命令备份下来的文件。这就要用到RMAN中的CATALOG命令
273. You are working on a 24x7 (available 24 hours per day, 7 days per week) production database. An operating system (OS) user deletes the alert log file accidentally. Which statement in this scenario is true?
A. The database crashes.
B. The DBA needs to re-create the file.
C. The file gets re-created automatically.
D. The file gets restored automatically from the last backup.
E. The DBA needs to perform a complete database recovery.
F. The DBA needs to perform an incomplete database recovery.
答案：C
解析：alter log file被删除后数据库会自动重建
274. Anyone who knows just the host name and the listener name can have full control over the listener. They can stop the listener and also obtain detailed information about the listener, database, and the configuration of the application.
How would you avoid this scenario?
A. lock the listener
B. hide the listener
C. create multiple listeners
D. run listener on a remote client
E. set a password for the listener
F. store listener.ora in a non-default location
答案：E
解析：为了防止题中出现的情况，可以采用口令认证，也就是为监听创建一个密码
275. In your database, you discovered that a tempfile in a locally managed temporary tablespace has been deleted at
the operating system level. How would you recover the tablespace?
A. flash back the database
B. perform point-in-time recovery
C. perform a full database recovery
D. drop and re-create the tablespace
E. use Recovery Manager (RMAN) to recover the database
答案：D
解析：因为在物理上已经被删除，所以在逻辑上drop再重建一张新表
276. Exhibit:
View the Exhibit to see the data in the emp table. You created a PRIMARY KEY constraint on the empno column of
the emp table, and the constraint is not deferred. Which two statements are true in this scenario? (Choose two.)
A. No index would be created or used in this case.
B. A unique index on the empno column would be created.
C. A CHECK constraint would be enforced on the empno column.
D. A NOT NULL constraint would be enforced on the empno column.
E. A bitmap unique index would be created on the empno column.
答案：BD
解析：非延迟主键=非空+唯一索引
277. You have three databases, FINDB, PAYDB and ADMINDB, located in Sydney, Tokyo and Singapore respectively.
You want to perform administrative tasks which include starting up and shutting down the databases, creating and
managing tablespaces and database users, and taking regular backups, for all of the three databases from
London.Which component must be enabled and running on each host machine to achieve your objective?
A. Oracle Management Agent
B. Enterprise Manager with Grid Control
C. Enterprise Manager with Database Control
D. Operating System Socket for incoming requests
E. Real Application Cluster (RAC) with three instances
F. Enterprise Manager with Generic Database Management
答案：A
解析：
Oracle Management Agent (Management Agent) is one of the
integral components of Enterprise Manager Grid Control (Grid
Control) architecture. Management Agent communicates with the
monitored targets, collects information about their health,
transports that information to Oracle Management Service(OMS),
which in turn stores the collected details in the central
repository created in Oracle Database.
278. Exhibit:
View the Exhibit to see the structure of EMPLOYEES, DEPARTMENTS and EMP_DEP tables. User A wants to
insert rows from EMPLOYEES and DEPARTMENTS table into
EMP_DEP table by using
following insert command.
INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id)
SELECT e.employee_id,
e.first_name ||' '|| e.last_name,
e.salary,
d.department_name,
e.manager_id
FROM employees e,
departments d
where e.department_id = d.department_id;
While user A executes the command, it errors out, displaying the following error message:
INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id)
*
ERROR at line 1:
ORA-01653: unable to allocate extent table A. EMP_DEP by 8 in tablespace USERS
What would have caused the error?
A. The user A does not have space quota.
B. RESOURCE role has not been granted to user A.
C. User A does not have insert privilege on EMP_DEP table.
D. The EMP_DEP table is residing on a temporary tablespace.
E. The default tablespace of user A does not have enough free space.
F. The tablespace where EMP_DEP table resides does not have enough free space.
答案：F
解析：
ORA-01653: unable to extend table string.string by string in tablespace string
Cause: Failed to allocate an extent of the required number of blocks for a table segment in the tablespace indicated.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
279. You decided to increase the value for the SHARED_SERVERS parameter by using the following command:
SQL> ALTER SYSTEM SET SHARED_|SERVERS=3 SCOPE=?;
Which three values can be specified for the SCOPE clause? (Choose three.)
A. ALL
B. PFILE
C. BOTH
D. NONE
E. SPFILE
F. MEMORY
G. INSTANCE
H. DATABASE
答案：CEF
解析：
1. SCOPE = SPFILE
既适用于动态初始化参数的修改，也使用与静态初始化参数的修改。也是静态参数唯一可以使用的方式。
对参数的修改仅记录在服务器初始化参数文件中，更改将在下次DB启动时生效。
2. SCOPE = MEMORY
只适用于动态初始化参数的修改。静态参数不允许。
对参数的修改仅在内存上，立即生效，但重启后将不再有效，因为并没有写入到初始化参数文件。
DB重启后这个修改会丢失,参数复原为修改前的参数值。
3. SCOPE = BOTH
只适用于动态初始化参数的修改。静态参数不允许。
对参数的修改同时既写入到初始化参数文件，也在内存上修改，立即生效
280. Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is
highly fragmented. In the process of defragmentation you lose the redo log member, which is not a member of the current group. How would you recover from the loss of the redo log member?
A. SMON would automatically restore the lost file.
B. You would need to restore the whole database from the last backup.
C. You would need to restore the file from the last full database backup.
D. You would need to use flashback technology to restore the lost redo log member.
E. You would need to use Recovery Manager (RMAN) to restore the lost redo log member.
F. You would need to restore the missing log file by copying one of the remaining files from the same group.
答案：F
解析：http://blog.csdn.net/leishifei/article/details/6381493
281. Your application demands frequent connection and disconnection from the database. You have three listener
processes that are listening for the database PROD. While setting up the connect string using Oracle Enterprise
Manager 10g Database Control, which two options would you select to balance the connectionload across all the listener processes? (Choose two.)
A. Use only the first address.
B. Try one address, selected at random.
C. Try each address, in order, until one succeeds.
D. Try each address, randomly, until one succeeds.
答案：BD
解析：The picture above is from< Oracle Database10g: Administration Workshop I 12-22 >
Web site associated:
http://www.itpub.net/thread-505819-1-1.html#
282. You find today's performance of your production database to be the best ever. Therefore, you want to be notified
in the future whenever the performance degrades by 10% of today's performance. What is the first step that you would take to ensure this?
A. create baseline metrics for today's performance
B. write the current database metrics to a database table and create a trigger to compare with future database statistics
C. write the current database metrics to a flat file and create an operating script to compare with future database statistics
D. write the current database metrics to a database table and create a procedure to compare with future database statistics
E. write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics
答案：A
解析：基线度量可以监视性能，并在达到一定要求时提醒DBA
283. The following are the details of your database:
Instance name : test
Host name : tech1.us.oracle.com
IP address : 145.33.230.186
Enterprise Manager Console HTTP Port number : 5500
You started the database instance and you want to manage your database remotely with Enterprise Manager
through a Web browser. Which two URLs would you use to access the Database Control? (Choose two.)
A. http://145.33.230.186:5500/em
B. http://www.145.33.230.186:5500/em
C. http://tech1.us.oracle.com:5500/em
D. http://test.145.33.230.186:5500/em
E. http://test.tech1.us.oracle.com:5500
F. http://www.tech1.us.oracle.com:5500/em
G. http://test.tech1.us.oracle.com:5500/em
答案：AC
解析:要么是A一样的IP地址，要么是C一样的域名
284. In your database, you may be forced to perform a recovery using the RESETLOGS option during which the
redo logs would be reset to sequence number 1. You want to avoid the overwriting of old log files. Which archived log
file name format ensures this?
A. %t_%s.dbf
B. arch_%t.arc
C. arch_%d.arc
D. arch_%t_%d.arc
E. arch_%d_%s_.dbf
F. arch_%t_%s_%r.arc
答案:F
解析：This setting will generate archived logs as follows for thread 1; log sequence numbers 100, 101, and 102; resetlogs ID 509210197. The identical resetlogs ID indicates that the files are all from the same database incarnation:
285. You manually create an additional listener process, L1, for databases PROD, PAYDB and FINDB. While
starting up the listener process, you get the following error message:
LSNRCTL> start l1
Starting /u01/app/oracle/product/10.1.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.1.0.2.0 - Production
System parameter file is /u01/app/oracle/product/10.1.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.1.0/db_1/network/log/l1.log
Error listening on:
(ADDRESS=(PROTOCOL=TCP)(HOST=144.23.230.185)(port=8899))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use
Listener failed to start. See the error message(s) above...
What action would you take to overcome this error without disrupting any existing database communications?
A. stop and restart the listener process
B. set the TNS_ADMIN environmental variable
C. stop all running listener processes and restart the listener process
D. change the port number to an unused port number and restart the listener process
E. change the IP address to host machine name in the LISTENER.ORA file and restart the listener process
答案：D
解析：TNS-12542: TNS:address already in use
说明端口被占用，需要更换个端口
286. The customer and order tables are often used in joins, thereby resulting in complex queries. You created views to simplify the writing of queries. These views are stored in _____.
A. user tables
B. view segment
C. table segment
D. data dictionary
E. object segment
F. performance tables
答案：D
解析：视图存放在数据字典中
287. Users in your PROD database complain about the slow response of the transactions. While investigating the
reason, you find that the transactions are waiting for the undo segments to be available, and undo retention has been
set to zero. What would you do to overcome this problem?
A. increase the undo retention
B. create more undo segments
C. create another undo tablespace
D. increase the size of the undo tablespace
答案：D
解析：transactions are
waiting for the undo segments to be available, and undo retention has been set to zero.
这句说明undo表空间已经满了，所以需要增加表空间容量
288. In the instance of the PROD database, the checkpoint (CKPT) process runs after every minute. A database user
updates the rows of the ORDERS table. Because of the configuration, the CKPT process gets initiated before the
user commits the transaction. What would happen to the modified blocks when the CKPT process is started?
A. The modified blocks would be written to the data files.
B. The modified blocks would be written to the temp files.
C. The modified blocks would be written to the control file.
D. The modified blocks would be written to the redo log files.
E. The modified blocks would be written to the archived redo log files.
F. The modified blocks would be retained in the database buffer cache
答案：A
解析：CKPT进程把data buffer cache中的写入data files
289. You are working on a very large database. You had performed a binary backup of the control file a month ago. After this you added a few tablespaces, and dropped a couple of tablespaces. This morning, due to hardware failure, you lost all your control files. How would you recover the database from this situation?
A. execute the CREATE CONTROLFILE FROM BACKUP.. command
B. restore all database files from the last backup and apply redo logs till the point of failure
C. restore the binary copy of the control file to the respective location and start up the database
D. start up the database in the NOMOUNT state, generate the trace file from binary backup, and re-create the control file using the trace file andthen mount and open the database
E. restore the binary copy of the control file to the correct location, start up the instance in the mount state, backup the control file to trace, shut down the instance, edit the trace file to reflect the added and removed data files, then use the script generated in the trace file to start the instance and re-create the control file
答案：E
290. You are using the following command to clear the log file group: ALTER DATABASE CLEAR LOFFILE
GROUP 2; In which case would the command be successful?
A. Group 2 is the active group.
B. Group 2 is the current group.
C. Database is in the MOUNT state.
D. Group 2 has been already archived.
答案：D
解析：clear logfile前要先checkpoint
291. You want to administer your PROD database from a remote host machine using a Web-enabled interface.
Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces?
A. SQL*Plus
B. iSQL*Plus
C. Management Server
D. Management Repository
E. Oracle Enterprise Manager 10g Database Control
答案：D
解析：without using command-line interfaces 所以只能选E了
292. While creating a database using Database Configuration Assistant tool, you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used?
A. the CREATE TABLE .. command
B. sorting of the SYSTEM tablespace's data
C. sorting of data required by recursive SQL statements
D. the CREATE TABLE .. ORGANIZATION EXTERNAL .. command
E. sorting of data if the users have not been allocated temporary tablespace explicitly
F. sorting of data if the users have been allocated temporary tablespace explicitly
答案：E
解析：使用临时表空间
1.创建临时表
2.sorting of data if the users have not been allocated temporary tablespace explicitly
293. In your database, UNDO_RETENTION has been set to 600 sec and UNDO tablespace is configured for RETENTION GUARANTEE.
Which statement regarding RETENTION GUARANTEE is true?
A. Undo data is retained until the next full database backup.
B. No committed undo data will be overwritten for 10 minutes.
C. Committed undo data will be kept forever if not overwritten within 600 seconds.
D. Guarantees that requested undo information are available until the instance is shut down.
答案：B
解析：undo_retension
http://blog.csdn.net/seagal890/article/details/3044226
294. You want to migrate your application from the development environment to the production environment. While doing the task, you want the database objects owned by the user DEVUSER in the development environment to be moved to the user APPS in the production environment. Which option of Oracle Data Pump Import would you use to achieve this objective?
A. owner
B. touser
C. include
D. schemas
E. fromuser
F. transform
G. remap_schema
H. remap_datafile
I. reuse_datafiles
J. remap_tablespace
答案：G
解析：
1. REMAP_DATAFILE 该选项用于将源数据文件名转变为目标数据文件名,在不同平台之间搬移表空间时可能需要该选项. REMAP_DATAFIEL=source_datafie:target_datafile
2. REMAP_SCHEMA 该选项用于将源方案的所有对象装载到目标方案中
295. View the Exhibit to see the output of queries on DATABASEPROPERTIES and DBAUSERS. You observe that
the current default permanent tablespace of the database is running out of space and you decide to change it to
NEWDEFTBSP. You create a new user, USER04, after changing the default permanent tablespace of the database.
What would be the new user's default tablespace?
A. DEFTBSP
B. SYSTEM
C. NEWDEFTBSP
D. USERS and NEWDEFTBSP both
E. USERS
答案：C
解析：可以看到，默认的表空间是DEF_TBSP
296. You connected to the database using the following connection string:
CONNECT hr/hr@test.us.oracle.com:1521/mydb
Which three statements are correct regarding the connection string? (Choose three.)
A. mydb is a service name.
B. test.us.oracle.com is a database name.
C. 1521 is the listener port number.
D. mydb is a host name.
E. test.us.oracle.com is a net service name.
F. hr is a username.
G. test.us.oracle.com is an instance name.
答案：ACF
