Interview Questions

Python Interview Questions and Answers

Python Interview Questions and Answers   What is exception object? If exception has raised with in the logic, an object will be created with the complete information of error to be handled is called “Exception object”. Describe except block? Except-block contains exception handling logic. Except block executes only if an exception has risen in try block. What is the need of finally block? Finally, block contains resource releasing logic. It is recommended to shutdown(release) the resources properly after use in the application. What is the main advantage of [...]

Read more...

Python Interview Questions 1

What is Script? A program that serves the application (Standalone or Web) that was developed using another programming language. Script is a set of instructions that will be interpreted. Script carried out by another program rather than by the computer processor. Why Python programming language? Every programming language has its scope. Different programming languages used for different types of application development. Python script analyzes the data effectively using its pre-defined functionality than other programming codes. Python can be used in web development, Gaming development, Embedded System [...]

Read more...

PL SQL Practice Test 12

Where can a Varray be stored? At package or at the schema level. PL/SQL block or at the schema level. PL/SQL block or at the package level. PL/SQL block or package or at the schema level Ans : 4 Which of the following collections can be stored in the database? Associative array and Varray Varray and nested table Associative array and nested table Associative array, Varray and nested table Ans : 2 Which of the following collections have an initialized status as empty? Associative array Varray Nested table Records Ans : 1 What does DELETE (m,n) do [...]

Read more...

PL SQL Practice Test 11

What are the types of composite datatypes? Records and Nested table Collections and BOOLEAN Collections, PLS_INTEGER and BOOLEAN Collections and Records Ans : 4 Which of the following statement is true for a collection? In a collection, the internal components always have the same data type. In a collection, the internal components always have different data type In a collection, the internal components may have same data type or different datatype. All collection except records have the same datatype. Ans : 1 How are the elements of a collection variable accessed? variable_name[index] variable_name(index) index variable_name{index} Ans [...]

Read more...

PL SQL Practice Test 10

Which is not a type of trigger? DDL DML DCL Database Ans :  3 Which prefixes are available to Oracle triggers? : new only : old only Both: new and : old Neither: new nor :old Ans : 3  Triggers ________ enabled or disabled Can be  Cannot be Ought to be Always Ans : 1 What are the after triggers?  Triggers generated after a particular operation These triggers run after an insert, update or delete on a table These triggers run after an insert, views, update or delete on a table Both b and c Ans : 2 Which of the following is [...]

Read more...

PL SQL MCQ Questions 9

Which of the following is used to define code that is fired when certain actions or event occur? Replace Keyword Trigger Cursor Ans : 3  ………………….. are used to recreate if trigger already exists. Cursor Trigger Keywords Replace Ans : 4 For which trigger timing can you reference the NEW and OLD qualifiers? Statement and Row Statement only Row only Oracle Forms trigger Ans : 4 Which of the following is not a benefit of a database trigger? Enforcing referential integrity Event logging and storing information on table access Allowing invalid transactions Generating some derived column values automatically Ans : 3 Does the [...]

Read more...

PL SQL MCQ Questions 8

Which statement is package specification or body of a stored subprogram? Package Specification only requires recompilation Package body only requires recompilation Both package & body requires recompilation Both package & body does not require recompilation. Ans : 1 The packaged procedure that makes data in form permanent in the Database is Post Post form Commit form None of the above Ans :  3 Which of the following do not execute multiple PL/SQL programs simultaneously? Oracle Advanced Queuing DBMS_JOB DBMS_SQL Pipelined Functions Ans : 3 Which package can you use to output values and messages stored procedures? DBMS_DISPLAY DBMS_OUTPUT DBMS_LIST DBMS_DESCRIBE Ans : [...]

Read more...

PL SQL Practice Test 7

In a stored procedure, when specifying a string parameter should use which of these ? Char varchar2 TEXT REAL Ans : 2 A Stored Procedure is a Sequence of SQL or PL/SQL statements to perform specific function Stored in compiled form in the database Can be called from all client environments All of the above Ans : 4 Which of the following is true ,Creating a procedure have compile errors.? The line numbers reported match the line numbers you see in your text editor. SQL*Plus will automatically show the errors to you. To see [...]

Read more...
PL-SQL-Objective-Questions-NareshIT

PL SQL Practice Test 6

Whenever compiler implicitly converts the data type of the actual to formal parameter? When pass by reference Always, when pass by any method It never converts implicitly and has to be explicitly done by user When pass by value Ans : 4 What are the two different types of values for a parameter? Default and System given Default and user given System given and user given Compile time and run time values Ans : 2 What happens data type of the actual parameter is not  same as formal parameter? An error is [...]

Read more...

PL SQL MCQ Questions 5

Which collection exception is raised when a subscript exceeds in a collection? VALUE_ERROR COLLECTION_IS_NULL SUBSCRIPT_BEYOND_COUNT SUBSCRIPT_OUTSIDE_LIMIT Ans : 3 Which exception is raised when a nonexistent element of an associative array? NO_DATA_FOUND COLLECTION_IS_NULL SUBSCRIPT_BEYOND_COUNT SUBSCRIPT_OUTSIDE_LIMIT Ans : 1 In which subprogram a RETURN statement does not return a value ? In Procedures In Functions Both A & B None of the above Ans : 1 Which part of a subprogram heading is optional? Name of the subprogram Declaration part of a subprogram Parameters Exception handling part Ans : 3 Which of the following is not a subprogram? Procedure Function Package Anonymous PL/SQL block Ans :  3 Attend Free Demo [...]

Read more...