Filter interviews by
Clear (1)
Currently working as a Research Assistant at XYZ University with 3 years of experience in conducting experiments and analyzing data.
Research Assistant at XYZ University
3 years of experience in conducting experiments and analyzing data
I applied via Referral and was interviewed before Mar 2023. There was 1 interview round.
A view in DBMS is a virtual table created by a query that can be used like a regular table.
Views are used to simplify complex queries by storing them as a virtual table.
They can also be used to restrict access to certain columns or rows of a table.
Views do not store data themselves, but instead display data from the underlying tables.
Changes made to the data in a view will affect the underlying tables.
Example: CREATE V...
Primary key uniquely identifies a record in a table, while foreign key establishes a link between two tables.
Primary key ensures uniqueness of each record in a table
Foreign key establishes a relationship between two tables
Primary key can't have null values, while foreign key can have null values
Example: In a 'students' table, 'student_id' can be a primary key, while in a 'courses' table, 'student_id' can be a foreign k
The acid properties of a transaction refer to its key characteristics for ensuring reliability and consistency in database systems.
Atomicity: A transaction is considered atomic if it is treated as a single unit of work that either completes in its entirety or is fully rolled back.
Consistency: This property ensures that a transaction transforms the database from one consistent state to another consistent state.
Isolation...
DDL commands are used to define the structure of database objects, while DML commands are used to manipulate data within those objects.
DDL commands include CREATE, ALTER, DROP, TRUNCATE, etc.
DML commands include INSERT, UPDATE, DELETE, SELECT, etc.
DDL commands are used to create or modify the structure of database objects like tables, indexes, etc.
DML commands are used to insert, update, delete, or retrieve data from t
2NF and 3NF are both normal forms in database normalization, with 3NF being a stricter form of normalization than 2NF.
2NF eliminates partial dependencies, while 3NF eliminates transitive dependencies.
In 2NF, every non-prime attribute is fully functionally dependent on the primary key, while in 3NF, every non-prime attribute is non-transitively dependent on the primary key.
Example: If a table is in 2NF but not in 3NF, i...
I applied via Naukri.com and was interviewed before Sep 2022. There were 3 interview rounds.
A page fault is an exception that occurs when a program tries to access a page of memory that is not currently in physical memory.
Occurs when a program tries to access a page of memory that is not in physical memory
Causes the operating system to bring the required page into memory from disk
Can be classified as major or minor depending on whether the page is already in memory but marked as invalid
Example: When a program...
Page replacement techniques are algorithms used in operating systems to manage memory efficiently.
FIFO (First In, First Out)
LRU (Least Recently Used)
LFU (Least Frequently Used)
Optimal Page Replacement
Clock Page Replacement
K L University interview questions for designations
Get interview-ready with Top K L University Interview Questions
I applied via Naukri.com and was interviewed in Jan 2022. There were 4 interview rounds.
I applied via Naukri.com and was interviewed in Apr 2022. There was 1 interview round.
I applied via Company Website and was interviewed in Dec 2021. There were 2 interview rounds.
I applied via Naukri.com and was interviewed in Nov 2020. There were 5 interview rounds.
Quick sort is faster for small arrays, while Merge sort is more efficient for larger arrays.
Quick sort has an average time complexity of O(nlogn), while Merge sort has a time complexity of O(nlogn) in all cases.
Quick sort is an in-place sorting algorithm, while Merge sort requires extra space.
Quick sort is not stable, while Merge sort is stable.
Quick sort is often used in practice due to its efficiency, while Merge sor...
I prefer classless addressing due to its flexibility and efficient use of IP addresses.
Classless addressing allows for more efficient use of IP addresses by allowing for variable-length subnet masks.
Classful addressing is limited to fixed-length subnet masks, which can result in wasted IP addresses.
Classless addressing also allows for more flexibility in network design and can accommodate networks of varying sizes.
Clas...
Top trending discussions
based on 5 interviews
2 Interview rounds
based on 80 reviews
Rating in categories
Assistant Professor
223
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Professor
67
salaries
| ₹0 L/yr - ₹0 L/yr |
Student Counsellor
24
salaries
| ₹0 L/yr - ₹0 L/yr |
Professor
21
salaries
| ₹0 L/yr - ₹0 L/yr |
HR Executive
18
salaries
| ₹0 L/yr - ₹0 L/yr |
VIT University
Manipal University
SRM Institute of Science and Technology
Amity University