DPSC Interview Questions and Answers

When files are deleted in Linux, they are not immediately removed from the disk but rather marked as available for reuse.

• Deleting a file in Linux removes its entry from the file system's directory structure.

• The file's data blocks are not immediately erased but are marked as available for reuse.

• The file's inode, which contains metadata about the file, is also marked as available for reuse.

• Until the space occupied by the deleted file is overwritten by new data, it can potential...read more

The kernel is the core component of an operating system that manages system resources and provides a bridge between hardware and software.

• The kernel is loaded into memory during the boot process.

• It manages memory, processes, and device drivers.

• It provides system calls for applications to interact with hardware.

• Examples of kernels include Linux kernel, Windows NT kernel, and macOS kernel.

A view in SQL is a virtual table that is based on the result of a query. It can be used to simplify complex queries and provide a logical representation of data.

• A view is created by using the CREATE VIEW statement in SQL.

• It is defined by a query that retrieves data from one or more tables.

• Views can be used to hide complexity and provide a simplified interface to the underlying data.

• They can also be used to restrict access to certain columns or rows of a table.

• Views are update...read more

Yes, I have experience in SQL.

• I have worked with SQL databases such as MySQL, Oracle, and SQL Server.

• I am proficient in writing SQL queries for data retrieval and manipulation.

• I have experience in creating and modifying database tables, views, and stored procedures.

• I have used SQL in conjunction with RPA tools such as UiPath and Automation Anywhere.

• I am familiar with SQL functions and operators for data analysis and reporting.