[Discussion}Questions for 1z0-007

hualing

23. 要选出你一个dd view，可以查看所有的字段owned by u but the access privs have been granted to other users。

A.user_tab_privs_made

B.user_tab_privs_recd

C.user_col_privs_made

D.user_col_privs_recd.

Ans: D

tbessi

最初由 shyu1 发布
[B]2. Which SELECT statement will get the result 'elloworld' from the string 'HelloWorld'?
      A. SELECT SUBSTR( 'HelloWorld',1) FROM dual;
      B. SELECT INITCAP(TRIM ('HelloWorld', 1,1)) FROM dual;
      C. SELECT LOWER(SUBSTR('HelloWorld', 1, 1) FROM dual;
      D. SELECT LOWER(SUBSTR('HelloWorld', 2, 1) FROM dual;
      E. SELECT LOWER(TRIM ('H' FROM 'HelloWorld')) FROM dual;

ANS: E [/B]

E the only correct answer

tbessi

最初由 shyu1 发布
[B]8. 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: BE [/B]

[B]last_name LIKE 'Ma%'[/B]

BE

tbessi

最初由 shyu1 发布
[B]19. Which of the following are the valid ordering sequences of an ORDER BY clause?

      A. ASEC
      B. DESC
      C. REVERT
      D. RANDOM
      E. ASC

ANS: BE [/B]

BE