Blog

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 […]

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 […]

C Objective Questions 8

152. What is the output? void main() { int a; a=100; printf(“%d %d”,++a,++a); } 153. What is the output? void main() { int i=-1; +i; printf(“i = %d, +i = %d \n”,i,+i); } 154. Which of the following is not a valid operator? A) + B)++ C)+++ D)+= 155. Which of the following daa type […]

C Objective Questions 7

95. What is the output of the following program? void main() { int i = 2, j = 3, k, l; float a,b; k = i / j * j; l = j / i * i; a = i / j * j; b = j / i * i; printf(“%d %d %f %f […]

C Online Test 6

32. What is the output of the following code? void main() { int a = 010; printf(“\n a = %d “, a); } 33. What is the output of the following code? void main() { int a = 010; printf(“\n a = %o “, a); } 34. What is the output of the following code? […]

C Online Test 5

1. What is the output of the following code? void main() { int x; x = 3 > 2 > 1; printf(“%d” , x); } 2. What is the output of the following code? void main() { printf(“%X” , -1<<4); } 3. What is the output of the following code? void main() { int c […]

C Language Online Test 4

What is the output? #include <stdio.h> void main() { int a[] = {10,12,6,7,2}; int i,sum=0; for(i=0; i<5; i++) { sum = sum + *(a+i); } printf(“%d\n”, sum); } Ans: Sum of array elements What is the output? int main() { int val = 5; int* ptr = &val; printf(“%d %d”,val,(*ptr)++); return 0; } Ans: 6 […]

C Language Online Test 3

what is the output? int main() { int a[100]; int sum = 0; int k; for(k=0; k<100; k++) { *(a+k) = k; } printf(“%d”,a[–k]); return 0; } Ans: 99 What is the output? void main() { int i=5; int *p; p = &i; printf(”The value of i is : %d \n”,*p); *p = *p + […]

C Language Practice Programs 2

What is the output? #include <stdio.h> void main() { int a[2][3]={0,1,2,3,4,5}; printf(“%d”,sizeof(a[2])); } Ans:  6 or 12 What will be the output of the following program code? #include <stdio.h> void main() { int i=3, *j, **k; j = &i; k = &j; printf(“%d%d%d”, *j, **k, *(*k)); } 444 000 333 433 Ans: 3 What is […]

C Language Practice Programs 1

Determine output: #include <stdio.h> void main() { char *p = NULL; char *q = 0; if(p) printf(” p “); else printf(“nullp”); if(q) printf(“q”); else printf(” nullq”); } p q Depends on the compiler x nullq where x can be p or nullp depending on the value of NULL nullp nullq Ans: 4  What is the […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

PL SQL MCQ Questions 4

What are internally defined exceptions? The Oracle ORA errors Exceptions which are already defined in the STANDARD package Exceptions defined by a user Any error that occurs in PL/SQL Ans : 1 How can a user defined exception be raised? Using RAISE statement only Using RAISE statement or RAISE_APPL_ERROR function Using INVOKE statement or RAISE […]

PL/SQL Multiple Choice Questions 3

Can you use %RowCount as a parameter to a cursor? Yes No None of the above Depends upon Ans :  1 How is it possible to fetch a current row from a cursor without using ROWID? Where HAVING WHERE CURRENT OF None of the above Ans : 3 How many types of ref-cursor? One Two […]