Rotex Software Developer Interview Questions and Answers

Questions on DBMS, CN and OS

Q1. What's a view in SQL
Ans. 
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 acc...read more
Answered by AI
Add your answer
Q2. How a kernel works in OS
Ans. 
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.
Answered by AI
Add your answer
Q3. What happens when you delete files in Linux
Ans. 
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...read more
Answered by AI
Add your answer