In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）

相似题目

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

  查看最佳答案

• In which of the following scenarios is a tablespace recovery required？（）

  A .  when recovering a lost read-only tablespace from a read-only tablespace backup B .  when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  ARCHIVELOG mode C .  when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  NOARCHIVELOG mode and the changes in the online redo log files have been overwritten D .  when recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file， the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement， and this statement was issued when the tablespace was read-only

  查看最佳答案

• In which scenarios would you rebuild an index？（）

  A .  when you need to disable the index usage B .  when you need to change storage options C .  when you need to enable index monitoring D .  when you need to move the index to another tablespace

  查看最佳答案

• In which scenario do you use the Flashback Database feature？（）

  A .  when a table is dropped and you restore it from the Recycle Bin B .  when a user’s schema is dropped and you recover the user’s schema C .  when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp D .  when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duratio

  查看最佳答案

• You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）

  A . The EMPLOYEES table will be changed to read-only mode during the shrink operation. B . The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over. C . The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation. D . Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.

  查看最佳答案

• Which is a valid Cisco CRS 4.0 deployment scenario? （）

  A . redundant Cisco CRS Engines and a simplex database server   B . redundant Cisco CRS Engines with five simplex VoIP monitoring servers   C . redundant Cisco CRS Engines and databases running on two different nodes outside of the Cisco CRS cluster   D . redundant Cisco CRS Engines and databases with two VoIP monitoring servers and three recording server

  查看最佳答案

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

  查看最佳答案

• In which scenario would index be most useful? （）

  A . The indexed column is declared as NOT NULL. B . The indexed columns are used in the FROM clause. C . The indexed columns are part of an expression. D . The indexed column contains a wide range of values.

  查看最佳答案

• In which scenario would TOP N analysis be the best solution? （）

  A . You want to identify the most senior employee in the company. B . You want to find the manager supervising the largest number of employees. C . You want to identify the person who makes the highest salary for all employees. D . You want to rank the top three sales representatives who have sold the maximum number of products.

  查看最佳答案

• You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario？（）

  A .  You must ensure that the SALES database is mounted or open. B .  You must restore a backup control file to perform a block media recovery. C .  You must take the tools01.dbf data file offline before you start a block media recovery. D .  You must put the database in NOARCHIVELOG mode to perform a block media recovery. E .  You can perform only a complete media recovery of individual blocks， point-in-time recovery of individual data blocks is not supported.

  查看最佳答案

• You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact.  In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）

  A . loss of a tempfile B . loss of a system data file C . loss of one of the control files D . loss of one of the tablespaces E . loss of a member from each redo log group F . loss of the only member of an unarchived redo log grou

  查看最佳答案

• You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）

  A .  loss of one of the tablespaces B .  loss of a system data file C .  loss of one of the control files D .  loss of a tempfile E .  loss of the only member of an unarchived redo log group F .  loss of a member from each redo log grou

  查看最佳答案

• In which scenario will you perform an incomplete recovery？（）

  A .  when a table is dropped and stored in the Recycle Bin B .  when all the control files are deleted C .  when a member of a multiplexed redo log group is dropped D .  when you are required to recover a table to its previous state

  查看最佳答案

• A web application allows the HTML title banner to be set using a servlet context initialization parametercalled titleStr. Which two properly set the title in this scenario？（）

  A . <title>${titleStr}</title> B . <title>${initParam.titleStr}</title> C . <title>${params[0].titleStr}</title> D . <title>${paramValues.titleStr}</title> E . <title>${initParam[’titleStr’]}</title&gt

  查看最佳答案

• In which scenario will you perform a cancel-based recovery？（）

  A .  when a tablespace is dropped and you have only RMAN-based backup of the database B .  when a table is dropped and stored in the Recycle Bin C .  when you are required to recover an existing table to its previous state D .  when a tablespace is dropped and you have only a user-managed full backup of the database

  查看最佳答案

• Which scenario describes an appropriate use for opening a form in a new session?（）

  A . The data entered into the called form is logically independent of the data entered in the calling form.  B . The called form requires different privileges than the calling form.  C . The called form must execute as a different user than the calling form.  D . The calling form must be able to query data in the called form before it is saved.

  查看最佳答案

• Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?（）

  A . Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO. B . Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO). C . Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table. D . Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.

  查看最佳答案

• You are working on a 24x7 （available 24 hours per day， 7 days per week） production database. An operating system （OS） user deletes the alert log file accidentally. Which statement in this scenario is true？（）

  A . The database crashes. B . The DBA needs to re-create the file. C . The file gets re-created automatically. D . The file gets restored automatically from the last backup. E . The DBA needs to perform a complete database recovery. F . The DBA needs to perform an incomplete database recovery.

  查看最佳答案

• Which of the following is a valid CRS deployment scenario?（）

  A . CRS 4.0 running with Cisco Unified CallManager 4.0   B . CRS 4.1 running with Cisco Unified CallManager 4.1   C . CRS 4.0 running with Cisco Unified CallManager 4.1   D . CRS 3.5 running with Cisco Unified CallManager 3.3

  查看最佳答案

• You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN.   Which two statements are correct in this scenario？（）

  A . You must ensure that the SALES database is mounted or open. B . You must restore a backup control file to perform a block media recovery. C . You must take the tools01.dbf data file offline before you start a block media recovery. D . You must put the database in NOARCHIVELOG mode to perform a block media recovery. E . You can perform only a complete media recovery of individual blocks； point-in-time recovery of  individual data blocks is not supported.

  查看最佳答案

• You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）

  A . The data in the segment will be compacted but the high water mark will not be adjusted  B . The EMPLOYEES table will be changed to read-only mode during the shrink operation  C . The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over D . The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation  E . Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operatio

  查看最佳答案

• The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario?（）

  A . The optimizer adds the new plan to the plan history. B . The optimizer selects the new plan for the execution of the SQL statement. C . The optimizer adds the new plan to the SQL plan baseline as an accepted plan. D . The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state. E . The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.

  查看最佳答案

• In which of the scenarios will the DBA perform recovery（）

  A . The alert log file is corrupted. B . A tablespace is accidentally dropped. C . One of the redo log members is corrupted. D . A database user terminates the session abnormally. E . The hard disk on which the data file is stored is corrupted.

  查看最佳答案