Select incorrect variable declarationsĢ1. List the correct sequence of commands to process a set of records when using explicit cursorsĪNS: C 19. foo_text varchar2(10) := 'hello world' ġ8. Which functions can be used with any datatype? Please select all the correct answers.ġ6. All exceptions that are referenced in the blockġ5. What is the maximum number of exception handlers processed before the PL/SQL block is exited, provided an exception occurs? Please select the best answer.ī. Referring to a number variable by using a logical operatorġ4. Using a hyphen to concatenate two columnsĭ.
Using a reserved word to declare an identifierĬ. For which task is it best to use a character string enclosed by double quotes? Please select the best answer.ī. what is the value of customer_id at this point?ġ3. What is the value of customer_id within the nested block in the example below? For which trigger timing can you reference the NEW and OLD qualifiers?ġ2. What is the maximum number of handlers processed before the PL/SQL block is exited when an exception occurs?ġ0. It creates the variables to hold the current row valuesĩ. It loads the current row values into variablesĭ. What happens when rows are found using a FETCH statementĬ. None, cursor for loops handle cursor opening implicitly.Ĩ. The command used to open a CURSOR FOR loop isĭ. Which line in the following statement will produce an error?Į. If left out, which of the following would cause an infinite loop to occur in a simple loop?Ħ. Which three of the following are implicit cursor attributes?ĥ. Look up datatype for EMPLOYEE column on LASTNAME table and use that.Ĥ. How would the developer define this variable using referential datatypes?Ĭ.
The variable name is EMPLOYEE_LASTNAME, and the corresponding table and column is EMPLOYEE, and LNAME, respectively. A developer would like to use referential datatype declaration on a variable. Which of the following is not a feature of a cursor FOR loop?ī. Implicit cursors are no longer a feature in Oracle.Ģ. Implicit cursors are used in cursor for loops to handle data processing.ĭ. Developers should use implicit cursors with great care.Ĭ. Implicit cursors are used for SQL statements that are not named.ī. Which of the following statements is true about implicit cursors?Ī. As per my experience good interviewers hardly plan to ask any particular question during your Job interview and these model questions are asked in the online technical test and interview of many IT companies. These objective type PL/SQL questions are very important for campus placement test and job interviews. Best PL/SQL Objective Questions and Answersĭear Readers, Welcome to PL/SQL Objective Questions have been designed specially to get you acquainted with the nature of questions you may encounter during your Job interview for the subject of PL/SQL MCQs.
0 kommentar(er)
