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

You issued the following command： ALTER DATABASE ENABLE BLOC

题目
单选题
You issued the following command： ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；  What will be the result of issuing this command？（）
A

 The block change tracking feature is enabled， and the information about the system change number is written in the change tracking file.

B

 The block change tracking feature is enabled， and the information about the log sequence number is written in the change tracking file.

C

 The block change tracking feature is enabled， and the information about the blocks that are changed since the last backup is written in the change tracking file.

D

 The block change tracking feature is enabled， and the information about the locations of the datafiles and the online redo log files are written in the change tracking file.

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）

  • A、’SQL ALTER DATABASE OPEN’；
  • B、SQL ALTER DATABASE ’OPEN’；
  • C、OPEN DATABASE；
  • D、DATABASE OPEN

正确答案:C

第2题：

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.

正确答案:D

第3题：

You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）

A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;

B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;

C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;

D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;


参考答案：C

第4题：

You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）

  • A、  STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；
  • B、  STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
  • C、  STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS；
  • D、  STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

正确答案:D

第5题：

After the recovery is complete， which command should you execute？（）

  • A、ALTER DATABASE OPEN；
  • B、ALTER DATABASE CLEAR LOGFILE；
  • C、ALTER DATABASE OPEN RESETLOGS；
  • D、ALTER DATABASE OPEN NORESETLOGS；

正确答案:C

第6题：

You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement will you use to enable the block change tracking feature？（）

  • A、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING；
  • B、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING；
  • C、 ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE ；
  • D、 ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE ；

正确答案:D

第7题：

You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）

  • A、Immediately following statement execution 
  • B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued 
  • C、After the ALTER TABLE SET UNUSED COLUMN command is issued 
  • D、After the ALTER TABLE MODIFY command is issued

正确答案:B

第8题：

Upon starting your database, you receive the following error:You can choose from the following steps:1.Restore the database datafiles.2.Issue the alter database clear unarchived logfile group 1 command.3.Issue the alter database open command.4.Issue the alter database open resetlogs command.5.Recover the database using point-in-time recovery.6.Issue the Startup Mount command to mount the database.7.Back up the database.Which is the correct order of these steps in this case?（）

A. 1,6,5,4,7

B. 6,5,4

C. 6,2,3,7

D. 1,6,3

E. The database cannot be recovered


参考答案：C

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

What command would you issue to enable automated backups of control files? （）

  • A、alter database controlfile autobacku on
  • B、alter system controlfile autobackup on 
  • C、configure controlfile autobackup on 
  • D、enable controlfile autobackup

正确答案:C

更多相关问题
相关内容