[Discussion}Questions for 1z0-007

shyu1

9. Which of the following SQL statements can calculate and return the absolute value of -33?

      A. SELECT ABS(-33) "Absolute" FROM DUAL;
      B. SELECT ABS(-33), Absolute FROM DUAL;
      C. SELECT ABS("-33" Absolute FROM DUAL;

ANS: A

shyu1

10. What does the following SQL script do?

      SELECT AVG(MAX(salary)) FROM employees GROUP BY department_id;

      A. it has a syntax error, the AVG clause is not valid
      B. it calculates the average of the maximum salaries of all the departments
      C. it has a syntax error, the MAX clause is not valid
      D. it has no error, but the GROUP BY clause is not effective
      E. it has no error, but the AVG clause is not effective
      F. it has no error, but the MAX clause is not effective

ANS:B

engineer

should Ma% be quoted as 'Ma%'?

shyu1

11. Which three SELECT statements display 2000 in the format "$2,000.00"? (Choose three.)
      A. SELECT TO_CHAR(2000, '$#,###.##')
      FROM dual;

      B. SELECT TO_CHAR(2000, '$0,000.00')
      FROM dual;

      C. SELECT TO_CHAR(2000, '$9,999.00')
      FROM dual;

      D. SELECT TO_CHAR(2000, '$9,999.99')
      FROM dual;

      E. SELECT TO_CHAR(2000, '$2,000.00')
      FROM dual;

      F. SELECT TO_CHAR(2000, '$N,NNN.NN')
      FROM dual;

ANS: BCD

shyu1

12. What condition can you use for testing that involves pattern matching?
      A. LIKE

ANS: A

shyu1

13. What condition can you use to test for the existence of rows in a subquery:
      A. EXISTS

ANS: A

shyu1

14. 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_name
      FROM employees
      WHERE last_name LIKE '%A\_B%' ESCAPE '\';

      D. SELECT last_name
      FROM employees
      WHERE last_name LIKE '%A\_B%' ESCAPE '\\';

ANS: C

shyu1

15. the DBA create a public sysnonym named HR,and u have created a table named HR.so,what's the result when u execute the sql statement followed:

select * from hr;

ANS: your table.

shyu1

16 which three is datatime types that can be used in column definitions when create table?
A. timestamp
B. interval month to day
C. interval day to second
D. interval year to month
E timestamp with database

Ans: A,C,D

xmzw

还有吗？