oracle11g数据库教程第四章答案,Oracle11g数据库基础教程课后习题答案

‘D:\ORACLE\ORADATA\ORCL\userdata005.dbf’,

‘D:\ORACLE\ORADATA\ORCL\example005.dbf’;

ALTER DATABASE OPEN;

(13)

ALTER DATABASE BACKUP CONTROLFILE TO ‘D:\ORACLE\CONTROL.BKP’;

(14)

ALTER DATABASE ADD LOGFILE GROUP 5

(‘D:\ORACLE\ORADATA\ORCL\redo05a.log’,

’D:\ORACLE\ORADATA\ORCL\redo05b.log’)SIZE 5M;

(15)

ALTER DATABASE ADD LOGFILE MEMBER ‘D:\ORACLE\ORADATA\ORCL\redo05c.log’ TO GROUP 5;

(16)

SHUTDOWN IMMEDIATE

STARTUP MOUNT

ALTER DATABASE ARCHIVELOG;

ALTER DATABASE OPEN;

ALTER SYSTEM ARCHIVE LOG START

(17)

ALTER SYSTEM SET LOG_ARCHIVE_DEST=’D:\ORACLE\BACKUP’

3．选择题

(1) B

(2) A

(3) B

(4) B

(5) A

(6) D

(7) BC

(8) A

(9) A

(10) C

(11) B

(12) C

(13) B

(14) B

(15) C

(16) BC

(17) B

(18) AC

(19) BD

(20) C