单选题Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday. What would you do in this sit

题目
单选题
Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday. What would you do in this situation？（）
A

recover using Oracle Flashback Database technology

B

restore the data files from backup and perform a complete recovery

C

restore only the corrupted data file and perform tablespace recovery

D

restore the data files from backup and perform cancel-based recovery

E

restore the entire database from the most recent backup and start the instance and open the database

相似考题

1.单选题You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）A create baseline metrics for today’s performanceB write the current database metrics to a database table and create a trigger to compare with future database statisticsC write the current database metrics to a flat file and create an operating script to compare with future database statisticsD write the current database metrics to a database table and create a procedure to compare with future database statisticsE write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics

2.单选题In your database， you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. You want to avoid the overwriting of old log files. Which archived log file name format ensures this？ （）A %t_%s.dbfB arch_%t.arcC arch_%d.arcD arch_%t_%d.arcE arch_%d_%s_.dbfF arch_%t_%s_%r.arc

3.单选题Your test database is running in NOARCHIVELOG mode. What are the implications of this？ （）A You can perform open database backups.B You can perform closed database backups.C You cannot perform schema-level logical backups.D You can perform the backup of only the SYSTEM tablespace when the database is open.

4.单选题Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command： LSNRCTL> STOP  What would happen to the sessions that are presently connected to the database instance？（）A The sessions are able to perform only queries.B The sessions are not affected and continue to function normally.C The active transactions are rolled back and the sessions get terminated.D The sessions are not allowed to perform any operations till the listener is started.

参考答案和解析
正确答案： D
解析： 暂无解析
更多“Your database is in NOARCHIVELOG mode and a logswitch happen”相关问题

  • 第1题：

    单选题
    While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）
    A

    the CREATE TABLE .. command

    B

    sorting of the SYSTEM tablespace’s data

    C

    sorting of data required by recursive SQL statements

    D

    the CREATE TABLE .. ORGANIZATION EXTERNAL .. command

    E

    sorting of data if the users have not been allocated temporary tablespace explicitly

    F

    sorting of data if the users have been allocated temporary tablespace explicitly


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

  • 第2题：

    单选题
    You are using the following command to clear the log file group： ALTER DATABASE CLEAR LOFFILE GROUP 2； In which case would the command be successful？（）
    A

    Group 2 is the active group.

    B

    Group 2 is the current group.

    C

    Database is in the MOUNT state.

    D

    Group 2 has been already archived.


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

  • 第3题：

    单选题
    According to your backup strategy， you performed an incremental level 0 backup of yourdatabase. Which statement regarding this backup is true？（）
    A

    The backup is similar to image copy.

    B

    The backup contains all used data blocks.

    C

    The backup contains only unused data blocks.

    D

    The backup contains all data blocks changed since the last incremental level 1 backup.


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

  • 第4题：

    单选题
    You work as a database administrator for Supportcenter.cn. You want to configure database backups to be run automatically. Which tool or utility would you use to achieve this？（）
    A

    The DBMS_JOB package

    B

    The BACKUP_JOB package

    C

    The DBMS_BACKUP_RESTORE package

    D

    The calendar tool in the Operating System （OS）

    E

    The backup scheduler in Enterprise Manager （EM）

    F

    The DBMS_BACKUP_SCHEDULER packager inline mode


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

  • 第5题：

    单选题
    One of the users in the PROD database， Adams， complains that his update on the table， TRANS， is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions， and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table， he should get the highest priority. Which method would you use to overcome this problem？（）
    A

    execute the command， ALTER SESSION KILL ..， to kill the blocking session

    B

    execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking session

    C

    execute the command， ALTER SYSTEM KILL SESSION ..， to kill the blocking session

    D

    execute the command， ALTER SESSION UNLOCK ..， to release the lock for the blocking session

    E

    execute the command， ALTER SYSTEM UNLOCK SESSION ..， to release the lock for the blocking session


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

  • 第6题：

    多选题
    While setting up the database for your production environment， you want to create a user with following requirements.   1.The objects created by the user must be stored in a tablespace， TBS1， if the  TABLESPACE option is not defined during the object creation.   2.The user should be able to use 10MB of space in the tablespace TBS1.   3.The user must change the password immediately after logging in for the first time.   Which three options of the CREATE USER command would you use to achieve this objective？（）
    A

    profile

    B

    account lock

    C

    account unlock

    D

    password expire

    E

    quota 10MB on TBS1

    F

    password never expire

    G

    default tablespace TBS1

    H

    quota unlimited on TBS1

    I

    temporary tablespace TEMP

    J

    temporary tablespace SYSTEM


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

  • 第7题：

    单选题
    Two database users, Jack and Bill, are accessing the SupportCenter STAFF table of the SupportCenter DB database. When Jack modifies a value in the table, the new value is invisible to Bill. Which is the modified value invisible to Bill?（）
    A

    The modified data are not available on disk.

    B

    The modified data have been flushed out from memory.

    C

    The modified rows of the SupportCenter STAFF table have been locked.

    D

    Jack has not committed the changes after modifying the value.

    E

    Both users are accessing the database from two different machines.


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

  • 第8题：

    单选题
    You work as a database administrator for Supportcenter.cn. In your organization， you have four databases， SupportCenter DB01， SupportCenter DB02， SupportCenter DB03， and SupportCenter DB04， which are located in Berlin， Frankfurt，Rammstein， and Munich respectively， and which were created using Database Configuration Assistant （DBCA）. You want to perform administrative tasks on these databases that include startup and shutdown， taking regular backups， and so on， fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform this task？（）
    A

    Control file

    B

    Password file

    C

    Parameter file

    D

    Online redo log file

    E

    Listener controller file

    F

    Server parameter file


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

  • 第9题：

    多选题
    You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）
    A

    Average row size

    B

    Last analyzed date

    C

    Size of table in bytes

    D

    Size of table in database blocks

    E

    Number of free blocks in the free list

    F

    Number of extents present in the table.


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

  • 第10题：

    单选题
    According to your backup strategy， you performed an incremental level 0 backup of your database. Which statement regarding this backup is true？（）
    A

    The backup is similar to image copy.

    B

    The backup contains all used data blocks.

    C

    The backup contains only unused data blocks.

    D

    The backup contains all data blocks changed since the last incremental level 1 backup.


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

  • 第11题：

    单选题
    You are unable to move the Unified Job Scheduler occupant from the SYSAUX tablespace to the USERS tablespace. What could be the reason？（）
    A

    None of the SYSAUX occupants can be relocated.

    B

    The USERS tablespace is a bigfile tablespace （BFT）.

    C

    The united Job Scheduler occupant cannot be relocated.

    D

    The SYSAUX occupants can be relocated to the SYSTEM tablespace only.


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

  • 第12题：

    多选题
    What are the consequences of executing the SHUTDOWN ABORT command？ （）
    A

    The database files are synchronized.

    B

    Uncommitted changes are not rolled back.

    C

    The database is closed， but the instance is still started.

    D

    Database buffers and redo buffers are not written to the disk.

    E

    The database undergoes automatic media recovery during the next startup.


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

  • 第13题：

    单选题
    You work as a database administrator for Supportcenter.cn. Your database is in NOARCHIVELOG mode and you want to perform a backup. Which type of backup would be appropriate in this case？（）
    A

    Hot backup

    B

    Online backup

    C

    consistent backup

    D

    incremental backup

    E

    inconsistent backup


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

  • 第14题：

    单选题
    You work as a database administrator for Certkiller .com. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated.  What could be the reason for this problem？（）
    A

    The advisory memory has been turned off.

    B

    The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.

    C

    The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.

    D

    The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.

    E

    The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.


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

  • 第15题：

    单选题
    You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file.  How does the loss of a redo log member affect the instance of the database that is currently running？（）
    A

    The instance would normally abort.

    B

    The instance would not be affected.

    C

    The instance would be invalid， so would have to be aborted.

    D

    The instance would remain open， but the LGWR process would fail.

    E

    The instance would remain open and would automatically create the missing file


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

  • 第16题：

    单选题
    You work as a database administrator for Certkiller .com. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task？（）
    A

    Shut down the instance， copy the control file to the third location and open the database.

    B

    Abort the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.

    C

    Copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile， restart the instance and open the database.

    D

    Shut down the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.

    E

    Shut down the instance， startup in the mount state， copy the control file to the third location， modify the CONTROL_FILES parameter ininit.oraand open the database.


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

  • 第17题：

    单选题
    In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）
    A

    flash back the database

    B

    perform point-in-time recovery

    C

    perform a full database recovery

    D

    drop and re-create the tablespace

    E

    use Recovery Manager （RMAN） to recover the database


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

  • 第18题：

    多选题
    You work as a database administrator for Supportcenter.cn. You are working on Oracle Database 10g. To forward client connections to an instance， the listener must know information such as the name of the instance and where the instance’s ORACLE_HOME is located. How does the listener get this information？（）
    A

    It gets it from the parameter file.

    B

    The listener prompts for details on startup.

    C

    The listener gathers information from the control file.

    D

    The instance automatically registers with the default listener.

    E

    The listener gets this information through thelistener.orafile.


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

  • 第19题：

    多选题
    Data files of which three tablespaces can be recovered by performing an openrecovery？（）
    A

    TEMP

    B

    UNDO

    C

    INDEX

    D

    SYSAUX

    E

    SYSTEM


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

  • 第20题：

    单选题
    In your Supportcenter.cn database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）
    A

    The source PL/SQL code will be stored in native machine code.

    B

    The source PL/SQL code will be stored in interpreted byte code.

    C

    The compiled PL/SQL code will be stored in native machine code.

    D

    The compiled PL/SQL code will be stored in interpreted byte code.


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

  • 第21题：

    单选题
    Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning， media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday. What would you do in this situation？（）
    A

    recover using Oracle Flashback Database technology

    B

    restore the data files from backup and perform a complete recovery

    C

    restore only the corrupted data file and perform tablespace recovery

    D

    restore the data files from backup and perform cancel-based recovery

    E

    restore the entire database from the most recent backup and start the instance and open the database


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

  • 第22题：

    单选题
    Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true？ （）
    A

    Transactions are rolled back using redo log files.

    B

    Transactions are rolled forward using redo log files.

    C

    Transactions are rolled back using redo log files and archived log files.

    D

    Transactions are rolled forward using redo log files and rolled back using redo log files.


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

  • 第23题：

    单选题
    The database users are connecting to the PROD database from different  applications， thereby degrading the database performance. The senior database administrator suspects the large number of concurrent connections to be the reason for low performance and asks you to restrict the number concurrent connections per database user to one.  Which action would you take to achieve this objective？（）
    A

    set the SESSIONS to 1 in the parameter file

    B

    grant SINGLE SESSION privilege to all of the users

    C

    set the SESSIONS_PER_USER to 1 in the users’ profile

    D

    grant RESTRICTED SESSION privilege to all of the database users

    E

    create a role with SINGLE SESSION privilege and assign the role to the users


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

  • 第24题：

    多选题
    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,C
    解析： 暂无解析

相关内容