1z1-149 試験問題を無料オンラインアクセス

Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)

• A.ENABLE
• B.ALL
• C.ERROR
• D.DISABLE
• E.SEVERE

Examine the structure of the ora1.depts table:

Now, examine these statements issued by user ora1 which execute successfully:
Create or replace view dep_vu as select * from depts;
Alter table depts add dep_email varchar2(20);
Finally, examine this block of code executed by user ora1:

Which is true?

• A.It will result in an error because table depts has been altered.
• B.It will run successfully producing a result of 4.
• C.It will run successfully producing a result of 5.
• D.DEP_VU must be manually recompiled to successfully run this code.

Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)

• A.PL/SQL code can be compiled and executed based on different versions of Oracle.
• B.PL/SQL code can be compiled and executed based on different versions of the operating system.
• C.The PL/SQL compiler can conditionally include selected parts of a program.
• D.Conditional compilation is disabled by default.
• E.It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.

Which three are valid PL/SQL variable names? (Choose three.)

• A.#printer_name
• B.leap$year
• C.1to7number
• D.printer_name#
• E.yesterday's_date
• F.Number_of_days_between_March_and_April
• G.v_fname

Examine these statements from a block of code:

Which two are true? (Choose two.)

• A.The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.
• B.The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.
• C.Only the PRICE column can be updated in the PRODUCTS table.
• D.An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.
• E.The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.