Pointel Technology & Solutions Application Support Interview Questions and Answers

An index is a data structure that improves the speed of data retrieval operations in a database.

• Types of indexes include clustered, non-clustered, unique, and composite indexes.

• Indexes can be created on one or multiple columns in a table.

• Indexes help in quickly locating data without having to scan the entire table.

• Examples of indexes are primary keys, foreign keys, and indexes created for frequently searched columns.

Soft links are pointers to the original file while hard links are direct references to the file's data on disk.

• Soft links are symbolic links that point to the original file by its path.

• Hard links are direct references to the file's data on disk, sharing the same inode.

• Soft links can span across different file systems while hard links cannot.

• If the original file is deleted, soft links become broken while hard links stil

A view is a virtual table based on the result set of a SQL query. Normalization is the process of organizing data in a database to reduce redundancy.

• Views in databases are used to simplify complex queries by storing the query as a virtual table.

• Normalization involves breaking down data into smaller, more manageable tables to reduce redundancy and improve data integrity.

• Examples of normalization include breaking down a ...read more