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

相似题目

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

  查看最佳答案

• Which two client requests are captured during database replay Capture？（）

  A .  Flashback queries B .  Shared server requests C .  Login and logoff activities of sessions D .  Direct path load of data from external files by using utilities such as SQL *loader E .  Data definition language （DDL） and data manipulation language （DML） operatio

  查看最佳答案

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

  查看最佳答案

• Flashback Database relies on which technologies to recover to a point in time？（）  

  A .  Flashback Data Archive B .  Flashback logs in the flash recovery area C .  FlashbUndo tablespace D .  RMAN command line E .  None of the above

  查看最佳答案

• Which two client requests are captured during database replay Capture?（） (Choose two)

  A . Flashback queries B . Shared server requests C . Login and logoff activities of sessions D . Direct path load of data from external files by using utilities such as SQL *loader E . Data definition language (DDL) and data manipulation language (DML) operatio

  查看最佳答案

• When performing recover of a database in NOARCHIVELOG mode with RMAN， the target database must be in the （） state to restore the control file.

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

  查看最佳答案

• Which two client requests are captured during database replay Capture?（）

  A . Flashback queries B . Shared server requests C . Login and logoff activities of sessions D . Direct path load of data from external files by using utilities such as SQL *loader E . Data definition language (DDL) and data manipulation language (DML) operatio

  查看最佳答案

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

  查看最佳答案

• In which situation would you use static database registration for a listener（）

  A . when multiple databases are to be registered with the listener B . when DBAs need to connect remotely to start up the database instance C . when users need to connect the database instance using the host naming method D . when the database instance that is to be registered with the listener is configured in shared server mode

  查看最佳答案

• Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel­based 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.

  查看最佳答案

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

  查看最佳答案

• Which of the following cmdlets will you use to check all aspects of the replication and replay status to provide a cor Mailbox server in a database availability group （DAG）？（）

  A . Get-DatabaseAvailabilityGroup B . Test-MRSHealth C . Test-ReplicationHealth D . Get-DetailsTemplate

  查看最佳答案

• Which files are required for a full recovery of the database in ARCHIVELOG mode？（）

  A .  Database datafiles B .  Online redo logs C .  Archived redo logs D .  Backup control file E .  Control file from a backu

  查看最佳答案

• Which three statements are true about using flashback database in a multitenant container database(CDB)?（）

  A . The root container can be flashed back without flashing back the pluggable databases (PDBs). B . To enable flashback database, the CDB must be mounted. C . Individual PDBs can be flashed back without flashing back the entire cdb. D . The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb. E . A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

  查看最佳答案

• Which two changes and their effect on the system can be tested by using the Database Replay feature？（）

  A .  multiplexing of the control file B .  adding the redo log member to the database C .  database and operating system upgrades D .  changing the database storage to ASM-managed storage

  查看最佳答案

• Which files must be synchronized in order for a database to start？（）

  A . temp files B . online data files C . offline data files D . read only data file

  查看最佳答案

• You work as a database administrator for Certkiller .com. 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 backu

  查看最佳答案

• In your database， the Log Writer （LGWR） process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）

  A . The database instance aborts. B . The database operation temporarily halts till the member becomes available. C . Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members. D . The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file. E . The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.

  查看最佳答案

• Which of the following represents the correct sequence of events for Database Replay？（）

  A .  Capture，analyze，preprocess，replay B .  Capture，preprocess，analyze，replay C .  Capture，preprocess，replay，analyze D .  Analyze，capture，preprocess，replay E .  None of the above

  查看最佳答案

• 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

  查看最佳答案

• We will often find more in-depth coverage in a general database.

  查看最佳答案

• A database provides ____________ of scholarly publications in a number of areas.

  查看最佳答案

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

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

  查看最佳答案

• Which type of attack uses a database or databases to guess a password in order to gain

  A．Hijacking attack B．Virus attack C．Dictionary attack D．Man-in-the-middle attack

  查看最佳答案