20151218 OCP 047 30-60

31.select to_char(list_price,$0,999") from product_information;

which two statements would be true regarding the outpput for this sql statement?

这道题考查的是格式化输出/format

'$9,999'的意思是以$开头，显示四位整数，位数超过全部为#,三位用逗号分隔，小数部分四舍五入

a.the list_price column hacing value 1123.90 would be dispayed as $1,124

d.the list_price column having value 11235.90 would be displayed as #####

32.which three statements are true regarding siglerow functions?

a.they can accept only one argument

single-row functions 指的是输入一行数据输出一个结果，并没有要求参数为1，比如substr函数

就不止一个参数

b.they can be nested up to only two levels

嵌套没有层数限制

c.they can return multiple values of more than one data type

函数只能返回一个值，这是错的

d.they can be used in select,where,and order by clause

e.they can modify the data type of the argument that is referenced

f.they can accept a column name,expression,variable name,or a usersupplied constant as arguments

34.given below is a list of functions and their purpose in random order

function purpose

1.nvl d used to convert null values to actual values

2.nullif c.used to compare two expressions,if both are same =,it returns null ;

otherwise,it only the first expression

3.coalesce b.used to return the first non -null values in a list of expressions

4.nvl2 d used to convert null values to actual values

35

DROP TABLE productsPURGE

不进入recyvlebin直接删除

41.which statement is true regarding the session_privs dictionary view?

b.it contains the current system privileges available in the usere session

48.view the exhibit and examine the description of the employees table,you want to calculate the total; remuneration for each employee.total rremuneration is the sum of the annual salary and the percentage commission earned for a year.only a few employees earn commission

which sql statement would you execute to get the desired output?

b.select dirst_name,salary,salary*12+nvl(salary*commission_pct)total from employees;