单选题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（）A2， 5， 1， 4， 3B1， 2， 3， 4， 5C5， 2， 1， 3， 4D2， 1， 5， 4， 3
单选题
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（）
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-->oracle data block
1、数据库是由多个表空间组成。
2、每个表空间只属于一个数据库，包含一个或多个数据文件，每个数据文件只属于一个表空间，
3、每个段包括一个或多个extents区
4、extent（区），由相邻的数据块的组成。
5、块BLOCK:是数据库中最小的I/O单元,db_block_size
1、数据库是由多个表空间组成。
2、每个表空间只属于一个数据库，包含一个或多个数据文件，每个数据文件只属于一个表空间，
3、每个段包括一个或多个extents区
4、extent（区），由相邻的数据块的组成。
5、块BLOCK:是数据库中最小的I/O单元,db_block_size
相关考题：
Notethefollowingstructuresinyourdatabaseserver:1.Extents2.OSBlocks3.Tablespace4.Segments5.OracleDataBlockWhichoptionhasthecorrectarrangementofthesestructuresfromthesmallesttothelargest() A.2，5，1，4，3B.1，2，3，4，5C.5，2，1，3，4D.2，1，5，4，3
otethefollowingstructuresinyourdatabaseserver:1:Extents2:OSBlocks3:Tablespace4:Segments5:OracleDataBlockWhichoptionhasthecorrectarrangementofthesestructuresfromthesmallesttothelargest() A.2，5，1，4，3B.1，2，3，4，5C.5，2，1，3，4D.2，1，5，4，3
数据库服务器的下面结构中1.Extents 2.OSBlocks 3.Tablespace 4.Segments 5.Oracle Data Block有关从小到大的顺序,以下那个描述是正确的?() A.2，5，1，4，3B.5，2，1，3，4C.2，1，5，4，3D.1，2，3，4，5
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?（）A、2, 4, 3B、1, 4, 3, 2C、2, 5, 4, 3, 6D、5, 2, 4, 3, 6E、1, 5, 4, 3, 6, 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（）A、2，5，1，4，3B、1，2，3，4，5C、5，2，1，3，4D、2，1，5，4，3
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（）A、2， 5， 1， 4， 3B、1， 2， 3， 4， 5C、5， 2， 1， 3， 4D、2， 1， 5， 4， 3
数据库服务器的下面结构中1.Extents 2.OSBlocks 3.Tablespace 4.Segments 5.Oracle Data Block有关从小到大的顺序，以下那个描述是正确的？（）A、2，5，1，4，3B、5，2，1，3，4C、2，1，5，4，3D、1，2，3，4，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（）A、7，1，5，2，3，6，4B、1，2，3，7，5，6，4C、7，1，4，5，2，3，6D、1，7，5，4，2，3，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？（）A、 2，4，3B、 1，4，3，2C、 2，5，4，3，6D、 5，2，4，3，6E、 1，5，4，3，6，2
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?（）A、2，4，3B、1，4，3，2C、2，5，4，3，6D、5，2，4，3，6E、1，5，4，3，6，2
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（）A、7，1，5，2，3，6，4B、1，5，7，2，3，6；step 4 is not requiredC、7，1，5，2，3，6；step 4 is not requiredD、1，2，3，5，6，4；step 7 is not required
Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?（） 1.shutdown immediate from RMAN 2.Log into RMAN 3.startup mount from RMAN 4.backup database 5.alter database open 6.backup database plus archivelog delete inputA、2，3，1，4，5B、2，1，3，6，5C、1，3，5，4D、2，1，3，5，6E、2，1，3，4，5
Note the following functionalities of various background processes： 1：Record the checkpoint information in data file headers. CKPT 2：Perform recovery at instance startup. SMON 3：Cleanup unused temporary segments. SMON 4：Free the resources used by a user process when it fails. 5：Dynamically register database services with listeners. 6：Monitor sessions for idle session timeout. Which option has the correct functionalities listed for a background process（）A、Archiver Process （ARCn）：1， 2，5B、System Monitor Process （SMON）：1，4，5C、Process Monitor Process （PMON）：4，5，6D、Database Writer Process （DBWn）：1，3，4
In Recovery Manager （RMAN）， you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task， you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this： 1） Mount the database 2） Take the data file offline 3） Bring the data file online 4） Use the RMAN SWITCH TO command to switch the image copy 5） Apply the archived redo logs 6） Open the database 7） Use the RMAN RESTORE TO command to switch to the image copy Which two options illustrate the correct sequence of steps that you could follow？（）A、 2， 6， 4， 5， 3B、 1， 2， 4， 5， 3， 6C、 1， 2， 4， 6， 3D、 1， 2， 7， 5， 3， 6
You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the stepsthat 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（）A、7， 1， 5， 2， 3， 6， 4B、1， 2， 3，7， 5， 6， 4C、7， 1， 4， 5， 2， 3， 6D、1， 7， 5， 4， 2， 3， 6
You used the IMMEDIATE option to shut down your database instance. Consider the steps that may occurwhen 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（）A、7， 1， 5， 2， 3， 6， 4B、1， 5， 7， 2， 3， 6； step 4 is not requiredC、7， 1， 5， 2， 3， 6； step 4 is not requiredThis document was downloaded from = http：//www.amaderforum.comD、1， 2， 3， 5， 6， 4； step 7 is not required
Note the following functionalities of various background processes： 1. Record the checkpoint information in data file headers. 2. Perform recovery at instance startup. 3. Cleanup unused temporary segments. 4. Free the resources used by a user process when it fails. 5. Dynamically register database services with listeners. 6. Monitor sessions for idle session timeout. Which option has the correct functionalities listed for a background process（）A、Archiver Process （ARCn）： 1， 2， 5B、System Monitor Process （SMON）： 1， 4， 5C、Process Monitor Process （PMON）： 4， 5， 6D、Database Writer Process （DBWn）： 1， 3， 4
单选题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（）A2， 5， 1， 4， 3B1， 2， 3， 4， 5C5， 2， 1， 3， 4D2， 1， 5， 4， 3
单选题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（）A2，5，1，4，3B1，2，3，4，5C5，2，1，3，4D2，1，5，4，3
单选题数据库服务器的下面结构中1.Extents 2.OSBlocks 3.Tablespace 4.Segments 5.Oracle Data Block有关从小到大的顺序，以下那个描述是正确的？（）A2，5，1，4，3B5，2，1，3，4C2，1，5，4，3D1，2，3，4，5
单选题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（）A7，1，5，2，3，6，4B1，5，7，2，3，6；step 4 is not requiredC7，1，5，2，3，6；step 4 is not requiredD1，2，3，5，6，4；step 7 is not required
单选题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？（）A 2，4，3B 1，4，3，2C 2，5，4，3，6D 5，2，4，3，6E 1，5，4，3，6，2
单选题You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the stepsthat 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（）A7， 1， 5， 2， 3， 6， 4B1， 2， 3，7， 5， 6， 4C7， 1， 4， 5， 2， 3， 6D1， 7， 5， 4， 2， 3， 6
单选题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（）A2，5，1，4，3B1，2，3，4，5C5，2，1，3，4D2，1，5，4，3
单选题You used the IMMEDIATE option to shut down your database instance. Consider the steps that may occurwhen 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（）A7， 1， 5， 2， 3， 6， 4B1， 5， 7， 2， 3， 6； step 4 is not requiredC7， 1， 5， 2， 3， 6； step 4 is not requiredThis document was downloaded from = http：//www.amaderforum.comD1， 2， 3， 5， 6， 4； step 7 is not required
单选题You are using Recovery Manager （RMAN） with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure， you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task： 1） Restore an autobackup of the server parameter file. 2） Restore the control file 3） Start the target database instance 4） Mount the database 5） Restore the data files 6） Open the database with RESETLOGS option 7） Recover the data files 8） Set DBID for the target database Which option illustrates the correct sequence that you must use？（）A 8， 1， 3， 2， 4， 5， 7， 6B 1， 8， 3， 4， 2， 5， 7， 6C 1， 3， 4， 2， 8， 5， 6， 7D 1， 3， 2， 4， 6， 5， 7， 8
单选题You used the IMMEDIATE option to shut down your database instance. Consider the steps that may occurwhen 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（）A7， 1， 5， 2， 3， 6， 4B1， 5， 7， 2， 3， 6； step 4 is not requiredC7， 1， 5， 2， 3， 6； step 4 is not requiredThis document was downloaded from = http：//www.amaderforum.comD1， 2， 3， 5， 6， 4； step 7 is not required
单选题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（）A7，1，5，2，3，6，4B1，2，3，7，5，6，4C7，1，4，5，2，3，6D1，7，5，4，2，3，6