又是在家考试,考试的时候差点睡着。 脑袋比较糊涂,没有什么机经,发个帖子就是想让还在备考的人们放心。 之前的机经真的是囊括全部。 没有没见过的题。 可能也是因为所有题都看过,所以昏昏欲睡。 大家都提的MZX的考经,非常非常好用。 就看他的就行。 他是98%。 我分析他错的是sas官网给的那道题。 他说他选B,实际答案是A 不晓得是不是换顺序了,感觉不太像。这可能是我唯一可能的贡献。
最有用的帖子:
https://bbs.pinggu.org/thread-6203959-1-1.html
他可能错的题:
Given the following SQL procedure output:
Table Physical Obs % Deleted
EMPLOYEE_ADDRESSES 424 5.0%
EMPLOYEE_PAYROLL 424 5.0%
Which SQL query will produce a report for tables in the ORION library which have had at least 5% of
their physical rows deleted, as shown above?
A. select MEMNAME 'Table', NOBS 'Physical Obs'
, DELOBS/NOBS '% Deleted' format=percent6.1
from dictionary.tables
where LIBNAME='ORION' AND DELOBS/NOBS >= .05;
B. select Table_Name, Num_Rows 'Physical Obs'
, Deleted_Rows/Num_Rows '% Deleted' format=percent6.1
from dictionary.DBA_TABLES
where TABLESPACE_NAME='ORION'
AND Deleted_Rows/Num_Rows >= .05;
C. select MEMNAME 'Table', NLOBS 'Physical Obs'
, DELOBS/NLOBS LABEL='% Deleted' format=percent6.1
from dictionary.tables
where LIBNAME='ORION' AND DELOBS/NLOBS >= .05;
D. select MEMNAME 'Table', NOBS 'Physical Obs'
, DELOBS/NOBS LABEL='% Deleted' format=percent6.1
from dictionary.members
where LIBNAME='ORION' AND DELOBS/NOBS >= .05;
correct_answer = "A"