Technology Questions

Q:

How can we call DDL statements like CREATE, DROP, TRUNCATE, etc. from PL/SQL?

Answer

EXECUTE IMMEDIATE command can be used to call DDL statements. 


Example:


BEGIN


EXECUTE IMMEDIATE  'TRUNCATE TABLE employee';


END;

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2635
Q:

What files are important in a bootable Windows XP operating system?

Answer

There are four important files in order to make a bootable Windows XP operating system. These are Ntldr, Ntdetect, Boot.ini and Ntfs.sys

Report Error

View answer Workspace Report Error Discuss

0 2633
Q:

What is a DB2 plan?

Answer

An application plan or package is generated by the bind to define an access path. 

Report Error

View answer Workspace Report Error Discuss

0 2631
Q:

What is the Routing Information Protocol or RIP?

Answer

RIP is a is an interior gateway protocol that was often used in interior networks and in some degree in internet networks. It helps the router adapt to the modifications that are made in a network regarding connections. Now it become less used since more efficient protocols were implemented like OSPF or IS-IS. It is limited to a lower number of routers, a maximum of fifteen router.

Report Error

View answer Workspace Report Error Discuss

0 2630
Q:

If I call performSelector:withObject:afterDelay: – is the object retained?

Answer

Yes the object is retained. It creates a timer that calls a selector on the current threads run loop. It may not be 100% precise time-wise as it attempts to dequeue the message from the run loop and perform the selector.

Report Error

View answer Workspace Report Error Discuss

0 2627
Q:

What is Marshalling?

Answer

Marshalling is the process of gathering data from one or more applications or non-contiguous sources in computer storage, putting the data pieces into a message buffer, and organizing or converting the data into a format that is prescribed for a particular receiver or programming interface.  

Report Error

View answer Workspace Report Error Discuss

0 2627
Q:

What type of Joins have you used?

Answer

The knowledge of Joins is a MUST for every interviewee. Most SQL programmers have used inner join and  outer join[left/right]; but the catch point here is to also mention cross join and self-join.


 

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

1 2626
Q:

What are different ABAP/4 editors? What are the differences?

Answer

The 2 editors are se38 and se80 both have the abap editor in place. In se38 you can go create programs and view online reports and basically do all thedevelopmet of objects in this editor. In se80 ( object navigator) there are additional features such as creating packages,module pool , function group ,classes, programs ( where you can create ur programs) and BSP applications .

Report Error

View answer Workspace Report Error Discuss

Subject: SAP

0 2626