1z0-007 考试回忆

　　update 07/15/2002
　　IZ0-007 - Introduction to oracle 9i:SQL
　　
　　Please note that the answers may not be correct.
　　
　　
　　1.Based on the following conditions, which of the following will make a true condition?
　　
　　last_name LIKE Ma%
　　
　　A. MADNESS
　　
　　B. Man
　　
　　C. MARY
　　
　　D. mary
　　
　　E. Mandy
　　
　　Ans:B,E
　　
　　2.What will happen if you call a SQL function with an argument of a datatype other than the datatype expected by a SQL function?
　　
　　A. the argument will need to be converted explicitly
　　
　　B. the argument will be rejected
　　
　　C. the argument will be accepted as is
　　
　　D. the argument will be converted implicitly
　　
　　
　　Ans:D
　　
　　3.Which of the following correctly describe the aggregate functions?
　　
　　A. None of the choices.
　　
　　B. It returns a single result row based on single rows
　　
　　C. It can only appear in ORDER BY clauses
　　
　　D. It returns a single result row based on groups of rows
　　
　　E. It cannot appear in select lists
　　
　　Ans:D
　　
　　4.What condition can you use for testing that involves pattern matching?
　　
　　
　　Ans:LIKE
　　
　　5.Which of the following queries can you use to search for employees with the pattern A_B in their names?
　　
　　A. SELECT last_name
　　FROM employees
　　WHERE last_name LIKE %A_B% ESCAPE ;
　　
　　B. SELECT last_name
　　FROM employees
　　WHERE last_name LIKE A_B% ESCAPE %;
　　
　　C. SELECT last

[1] [2] [3] [4] [5] 下一页