Interview Questions

- A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index.

- A non clustered index is a special type of index in which the logical order of the index does not match the physical stored order of the rows on disk. The leaf node of a non clustered index does not consist of the data pages. Instead, the leaf nodes contain index rows.

Purchase return and allowances is a contra account to purchases.

Payroll Transaction is nothing but the calculation of salary for a month / week / day of an individual / group of employees depends upon the attendance / variable inputs / other benefits / salary component and generate the reports for IT / Statutory / PT payments.

- Fail-safe approach defines the level that divides the security such that it is safe even in case the system is failed.

- The fail safe approach doesn’t allow an attacker to take the advantage by breaking in the system and crashes out.

- This approach allows the web server to perform the routines even if the system runs out of the memory in case of any attack. 

- The system in attacks doesn’t skip the access to the control check or it doesn’t skip serving any document requested. 

- Fail safe approach can force the web server to run of the memory and have a DoS attack.

Oracle supports 3 transaction isolation levels: 

- Read committed (default)

- Serializable transactions

- Read only

unlink()-deletes the given file from the file system.
unset() -makes a variable undefined.

• Intelligent Search and Siri- Intelligent Search is an excellent mechanism to learn user habits and act on that information- open apps before we need them, make recommendations on places we might like and guide us through our daily lives to make sure we’re where we need to be at the right time.
  Siri is a personal assistant to the users, able to create contextual reminders and search through photos and videos in new ways. Swiping right from the home screen also brings up a new screen that houses “Siri Suggestions,” putting favorite contacts and apps right on your fingertips, along with nearby restaurant and location information and important news.


• Deeper search capabilities can show results like sports scores, videos, and content from third-party apps, and you can even do simple conversions and calculations using the search tools on your iPhone or iPad.


• Many of the built-in apps have been updated.
  ✓ Notes includes new checklists and sketching features
  ✓ Maps now offers transit directions
  ✓ Mail allows for file attachments
  ✓ Apple Pay is being improved with the addition of store credit cards and loyalty cards
  ✓ Leading “Passbook” to be renamed to “Wallet” in iOS 9.


• San Francisco font, wireless CarPlay support


• An optional iCloud Drive app, built-in two-factor authentication and optional longer passwords for better security.


• Performance improvements

Basically there are many standards of Wi-Fi in the industry but some popular of them are 802.11a, 802.11b, 802.11g/n. With the support of these Wi-Fi protocols we can communicate/interact among the devices at the speed of 5Ghz to 2.4Ghz dual band communication.

If we have Wi-Fi nic card so firstly we have to install their drivers and after installation if we have Wi-Fi access point then we can see the signal strength in the right corner below just open that and find the access point to connect, if access point is configured with the security, type the key to connect and enjoy the service.

Wi-Fi is technically referred to as the 802.11 protocol. Over time, Wi-Fi has improved, giving rise to different variations of the protocol.

802.11a – This version operates at 54Mbps. It is considered as the favorite wireless LAN protocol for IP telephony.