Pl sql aptitude questions and answers pdf

A report c]. A bug d]. A trigger sequence. Object oriented language b]. Block-Structured c]. Non-Structured d]. Number b]. String c]. Binary d]. None of these.

What is always evaluated to false in case of implicit cursors? What allows passing values dynamically to a cursor while opening a cursor? A developer would like to use referential datatype declaration on a variable. How would the developer define this variable using referential datatypes? Declare as long. Which functions can be used with any datatype? Please select all the correct answers. SUM B.

MIN C. MAX D. Select incorrect variable declarations A. Select invalid variable types A. CHAR B. List the correct sequence of commands to process a set of records when using explicit cursors A. None of the above ANS: B None of the above ANS: D Incantination B.

Integration C. Continuation D. Concatenation E. Which of the following is not an Oracle DML function? NVL E. None of the above. All are valid. ANS: C. Select the best answer. Which listed attribute is an invalid attribute of an Explicit cursor. All of these are valid.

ANS: E Which of the following is not a grouping function. SUM C. MIN E. All of the above. ANS: C These are all valid. ANS: B What command can you use to see the errors from a recently created view or stored procedure?

ANS: D Select the best answer below. What are the components of a package? Box, wrapping and binding B. Header and body C. Specification and content D. Specification and body E. True or False? True b. False ANS: A Subprograms and anonymous blocks can be called by other applications.

A nested subprogram can be called from the main procedure or from the calling environment. Trueor False? False ANS: B When modifying procedure code, the procedure must be re-executed to validate and store it in the database. Which of the following can be used as an argument for a procedure parameter? The name of a variable. A literal value. An expression. OUT b. COPY d. R ead ANS: B R ead e.

W rite ANS: A What are the three parameter modes for procedures? Which one of the following statements about formal and actual parameters is true? Formal and actual parameters must have the same name.