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 ?
A. Service Broker options
B. ALLOW_SNAPSHOT_ISOLATION
C. DB_CHAINING
D. Database mirroring
Answer:A
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 ?
A. Service Broker options B. ALLOW_SNAPSHOT_ISOLATION C. DB_CHAINING D. Database mirroring
Explanation:CREATE DATABASE is used mainly for creating new database. 3. Which of the following statement removes database including its related components ?