SM - PL SQL test

PL/SQL stands for what ?

• Procedural Language
• Programming Language
• Presequences Language
• Processing Language

Correct order of a PL/SQL structre ?

• declare … begin ... exception … end;
• begin … declare … exception … end;
• declare … begin … end … exception ;
• declare … begin … end ;
• begin … end ;

How to comment in Oracle ?

• // comment
• /* comment */
• -- comment
• # comment
• <! –– comment ––>

What will happen with this code ?

• Error because it has 2 my_var variables
• Error because its 2 my_var variables have same data type
• Run success and print 0
• Run success and print 1

What will happen with this code ?

• Error because the" if else" syntax is wrong
• Error because the "between" syntax is wrong
• Run success and print A
• Run success and print B
• Run success and print C

What will happen with this code ?

• Error because the"case when" syntax is wrong
• Error because the "when 10" appeared twice
• Run success and print A
• Run success and print B
• Run success and print C

What will happen with this code ?

• Error because the "while" syntax is wrong
• Error because missing my_var changes in the loop
• Run success and print from 0 to 9
• Run success and print 0 repeatedly

What will happen with this code ?

• Error because the "for" syntax is wrong
• Error because the "in 1..-1" : the smaller number must be in front of the greater one
• Run success and print from 0 to 1
• Run success and print nothing

After create it, how to call this procedure ?

• execute my_test_procedure ;
• execute my_test_procedure() ;
• begin my_test_procedure ; end;
• begin my_test_procedure() ; end;
• Can not call it because the create code is error

Which things make function and procedure become different ?

• functions can have a return type. procedures can not
• procedures can have OUT-mode parameter. functions can not
• procedures can have IN-mode parameters. functions can not
• procedures can belong to a package. functions can not
• functions can belong to a package. procedures can not