Which two database operations can be performed at the MOUNT stage of database startup？（）

相似题目

• 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 two statements are true regarding transactions in an Oracle database（）

  A . Multiple transactions can use the same undo segment. B . A transaction is assigned an undo segment when it is started. C . More than one transaction cannot share the same extent in the undo tablespace. D . The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.

  查看最佳答案

• Which two statements are correct about database transportation?（） (Choose two.)

  A . The source and target platforms must be the same B . Redo logs, control files and temp files are also transported C . The transported database must have the same database identifier (DBID) as the source database and cannot be changed D . The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported E . Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

  查看最佳答案

• You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）

  A .  Flashback logs are not archived. B .  Flashback logs are maintained in redo log files. C .  Flashback logs are maintained in the Flash Recovery Area. D .  Flashback logs are used to maintain Flashback Database related errors. E .  Flashback logs need to be cleared manually after you disable Flashback Database.

  查看最佳答案

• Which two statements are correct about database transportation? （）

  A . The source and target platforms must be the same B . Redo logs, control files and temp files are also transported C . The transported database must have the same database identifier (DBID) as the source database and cannot be changed D . The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported E . Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

  查看最佳答案

• Which two statements are true about the RMAN validate database command?（）

  A . It checks the database for intrablock corruptions. B . It can detect corrupt pfiles. C . It can detect corrupt spfiles. D . It checks the database for interblock corruptions. E . It can detect corrupt block change tracking files.

  查看最佳答案

• 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

  查看最佳答案

• You performed the RMAN database backup with the KEEP option.Which two statements are true about this backup?（） (Choose two)

  A . The KEEP option overrides the configured retention policy B . The KEEP option is an attribute of an individual backup piece C . The backup contains only data files and archived redo log files D . The backup contains data files, the server parameter file and the control file even if the control file auto backup is disabled

  查看最佳答案

• 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 two are true concerning a multitenant container database with three pluggable database?（）

  A . All administration tasks must be done to a specific pluggable database. B . The pluggable databases increase patching time. C . The pluggable databases reduce administration effort. D . The pluggable databases are patched together. E . Pluggable databases are only used for database consolidation.

  查看最佳答案

• Which two statements are true about standard database auditing（）

  A . DDL statements can be audited. B . Statements that refer to stand-alone procedure can be audited. C . Operations by the users logged on as SYSDBA cannot be audited. D . Only one audit record is ever created for a session per audited statement even though it is executedmore than once.

  查看最佳答案

• 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

  查看最佳答案

• Which two statements are true about the Automatic Database Diagnostic Monitor （ADDM）（）

  A . The ADDM requires at least four AWR snapshots for analysis. B . The ADDM runs after each AWR snapshot is collected automatically by MMON. C . The results of the ADDM analysis are stored in the Automatic Workload Repository （AWR）. D . The ADDM analysis provides only diagnostic information but does not provide recommendations. E . The ADDM calls other advisors if required， but does not provide recommendations about the advisors.

  查看最佳答案

• Which two statements are true regarding Health Monitor checks in Oracle Database 11g？（）  

  A .  Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption. B .  Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible，corrupt or inconsistent. C .  Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically. D .  Health Monitor checks are always initiated manually when there is some critical error.

  查看最佳答案

• Which two steps check out a database connection from the connection pool?（）

  A . DB Get   B . DB Read   C . DB Write   D . DB Release

  查看最佳答案

• You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario（）

  A . You must shut down the database instance to perform the backups. B . You must configure the Flash Recovery Area （FRA） for the database. C . You can perform complete database backups without closing the database. D . All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

  查看最佳答案

• Which two statements are true about the roles in the Oracle database？（）

  A . A role can be granted to itself. B . Roles are owned by the SYS user. C . Roles can be granted to other roles. D . A role cannot be assigned external authentication. E . A role can contain both system and object privileges.

  查看最佳答案

• Which two statements are true regarding the database in ARCHIVELOG mode？（）

  A . You have to shut down the database to perform the backups. B . Archiving information is written to the data files and redo log files. C . You can perform complete database backups without closing the database. D . Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode. E . All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

  查看最佳答案

• Which two statements about the background process of the database writer are true（）

  A . It is possible to have multiple database writers in an Oracle instance. B . It writes dirty buffers， if any， to data files whenever a checkpoint occurs. C . It writes dirty buffers， if any， to data files whenever a transaction commits. D . It writes dirty buffers， if any， to data files before the log writer （LGWR） write

  查看最佳答案

• Which two partitioned table maintenance operations support asynchronous Global Index Maintenance inOracle database 12c?（）

  A . ALTER TABLE SPLIT PARTITION B . ALTER TABLE MERGE PARTITION C . ALTER TABLE TRUNCATE PARTITION D . ALTER TABLE ADD PARTITION E . ALTER TABLE DROP PARTITION F . ALTER TABLE MOVE PARTITION

  查看最佳答案

• Which two statements are correct about database transportation？（） 

  A .  The source and target platforms must be the same B .  Redo logs，control files and temp files are also transported C .  The transported database must have the same database identifier （DBID） as the source database and cannot be changed D .  The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported E .  Recovery Manager （RMAN） is used to convert the necessary data files of the database if the target platform is different and has different endian format

  查看最佳答案

• For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）(Choose two.)

  A . views B . fixed tables C . heap tables D . external tables E . temporary tables F . index-organized tables (IOT)

  查看最佳答案

• You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario（）

  A . You must shut down the database instance to perform the backups. B . You must configure the Flash Recovery Area （FRA） for the database. C . You can perform complete database backups without closing the database. D . All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

  查看最佳答案

• Flashback is enabled for your multitenant container database （CDB), which contains two plu

  Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:SQL ＞ SHUTDOWN IMMEDIATE SQL ＞ STARTUP MOUNT SQL ＞ FLASHBACK DATABASE to TIME TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”;Examine following commands:1. ALTER PLUGGABLE DATABASE ALL OPEN;2. ALTER DATABASE OPEN;3. ALTER DATABASE OPEN RESETLOGS;Which command or commands should you execute next to allow updates to the flashback back schema？（） A. Only 1 B. Only 2 C. Only 3 D. 3 and 1 E. 1 and 2

  查看最佳答案