text1229（text1229）.docVIP

text1229（text1229） TCSD Standard Test C++ (2) examination questions (100 points, examination time 150 minutes) A radio (40 items, a total of 80 points) One Is the function that handles the shared library file error? A. Dlerror B. Dlsym C. Dlopen D. PERROR Two The DML statement is not belong to? A. Insert B. Delete C. Update D. Select Three The following data types that cannot be used in Oracle are? A. Number B. Varchar2 C. Int D. Date Four The following function belongs to the group function, is it? A. To_date B. Substr C. To_char D. Avg Five About sorting, whats wrong with the following statement? A. The sort key is order by B. Ascending order is the default sort order C. Descending key is desc D. Can not use multiple sort field Six What is the following grouping statement correct? A. Select, name, dept_id, from, s_dept, D, s_emp, e, where, dept_id=id,, group, by, dept_id; B. Select, e.name, dept_id, from, s_dept, D, s_emp, e, where, dept_id=d.id,, group, by, dept_id; C. Select, e.name, dept_id, from, s_dept, D, s_emp, e, where, dept_id=d.id,, group, by, dept_id; D. Select, max (name), dept_id, from, s_dept, D, s_emp, e, where, dept_id=d.id,, group, by, dept_id; Seven The following statement allows you to get manager_id, not NULL data: A. Select, first_name, manager_id, from, s_emp, where, manager_id, =null; B. Select, first_name, manager_id, from, s_emp, where, manager_id, no, in (null); C. Select, first_name, manager_id, from, s_emp, where, manager_id, null, not, is; D. Select, first_name, manager_id, from, s_emp, where, manager_id, null, is, not; Eight What about the constraint statement? A. Constraints are divided into table level constraints and column level constraints B. Non empty constraints have no table level constraints C. Column level constraints can perform all of the table level constraints of all functions D. Table level constraints can accomplish joint constraints, column level, and no joint constraints Nine A sequence is wrong? A. The key to creati