999kao.com
SASBase认证考试(70真题+答案详解
有以下类定义 class MyClass { private： int id； Char gender； Char*phone； public： MyClass()：id(0)，gender(‘#’)，phone(NULL){} MyClass(int no,charge＝’#’，char*ph＝NULL) {id=no;gender=ge;phone=ph;} )； 下列类对象定义语句中错误的是( )。
A．MyClass myObj；
B．MyClass myObj(11，”13301111155”)；
C．MyClassmyObj(12，’m’)；
D．MyClassmyObj(12)；
解析： 本题考查构造函数的应用。对象建立用初始化列表对数据成员进行时，列表中的参数类型要与构造函数中形参类型一致。B选项中第二个参数为”13301111155”是字符串，而构造函数中第二个形参为char型，两者不一致造成错误。
A.Set set = new TreeSet();
B.Set set = new HashSet();
C.Set set = new SortedSet();
D.List set = new SortedList();
E.Set set = new LinkedHashSet();
有以下类定义: class MyClass { private: int id; char gender; char *phone; public: MyClass():id(0),gender('#'),phone(NULL){} MyClass(int no,char ge='#',char *ph=NULL) {id=no;gender=ge;phone=ph; } };下列类对象定义语句中错误的是______。
A．MyClass myObj;
B．MyClass myObj(11,"13301111155");
C．MyClass my0bj(12,'m');
D．MyClass myObj(12);
解析：初始化应该和构造函数相同。
A. A two disk set with one data strip
B. A three disk set with two data strips and a parity strip
C. A two disk set with two data strips
D. A four disk set with two sets of data strips
A.Within the job environment set up
B.Within the user data of the at job
C.In the file name preceeded with a userid
D.In a special file used by the cron daemon
SAS Base认证考试70题SAS分多个认证种类：base，advanced，clinic等，但大多需要先通过base认证。但凡这类商业组织提供的考证，基本都是题库型，所以想考过难度并不大。对于只想拿SAS认证的人，如果熟练掌握网上流传甚广的sas真题70题，通过base认证基本就没问题。Q 11. The following SAS program is submitted:data WORK.TOTAL;set WORK.SALARY;by Department Gender;if First. then Payroll=0; Payroll+Wagerate;if Last.;run;The SAS data set WORK.SALARY is currently ordered by Gender within Department.Which inserted code will accumulate subtotals for each Gender within Department?A. GenderB. DepartmentC. Gender DepartmentD. Department Gender答案：A本题知识点：自动变量在SAS读取数据时，在PDV过程中会产生很多自动变量，在输出的数据集中是不可见的。 FIRST.VARIABLE：同一个BY变量（组），若新的变量值第一次出现时，其first.variable值为1。 LAST.VARIABLE：同一个BY变量（组），若新的变量值最后一次出现时，其last.variable值为1。另外，在BY变量右面有多个变量时，先按第一个变量排序，若第一个变量的观测存在重复时，才按第二个变量排序。Q 2Given the following raw data records in TEXTFILE.TXT: -|-10-|-20-|-30 John,FEB,13,25,14,27,Final John,MAR,26,17,29,11,23,Current Tina,FEB,15,18,12,13,Final Tina,MAR,29,14,19,27,20,CurrentThe following output is desired:Obs Name Month Status Week1 Week2 Week3 Week4 Week5 1 John FEB Final $13 $25 $14 $27 . 2 John MAR Current $26 $17 $29 $11 $23 3 Tina FEB Final $15 $18 $12 $13 . 4 Tina MAR Current $29 $14 $19 $27 $20Which SAS program correctly produces the desired output?A. data WORK.NUMBERS;length Name $ 4 Month $ 3 Status $ 7;infile TEXTFILE.TXT dsd;input Name $ Month $;if Month=FEB then input Week1 Week2 Week3 Week4 Status $;else if Month=MAR then input Week1 Week2 Week3 Week4 Week5 Status $;format Week1-Week5 dollar6.;run;proc print data=WORK.NUMBERS;run;B. data WORK.NUMBERS;length Name $ 4 Month $ 3 Status $ 7;infile TEXTFILE.TXT dlm=, missover;input Name $ Month $;if Month=FEB then input Week1 Week2 Week3 Week4 Status $;else if Month=MAR then input Week1 Week2 Week3 Week4 Week5 Status $;format Week1-Week5 dollar6.;run;proc print data=WORK.NUMBERS;run;C. data WORK.NUMBERS;length Name $ 4 Month $ 3 Status $ 7;infile TEXTFILE.TXT dlm=,;input Name $ Month $ ;if Month=FEB then input Week1 Week2 Week3 Week4 Status $;else if Month=MAR then input Week1 Week2 Week3 Week4 Week5 Status $;format Week1-Week5 dollar6.;run;proc print data=WORK.NUMBERS;run;D. data WORK.NUMBERS;length Name $ 4 Month $ 3 Status $ 7;infile TEXTFILE.TXT dsd ;input Name $ Month $;if Month=FEB then input Week1 Week2 Week3 Week4 Status $;else if Month=MAR then input Week1 Week2 Week3 Week4 Week5 Status $;format Week1-Week5 dollar6.;run;proc print data=WORK.NUMBERS;run;答案：C本题知识点：INFILE语句与指示器、INFILE filespecification options;其中，filespecification用来定义文件, options给出选择项; filespecification有以下三种形式:、fileref(文件标志)、filename(文件名)、CARDS指明输入的数据，紧跟着CARDS语句 下列选择项(options)可以出现在INFILE语句中:、COLUMN=variable或COL=variable 定义一个变量, 其值是指针所在的当前列位置。、END=variable 定义一个变量, 作为文件结束的标志。、EO、F=label是一个语句标号, 当INFILE语句读到文件末尾时, 作为隐含的GOTO语句的目标。、LENGHT=variable 定义一个变量, 其值是当前输入数据行的长度。、FIRSTOBS=linenumber 要求从指定的行开始读取数据, 而不是从文件的第一个记录开始。、OBS=n 指定从一个顺序输入文件中读取数据的最后一个行(即第1第n行)。一个观察可能占n行。、DLM= 若分隔符不是空格，则使用DLM=指定、DSD 忽略引号中数值的分隔符；自动将字符数据中的引号去掉；将两个相邻分隔符视为缺失值处理。、MISSOVER 阻止INPUT进入下一行读取，未赋值变量视为缺失值。、TRUNC、OVER 与MISSOVER相似，但在COLUMN INPUT或FORMATTED INPUT中使用。比较 与 的区别： 用于1个数据行用多个input语句读取，停留到下一个INPUT语句。 用于1个数据行含有多个观测值读取时，停留到下一个DATA步。Q 3The following SAS program is submitted:data WORK.DATE_INFO; Day=01 ; Yr=1960 ; X=mdy(Day,01,Yr) ;run;What is the value of the variable X?A. the numeric value 0B. the chara
All client computers on your company network run Windows 7. The Finance department staff run an application that collects data from 09.30 hours to 15.00 hours everyday. After data collection, the application generates reports that contain data aggregation for the day and the previous week. During report generation, the Finance department staff experience slow performance on their computers. You discover that the usage of the processor on these computers is between 90 and 100 percent. You need to reduce the impact of report generation on the Finance computers. What should you do?（）
A.Set the priority of the application to Low.
B.Set the priority of the application to Real-time.
C.Configure the processor affinity mask to ensure that the application uses all the available processors.
D.Modify the memory settings of the computers to optimize the performance of the background applications.
B.occupation
C.permission
D.compensation
Which of the following is the correct configuration for a RAID 5 array?（）
- A、A two disk set with one data strip
- B、A three disk set with two data strips and a parity strip
- C、A two disk set with two data strips
- D、A four disk set with two sets of data strips
正确答案:B
The SET CONTROLFILE AUTOBACKUP FORMAT command， which you can specify either within a RUN block or at the RMAN prompt， overrides the configured autobackup in the session only. What is the order of precedence？（） 1. SET within RUN 2. SET at RMAN prompt 3. CONFIGURE
- A、1,2,3
- B、2,3,1
- C、3,2,1
- D、There is no precedence between RUN and the RMAN prompt. Each will override CONFIGURE in the session.
正确答案:A
You want to perform in incomplete recovery of your database. You plan to use these commands to recover your database： SET UNTIL TIME = ’2000-12-09：11：44：00’； RESTORE DATABASE； RECOVER DATABASE； How should the commands be executed？ （）
- A、Only the SET command must be within a RUN block.
- B、All commands should be executed at the RMAN prompt.
- C、All three commands must be within a single RUN block.
- D、Only the RESTORE and RECOVER commands must be within a single RUN block.
正确答案:C