ote the following structures in your database server: 1:Extents 2:OS Blocks 3:Tablespace 4:Segments 5:Oracle Data Block Which option has the correct arrangement of these structures from the smallest to the largest()
第1题:
A.2,5,1,4,3
B.5,2,1,3,4
C.2,1,5,4,3
D.1,2,3,4,5
第2题:
Note the following structures in your database server: 1.Extents 2.OS Blocks 3.Tablespace 4.Segments 5.Oracle Data Block Which option has the correct arrangement of these structures from the smallest to the largest()
第3题:
A.2,5,1,4,3
B.1,2,3,4,5
C.5,2,1,3,4
D.2,1,5,4,3
第4题:
Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?()
第5题:
You have issued a SHUTDOWN ABORT command to bring down your database instance. Considerthe steps that will be performed later when you open the database: 1:SGA is allocated. 2:Control file is read. 3:Redo log files are read. 4:Instance recovery is started. 5:Background processes are started. 6:Data files are checked for consistency. 7:Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur()
第6题:
Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?()
第7题:
数据库服务器的下面结构中1.Extents 2.OSBlocks 3.Tablespace 4.Segments 5.Oracle Data Block有关从小到大的顺序,以下那个描述是正确的?()
第8题:
A.2,5,1,4,3
B.1,2,3,4,5
C.5,2,1,3,4
D.2,1,5,4,3
Oracle存储模型,逻辑结构在左,物理结构在右。 逻辑结构由大到小database-->tablespace-->segment-->extent-->oracledatablock
1、数据库是由多个表空间组成。
2、每个表空间只属于一个数据库,包含一个或多个数据文件,每个数据文件只属于一个表空间,
3、每个段包括一个或多个extents区
4、extent(区),由相邻的数据块的组成。
5、块BLOCK:是数据库中最小的I/O单元,db_block_size
第9题:
Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?()
第10题:
You used the IMMEDIATE option to shut down your database instance. Consider the steps that mayoccur when a database instance is started and database is opened: 1:SGA is allocated. 2:Control file is read. 3:Redo log files are opened. 4:Instance recovery is started. 5:Background processes are started. 6:Data file headers are checked for consistency. 7:Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur()