READ Free Dumps For Oracle- 1z0-007
| Question ID 7933 | Which two are character manipulation functions? (Choose two.)
|
| Option A | TRIM
|
| Option B | REPLACE
|
| Option C | TRUNC
|
| Option D | TO_DATE
|
| Option E | MOD
|
| Option F | CASE
|
| Correct Answer | AB |
Explanation Explanation/Reference: Explanation: TRIM() and REPLACE() are character manipulation functions. Incorrect Answers C: TRUNC(x,y) is arithmetic function, it truncates x to the decimal precision of y. If y is negative, it truncates to y number of places to the left of the decimal point. This can also be used on DATE columns. D: TO_DATE(x,[y]) function converts the non-date value x to a date using the format specified by y. E: MOD(x,y) is arithmetic function, the modulus of x, defined in long division as the integer remainder when x divided by y until no further whole number can be produced. F: There is no character manipulation function CASE in Oracle. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 67-93 Chapter 2: Limiting, Sorting, and Manipulating Return Data
| Question ID 7934 | Which three statements correctly describe the functions and use of constraints? (Choose three.)
|
| Option A | Constraints provide data independence.
|
| Option B | Constraints make complex queries easy.
|
| Option C | Constraints enforce rules at the view level.
|
| Option D | Constraints enforce rules at the table level.
|
| Option E | Constraints prevent the deletion of a table if there are dependencies.
|
| Option F | Constraints prevent the deletion of an index if there are dependencies.
|
| Correct Answer | CDE |
Explanation Explanation/Reference: Explanation: Constraints have functions to enforce rules at the view and table levels and to prevent the deletion of data if dependencies exist between tables. Incorrect Answers A: Constraints are used to put dependencies on data. B: Constrains are not used to make complex queries more easy. F: Constraints does not prevent the deletion of an index if there are dependencies. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 227-248 Chapter 5: Creating Oracle Database Objects