[Discussion}Questions for 1z0-007

shyu1

17. Which two statements about creating constraints are true? (Choose two.)
      A. Constraint names must start with SYS_C.
      B. All constraints must be defined at the column level.
      C. Constraints can be created after the table is created.
      D. Constraints can be created at the same time the table is created.
      E. Information about constraints is found in the VIEW_CONSTRAINTS dictionary view

ANS: CD

shyu1

18. 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

shyu1

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

shyu1

20.You have the following SQL statements:

SELECT * FROM employees

You want to retrieve those who have salaries between $1000 and $1500. What clause can you use?

A. OR … BETWEEN
B. AND … BETWEEN
C. BETWEEN … AND
D. IN … BETWEEN
E. BETWEEN … OR


Ans:C

21. When should you create a role? (Choose two.)
      A. to simplify the process of creating new users using the CREATE USER xxx IDENTIFIED by yyy statement
      B. to grant a group of related privileges to a user
      C. when the number of people using the database is very high
      D. to simplify the process of granting and revoking privileges
      E. to simplify profile maintenance for a user who is constantly traveling

ANS: BD

shyu1

22.Which of the following matches are correct?

A. UNION - returns all rows selected by either query.

B. UNION ALL - returns all rows selected by either query, including all duplicates.

C. INTERSECT - returns all distinct rows selected by both queries.

D. MINUS - returns all distinct rows selected by the first query but not the second.

Ans:A,B,C,D

xmzw

你真是好人！
这些是真的考题吗？
你怎么记得了怎么多？

shyu1

I'm not sure they are  真的考题, they are all come from 考试回忆 of WWW.

*************************
* Only for reference. *
*************************

I will take a exam after two weeks.

shyu1

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

xmzw

我这周六早上考
能告诉我这些考试回忆 of WWW的url吗？

hey3

at leas the question on datetime type appeared in real exam, for someone has mentioned it in his tips.

could you please tell me the web site you found these questions?

thanks