A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message . Which is the recommended sequence of operations you need to perform for the query successfully?（）

相似题目

• You work as a database administrator for Certkiller .com. In the middle of a transaction， a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario？（）

  A . Event Viewer gives more details on the failure. B . The alert log file gives detailed information about the failure. C . PMON rolls back the transaction and releases the locks. D . SMON rolls back the transaction and releases the locks. E . The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction. F . Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.

  查看最佳答案

• 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

  查看最佳答案

• Which is the correct description of a pinned buffer in the database buffer cache（）

  A . The buffer is currently being accessed. B . The buffer is empty and has not been used. C . The contents of the buffer have changed and must be flushed to the disk by the DBWn process.  D . The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk.

  查看最佳答案

• You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode.   Which two statements are correct in this scenario？（）

  A . The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO. B . The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas. C . Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA  memory management. D . The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA  memory management mode.

  查看最佳答案

• You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？ （）

  A .  The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO. B .  The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas. C .  Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management. D .  The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.

  查看最佳答案

• 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

  查看最佳答案

• 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 . archival B . log writer C . database writer D . system monitor E . process monitor F . change tracking writer

  查看最佳答案

• The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）

  A .  Enable flashback logging. B .  Start the database in the ARCHIVELOG mode. C .  Issue the ALTER DATABASE FLASHBACK ON； command. D .  Set the FAST_START_MTTR_TARGET initialization parameter.

  查看最佳答案

• Assuming default setting,how can you erase the VTP database of VLANs on a CISCO IOS switch running in VTP server mode?（）

  A . Enable VTP pruning B . From privileged mode ,erase the startup configuration file,then reload. C . From privileged mode ,erase the vlan date file, then reload. D . Cycle the switch power.

  查看最佳答案

• 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

  查看最佳答案

• ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure.  Which statement is true in this situation（）

  A . The online redo log files and archived redo log files are required to accomplish the recovery. B . The uncommitted transaction will be committed at the next startup of the database instance. C . The uncommitted transaction is rolled back automatically at the next opening of the database. D . The DBA has to perform the recovery on the database to recover the uncommitted transaction.

  查看最佳答案

• Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode（）

  A . The backup will consist of used data blocks only. B . The database must be shut down to accomplish the backup. C . The backup can be accomplished without shutting down the database. D . The backup will contain all database files that have never been backed up.

  查看最佳答案

• Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)

  A . Creating the control file for the duplicate database B . Restoring the target data files to the duplicate database C . Performing complete recovery using all available backups D . Generating a new, unique DBID for the duplicate database E . Copying the online redo log files from the target database to the duplicate database

  查看最佳答案

• The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）

  A . Restore the data file and perform incomplete recovery. B . Restore the data file and perform point-in-time recover. C . Drop the tablespace and lose all data in the tablespace. D . Restore the database and lose all data since the last backup.

  查看最佳答案

• Which two operations are NOT performed by the DUPLICATE command in Recovery Manager （RMAN） while duplicating a running database？（）

  A .  Creating the control file for the duplicate database B .  Restoring the target data files to the duplicate database C .  Performing complete recovery using all available backups D .  Generating a new， unique DBID for the duplicate database E .  Copying the online redo log files from the target database to the duplicate database

  查看最佳答案

• 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.

  查看最佳答案

• 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

  查看最佳答案

• You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code？（）  RMAN>RUN  {   SET UNTIL SEQUENCE  THREAD ；   RESTORE DATABASE；   RECOVER DATABASE；  }

  A .  NOMOUNT B .  MOUNT C .  OPEN D .  RESTRICTED

  查看最佳答案

• Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true？（）

  A . The destination must be global only. B . A maximum of five destinations can be assigned. C . A maximum of ten different destinations can be assigned. D . All the destinations are determined by the server automatically. E . The destination may be local or remote for a Standby Database. F . The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.

  查看最佳答案

• A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance？（）

  A . Data Pump B . Oracle Net Manager C . Oracle Enterprise Manager D . Oracle Universal Installer （OUI） E . Database Configuration Assistant （DBCA）

  查看最佳答案

• Which statement is true about a whole consistent database backup on a database running in ARCHIVELOGmode（）https://assets.asklib.com/images/image2/201808020910242598.jpg

  A . The backup will consist of used data blocks only. B . The database must be shut down to accomplish the backup. C . The backup can be accomplished without shutting down the database. D . The backup will contain all database files that have never been backed u

  查看最佳答案

• Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）

  A . User process B . Server process C . System Monitor (SMON) D . Process Monitor (PMON) E . Checkpoint process (CKPT)

  查看最佳答案

• In a Database Replay workload capture， what client request information is gathered？（）

  A .  SQL text B .  Shared server requests （Oracle MTS） C .  Bind variable values D .  Information about transactions E .  Remote DESCRIBE and COMMIT operatio

  查看最佳答案

• ______ is a query language for manipulating data in a relmional database.

  A．Assemble B． SQL C． C++ D． Fortran

  查看最佳答案