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

You execute a co

题目

You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M；  Which statement is true about this command（）

  • A、The command must be issued in MOUNT state.
  • B、The command succeeds only if the data file is offline.
  • C、The command must be issued when the database is in the archivelog mode.
  • D、The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You share your portable computer with a co-worker. You use separate user accounts to log on. A wireless netework is available to you and your co-worker. You need to prevent your co-worker from modifying your wireless network profile.What should you do?（）

A.A

B.B

C.C

D.D


参考答案：D

第2题：

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

第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 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

第5题：

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

第6题：

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

第7题：

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

第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 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

第10题：

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

更多相关问题
相关内容