单选题You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）A One tablespace has only one datafileB Many tablespaces can share one datafileC One tablespace can

题目
单选题
You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）
A

One tablespace has only one datafile

B

Many tablespaces can share one datafile

C

One tablespace can have many datafiles

D

One datafile can contain many tablespaces

相似考题

1. Your Oracle Database 10g is online when you execute the following statement：        SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF；   What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）A、 The database does not record flashback logs for MY_TABLESPACEB、 The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.C、 All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.D、 None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

2.Which two statements about bigfile tablespaces are true？ （）A、The bigfile tablespace have only one data file.B、The segment space management is automatic.C、The extent management is dictionary managed.D、The database can have only one bigfile tablespace.E、The bigfile tablespace can be converted to a smallfile tablespace.

3. You issued the following command on the temporary tablespace LMTEMP in your database：   SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M；   Which requirement must be fulfilled for this command to succeed？（）  A、 The tablespace must be locally managed.B、 The tablespace must have only one temp file.C、 The tablespace must be made nondefault and offline.D、 The tablespace can remain as the default but must have no active sort operations.

4.The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed？（）A、 The Oracle database will not perform block checking for any of the data blocks.B、 The Oracle database will perform block checking for the default permanent tablespace only. C、 The Oracle database will perform block checking for the data blocks in all user tablespaces.D、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.E、 The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.

参考答案和解析
正确答案： C
解析： 暂无解析
更多“单选题You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）A One tablespace has only one datafileB Many tablespaces can share one datafileC One tablespace can”相关问题

  • 第1题：

    Which statements are true about logical structures of the Oracle database（）

    • A、Each segment contains one or more extents.
    • B、Multiple tablespaces can share a single data file
    • C、A data block is the smallest unit of input/output （I/O） in data files.
    • D、It is possible to have tablespaces of different block sizes in a database.
    • E、Each data block in the database always corresponds to one operating system block

    正确答案:A,C,D

  • 第2题：

    Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）

    • A、 undo tablespace
    • B、 index tablespace
    • C、 read-only tablespace
    • D、 temporary tablespace

    正确答案:D

  • 第3题：

    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

  • 第4题：

    Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

    • A、The database is in mount state.
    • B、One of the tablespaces is offline.
    • C、One of the tablespaces is read only.
    • D、The database operates in ARCHIEVELOG mode.
    • E、The database operates in NOARCHIEVELOG mode.

    正确答案:E

  • 第5题：

    Which three statements are true about logical structures of the Oracle database（）

    • A、Each segment contains one or more extents.
    • B、Multiple tablespaces can share a single data file.
    • C、A data block is the smallest unit of input/output （I/O） in data files.
    • D、It is possible to have tablespaces of different block sizes in a database.
    • E、Each data block in the database always corresponds to one operating system block.

    正确答案:A,C,D

  • 第6题：

    Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）

    • A、Shut down the database, restore the two data files and then start up the database. 
    • B、Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. 
    • C、Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. 
    • D、Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.

    正确答案:C

  • 第7题：

    单选题
    One of the tablespaces is read/x7fonly in your database. The loss of all control files forced you to re/x7fcreate the control file.  Which operation do you need to perform after re/x7fcreating the control file and opening the database？（）
    A

    drop and re­create the read­only tablespaces

    B

    rename the read­only data files to their correct file names

    C

    change the tablespace status from read/write to read­only

    D

    re­create the read­only tablespace because it is automatically removed


    正确答案： D
    解析： 暂无解析

  • 第8题：

    单选题
    You lost the index tablespace in your database. You are not able to use tablespace point/x7fin/x7ftime 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.


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）
    A

     undo tablespace

    B

     index tablespace

    C

     read-only tablespace

    D

     temporary tablespace


    正确答案： D
    解析： 暂无解析

  • 第10题：

    单选题
    One of the tablespaces is read-only in your database. The loss of all control files forced you to re-create the control file. Which operation do you need to perform after re-creating the control file and opening the database？（）
    A

     drop and re-create the read-only tablespaces

    B

     rename the read-only data files to their correct file names

    C

     change the tablespace status from read/write to read-only

    D

     re-create the read-only tablespace because it is automatically removed


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed？（）
    A

     The Oracle database will not perform block checking for any of the data blocks.

    B

     The Oracle database will perform block checking for the default permanent tablespace only. 

    C

     The Oracle database will perform block checking for the data blocks in all user tablespaces.

    D

     The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.

    E

     The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.


    正确答案： E
    解析： 暂无解析

  • 第12题：

    单选题
    Your Oracle Database 10g is online when you execute the following statement：        SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF；   What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）
    A

     The database does not record flashback logs for MY_TABLESPACE

    B

     The tables residing in MY_TABLESPACE are not protected by the Recycle Bin.

    C

     All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature.

    D

     None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE


    正确答案： B
    解析： 暂无解析

  • 第13题：

    One of the tablespaces is read/x7fonly in your database. The loss of all control files forced you to re/x7fcreate the control file.  Which operation do you need to perform after re/x7fcreating the control file and opening the database？（）

    • A、drop and re­create the read­only tablespaces
    • B、rename the read­only data files to their correct file names
    • C、change the tablespace status from read/write to read­only
    • D、re­create the read­only tablespace because it is automatically removed

    正确答案:B

  • 第14题：

    You lost the index tablespace in your database. You are not able to use tablespace point/x7fin/x7ftime 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

  • 第15题：

    There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow.  There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）

    • A、Only bring the tablespace back online.
    • B、Only recover the tablespace and then bring the tablespace back online.
    • C、Shut down the database， recover the data file and then start up the database.
    • D、Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.
    • E、Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.

    正确答案:D

  • 第16题：

    You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）

    • A、One tablespace has only one datafile
    • B、Many tablespaces can share one datafile
    • C、One tablespace can have many datafiles
    • D、One datafile can contain many tablespaces

    正确答案:C

  • 第17题：

    Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database：   a. Restore the three database datafiles that were lost.  b. Issue the Startup Mount command to mount the database.  c. Issue the alter database open command.  d. Issue the alter database open resetlogs command.  e. Recover the database using the recover database command. f. Recover the datafiles with the recover datafile command.  g. Take the datafiles offline.  Which is the correct order of these steps in this case？（）

    • A、a， b， e， c
    • B、b， e， d
    • C、a， b， d， c
    • D、b， g， c， f
    • E、a， b， d， f

    正确答案:A

  • 第18题：

    单选题
    Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）
    A

    Shut down the database, restore the two data files and then start up the database. 

    B

    Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. 

    C

    Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. 

    D

    Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.


    正确答案： B
    解析： 暂无解析

  • 第19题：

    单选题
    Your database is configured in NOARCHIVELOG mode. Due to a media failure， you have lost one of the datafiles belonging to a read-only tablespace. You know that the last backup was performed after the tablespace was made read-only. Which action should you take to restore the missing datafile in the minimum amount of time？（）
    A

     Restore all the datafiles from the backup.

    B

     Restore only the lost datafile from the backup.

    C

     Restore all the datafiles for the lost tablespace from the backup.

    D

     Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）
    A

    One tablespace has only one datafile

    B

    Many tablespaces can share one datafile

    C

    One tablespace can have many datafiles

    D

    One datafile can contain many tablespaces


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    You issued the following command on the temporary tablespace LMTEMP in your database：   SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M；   Which requirement must be fulfilled for this command to succeed？（）
    A

     The tablespace must be locally managed.

    B

     The tablespace must have only one temp file.

    C

     The tablespace must be made nondefault and offline.

    D

     The tablespace can remain as the default but must have no active sort operations.


    正确答案： D
    解析： 暂无解析

  • 第23题：

    多选题
    Which two statements about bigfile tablespaces are true？ （）
    A

    The bigfile tablespace have only one data file.

    B

    The segment space management is automatic.

    C

    The extent management is dictionary managed.

    D

    The database can have only one bigfile tablespace.

    E

    The bigfile tablespace can be converted to a smallfile tablespace.


    正确答案： D,B
    解析： 暂无解析

  • 第24题：

    单选题
    Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database：   a. Restore the three database datafiles that were lost.  b. Issue the Startup Mount command to mount the database.  c. Issue the alter database open command.  d. Issue the alter database open resetlogs command.  e. Recover the database using the recover database command. f. Recover the datafiles with the recover datafile command.  g. Take the datafiles offline.  Which is the correct order of these steps in this case？（）
    A

    a， b， e， c

    B

    b， e， d

    C

    a， b， d， c

    D

    b， g， c， f

    E

    a， b， d， f


    正确答案： D
    解析： 暂无解析

相关内容