Interview Question in SQL Server Triggers
Interview Question :: Oracle help
1.An Exit statement can only be used inside a PL/SQL loop.
True
False
2.An inner loop can use a variable declared in the outer loop but the outer loop can not use variable declared in the inner loop.
True
False
3.An implicit cursor is automatically associated (generated) with every DML statement.
True
False
4. Main advantage of using an explicit cursor is that it allows you to process rows returned by SELECT statement, one row a a time.
True
False
5.Once all of the rows in the cursor have been processed (retreived), the cursor should be closed. Otherwise, it will generate syntax error.
True
False
6. A PL/SQL procedure can be created and stored in the database without execution of the code.
True
False
7. PL/SQL functions returns a scalar value and PL/SQL procedures return nothing. Both can take zero or more number of parameters as input or output.
True
False
8. A PL/SQL function can be called as part of a SQL expression or as part of a PL/SQL expression.
True
False
9. In PL/SQL function, multiple RETURN statements are allowed, usually within an IF statement. Only one RETURN statement will be executed.
True
False
10. The parameters of a function must be labeled IN or the function will not complete successfully.
True
False
11. IN OUT paramenters are permissible in PL/SQL functions.
True
False
12. PL/SQL package groups logically related program units like procedures and function.
True
False
13. All procedures and functions in a package body must be declared in the package specification.
True
False
14. A trigger is a PL/SQL block that executes implicitly whenever a particular event takes place.
True
False
Loading ...