Interview Questions

Dimensional modeling is often used in Data warehousing. In simpler words it is a rational or consistent design technique used to build a data warehouse. DM uses facts and dimensions of a warehouse for its design. A snow and star flake schema represent data modeling.

Asset means anything that can be converted into cash. Here in banks, the loans disbursed by Bank to its customers is considered as assets because when they are cleared by them, then they are directly converted to cash.

Copy() makes a copy of the file. It returns TRUE on success. It can copy from any source to destination. Move simply Moves the file to destination if the file is valid. While move can move the uploaded file from temp server location to any destination on the server. If filename is a valid upload file, but cannot be moved for some reason, no action will occur.

virtual LAN (VLAN) is any broadcast domain that is partitioned and isolated in a computer network at the data link layer (OSI layer 2). LAN is the abbreviation for local area network and in this context, virtual refers to a physical object recreated and altered by additional logic.

VLANs work by applying tags to network packets and handling these tags in networking systems – creating the appearance and functionality of network traffic that is physically on a single network but acts as if it is split between separate networks. In this way, VLANs can keep network applications separate despite being connected to the same physical network, and without requiring multiple sets of cabling and networking devices to be deployed.

An OOK-Rec is a one of a kind record set, used to get to another record set.

 Test scenarios are derived from requirement documents. We follow each and every functionality (called business rules) mentioned in the requirement document. One functionality can have multiple business rules. For example, let us say in there is one requirement called “Login”. This “Login” may have various scenarios. For example, one scenario is, enter the right User ID and wrong password. The system should display an error message. Another scenario would be to enter wrong User ID and right Password. The system should display an error message. The third scenario could be to enter the right User Name and right Password. The system should allow the user to get into the system. This is how the test cases are derived from the requirement documents or from the Use Cases.

When responding to conflict resolution questions, answer with confidence since you're being considered for a supervisory position where you will frequently be required to work in teams, delegate responsibilities, and handle difficult problems.

The following is an effective way to answer conflict resolution questions:

Before proposing a solution, I collect all relevant facts surrounding the conflict. Conflicts are often resolved if sufficient time is devoted to determining root causes, while disregarding trivial or irrelevant facts.

An effective answer can also be supplemented with the following response:

When resolving a problem between employees, I serve as a neutral third party. When needed, I establish rules of conduct. For an organization to operate efficiently, employees must be on the same page. At most organizations, bad feelings exist among some employees, so a manager is responsible for ensuring that employees are placed in situations where they're comfortable to focus on their job responsibilities. In other words, employees must be situated around others they can work with so productivity is not affected.

RBI issued currency notes under Fixed Minimum Reserve System.