单选题If you are going to run a TSPITR recovery， which view will help you to determine which objects will be lost during the TSPITR？（）ATS_OBJECTS_TO_BE_DROPPEDBTS_PTTR_OBJECT_DROPPEDCTS_PITR_OBJECTS_TO_BE_DROPPEDDTS_OBJECTS_DROPPEDETS_DROPPED_OBJECTS

题目
单选题
If you are going to run a TSPITR recovery， which view will help you to determine which objects will be lost during the TSPITR？（）
A

 TS_OBJECTS_TO_BE_DROPPED

B

 TS_PTTR_OBJECT_DROPPED

C

 TS_PITR_OBJECTS_TO_BE_DROPPED

D

 TS_OBJECTS_DROPPED

E

 TS_DROPPED_OBJECTS

相似考题

1.Which command would you configure globally on a Cisco router that would allow you to view directly connected Cisco devices?()A. enable cdpB. cdp enableC. cdp runD. run cdp

2.Which command would you configure globally on a Cisco router that would allow you to view directly connected Cisco devices?（）A、enable cdpB、cdp enableC、cdp runD、run cdp

3.Which version of a view would you use if you just want a quick， easy view within your XPage？（）A、Data Table ControlB、View ControlC、Repeat ControlD、Filter by category View Control

4.If you are going to run a TSPITR recovery， which view will help you to determine which objects will be lost during the TSPITR？（）A、 TS_OBJECTS_TO_BE_DROPPEDB、 TS_PTTR_OBJECT_DROPPEDC、 TS_PITR_OBJECTS_TO_BE_DROPPEDD、 TS_OBJECTS_DROPPEDE、 TS_DROPPED_OBJECTS

更多“If you are going to run a TSPITR recovery， which view will h”相关问题

  • 第1题：

    Which view will you use to view information regarding the jobs that are currently running in a database？（）

    • A、DBA_SCHEDULER_RUNNING_JOBS
    • B、DBA_SCHEDULER_JOB_RUN_DETAILS
    • C、DBA_SCHEDULER_JOBS
    • D、DBA_SCHEDULER_JOB_LOG

    正确答案:A

  • 第2题：

    In which scenario will you perform a user-managed incomplete recovery？（）

    • A、 when a table is dropped and stored in the Recycle Bin
    • B、when a table is dropped and purged from the Recycle Bin
    • C、 when you are required to recover an existing table to its previous state
    • D、 when you are required to view all the versions of a row of an existing table between a specific time period

    正确答案:B

  • 第3题：

    You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）

    • A、 Query the V$FLASHBACK_DATABASE_LOG view.
    • B、 Query the V$FLASHBACK_DATABASE_STAT view.
    • C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
    • D、 Query the V$RECOVERY_FILE_DEST view.

    正确答案:B

  • 第4题：

    You need to recommend a BitLocker recovery method that meets the company’s technical requirements.   Which recovery method should you recommend？（）

    • A、a data recovery agent
    • B、a recovery key
    • C、a recovery password printed and stored in a secure location
    • D、a recovery password stored in Active Directory

    正确答案:A

  • 第5题：

    单选题
    If you are going to run a TSPITR recovery， which view will help you to determine which objects will be lost during the TSPITR？（）
    A

     TS_OBJECTS_TO_BE_DROPPED

    B

     TS_PTTR_OBJECT_DROPPED

    C

     TS_PITR_OBJECTS_TO_BE_DROPPED

    D

     TS_OBJECTS_DROPPED

    E

     TS_DROPPED_OBJECTS


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

  • 第6题：

    单选题
    You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）
    A

     DBA_SCHEDULER_JOB_RUN_DETAILS

    B

     DBA_SCHEDULER_RUNNING_JOBS

    C

     DBA_SCHEDULER_JOBS

    D

     DBA_SCHEDULER_JOB_LOG


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

  • 第7题：

    单选题
    You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations.  Which view would you query to estimate the flashback space required？（）
    A

     V$DATABASE

    B

     V$FLASHBACK_DATABASE_STAT

    C

     V$FLASHBACK_DATABASE_LOG

    D

     V$RECOVERY_FILE_DEST


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

  • 第8题：

    单选题
    Because of a logical corruption in your production database， you wanted to perform Tablespace Point in Time Recovery （TSPITR）. But before you start the recovery，you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects.  Which option must you use to perform TSPITR and preserve the object？（）
    A

     Perform Export before TSPITR and Import after TSPITR

    B

     Move objects to another schema that has the same tablespace assigned

    C

     Perform Incomplete Recovery before TSPITR with the Log Sequence Number （LSN）

    D

     Perform Incomplete Recovery before TSPITR with the System Change Number （SCN）


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

  • 第9题：

    单选题
    You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task？（）
    A

     the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view

    B

     the column of the V$INSTANCE_RECOVERY view

    C

     the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view

    D

     the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view


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

  • 第10题：

    多选题
    Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）
    A

    The target database must be in NOARCHIVELOG mode.

    B

    No backup is required of the database before you perform a TSPITR.

    C

    You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.

    D

    If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.

    E

    If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.


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

  • 第11题：

    单选题
    In your production database， users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason， you realize that another user executed the TRUNCATE TABLE command， which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.  Which method must you use to recover the lost data？（）
    A

     Complete Recovery with online redo log

    B

     Complete Recovery with archived redo log

    C

     Tablespace Point-in-Time Recovery （TSPITR）

    D

     Incomplete Recovery with system change number （SCN）


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

  • 第12题：

    单选题
    Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS  which statement is true？（）
    A

     You cannot perform the TSPITR with the constraints enabled.

    B

     You must perform the TSPITR recovery of both tablespaces for it to be successful.

    C

     You can perform TSPITR only on the USERS tablespace.

    D

     RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it  automatically.

    E

     The TSPITR will only be successful if the constraint is enabled.


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

  • 第13题：

    Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）

    • A、 The target database must be in NOARCHIVELOG mode.
    • B、 No backup is required of the database before you perform a TSPITR.
    • C、 You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.
    • D、 If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.
    • E、 If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.

    正确答案:A,B

  • 第14题：

    You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）

    • A、 DBA_SCHEDULER_JOB_RUN_DETAILS
    • B、 DBA_SCHEDULER_RUNNING_JOBS
    • C、 DBA_SCHEDULER_JOBS
    • D、 DBA_SCHEDULER_JOB_LOG

    正确答案:C

  • 第15题：

    Your network consists of a single Active Directory domain. All servers run Windows Server 2003 Service Pack 2 (SP2). All client computers run Windows XP Professional Service Pack 3 (SP3). You have a user account named User1. You need to identify which permissions User1 has on a file. What should you do? （）

    • A、At a command prompt, run Net file.
    • B、At a command prompt, run Attrib.exe.
    • C、From the file properties, view the Summary settings.
    • D、From the file properties, view the Advanced Security settings.

    正确答案:D

  • 第16题：

    多选题
    During recovery， you need to know if log sequence 11 is in the online redo logs， and if so， you need to know the names of the online redo logs so you can apply them during recovery.  Which view or views would you use to determine this information？（）
    A

    V$LOGFILE

    B

    V$RECOVER_LOG

    C

    V$RECOVER_DATABASE

    D

    V$LOG_RECOVER

    E

    V$LOG


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

  • 第17题：

    单选题
    Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）
    A

    Perform Export before TSPITR and Import after TSPITR

    B

    Move objects to another schema that has the same tablespace assigned

    C

    Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)

    D

    Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)


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

  • 第18题：

    单选题
    Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?（）
    A

    New channels for restore and recovery tasks

    B

    New name for the data files of the tablespace

    C

    Auxiliary name for the data files of the tablespace

    D

    Auxiliary destinations for an auxiliary set of data files


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

  • 第19题：

    单选题
    In which scenario will you perform a user-managed incomplete recovery？（）
    A

     when a table is dropped and stored in the Recycle Bin

    B

    when a table is dropped and purged from the Recycle Bin

    C

     when you are required to recover an existing table to its previous state

    D

     when you are required to view all the versions of a row of an existing table between a specific time period


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

  • 第20题：

    单选题
    Which options must you configure while performing an automated Tablespace Point-in-Time Recovery （TSPITR） by using Recovery Manager （RMAN）？（）
    A

     New channels for restore and recovery tasks

    B

     New name for the data files of the tablespace

    C

     Auxiliary name for the data files of the tablespace

    D

     Auxiliary destinations for an auxiliary set of data files


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

  • 第21题：

    单选题
    Which view will you use to view information regarding the jobs that are currently running in a database？（）
    A

    DBA_SCHEDULER_RUNNING_JOBS

    B

    DBA_SCHEDULER_JOB_RUN_DETAILS

    C

    DBA_SCHEDULER_JOBS

    D

    DBA_SCHEDULER_JOB_LOG


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

  • 第22题：

    单选题
    In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?（）
    A

    Complete Recovery with online redo log

    B

    Complete Recovery with archived redo log

    C

    Tablespace Point-in-Time Recovery (TSPITR)

    D

    Incomplete Recovery with system change number (SCN)


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

  • 第23题：

    单选题
    Your network consists of a single Active Directory domain. All servers run Windows Server 2003 Service Pack 2 (SP2). All client computers run Windows XP Professional Service Pack 3 (SP3). You have a user account named User1. You need to identify which permissions User1 has on a file. What should you do? （）
    A

    At a command prompt, run Net file.

    B

    At a command prompt, run Attrib.exe.

    C

    From the file properties, view the Summary settings.

    D

    From the file properties, view the Advanced Security settings.


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

  • 第24题：

    单选题
    You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）
    A

     Query the V$FLASHBACK_DATABASE_LOG view.

    B

     Query the V$FLASHBACK_DATABASE_STAT view.

    C

     Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.

    D

     Query the V$RECOVERY_FILE_DEST view.


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

相关内容