A. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.
B. Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
C. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
D. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
E. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
第1题:
A.AutomaticstatisticscollectionisstoppedfortheCUSTOMERStable.
B.StatisticsfortheCUSTOMERStablearelockedandcannotbeoverwritten.
C.ExistingstatisticsfortheCUSTOMERStablebecomeunusableforthequeryoptimizer.
D.Subsequently,statisticsgatheredontheCUSTOMERStablearestoredaspendingstatistics
第2题:
表示SQL语句类别的Command属性是()。
A.CommandText
B.CommandString
C.SqlCommand
D.CommandType
第3题:
3、command1 && comman2 || command3的含义是:()
A.当command1,command2成功时才执行command3
B.当command1,command2失败时才执行command3
C.当command1失败,command2成功时才执行command3
D.当command1成功,command2失败时才执行command3
第4题:
Command对象可以执行SQL语句
第5题:
执行SQL语句时,SQL语句应设置在Command对象的()属性中。
A.SqlCommand
B.CommandString
C.CommandText
D.CommandSql