AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-007





Question ID 7923

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) DEFAULT 'SA_REP' SAL NUMBER COMM_PCT NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below: JOB_ID: Default value specified for this column definition. SAL: Maximum salary earned for the job ID SA_REP. COMM_PCT: Default value specified for this commission percentage column, if any. If no default value is specified for the column, the value should be NULL. DEPARTMENT_ID: Supplied by the user during run time through substitution variable. Which UPDATE statement meets the requirements?

Option A

UPDATE employees SET job_id = DEFAULT AND Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP') AND comm_pct = DEFAULT AND department_id = &did WHERE employee _id IN (103,115);

Option B

UPDATE employees SET job_id = DEFAULT AND Sal = MAX(sal) AND comm_pct = DEFAULT OR NULL AND department_id = &did WHERE employee_id IN (103,115) AND job _ id = 'SA_ REP';

Option C

UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP'), comm_pct = DEFAULT, department_id = &did WHERE employee_id IN (103,115);

Option D

UPDATE employees SET job_id = DEFAULT, Sal = MAX(sal), comm_pct = DEFAULT, department_id = &did WHERE employee_id IN (103,115) AND job _ id = 'SA_ REP';

Option E

UPDATE employees SET job_id = DEFAULT, Sal = (SELECT MAX(sal) FROM employees WHERE job_id = 'SA_REP') comm_pct = DEFAULT OR NULL, department_id = &did WHERE employee_id IN (103,115);

Correct Answer C
Explanation Explanation/Reference: Explanation: This UPDATE statement is correct to receive desired results. Correct syntax is UPDATE table_name SET column_name1 = value, column_name2 = value2. You can also use the DEFAULT keyword to set a column value to its specified default value in update statements as well. Incorrect Answers A: You cannot use syntax like UPDATE table_name SET column_name1 = value AND column_name2 = value2. Correct syntax is UPDATE table_name SET column_name1 = value, column_name2 = value2. B: You cannot use syntax like UPDATE table_name SET column_name1 = value AND column_name2 = value2. Correct syntax is UPDATE table_name SET column_name1 = value, column_name2 = value2. D: Group function is not allowed to use in the SET clause of the UPDATE command. E: You cannot set column to value DEFAULT OR NULL: this is wrong syntax to use. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 267-270 Chapter 6: Manipulating Oracle Data


Question ID 7924

Which two statements about sequences are true? (Choose two)

Option A

You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.

Option B

You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.

Option C

You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.

Option D

You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.

Option E

If a sequence starting from a value 100 and incremented by 1 is used by more then one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.

Option F

You use REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.

Correct Answer BC
Explanation Explanation/Reference: Explanation: You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence. You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence. Incorrect Answers A: You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence. D: You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence. E: This statement is not correct. There is no limitation like that in Oracle. F: You use CYCLE clause, not REUSE, when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 315-322 Chapter 7: Creating Other Database Objects in Oracle

Send email to admin@getfreedumps for new dumps request!!!