单项选择题
A. It updates the existing SQL profiles with current statistics.
B. It makes the statistics information available to GATHER_STATS_JOB
C. It initiates the statistics collection process by running GATHER_STATS_JOB
D. It logs a warning message in the alert log so that the DBA can perform statistics collection manually.
单项选择题 You need to restore your database back to 9/30/2008 at 18:00. In what order would you run the following commands to compete this task?() a. restore controlfile until time `09/30/2008:18:00:00’ b. restore database until time `09/30/2008:18:00:00’ c. restore spfile until time `09/30/2008:18:00:00’ d. recover database until time `09/30/2008:18:00:00’ e. alter database open resetlogs f. alter database open
多项选择题 Which two statements about the SQL Management Base (SMB) are true? ()(Choose two.)
多项选择题 When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? ()(Choose two.)