单选题By default, checkpoints happen at least as often as（）.A Redo log switches. B UPDATE statements are issued against the database. C The SYSTEM tablespace is accessed. D SMON coalesces free space in a tablespase.

题目
单选题
By default, checkpoints happen at least as often as（）.
A

Redo log switches. 

B

UPDATE statements are issued against the database. 

C

The SYSTEM tablespace is accessed. 

D

SMON coalesces free space in a tablespase.

相似考题

1. Evaluate the following command and its output：   SQL>SELECT * FROM dba_temp_free_space；  TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE  LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output？（）A、 FREE_SPACE indicates only the space that is currently unallocated.B、 ALLOCATED_SPACE indicates only the space currently allocated and in use.C、 FREE_SPACE indicates only the space that is currently allocated and available for reuse.D、 ALLOCATED_SPACE indicates both the space currently allocated and used，and the space that is available for reuse.E、 FREE_SPACE indicates both the space that is currently allocated and available for reuse，and the space that is currently unallocated.

2.During regular database operation, which background process will take smaller blocks of free space in a dictionary-managed tablespace and move things around to make bigger pieces of free space?（）A、DBW0 B、LGWR C、ARCH D、SMON E、PMON

3.You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）A、 online redo log filesB、 alert log filesC、 control fileD、 datafiles associated with the SYSTEM tablespace

4.Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）A、This clause is not valid for a temporary or undo tablespace.B、If the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate redo.C、The tablespace will be in the NOLOGGING mode by default，if not specified while creating a tablespace.D、The tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.

更多“单选题By default, checkpoints happen at least as often as（）.A Redo log switches. B UPDATE statements are issued against the database. C The SYSTEM tablespace is accessed. D SMON coalesces free space in a tablespase.”相关问题

  • 第1题：

    You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?（）

    • A、ALTER DATABASE 
    • B、ALTER SYSTEM 
    • C、ALTER USER 
    • D、ALTER REDO LOG

    正确答案:B

  • 第2题：

    Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct？（）

    • A、This clause is not valid for a temporary or undo tablespace.
    • B、If the tablespace is in the NOLOGGING mode， no operation on the tablespace will generate redo.
    • C、The tablespace will be in the NOLOGGING mode by default， if not specified while creating a tablespace.
    • D、The tablespace­level logging attribute can be overridden by logging specifications at the table， index， materialized view， materialized view log， and partition levels.

    正确答案:A,D

  • 第3题：

    You are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one.  Which is it?（）

    • A、Size of redo logs 
    • B、Number of datafiles 
    • C、LOG_CHECKPOINT_INTERVAL 
    • D、LOG_CHECKPOINT_TIMEOUT

    正确答案:B

  • 第4题：

    Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel/x7fbased recovery？（）

    • A、You find that one of the redo log members in each redo log group is lost.
    • B、You find that a data file that belongs to the USERS tablespace is damaged.
    • C、You find that a data file that belongs to the SYSTEM tablespace is damaged.
    • D、You find that the current redo log group is damaged and is not available for recovery.
    • E、You realized while performing a recovery that an archived redo log file needed for recovery is lost.

    正确答案:D,E

  • 第5题：

    Which statement is true regarding checkpoints and recovery？（）

    • A、A checkpoint defines the highest system change number （SCN）.
    • B、All redo entries higher or at the SCN are known to be written to the data files.
    • C、Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery.
    • D、The LOG_CHECKPOINT_INTERVAL initialization parameter specifies the amount of time between incremental checkpoints.

    正确答案:C

  • 第6题：

    Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database， each with three members， making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible？（）

    • A、Restore the data file for the SYSTEM tablespace then open the database. 
    • B、Restore all redo logs form last night's backup, then restart the database. 
    • C、Perform a complete restore of all files from last night's backup. Data entered into the database today must be reentered. 
    • D、Mount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online. 

    正确答案:C

  • 第7题：

    多选题
    View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；  Which three types of files are backed up？ （）
    A

    all the data files belonging to the USERS tablespace

    B

    password file

    C

    online redo log files

    D

    the current control file

    E

    archived redo log files

    F

    the current server parameter file

    G

    data files belonging to the USERS tablespace and all the default tablespaces


    正确答案： G,F
    解析： 暂无解析

  • 第8题：

    单选题
    Which statement is true regarding checkpoints and recovery？（）
    A

    A checkpoint defines the highest system change number （SCN）.

    B

    All redo entries higher or at the SCN are known to be written to the data files.

    C

    Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery.

    D

    The LOG_CHECKPOINT_INTERVAL initialization parameter specifies the amount of time between incremental checkpoints.


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

  • 第9题：

    多选题
    Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）
    A

    This clause is not valid for a temporary or undo tablespace.

    B

    If the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate redo.

    C

    The tablespace will be in the NOLOGGING mode by default，if not specified while creating a tablespace.

    D

    The tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.


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

  • 第10题：

    单选题
    You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）
    A

    Restore all the data files and open the database

    B

    Create the data file and perform tablespace recovery

    C

    No need to restore any file， just recover the database

    D

    Restore only the system data file and recover the database

    E

    Restore only lost date file and performtablespacerecovery


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

  • 第11题：

    多选题
    Which two statements are true regarding the MRKT tablespace（）
    A

    No more data files can be added to the tablespace.

    B

    Segment space is managed by free lists in the tablespace.

    C

    A user created without being assigned a default tablespace uses this tablespace.

    D

    The tablespace can be dropped with the current setting with segments present in it.


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

  • 第12题：

    单选题
    You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?（）
    A

    ALTER DATABASE 

    B

    ALTER SYSTEM 

    C

    ALTER USER 

    D

    ALTER REDO LOG


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

  • 第13题：

    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

  • 第14题：

    You configured the Flash Recovery Area （FRA） for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.  Which two files are removed automaticallyif the space is required in the FRA as per the retention policy（）

    • A、flashback log files
    • B、backups that have become obsolete
    • C、copies of the data files and control files
    • D、archived redo log files that have multiple copies in a different archive location and not backed up

    正确答案:A,B

  • 第15题：

    By default, checkpoints happen at least as often as（）.

    • A、Redo log switches. 
    • B、UPDATE statements are issued against the database. 
    • C、The SYSTEM tablespace is accessed. 
    • D、SMON coalesces free space in a tablespase.

    正确答案:A

  • 第16题：

    Examine the commands executed in a DBA session：SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created. SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered.  Which two statements are trueregarding the MRKT tablespace（）

    • A、No more data files can be added to the tablespace.
    • B、Segment space is managed by free lists in the tablespace.
    • C、A user created without being assigned a default tablespace uses this tablespace.
    • D、The tablespace can be dropped with the current setting with segments present in it

    正确答案:A,C

  • 第17题：

    You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）

    • A、Restore all the data files and open the database
    • B、Create the data file and perform tablespace recovery
    • C、No need to restore any file， just recover the database
    • D、Restore only the system data file and recover the database
    • E、Restore only lost date file and performtablespacerecovery

    正确答案:A

  • 第18题：

    View the Exhibit.You executed the following command to perform a backup of the USERS tablespace： RMAN> BACKUP TABLESPACE USERS；  Which three types of files are backed up？ （）

    • A、 all the data files belonging to the USERS tablespace
    • B、 password file
    • C、 online redo log files
    • D、 the current control file
    • E、 archived redo log files
    • F、 the current server parameter file
    • G、 data files belonging to the USERS tablespace and all the default tablespaces

    正确答案:A,D,F

  • 第19题：

    多选题
    Examine the commands executed in a DBA session：SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created. SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered.  Which two statements are trueregarding the MRKT tablespace（）
    A

    No more data files can be added to the tablespace.

    B

    Segment space is managed by free lists in the tablespace.

    C

    A user created without being assigned a default tablespace uses this tablespace.

    D

    The tablespace can be dropped with the current setting with segments present in it


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

  • 第20题：

    多选题
    Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct？（）
    A

    This clause is not valid for a temporary or undo tablespace.

    B

    If the tablespace is in the NOLOGGING mode， no operation on the tablespace will generate redo.

    C

    The tablespace will be in the NOLOGGING mode by default， if not specified while creating a tablespace.

    D

    The tablespace­level logging attribute can be overridden by logging specifications at the table， index， materialized view， materialized view log， and partition levels.


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

  • 第21题：

    单选题
    You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）
    A

     online redo log files

    B

     alert log files

    C

     control file

    D

     datafiles associated with the SYSTEM tablespace


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

  • 第22题：

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


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

  • 第23题：

    单选题
    Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database， each with three members， making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible？（）
    A

    Restore the data file for the SYSTEM tablespace then open the database. 

    B

    Restore all redo logs form last night's backup, then restart the database. 

    C

    Perform a complete restore of all files from last night's backup. Data entered into the database today must be reentered. 

    D

    Mount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online. 


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

  • 第24题：

    单选题
    By default, checkpoints happen at least as often as（）.
    A

    Redo log switches. 

    B

    UPDATE statements are issued against the database. 

    C

    The SYSTEM tablespace is accessed. 

    D

    SMON coalesces free space in a tablespase.


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

相关内容