Posts
是否显示我的答案
是否显示书上的答案和我的注释
1.
7、In your database, online redo log files are multiplexed and one of the members in a group is lost due to media failure? How would you recover the lost redo log member?
A. import the database from the last export
B. restore all the members in the group from the last backup
C. drop the lost member from the database and then add a new member to the group
D. restore all the database files from the backup and then perform a complete recovery
E. restore all the database files from the backup and then perform an incomplete recovery
C.
C.
教材4-10
日志成员所在的日志组必须是INACTIVE状态的, 才可被删除
教材4-10
日志成员所在的日志组必须是INACTIVE状态的, 才可被删除
SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------ 1 1 25 104857600 2 YES INACTIVE 192286 03-JAN-09 2 1 26 104857600 2 NO CURRENT 193879 03-JAN-09 3 1 24 104857600 2 YES INACTIVE 191800 03-JAN-09 SQL> alter database drop logfile member '/home/oracle/app/oracle/oradata/test/redo02b.rdo'; alter database drop logfile member '/home/oracle/app/oracle/oradata/test/redo02b.rdo' * ERROR at line 1: ORA-01609: log 2 is the current log for thread 1 - cannot drop members ORA-00312: online log 2 thread 1: '/home/oracle/app/oracle/oradata/test/redo02.rdo' ORA-00312: online log 2 thread 1: '/home/oracle/app/oracle/oradata/test/redo02b.rdo' SQL>
2.
27. In which scenarios would you rebuild an index? (Choose all that apply.)
A. when you need to disable the index usage
B. when you need to change storage options
C. when you need to enable index monitoring
D. when you need to move the index to another tablespace
BD.
BD
B 重建索引改变存储选项
D 索引重建到另一个表空间
A. alter index xxx nomonitoring usage;
C. alter index xxx monitoring usage;
B 重建索引改变存储选项
D 索引重建到另一个表空间
A. alter index xxx nomonitoring usage;
C. alter index xxx monitoring usage;
3.
46. A redo log file is corrupted while the database is open; as a consequence, database operations are stopped because archiving cannot continue. What would you do to solve the problem?
A. clear the redo log group
B. perform redo log file import
C. perform an incomplete recovery
D. perform a redo log recovery using Recovery Manager (RMAN)
E. shut down the database and open the database in the NOARCHIVELOG mode
A.
A
教材4-8
教材4-8
4.
68. You noticed that the index tablespace in your database requires a recovery. However, instead of performing a media recovery, you decided to re-create the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re-create the indexes? (Choose two.)
A. ONLINE
B. REVERSE
C. PARALLEL
D. COMPRESS
E. NOLOGGING
F. COMPUTE STATISTICS
CE.
CE
教材4-13
教材4-13
5.
82. You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this?
A. The index tablespace contains bitmap indexes.
B. The index tablespace contains more than one data file.
C. The index tablespace supports only complete recovery.
D. The index tablespace is not a dictionary-managed tablespace.
E. There is a dependency relationship between a table and its indexes.
E.
E
PDF教材D17092GC20上讲了
PDF教材D17092GC20上讲了
6.
97. Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table:
ERROR at line 1:
ORA-01654: unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES.
While investigating, you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed? (Choose two)
A. Drop and re-create the index.
B. Coalesce the ORDERS_IND index.
C. Coalesce the INDEXES tablespace.
D. Drop and re-create the ORDERS table.
E. Rebuild the index online and move it to another tablespace.
BE.
BE
B. coalesce合并相邻节点, , 释放空间. coalesce是在线操作, 不影响其他DML操作
E. 重建索引时需要额外的空间, 所在表空间没地了, 所以要重建到另一表空间上. 在线重建索引也不影响其他操作.
C. 合并表空间中的碎片，合并相邻的空闲盘区(extent). 但是题目说经调查没有空闲空间了, 所以不是碎片的问题, 所以C不对
B. coalesce合并相邻节点, , 释放空间. coalesce是在线操作, 不影响其他DML操作
E. 重建索引时需要额外的空间, 所在表空间没地了, 所以要重建到另一表空间上. 在线重建索引也不影响其他操作.
C. 合并表空间中的碎片，合并相邻的空闲盘区(extent). 但是题目说经调查没有空闲空间了, 所以不是碎片的问题, 所以C不对
7.
99. You lost a data file that belongs to an index tablespace in your database, which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem? (Choose two)
A. Restore the lost data file from the backup, and then flash back the database.
B. Restore the data file pertaining to index tablespace, and then recover the tablespace.
C. Restore all the data files, and then perform an incomplete recovery to get the tablespace back.
D. Restore all the data files, and then perform an incomplete recovery using the backup control file.
E. Drop and re-create the index tablespace, and then re-create all of the indexes in that tablespace.
CE
BE
索引表空间不能不完全恢复
索引表空间不能不完全恢复
8.
112. Because of hardware failure, you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file?
A. The redo log file should belong to an active group.
B. The redo log file should belong to an inactive group.
C. The redo log file should belong to the current group.
D. The redo log file can be dropped only if all the transactions are stopped.
E. Before a redo log file is dropped, it should be deleted from the operating system (OS).
B
B
见教材4-10
可以手工发起检查点, 使ACTIVE状态变成INACTIVE状态
见教材4-10
可以手工发起检查点, 使ACTIVE状态变成INACTIVE状态
SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------ 1 1 25 104857600 2 NO CURRENT 192286 03-JAN-09 2 1 23 104857600 2 YES INACTIVE 190894 03-JAN-09 3 1 24 104857600 2 YES ACTIVE 191800 03-JAN-09 SQL> alter system checkpoint; System altered. SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------ 1 1 25 104857600 2 NO CURRENT 192286 03-JAN-09 2 1 23 104857600 2 YES INACTIVE 190894 03-JAN-09 3 1 24 104857600 2 YES INACTIVE 191800 03-JAN-09 SQL>
9.
128. A media failure has occurred. This has resulted in all the members of the next hop log group being rendered inaccessible to the log writer process (LGWR) at a log switch. How does this failure affect the operational database?
A. The database re-created the missing redo log files automatically.
B. The database continues to function normally with the existing files.
C. The database allows only queries, no other statements are allowed.
D. The database returns and error and the database instance shuts down.
E. The user sessions that generate redo logs are terminated automatically.
C
D
没试过
没试过
10.
144. Last night, a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database? (Choose two.)
A. The database writer writes to a trace file, indicating that the temporary file is not found.
B. The database prompts for a database recovery.
C. The database opens normally.
D. The database gets mounted and throws an error indicating that the temporary file requires recovery.
AC
AC
题出的不好, A不准确. 举例:
删掉临时文件
启动数据库没有任何报错, 自动重建了临时文件
alert.log也显示自动重建了临时文件
没有写跟踪文件, 也没显示临时文件没找到, 所以A不准确
题出的不好, A不准确. 举例:
删掉临时文件
[oracle@DEV-RPT-2 ~/app/oracle/oradata/test]$ ls -l temp* -rw-r----- 1 oracle oinstall 23076864 Jan 3 04:50 temp01.dbf [oracle@DEV-RPT-2 ~/app/oracle/oradata/test]$ mv temp01.dbf temp01.dbf.1可以打开数据库
[oracle@DEV-RPT-2 ~/app/oracle/oradata/test]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on Sat Jan 3 10:23:13 2009 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 314572800 bytes Fixed Size 2083592 bytes Variable Size 167773432 bytes Database Buffers 138412032 bytes Redo Buffers 6303744 bytes Database mounted. Database opened. SQL> set pages 9999 line 120 SQL> select * from dba_temp_files; FILE_NAME ------------------------------------------------------------------------------------------------------------------------ FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS RELATIVE_FNO AUT MAXBYTES MAXBLOCKS ---------- ------------------------------ ---------- ---------- --------- ------------ --- ---------- ---------- INCREMENT_BY USER_BYTES USER_BLOCKS ------------ ---------- ----------- /home/oracle/app/oracle/oradata/test/temp01.dbf 1 TEMP 20971520 2560 AVAILABLE 1 YES 3.4360E+10 4194302 256 18874368 2304 SQL> !ls -l /home/oracle/app/oracle/oradata/test/temp* -rw-r----- 1 oracle oinstall 20979712 Jan 3 10:23 /home/oracle/app/oracle/oradata/test/temp01.dbf -rw-r----- 1 oracle oinstall 23076864 Jan 3 04:50 /home/oracle/app/oracle/oradata/test/temp01.dbf.1 SQL>
alert.log也显示自动重建了临时文件
Sat Jan 3 10:23:21 2009 ALTER DATABASE OPEN ... Sat Jan 3 10:23:22 2009 Re-creating tempfile /home/oracle/app/oracle/oradata/test/temp01.dbf Database Characterset is AL32UTF8 ... Sat Jan 3 10:23:24 2009 Completed: ALTER DATABASE OPEN
11.
149. You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes? (Choose all that apply.)
A. SQL scripts
B. Recovery Manager (RMAN) script
C. Data Pump
D. SQL*Loader
E. Flashback database
AC
AC
出的不好, impdp也不能只建索引呀, 还不是先获得sql语句, 再用sqlplus建
出的不好, impdp也不能只建索引呀, 还不是先获得sql语句, 再用sqlplus建
12.
166. You are working on a database, where you have three redo log groups. When the database is down for a backup, an operating system (OS) user deletes all the redo log files in a group. What will happen when you open your database?
A. The instance starts, the database is mounted, but efforts to open the database fail, and an error about the missing redo log group is displayed.
B. Before the instance starts, you receive an error about the missing redo log files of a group.
C. The instance starts and the database opens with an error message written to the alert log file.
D. The instance starts and the database opens because two redo log groups still exist.
E. The instance starts and the database opens, but every attempt to write to redo log files fails with an error.
E
A
果然起不来了
果然起不来了
SQL> select * from v$logfile; GROUP# STATUS TYPE MEMBER IS_ ---------- ------- ------- -------------------------------------------------- --- 1 ONLINE /home/oracle/app/oracle/oradata/test/redo01.rdo NO 2 ONLINE /home/oracle/app/oracle/oradata/test/redo02.rdo NO 3 ONLINE /home/oracle/app/oracle/oradata/test/redo03.rdo NO 1 ONLINE /home/oracle/app/oracle/oradata/test/redo01b.rdo NO 2 ONLINE /home/oracle/app/oracle/oradata/test/redo02b.rdo NO 3 ONLINE /home/oracle/app/oracle/oradata/test/redo03b.rdo NO 6 rows selected. SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------ 1 1 119 104857600 2 NO CURRENT 255447 05-JAN-09 2 1 117 104857600 2 YES INACTIVE 253970 05-JAN-09 3 1 118 104857600 2 YES INACTIVE 254672 05-JAN-09 SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> host mv /home/oracle/app/oracle/oradata/test/redo03.rdo /home/oracle/app/oracle/oradata/test/redo03.rdo.1 SQL> host mv /home/oracle/app/oracle/oradata/test/redo03b.rdo /home/oracle/app/oracle/oradata/test/redo03b.rdo.1 SQL> startup ORACLE instance started. Total System Global Area 314572800 bytes Fixed Size 2083592 bytes Variable Size 184550648 bytes Database Buffers 121634816 bytes Redo Buffers 6303744 bytes Database mounted. ORA-00313: open failed for members of log group 3 of thread 1 ORA-00312: online log 3 thread 1: '/home/oracle/app/oracle/oradata/test/redo03.rdo' ORA-00312: online log 3 thread 1: '/home/oracle/app/oracle/oradata/test/redo03b.rdo' SQL>
13.
170. A media failure has occurred. This has resulted in all the members of the next log group being rendered inaccessible to the log writer process (LGWR) at a log switch. How does this failure affect the operational database?
A. The database allows only queries; no other statements are allowed.
B. The database re-creates the missing redo log files automatically.
C. The database continues to function normally with the existing files.
D. The database returns an error and the database instance shuts down.
E. The user sessions that generate redo logs are terminated automatically.
A.
D
前面考过一遍
前面考过一遍
14.
176. Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens? (Choose three.)
A. log writer
B. archival
C. process monitor
D. system monitor
E. change tracking writer
F. database writer
ABF
ABF
写日志, 归档, 检查点
写日志, 归档, 检查点
==========
15.
1. Which of the following statements is true about non-critical losses?
A. Non-critical losses require media recovery.
B. Non-critical losses have a severe impact on database operations.
C. Non-critical losses can be resolved quickly with little impact to database operations.
D. Non-critical losses require the use of the RECOVER command.
C
1. C. Non-critical losses have little impact on database operations if resolved properly.
教材4-4
教材4-4
16.
2. Which of the following statements is true about temporary tablespaces?
A. Temporary tablespaces most often contain some permanent objects.
B. Temporary tablespaces are responsible for storing temporary or sort statements.
C. Temporary tablespaces must be recovered with the RECOVER command.
D. Temporary tablespaces cannot be managed locally.
B
2. B. Temporary tablespaces are responsible for storing temporary or sort segments. These are used in the sorting of select statements or in building indexes.
A不能保存永久对象
C临时表空间用不着恢复
D临时表空间只能是本地管理的
A不能保存永久对象
C临时表空间用不着恢复
D临时表空间只能是本地管理的
17.
3. Why is a missing tempfile considered a non-critical recovery situation?
A. The tempfile is dictionary managed and can only contain some permanent objects.
B. The tempfile is locally managed and can only contain some temporary objects.
C. The tempfile is locally managed and can only contain temporary objects.
D. The tempfile is dictionary managed and can only contain temporary objects.
C.
B和C有什么区别?
B和C有什么区别?
3. C. A missing tempfile can be re-created with the create tablespace command. Because the tempfile is locally managed and contains no permanent data, no restoring or recovering is needed. Therefore recovery can occur quickly with minimal impact to database operations.
B.some permanent objects意思是还可以有some permanent objects, 所以不对
B.some permanent objects意思是还可以有some permanent objects, 所以不对
18.
4. How can you resolve a missing temporary tablespace quickly? (Choose all that apply.)
A. Recover the tablespace immediately because restoring is not needed.
B. Restore the tablespace from disk and not from tape.
C. Run CREATE TEMPORARY TABLESPACE and then ALTER DATABASE to the new temporary tablespace.
D. If a temporary tablespace exists, then run ALTER DATABASE to the existing temporary tablespace.
CD
4. C, D. A missing temporary tablespace can be quickly reassigned with the command ALTER DATABASE to an existing temporary tablespace if one is available. If one is not available, you will need to run CREATE TEMPORARY TABLESPACE and then perform the ALTER DATABASE command.
先建create temporary tablespace, 然后 alter database default temporary tablespace xxx;
已有用户的默认临时表空间会自动改成新的
先建create temporary tablespace, 然后 alter database default temporary tablespace xxx;
已有用户的默认临时表空间会自动改成新的
SQL$gt; select username, temporary_tablespace from dba_users; USERNAME TEMPORARY_TABLESPACE ------------------------------ ------------------------------ OUTLN TEMP SYS TEMP SYSTEM TEMP CTXSYS TEMP DBSNMP TEMP WMSYS TEMP TSMSYS TEMP DIP TEMP ORACLE_OCM TEMP 9 rows selected. SQL$gt; create temporary tablespace ts_temp tempfile '/home/oracle/app/oracle/oradata/test/ts_temp01.dbf' size 10m autoextend on next 10m maxsize 100m extent management local uniform size 2m; 2 3 4 Tablespace created. SQL$gt; alter database default temporary tablespace ts_temp; Database altered. SQL$gt; select username, temporary_tablespace from dba_users; USERNAME TEMPORARY_TABLESPACE ------------------------------ ------------------------------ OUTLN TS_TEMP SYS TS_TEMP SYSTEM TS_TEMP CTXSYS TS_TEMP DBSNMP TS_TEMP WMSYS TS_TEMP TSMSYS TS_TEMP DIP TS_TEMP ORACLE_OCM TS_TEMP 9 rows selected. SQL$gt;
19.
5. What must be done to recover a missing redo log file member?
A. First perform a ALTER DATABASE DROP LOGFILE MEMBER filename and then ALTER DATABASE ADD LOGFILE MEMBER filename on the missing logfile member.
B. Perform ALTER DATABASE ADD LOGFILE MEMBER filename on the missing logfile.
C. Nothing is required if you have multiplexed redo logs.
D. Nothing is required if you do not have multiplexed redo logs.
A
5. A. The missing redo log must first be dropped even though it doesn’t exist physically in the file system. This removes the redo log metadata from the data dictionary. Next the log can be added back to database.
关数据库, 删掉一个在线日志文件后, 可以重启
redo02b.rdo显示为INVALID
alert.log日志里也报错
不能直接加
关数据库, 删掉一个在线日志文件后, 可以重启
SQL$gt; select * from v$logfile; GROUP# STATUS TYPE MEMBER IS_ ---------- ------- ------- -------------------------------------------------- --- 1 ONLINE /home/oracle/app/oracle/oradata/test/redo01.rdo NO 2 ONLINE /home/oracle/app/oracle/oradata/test/redo02.rdo NO 3 ONLINE /home/oracle/app/oracle/oradata/test/redo03.rdo NO 1 ONLINE /home/oracle/app/oracle/oradata/test/redo01b.rdo NO 2 ONLINE /home/oracle/app/oracle/oradata/test/redo02b.rdo NO 3 INVALID ONLINE /home/oracle/app/oracle/oradata/test/redo03b.rdo NO 6 rows selected. SQL$gt; select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------ 1 1 122 104857600 2 NO CURRENT 257655 05-JAN-09 2 1 120 104857600 2 YES INACTIVE 255844 05-JAN-09 3 1 121 104857600 2 YES INACTIVE 256866 05-JAN-09 SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> !mv /home/oracle/app/oracle/oradata/test/redo02b.rdo /home/oracle/app/oracle/oradata/test/redo02b.rdo.1 SQL> startup ORACLE instance started. Total System Global Area 314572800 bytes Fixed Size 2083592 bytes Variable Size 184550648 bytes Database Buffers 121634816 bytes Redo Buffers 6303744 bytes Database mounted. Database opened. SQL> SQL> select * from v$logfile; GROUP# STATUS TYPE MEMBER IS_ ---------- ------- ------- -------------------------------------------------- --- 1 ONLINE /home/oracle/app/oracle/oradata/test/redo01.rdo NO 2 ONLINE /home/oracle/app/oracle/oradata/test/redo02.rdo NO 3 ONLINE /home/oracle/app/oracle/oradata/test/redo03.rdo NO 1 ONLINE /home/oracle/app/oracle/oradata/test/redo01b.rdo NO 2 INVALID ONLINE /home/oracle/app/oracle/oradata/test/redo02b.rdo NO 3 INVALID ONLINE /home/oracle/app/oracle/oradata/test/redo03b.rdo NO 6 rows selected. SQL>
alert.log日志里也报错
Mon Jan 5 07:34:38 2009 Errors in file /home/oracle/app/oracle/admin/test/bdump/test_lgwr_14827.trc: ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1: '/home/oracle/app/oracle/oradata/test/redo02b.rdo' ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory Additional information: 3 Mon Jan 5 07:34:38 2009 Errors in file /home/oracle/app/oracle/admin/test/bdump/test_lgwr_14827.trc: ORA-00321: log 2 of thread 1, cannot update log file header ORA-00312: online log 2 thread 1: '/home/oracle/app/oracle/oradata/test/redo02b.rdo' Mon Jan 5 07:34:38 2009 Errors in file /home/oracle/app/oracle/admin/test/bdump/test_lgwr_14827.trc: ORA-00313: open failed for members of log group 3 of thread 1 Mon Jan 5 07:34:38 2009 Thread 1 opened at log sequence 122 Current log# 1 seq# 122 mem# 0: /home/oracle/app/oracle/oradata/test/redo01.rdo Current log# 1 seq# 122 mem# 1: /home/oracle/app/oracle/oradata/test/redo01b.rdo Successful open of redo thread 1 Mon Jan 5 07:34:38 2009
SQL> alter database add logfile member '/home/oracle/app/oracle/oradata/test/redo02b.rdo' reuse to group 2; alter database add logfile member '/home/oracle/app/oracle/oradata/test/redo02b.rdo' reuse to group 2 * ERROR at line 1: ORA-01577: cannot add log file '/home/oracle/app/oracle/oradata/test/redo02b.rdo' - file already part of database SQL>
20.
6. How would you know if you have lost a mirrored redo log member?
A. The database would hang.
B. The archive process would stop working.
C. The alert log would display an error, and the database would hang.
D. The alert log would display an error, and the database would process the archive logs.
D.
6. D. If your database has mirrored redo logs and a member is deleted, the database will function as normal. The error signaling that a log member has been deleted would be written to the alert log.
见前一道题
见前一道题
21.
7. What happens if the current or active online redo log group has a new member added?
A. Nothing, the redo log member will be added.
B. The redo log member will not be added because the log group is actively recording transactions.
C. The redo log member will be added, but it will be out of sync until a log switch occurs.
D. The redo log member will be added, but it will be empty.
C
7. B. The redo log member will not be added to the current or active redo log group. Oracle will not allow this because transactions are actively being written to the redo log group.
为什么不能加呀? 能加呀
而且这题出的不好, 什么叫out of sync呀? 应该是invalid状态, 切换使用后再变成正常状态
为什么不能加呀? 能加呀
SQL> alter database add logfile member '/home/oracle/app/oracle/oradata/test/redo01b.rdo' to group 1; Database altered. SQL> alter database add logfile member '/home/oracle/app/oracle/oradata/test/redo02b.rdo' to group 2; Database altered. SQL> alter database add logfile member '/home/oracle/app/oracle/oradata/test/redo03b.rdo' to group 3; Database altered. SQL> SQL> SQL> select * from v$logfile; GROUP# STATUS TYPE MEMBER IS_ ---------- ------- ------- -------------------------------------------------- --- 1 ONLINE /home/oracle/app/oracle/oradata/test/redo01.rdo NO 2 ONLINE /home/oracle/app/oracle/oradata/test/redo02.rdo NO 3 ONLINE /home/oracle/app/oracle/oradata/test/redo03.rdo NO 1 INVALID ONLINE /home/oracle/app/oracle/oradata/test/redo01b.rdo NO 2 INVALID ONLINE /home/oracle/app/oracle/oradata/test/redo02b.rdo NO 3 INVALID ONLINE /home/oracle/app/oracle/oradata/test/redo03b.rdo NO 6 rows selected. SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------ 1 1 22 104857600 2 YES INACTIVE 190066 03-JAN-09 2 1 23 104857600 2 YES INACTIVE 190894 03-JAN-09 3 1 24 104857600 2 NO CURRENT 191800 03-JAN-09 SQL>
SQL> alter system switch logfile; System altered. SQL> select * from v$logfile; GROUP# STATUS TYPE MEMBER IS_ ---------- ------- ------- -------------------------------------------------- --- 1 ONLINE /home/oracle/app/oracle/oradata/test/redo01.rdo NO 2 ONLINE /home/oracle/app/oracle/oradata/test/redo02.rdo NO 3 ONLINE /home/oracle/app/oracle/oradata/test/redo03.rdo NO 1 ONLINE /home/oracle/app/oracle/oradata/test/redo01b.rdo NO 2 INVALID ONLINE /home/oracle/app/oracle/oradata/test/redo02b.rdo NO 3 INVALID ONLINE /home/oracle/app/oracle/oradata/test/redo03b.rdo NO 6 rows selected. SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------------ 1 1 25 104857600 2 NO CURRENT 192286 03-JAN-09 2 1 23 104857600 2 YES INACTIVE 190894 03-JAN-09 3 1 24 104857600 2 YES ACTIVE 191800 03-JAN-09 SQL>
22.
8. What happens when you are recovering a temporary tablespace by switching to another available tablespace? (Choose all that apply.)
A. The new temporary tablespace is made available if the tablespace is permanent.
B. The new temporary tablespace is made available if the tablespace is temporary.
C. You will receive an ORA-12904 error if the available tablespace is temporary.
D. You will receive an ORA-12904 error if the available tablespace is permanent.
BD
8. B, C. You must use the ALTER DATABASE DEFAULT TEMPORARY TABLESPACE table name command on a temporary tablespace or you will receive an ORA-12904 error.
答案不对, 不报12904错误呀, 报12901错误
12904的意思是临时表空间不能改成永久的
试了一下, 语法也不对呀, 不让这么用
答案不对, 不报12904错误呀, 报12901错误
SQL> create tablespace ts_test datafile '/home/oracle/app/oracle/oradata/test/ts_test01.dbf' size 10m autoextend on next 10m maxsize 100m extent management local segment space management auto; 2 3 4 5 Tablespace created. SQL> alter database default temporary tablespace ts_test; alter database default temporary tablespace ts_test * ERROR at line 1: ORA-12901: default temporary tablespace must be of TEMPORARY type SQL>
12904的意思是临时表空间不能改成永久的
SQL> !oerr ora 12904 12904, 00000, "default temporary tablespace cannot be altered to PERMANENT type" // *Cause: // *Action: SQL> !oerr ora 12901 12901, 00000, "default temporary tablespace must be of TEMPORARY type" // *Cause: in a locally managed database, default temporary tablespace // must be TEMPORARY type // *Action: SQL>
SQL> alter tablespace temp permanent; alter tablespace temp permanent * ERROR at line 1: ORA-03217: invalid option for alter of TEMPORARY TABLESPACE SQL>
23.
9. How can you rebuild the objects in the index tablespace most efficiently?
A. Recover the index from tape.
B. Rebuild the index with LOGGING.
C. Rebuild the index with NOLOGGING.
D. Rebuild the index in parallel with NOLOGGING.
D
9. D. Rebuilding an index in parallel with NOLOGGING is the most efficient method of building an index to minimize the impact on database operations. You must be cautious not to use extensive server resources when you don’t use the parallel rebuild option.
教材4-13
教材4-13
24.
13. When connecting to an Oracle database locally to perform administrative functions, you are connecting with what access privilege?
A. SQL*Net
B. IPC
C. SYSDBA
D. SYSOPER
C.
13. B. IPC is the method that the local administrative access uses to connect to the database.
题意不明
题意不明
25.
14. What is the proper way of creating a password supporting up to 10 users?
A. orapwd file=orapwORA101T password=syspass users=10
B. orapwd file=orapwORA101T password=syspass entry=10
C. orapwd file=orapwORA101T password=syspass entries=10
D. orapass file=orapwORA101T password=syspass entries=10
C
14. C. The correct command to create a password file that supports 10 users is orapwd file=orapwORA101T password=syspass entries=10.
教材4-16
教材4-16
26.
15. Which initialization parameter is required for remote access to the database?
A. REMOTE_LOGIN_PASSWORDFILE
B. BREMOTE_LOGIN_PASSWORD_FILE
C. REMOTE_PASSWORD_FILE
D. REMOTE_LOGIN_FILE
A
15. A. The initialization parameter required for remote access is REMOTE_LOGIN_PASSWORDFILE.
教材4-16
教材4-16
27.
16. Which directory should the password file be stored in to function properly? (Choose all that apply.)
A. $ORACLE_HOME
B. $ORACLE_HOME/dbs
C. C:\$ORACLE_HOME\database
D. $ORACLE_SID
BC
16. B, C. The $ORACLE_HOME/dbs is the Unix location for the password file, and C:\$ORACLE_HOME\database is the Windows location for the password file.
教材4-17
教材4-17
28.
17. Before running the ORAPWD utility to generate a password file, what should be done?
A. Start the database but make sure it isn’t open.
B. Start up the database.
C. Start up the database in MOUNT mode.
D. Shut down the database.
D
17. D. The database should be shut down before running the ORAPWD utility.
教材4-17
教材4-17
29.
18. What do local connections to an Oracle database rely on for security and authentication of the user?
A. Password file
B. Database password
C. Operating system password
D. Listener password
A
18. C. Local connections are secured by the operating system password logging on to an administrative account such as Oracle user in Unix and administrator in Windows.
做题时想错了, 应该是操作系统认证的
做题时想错了, 应该是操作系统认证的
30.
20. Which situation is considered a non-critical loss to the database? (Choose all that apply.)
A. Loss of redo log group before archived
B. Loss of current or active redo member
C. Loss of archive log
D. Loss of current or active redo group
ABC
20. B, C. A non-critical loss should have limited impact on database operations. This means that incomplete recovery or media failure scenarios need to be performed. A loss of a redo group before archived will require incomplete recovery, which is the same as the loss of current or active redo log group. The current or active member or loss of archive will not significantly impact operations. A backup can be performed to eliminate the need for the archive log, and the database will function normally with the loss of a redo log member.
没看清, A是整个组都丢了
没看清, A是整个组都丢了
===
31.
9. What is the most efficient order in which to create a new default temporary tablespace named TEMP2 and have that tablespace available as the default tablespace for users?
A. Perform the CREATE TEMPORARY TABLESPACE temp2 command and then the ALTER USER username TEMPORARY TABLESPACE temp2 command.
B. Perform the CREATE TEMPORARY TABLESPACE temp2 command and then the ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2 command.
C. Perform the DROP TABLESPACE temp2, CREATE TEMPORARY TABLESPACE temp2 command and then the ALTER DATABASE TEMPORARY TABLESPACE temp2 command.
D. Perform the CREATE TEMPORARY TABLESPACE temp2 command.
A
9. B. The most efficient way to create a new default temporary tablespace named TEMP2 is to create the temporary tablespace TEMP2. Next, perform the ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temp2 command. This will make TEMP2 the default temporary tablespace for all users. You can perform the ALTER USER username TEMPORARY TABLESPACE temp2 command, but this could be more time-consuming than identifying all the users. See Chapter 3 for more information.
不用挨个ALTER USER, 只要ALTER DATABASE即可
不用挨个ALTER USER, 只要ALTER DATABASE即可
32.
10. What is the correct command sequence for recovering a missing tempfile named temp?
A. STARTUP MOUNT, CREATE TEMPORARY TABLESPACE temp TEMPFILE
B. STARTUP NOMOUNT, DROP TABLESPACE temp, CREATE TEMPORARY TABLESPACE temp TEMPFILE
C. STARTUP MOUNT, DROP TABLESPACE temp, CREATE TEMPORARY TABLESPACE temp TEMPFILE
D. STARTUP, DROP TABLESPACE temp, CREATE TEMPORARY TABLESPACE temp TEMPFILE
C
10. C. The correct command sequence for recovering a missing tempfile named temp is as follows:
1. STARTUP MOUNT
2. DROP TABLESPACE temp
3. CREATE TEMPORARY TABLESPACE temp TEMPFILE
The database must be mounted, and then the tablespace information needs to be dropped from the data dictionary. Then the tablespace can be created. See Chapter 3 for more information.
删了重建
1. STARTUP MOUNT
2. DROP TABLESPACE temp
3. CREATE TEMPORARY TABLESPACE temp TEMPFILE
The database must be mounted, and then the tablespace information needs to be dropped from the data dictionary. Then the tablespace can be created. See Chapter 3 for more information.
删了重建
-fin-
No comments:
Post a Comment