Technical Questions From IBM -I

Q)read abt all these topicssss
1 What is the difference between OOP (Object Oriented Programming) and POP (Procedure Oriented Programming).
2 Example of Polymorphism.
3 Why paging, segmentation needed.
4 What is ADT (Abstract Data Type)?


Q)ARP is used for...........
A. map from MAC address to IP add.
B. map from IP addresses to MAC add.
C. to store the IP addresses.
ans b

Q) Which of the following API is used to hide a window

a) ShowWindow

b) EnableWindow

c) MoveWindow

d) SetWindowPlacement

e)None of the above

ans a

Q) what is pragma exception???
ans Associating a PL/SQL Exception with a Number: Pragma EXCEPTION_INIT
To handle error conditions (typically ORA- messages) that have no predefined name, you must use the OTHERS handler or the pragma EXCEPTION_INIT. A pragma is a compiler directive that is processed at compile time, not at run time.In PL/SQL, the pragma EXCEPTION_INIT tells the compiler to associate an exception name with an Oracle error number. That lets you refer to any internal exception by name and to write a specific handler for it. When you see an error stack, or sequence of error messages, the one on top is the one that you can trap and handle.You code the pragma EXCEPTION_INIT in the declarative part of a PL/SQL block, subprogram, or package using the syntaxPRAGMA EXCEPTION_INIT(exception_name, -Oracle_error_number);where exception_name is the name of a previously declared exception and the number is a negative value corresponding to an ORA- error number. The pragma must appear somewhere after the exception declaration in the same declarative section, as shown in the following example:

DECLARE
deadlock_detected EXCEPTION;
PRAGMA EXCEPTION_INIT(deadlock_detected, -60);
BEGIN
... -- Some operation that causes an ORA-00060 error
EXCEPTION
WHEN deadlock_detected THEN
-- handle the error
END;

Q)Function entry for DLL in win3.1
ans WinMain

Q)What type of memory could be accessed in least time?
ans CPU registers. The top of the memory pyramid :)

Q)what is data integrity constants?
ans Oracle uses integrity constraints to prevent invalid data entry into the database. It can be achieved using NOTNULL, Primary Key ,CHECK, Foreign Key etc..... constraints

Q)Paging is ------------------------
ans Paging is the technique of accessing memory ,larger than the maximum memory which can be addressed by a microprocessor.The interfaced memory is divided into pages such that the size of each page is equal to or less then the maximum memory which can be interfaced. Then whenever a specific address is to be accessed, the corresponding page is selected and the memory location is accessed.

Q) What is trigger in DBMS?
ans A Trigger is a PL/SQL block that executes whenever a particular event takes place.events in database like Insert,Update, Delete and combination of these three will cause the trigger to execute.Trigger is a technique to maintain integrity constraints

Q)What is the difference b/w 0123 and 123 in c?

ans 0123 the number that can be start 0 it will be treated as a octal number that is base 8. 123 is the integer number representation base is 10.

Q) Nice command is used for?
ANS This is used for change the priority

13 Which of the choices is true for the mentioned declaration ?

const char *p;

and

char * const p;

a) You can't change the character in both

b) First : You can't change the characterr &

Second : You can;t change the pointer

c) You can't change the pointer in both

d) First : You can't change the pointer &

Second : You can't chanage the character

e) None

Ans) b ( check it)

14) The standard source for standard input , standard output and standard error is

a) the terminal

b) /dev/null

c) /usr/you/input, /usr/you/output/, /usr/you/error respectively

d) NOne

Ans) a

Q The very first process created by the kernal that runs

till the kernal process is haltes is

a)init

b)getty

c)

d)

e)none

(Ans is a)



15)which function is the entry point for a DLL in MS Windows 3.1

a) main

b) Winmain

c) Dllmain

d) Libmain

e) None

Ans) b

Comments