Interview Questions

I have had many disappointments, like the majority of the  people have, but I agree that we can learn from all the experiences we have got in life  and that the accomplishments, as well as the disappointments, make us better and stronger able to deal with many distinctive  situations.

Before answering the above question let us first understand the meaning of Intercompany transactions. Intercompany transactions are those transactions that takes place between two or more entities of the same group of company. So the receivable of one entity would the payable of another entity. All intercompany transactions are eliminated befor preparing the final Balance sheet of the group company.

A TCB is a complex data structure that contains a considerable amount of information about each connection

Excess payment to supplier is treated as Advance paid to supplier. This will show as debit balance in supplier account.

Supplier can send the payment by way of cheque / demand draft without adjusting in his subsequent bills.

Sample Response :

When I was a resident assistant at my college, a student I did not know asked me if he could use my phone to call another room. Although I did not know the student, I allowed him into my room. He used the phone and in the course of his conversation, he stated that he had just come from a fraternity party and was high from taking some drugs. Well after his conversation, I had to enforce the student conduct code by writing him up. He became very hostile towards me and would not give me any identification or information. I stood in the doorway to prevent him from leaving. I noted the serial numbers on his keys, so when the situation got to the point where I felt unsafe, I allowed the him to leave. I still preformed my job without jeopardizing my or his physical welfare. 

Difference between the heights of left and Right subtrees in an AVL tree can never be greater than +1

Dimensional modelling is very flexible for the user perspective. Dimensional data model is mapped for creating schemas. Where as ER Model is not mapped for creating shemas and does not use in conversion of normalization of data into denormalized form.

ER Model is utilized for OLTP databases that uses any of the 1st or 2nd or 3rd normal forms, where as dimensional data model is used for data warehousing and uses 3rd normal form.

ER model contains normalized data where as Dimensional model contains denormalized data.

Oracle Spatial, often referred to as spatial, provides a SQL schema and functions that facilitate the storage, retrieval, update, and query of collections of spatial features in an Oracle database. Oracle Spatial is designed to make spatial data management easier and more natural to users of location-enabled applications and geographic information system (GIS) applications. Once spatial data is stored in an Oracle database, it can be easily manipulated, retrieved, and related to all other data stored in the database.