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. If you don't specify a mode for a parameter, what is the default mode? OUT b. COPY d. R ead ANS: B R ead e. W rite ANS: A What are the three parameter modes for procedures? End-user database C. Commercial database D. Relational database. How many editions of the Oracle database there?
Compound Key B. Primary key C. Foreign Key D. View Answer Ans : B Explanation: A primary key is a single field or combination of fields that contains a unique record. It must be filled. None of the field of primary key can contain a null value. A table can have only one primary key. Which statement is used to create a table from an existing table by copying the columns of existing table?
View Answer Ans : A Explanation: Option A statement is used to create a table from an existing table by copying the columns of existing table. Trigger B.
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.
A formal parameter is declared within the called procedure, while an actual parameter is declared in thecalling environment. Your email address will not be published. Which of the following statements is true about implicit cursors? Implicit cursors are used for SQL statements that are not named.
Developers should use implicit cursors with great care. Implicit cursors are used in cursor for loops to handle data processing. Implicit cursors are no longer a feature in Oracle. Ans: A 2. Which of the following is not a feature of a cursor FOR loop?
Record type declaration. Opening and parsing of SQL statements. Fetches records from cursor. Requires exit condition to be defined. Ans:B 3. A developer would like to use referential datatype declaration on a variable. How would the developer define this variable using referential datatypes? Use employee. Declare it to be type LONG. Ans: A 4. Which three of the following are implicit cursor attributes?
If left out, which of the following would cause an infinite loop to occur in a simple loop? LOOP B. Which line in the following statement will produce an error?
There are no errors in this statement. Ans:C 7. None, cursor for loops handle cursor opening implicitly. Ans:D 8. It causes the cursor to close B. It causes the cursor to open C. It loads the current row values into variables D. It creates the variables to hold the current row values Ans: B 9. Only one B. All that apply C. All referenced D. None Ans: A Statement and Row B. Statement only C. Row only D.
0コメント