违法和不良信息举报 联系客服
免费注册 登录

You execute the 

题目

You execute the following RMAN commands in the order shown below：  BACKUP VALIDATE DATABASE;  BLOCKRECOVER CORRUPTION LIST;  What will these commands do？（）

  • A、create a backup of the database and recover all corrupted blocks found in the backup
  • B、run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database
  • C、run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view
  • D、run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view
  • E、run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You want to purge job entries older than 5 days from the job log. You do not want to purge window log entries. Which command will you use to accomplish this task？（）  

  • A、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（log_history => 5， job_name => ’JOB1’）；
  • B、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， job_name => ’JOB_LOG’）；
  • C、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log => ’JOB1’）；
  • D、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log =>’JOB_LOG’）；

正确答案:D

第2题：

You plan to execute the following command to perform a Flashback Database operation in your database：   SQL> FLASHBACK DATABASE TO TIMESTAMP （SYSDATE -5/24）；   Which two statements are true about this？（）

  • A、 The database must have multiplexed redo log files
  • B、 The database must be in the MOUNT state to execute the command
  • C、 The database must be in the NOMOUNT state to execute the command
  • D、 The database must be opened in RESTRICTED mode before this operation
  • E、 The database must be opened with the RESETLOGS option after the flashback operation

正确答案:B,E

第3题：

You have an SQL query that takes one minute to execute. You use the following code segment to execute theSQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader()You need to execute a method named DoWork() that takes one second to run while the SQL query is executing.DoWork() must run as many times as possible while the SQL query is executing.Which code segment should you use?（）

A.

B.

C.

D.


参考答案：B

第4题：

You work as a database administrator for Certkiller .com. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode.  How would you do this？（）

  • A、Execute the ALTER DATABASE ARCHIVELOG statement 
  • B、Select ARCHIVELOG option in the database control and restart the database to apply the changes. 
  • C、Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement. 
  • D、Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement. 

正确答案:B,D

第5题：

You issued the following statement：   SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n；   What will be the result of issuing the above statement？（）

  • A、The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.
  • B、 The command will not execute successfully because resumable space allocation is enabled at the session level.
  • C、 The command will execute successfully and resumable space will be allocated at the session level.
  • D、 The command will execute successfully and resumable space will be allocated at the instance level.

正确答案:B

第6题：

As an administrator at Cer-tech .com， you install Web server （IIS） role on a server that runs WindowsServer 2008. You created a new site called Cer-tech .com. You need to install an application on thewebsite called web content. You copy the application to the server. What should you do to add theapplication on the website？（）

  • A、Create a virtual directory and copy the website contents in it. Copy the application in the directory andinstall it
  • B、Execute appcmd command on the command prompt on the server
  • C、Open the IIS Manager Console and select the website. Select Add Application
  • D、Execute appcmd -t on the command prompt on the server

正确答案:C

第7题：

Identify four uses of the Oracle Scheduler.（）

  • A、 enables Oracle database to schedule which processes execute on which processors in a multiple CPU environment
  • B、 enables Oracle database to do patches according to a DBA-defined schedule
  • C、 enables you to schedule the execution of jobs based on time
  • D、 enables you to execute jobs in a clustered environment
  • E、 enables you to periodically execute operating systemscript files located on the same server as the database
  • F、 enables you to create a job that makes use of saved programs and schedules
  • G、 enables you to automate the management of the jobs that are created using the DBMS_JOB package

正确答案:C,D,E,F

第8题：

is NOT a concept of White Box Testing.

A．You should execute all logical decisions on their tree and false sides.

B．You should execute all independent paths within a module at least once.

C．You should execute all loops at their boundary conditions.

D．You should execute all interfaces at their boundary conditions.


正确答案：D

第9题：

You execute the following command to start an Automatic Storage Management （ASM） instance：   SQL>STARTUP；   In which of the following modes will the ASM instance start？（）

  • A、 OPEN
  • B、 MOUNT
  • C、 NORMAL
  • D、 NOMOUNT

正确答案:B

第10题：

One of the users in the PROD database，Adams，complains that his update on the table，TRANS， is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions，and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table， he should get the highest priority.  Which method would you use to overcome this problem？（）

  • A、execute the command， ALTER SESSION KILL ..， to kill the blocking session
  • B、execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking session
  • C、execute the command， ALTER SYSTEM KILL SESSION ..， to kill the blocking session
  • D、execute the command， ALTER SESSION UNLOCK ..， to release the lock for the blocking session
  • E、execute the command， ALTER SYSTEM UNLOCK SESSION ..， to release the lock for the blocking session

正确答案:C

更多相关问题
相关内容