What options did ALTER DATABASE statement add ?
A. DATABASE SNAPSHOT syntax
B. ATTACH_REBUILD_LOG clause
C. DB_CHAINING option
D. READ_COMMITTED_SNAPSHOT
Answer:A
What options did ALTER DATABASE statement add ?
A. DATABASE SNAPSHOT syntax B. ATTACH_REBUILD_LOG clause C. DB_CHAINING option D. READ_COMMITTED_SNAPSHOT
Explanation:ALTER DATABASE is used for instant file initialization when adding or growing data files. 2. Which of the following item is provided by CREATE DATABASE statement ?