What is thrashing? How many keys are in DBMS? What is a foreign key? What is 3NF? What is the function of mid-term-scheduler? and so many, total of 17-18 questions were asked.

Question

Accepted Answer

Answers to various technical questions related to computer science

Thrashing is a phenomenon in which a computer system spends more time in swapping pages than executing actual instructions
DBMS keys include primary key, foreign key, candidate key, super key, etc.
A foreign key is a field in a table that refers to the primary key of another table
3NF or Third Normal Form is a database normalization technique that ensures that there are no transitive dependencies in a table
The mid-term scheduler is responsible for selecting processes from the ready queue and loading them into memory for execution

Accepted Answer

1. What is Thrashing?

Thrashing occurs when a system spends more time swapping pages in and out of memory rather than executing actual processes. This happens due to excessive page faults, leading to a significant drop in performance.

2. How many types of keys are there in DBMS?

There are seven main types of keys in a Database Management System (DBMS):

1. Primary Key – Uniquely identifies a record.

2. Foreign Key – Refers to the primary key of another table.

3. Candidate Key – A set of attributes that could be a primary key.

4. Super Key – A superset of a candidate key.

5. Composite Key – A key made up of multiple attributes.

6. Alternate Key – Candidate keys that are not chosen as the primary key.

7. Unique Key – Ensures uniqueness but allows NULL values.

3. What is a Foreign Key?

A foreign key is an attribute (or a set of attributes) in one table that refers to the primary key of another table, ensuring referential integrity.

What is thrashing? How many keys are in DBMS? What is a foreign key? What is 3NF? What is the function of mid-term-scheduler? and so many, total of 17-18 questions were asked.

Top K L University Associate Professor interview questions & answers

Popular interview questions of Associate Professor

Top HR questions asked in K L University Associate Professor