Dump > Sql 1z0-007 > Sql#4

# 1. (1Z0-007q42) Before making a tablespace read only, which of the following conditions must be met (Choose all that apply)? A. The tablespace must contain an active rollback segments. B. The tablespace must not be involved in an open backup. C. The tablespace must be online. D. The tablespace must not contain any active rollback segments. E. The tablespace must be involved in an open backup BCD # 2. (1Z0-007q41) The MANAGE TABLESPACE system privilege allows you to perform which of the following operations (Choose all that apply)? A. Begin a backup B. End a backup C. Take the tablespace offline D. Make the tablespace read write E. Take the tablespace online F. Make the tablespace read only ABCDEF # 3. (1Z0-007q158) What statement can you use to create a special object for automatically generating primary key values (fill in the blank): CREATE SEQUENCE # 4. (1Z0-007q174) For Oracle to use function-based indexes in queries, what parameter must be set to TRUE (fill in the blank): QUERY_REWRITE_ENABLED # 5. (1Z0-007q44) Which of the following are the conditions that must b met before you can use RENAME DATAFILE with the alter tablepace command (Choose all that apply)? A. the database must be open B. when only a single datafile on the same drive is to be renamed C. the database must be taken offline before renaming D. when only a single datafile is to be renamed AC # 1. (1Z0-007q151) What statement can reset the STORAGE parameters of your table to the values when it was created (fill in the blank): TRUNCATE # 2. (1Z0-007q162) To create an ascending sequence that stops at a predefined limit, apart from the MAXVALUE parameter, what parameter must also be specified (fill in the blank): NOCYCLE # 3. (1Z0-007q9) Which of the following has been achieved by the following SQL codes?

SELECT employee_id FROM employees WHERE commission_pct = .5 OR salary > 23000; A. invalid syntax B. it returns employees who have a 50% of a salary less than $23,000: C. it returns employees who have a 50% commission rate and a salary greater than $23,000: D. runtime error E. it returns employees who have a 50% of a salary greater than $23,000: F. it returns employees who have a 50% commission rate or a salary greater than $23,000: F # 4. (1Z0-007q8) Which of the following has been achieved by the following SQL codes? SELECT * FROM employees WHERE hire_date < TO_DATE ('01-JAN-1999', 'DD-MON-YYYY') AND salary > 3500; A. only those hired before 1999 and earning less than $3500 a month are returned B. runtime error C. only those hired after 1999 and earning more than $3500 a month are returned D. only those hired before 1999 and earning more than $3500 a month are returned E. compile time error D # 5. (1Z0-007q19) 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; D. SELECT ABS("-33") Absolute FROM DUAL B