Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？ （）

相似题目

• Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？（）

  A .  log writer B .  archival C .  process monitor D .  system monitor E .  change tracking writer F .  database writer

  查看最佳答案

• In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files.  Which option would you use to migrate the database files from a non­ASM instance to an ASM instance？（）

  A . Oracle Migration Assistant B . Recovery Manager （RMAN） C . Oracle Data Pump Export and Import D . conventional Oracle Export and Import E . operating system utilities to copy the files to the ASM instance

  查看最佳答案

• Which options would you consider while configuring a flash recovery area fast recovery area in 11g Release 2 for your production database that is running in ARCHIVELOG mode？（） 

  A .  Setting the FAST_START_MTTR_TARGET to set the mean time to recover B .  Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs C .  Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area D .  Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area

  查看最佳答案

• 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 performance B . write the current database metrics to a database table and create a trigger to compare with future database statistics C . write the current database metrics to a flat file and create an operating script to compare with future database statistics D . write the current database metrics to a database table and create a procedure to compare with future database statistics E . write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistic

  查看最佳答案

• You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）

  A . Mount the database B . Open the database in NORMAL mode C . Open the database in RESTRICTED mode D . Open the database with the RESETLOGS optio

  查看最佳答案

• View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D： \oracle\product\10.2.0\oradata\oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）

  A . The tablespace has two data files. B . An error is reported and tablespace creation fails. C . Data files are created with names generated by the instance. D . The tablespace can be extended without specifying the data file. E . Data files belonging to the USERS tablespace cannot be renamed.

  查看最佳答案

• You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）

  A . Compare Period ADDM report B . AWR Compare Period report C . Active Session History (ASH) report D . Taking a new snapshot and comparing it with a preserved snapshot

  查看最佳答案

• You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? （）

  A . Restore and recover the datafile.  B . Restore and recover the tablespace.  C . Restore and recover the database.  D . Restore and recover the control file.  E . Restore and recover the parameter file.

  查看最佳答案

• Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups.  Which two backups would you be able to perform when the database is being accessed by users？（）

  A . backup of offline tablespaces B . backup of read­only tablespaces C . backup of system­critical tablespaces D . backup of online， locally managed tablespaces E . backup of read/write dictionary­managed tablespace

  查看最佳答案

• Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?（）

  A . Setting the FAST_START_MTTR_TARGET to set the mean time to recover B . Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs C . Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area D . Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area

  查看最佳答案

• You want to perform in incomplete recovery of your database.  You plan to use these commands to recover your database：  SET UNTIL TIME = ’2000-12-09：11：44：00’；  RESTORE DATABASE； RECOVER DATABASE；  How should the commands be executed？ （）

  A . Only the SET command must be within a RUN block. B . All commands should be executed at the RMAN prompt. C . All three commands must be within a single RUN block. D . Only the RESTORE and RECOVER commands must be within a single RUN block.

  查看最佳答案

• In your production database， you have multiple resource plan directives that refer to the consumer group DB_GRP. Which two statements are correct？（）

  A . The parallel degree limit for DB_GRP will be the minimum of all the incoming values. B . The parallel degree limit for DB_GRP will be the maximum of all the incoming values. C . The maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values. D . If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full. E . If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.

  查看最佳答案

• Which two requirements are critically important to implement for your database backup strategy if you require a 24 hours a day， 7 days a week production environment？（）

  A . ARCHIVELOG mode. B . NOARCHIVELOG mode. C . Open database backups. D . Consistent whole backups.

  查看最佳答案

• The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema.  Which two statements are true regarding the outcome of this action？（）

  A .  All the related indexes and views are automatically dropped B .  The flashback drop feature can recover only the table structure C .  Only the related indexes are dropped whereas views are invalidated D .  The flashback drop feature can recover both the table structure and its data

  查看最佳答案

• The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? （）(Choose two)

  A . All the related indexes and views are automatically dropped B . The flashback drop feature can recover only the table structure C . Only the related indexes are dropped whereas views are invalidated D . The flashback drop feature can recover both the table structure and its data

  查看最佳答案

• Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）

  A .  Backup of offline tablespaces. B .  Backup of read-only tablespaces. C .  Backup of system-critical tablespaces. D .  Backup of online， locally managed tablespaces. E .  Backup of read/write dictionary-managed tablespaces.

  查看最佳答案

• In your production database， you have multiple resource plan directives that refer to the customer group DB_GRP. Which two statements are correct？ （）

  A .  The parallel degree limit for DB_GRP will be the minimum of all the incoming values. B .  The parallel degree limit for DB_GRP will be the maximum of all the incoming values. C .  The maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values. D .  If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full. E .  Is a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.

  查看最佳答案

• You have lost datafile 4 from your database. Which is typically the fastest way to restore your database？（）  

  A .  Restore and recover the datafile. B .  Restore and recover the tablespace. C .  Restore and recover the database. D .  Restore and recover the control file. E .  Restore and recover the parameter file.

  查看最佳答案

• The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?（）

  A . All the related indexes and views are automatically dropped B . The flashback drop feature can recover only the table structure C . Only the related indexes are dropped whereas views are invalidated D . The flashback drop feature can recover both the table structure and its data

  查看最佳答案

• I saw your ad for a production ___ yesterday.

  查看最佳答案

• Everyone who visits your display knows the detail of your product or service.

  查看最佳答案

• I bought a box of milk for $ 5 in your supermarket this morning. I’m afraid I must complain about the product because I found the milk had gone bad when I opened the box. So, I would like to ask for a

  A．A complaint letter． B．A funny story． C．A notice D．A thank-you letter．

  查看最佳答案

• It’s better to use some catchy words to name your business or your products.

  A:正确; B:错误

  查看最佳答案

• “I have a strong work ethic. I am a fast learner and I am very enthusiastic about this company and the job. I believe that my motivation and commitment will ensure that I quickly become a productive and valued member of your team.”This part can be used to demonstrate that the job candidate’s _______ for the position.

  A．industry experience B．technical skills C．persoality traits D．core job behaviors

  查看最佳答案