20160103 ocp 180-end 1-20

1.the recyclebin parameter is set to on for your database .you drop a table,products,from the scott schema

which two statements are true regarding the outcome of this action?/

a.all the related indexes and views are automatically dropped

保留视图和同义词，但不再有效

b.the falshback drop feature can recover only the table structure

可以恢复数据和结构

c.only the related indexes are dropped whereas views are invaildate 

与该表关联的索引会被删除

d.the falshback drop feature can recover both the table structure and its data

使用drop table语句可以将表移至回收站或从数据库中全部删除该表及所有数据

如果不指定purge字句，drop table 语句就不会将使用的空间重新什邡到表空间中共其他对象使用，而且

该空间会继续视为用户的空间限额。删除表会使从属对象失效并删除表的对象权限。删除表后，在数据库中会失去表的所有数据以及与表关联的所有索引

DROP TABLE table [PURGE] 

在该语法中，table是表的名称。

准则

• 删除表中的所有数据。

• 保留视图和同义词，但不再有效。

• 提交所有待定的事务处理。

• 只有表的创建者或具有DROP ANY TABLE权限的用户才能删除表。

注：使用FLASHBACK TABLE语句可从回收站中还原已删除的表。

182.examine the following command:

sql>alter table booking shrink space compact;

which activity is perfored when the preceding command is executed

c.the progress of the shrink operation is saved in the bitmap blocks of the booking table

如果有长时间运行的查询，而且这些查询可能跨越收缩操作，并尝试从已回收的块中读取数据，则compact字句会很有用。指定shrink space compact

字句时，收缩操作的进度将保存在相应段的位图块中。这意味着下次在同一个段上执行收缩操作时，oracle

db server可以记住已经执行过的操作

184.multiple rman sessions are conencted to the database

c.specify the command id in the rman script

当有多个rman会话正在运行时，最好使用set command id命令在备份期间将某个进程与某个通道相关联

1.在每个会话中，将命令ID 设置为不同的值，然后备份所需的对象。例如，在会话1 中输入下列内容：

RUN

{

SET COMMAND ID TO 'sess1';

BACKUP DATABASE;

}

在会话2中运行的作业中将命令ID 设置为一个字符串，如sess2：

RUN

{

SET COMMAND ID TO 'sess2';

BACKUP DATABASE;

}

185.the database is configured in archivelog mode and regular complete database backups are taken.the loss of 

witch two types of files may requir a recovery with the resetlogs

a.controlfiels 这个自不用说

d.archived log files requrid to perform recovery

用来恢复的归档日志丢了，即不能做完全恢复，只能不完全恢复，只能resetlogs来打开数据库

191.you want to perform an rman backup of database as a copy.which two factors will you consider while performing the backyup operation?

a.the backup as copy can only be taken to disk

d.backup will constitute all used and unused blocks in the database

examb

9.you receive this eroor refularly and have to shutdowqn the database instance to overcome the error

automatic shared memory management is configured for the instane.what can you do to reduce the chance of 

'this error in the future

b.enable automatic memory management