READ Free Dumps For Oracle- 1z0-001
Question ID 8122 | Structure of DEPT table is as follows: Name Null Type DEPTNO NOT NULL NUMBER(2) DNAME VARCHAR2(14) LOC VARCHAR2(13) Examine the declaration section. DECLARE TYPE dept_table_type IS TABLE OF dept%ROWTYPE INDEX BY BINARY INTEGER dept_table dept_table_type; You need to assign LOC field in record 15 the value of 'Atlanta'. Which PL/SQL statement makes this assignment?
|
Option A | dept_table.loc.15 := 'Atlanta';
|
Option B | dept_table[15].loc := 'Atlanta';
|
Option C | dept_table(15).loc := 'Atlanta';
|
Option D | dept_table_type(15).loc := 'Atlanta';
|
Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct because this syntax is correct to assign LOC field in record 15. Incorrect Answers: A: Syntax is wrong, first need to be identified object, than number of record. B: Syntax is wrong, number of record need to be inside (), not []. D: Data type SEPT_TABLE_TYPE cannot be used to assign a value for LOC. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 212-213 Chapter 5: Introducing PL/SQL
Question ID 8123 | You need to change the job title Clerk to Administrative Clerk for all Clerks. Which statement does this?
|
Option A | UPDATE emp SET job = 'Administrative Clerk';
|
Option B | UPDATE emp Job := 'Administrative Clerk' WHERE UPPER (job) = 'Clerk';
|
Option C | UPDATE emp SET job = 'Administrative Clerk' WHERE UPPER (job) = 'CLERK';
|
Option D | UPDATE emp SET values job = 'Administrative Clerk' WHERE UPPER (job) = 'Clerk';
|
Correct Answer | C |
Explanation Explanation/Reference: Explanation: Answer C is correct because function UPPER will convert all letters in JOB column to uppercase and compare it to 'CLERK', identifying all Clerks. Command UPDATE ... SET will set new value to 'Administrative Clerk' for these records. Incorrect Answers: A: Statement will change job to 'Administrative Clerk' for ALL records in the table. B: Statement will not change job to 'Administrative Clerk' for any record in the table because function UPPER will convert all letters in JOB column to uppercase and comparison of its result with string 'Clerk' will return no records to change. D: The statement contains syntax error : SET values. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 22-23 Chapter 1: Selecting Data from Oracle