PL/SQL Assessment

This PL/SQL test is designed to assess the knowledge of test takers concerning the use of PL/SQL. The topics covered include basic syntax, procedures and functions, packages, advanced features, and triggers. It is appropriate to administer this assessment to test takers who have used PL/SQL for a year or more.  Total Questions 40 Question Types Multiple Choice Competencies Tested Basic SyntaxProcedures and FunctionsPackagesAdvanced FeaturesTriggers Tasks Tested Autonomous TransactionsFunctionsBlock StructureDynamic SQL ExecutionFOR LoopRetrieve Rows from a CursorVariable NamesFOR Loop SyntaxBoolean ConditionsTrapping ExceptionsDBMS_SQL PackageBlock SyntaxROWTYPE AttributeOverloading FeatureAnonymous BlocksParameter Mode Default ValueInvoke a FunctionSQL Statement Function CallFormal ParameterIntact Function PrivilegesCreate FunctionsObject Must Return ValuesData Dictionary ViewsCreate Stored ProceduresParameter ModeCreate PackagesPL/SQL P