Interview Questions

Wi-Fi technology is a technology used for transmitting a signal using the 802.11 specifications works a lot like it does with a basic Ethernet hub: They’re both two-way forms of communication, and they both use the same frequency to both transmit and receive, often referred to a half-duplex. WLANs used radio frequencies (RFs) that are radiated into the air from an antenna that creates radio waves. These waves can be absorbed, refracted, or reflected by walls, water, and metal surfaces, resulting in low signal strength. So because of this vulnerability to surrounding environmental factors, it’s pretty apparent that wire-less will never offer us the same robustness as a wired network can, but that still doesn’t mean we’re not going to use or run the wireless or Wi-Fi.

Sample Answers :

I would listen to their concerns, and reassure them that I was doing my very best for their loved one.

 Sometimes family members are looking for someone or something to blame for what their loved one is going through. I would try to reassure them that the patient was getting the best quality of care available.

 I would listen to their concerns, and make sure that if any were well founded they were addressed immediately.

Following are the benefits of data integration:

- Makes reporting, monitoring, placing customer information across the enterprise flexible and convenient.

- Data usage is efficient.

- Cost Effective.

- Risk adjusted profitability management as it allows accurate data extraction.

- Allows timely and reliable reporting, as data quality is the prime technology for business challenges.

I like new challenges and fortunate to develop. As long as I keep doing these, I don’t think I’ll need to alter. I’d like to consider that this relationship lasts for many years. However, I haven’t set a period of time limit as such.

An index is a object which is used to improve performance during retrieval of records.

CREATE [UNIQUE] INDEX index_name 

ON employee[emp_id, emp_name,dept_id]

[COMPUTE STATISTICS]

The UNIQUE keyword is used when combined values of the index should be unique.

The COMPUTE STATISTICS during the creation of index optimizes the plan of execution of the SQL statement and improves performance.

Oracle constraints are used to maintain consistent of data and ensure the data is properly maintained. A constraint is more or less a restriction we try to apply on a table.
Types of constraints:
- Check constraints
- NOT NULL constraint
- PRIMARY KEY constraint
- REFERENCES constraint
- UNIQUE constraint

Method contains name, parameters, return type and executable body. But block does not contains name, parameters, return type.It contains only executable body.

Methods are executed by method call statements. Blocks are executed automatically with class loading and with object creation.