1.Which three statements are true regarding the logical structure of the Oracle database?(choose three)
A – Each segment contains one or more extents
B – Mutiple tablespaces can share single datafile
C – A data block is a smallest unit of I/O for data files.
D – it is possible to have tablespaces of different blocks size in a database
E – Each data block in the database always corresponds to one OS block.
(Answer:A,C,D)
Continue reading OCP 10g(1z0-042) daily 10 practices-2
1.What are the consequences of executing the SHUTDOWN ABORT command(Choose tow)
A – The database files are synchronized.
B – Uncommitted changes are no rolled back.
C – The database is closed,but the instance is still started.
D – Database buffers and redo buffers are not written to the disk.
E – The data base undergose automatic media recovery during the next startup.
Continue reading OCP 10g(1z0-042) daily 10 practices-1
I found this web site scribd by accident.There are lots of books on this site.Here’s another similar site slideshare. Have fun!
if you get ORA-00600 or the following error message on your Oracle standby database:
Fri Mar 09 10:57:49 2007
Errors in file c:\oracle\admin92\crm\bdump\crmsb_mrp0_524.trc:
ORA-00600: internal error code, arguments: [3020], [356515961], [1], [4606], [2], [16], [], []
ORA-10567: Redo is inconsistent with data block (file# 85, block# 121)
ORA-10564: tablespace UNDOTBS2
ORA-01110: data file 85: ‘K:\ORADATA\CRM\UNDOTBS02_1.DBF’
ORA-10560: block type ‘KTU SMU HEADER BLOCK’
Or your undo tablespace has grown to unmanageable size (~ 35 Gbytes), you may want to recreate unto tablespace. Here is how:
Continue reading How to drop and recreate oracle undo tablespace and its datafile
–摘录满文军为悼念在汶川地震中殉难的同胞新歌歌词
–祝愿在汶川大地震中遇难的同胞们能够到达彼岸
很少有人真的了解
思念是片海
很少有人能够到达彼岸
很多人都治好伤口
重新扬起帆
航离这片无边际的蓝
我比别人都要了解
夜有多灿烂
音乐和回忆来抵抗孤单
想着你甜甜的睡去
美梦多浪漫
推开窗天快要亮起来
风
轻轻的告诉她
我还在等待
等
昨天的漂流瓶
载着爱回来
风
轻轻的吹过来
我为爱等待
等
你留下的誓言
带着爱回来
Recent Comments