You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

A .  To list all backups that were no longer available for restore operations B .  To list all backups that had aged beyond the RMAN retention criteria C .  To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the backup media D .  To list all datafiles that are no longer part of the database and thus do not need to be backed up E .  To list all archived redo logs that are no longer needed for any database recovery

A . Because row IDs may change during the flashback operation B . Because the object number changes after the flashback operation C . Because the rows are retrieved from the recycle bin during the flashback operation D . Because the table is moved forward and back to a temporary during the flashback opertio

A . Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed. B . FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed. C . FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column. D . FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

A . The command succeeds only if Automatic Memory Management is not enabled. B . The command succeeds， but you need to restart the database for changes to take effect. C . The command returns an error because the size of the redo log buffer cannot be changed dynamically. D . The parameter value is changed and it comes into effect as soon as space becomes available in theSystem Global Area （SGA）

A .  Enable Remote Desktop Protocol （RDP） and deploy the application without the startup script.  Connect to the web role instance by using RDP， and then manually test the startup script. B .  Deploy the application in the Windows Azure Compute Emulator. C .  Deploy the application with a custom error page. D .  Deploy the application and then use IntelliTrace.

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

A .  Enable Remote Desktop Protocol （RDP） and deploy the application without the startup script.  Connect to the web role instance by using RDP， and then manually test the startup script. B .  Deploy the application in the Windows Azure Compute Emulator. C .  Deploy theapplication with a custom error page. D .  Deploy the application and then use IntelliTrace.

A . Ipconfig.exe B . Nbtstat.exe C . Netstat.exe D . Netsh.exe

A .  The code will run a backup validation to populate the V$BACKUP_CORRUPTION view and repair corrupt blocks， if any， recorded in the view. B .  The code will run a backup validate to populate the V$COPY_CORRUPTION view and then repair any corrupt blocks recorded in the view. C .  The code will runs a backup validate to populate the V$DATABASE_BLOCK_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view. D .  The code will run a backup validate to populate the RC_BACKUP_CORRUPTION view and then repair corrupt blocks， if any， recorded in the view.

A .  Configure threadOne to run at a lower priority. B .  Configure threadTwo to run at a higher priority. C .  Use a WaitCallback delegate to synchronize the threads. D .  Call the Sleep method of threadOne.  E .  Call the SpinLock method of threadOne.

A . PMON coordinates media recovery. B . SMON coordinates instance recovery. C . PMON coordinates instance recovery. D . Undo Advisor would roll back all uncommitted transactions. E . SQL*PLUS reports an error with the message asking you to perform instance recovery.

A . back up the control file to trace B . bring database to the MOUNT state C . open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database D . set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

A . the time when the last flashback operation in your database was performed B . the time when the first flashback operation in your database was performed C . a list of flashback operations performed in your database using SCN and time D . the approximate time and the lowest system change number （SCN） to which you can flash back your database

A . The IP addresses of workstations allowed gain access to the router via an access list B . Permanent name-to-address mappings created using the ip host command. C . Temporary and permanent DNS entries. D . The names of the routers created using the hostname command. E . The length of time of users logged into the router, as well as the duratio

A .  The DBWn process writes to the datafile. B .  Changes in the background process are recorded. C .  The log file is updated with the current SCN number. D .  The System Change Number （SCN） is recorded in the control file. E .  The changes to the listener configuration in the listener.ora file are recorded.

A .  It produces less accurate results of the comparison analysis. B .  It automatically calls the SQL Tuning Advisor for recommendations. C .  It shortens the time of execution and reduces the impact on system resources. D .  Only the changes in the execution plan，and not performance regression，are detected.

A .  back up the control file to trace B .  bring database to the MOUNT state C .  open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database D .  set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

A . PMON coordinates media recovery. B . SMON coordinates instance recovery. C . PMON coordinates instance recovery. D . Undo Advisor would roll back all uncommitted transactions. E . SQL*PLUS reports an error with the message asking you to perform instance recovery.&e

A . Configure threadOne to run at a lower priority. B . Configure threadTwo to run at a higher priority. C . Use a WaitCallback delegate to synchronize the threads. D . Call the Sleep method of threadOne. E . Call the SpinLock method of threadOne.

A . The command succeeds only if Automatic Memory Management is not enabled. B . The command succeeds， but you need to restart the database for changes to take effect. C . The command returns an error because the size of the redo log buffer cannot be changed dynamically. D . The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area （SGA）.

A .  Because row IDs may change during the flashback operation B .  Because the object number changes after the flashback operation C .  Because the rows are retrieved from the recycle bin during the flashback operation D .  Because the table is moved forward and back to a temporary during the flashback opertio

<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/31f166c0cedddf6946f2b336e2153075.jpg' /> A. The command performs the recovery and closes the failures. B. The command only displays the advice and the RMAN script required for repair. C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command. D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135247/2c9611256b04bdd5ba39c52e4e7dd450.png' /> A. The pending area is automatically submitted after the plan creation B. The procedure must be executed before creating the resources plan directive C. The SYS_GROUP resource consumer group is not included in the resource plan directive D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

A. Because row IDs may change during the flashback operation B. Because the object number changes after the flashback operation C. Because the rows are retrieved from the recycle bin during the flashback operation D. Because the table is moved forward and back to a temporary during the flashback operation