Database Management System

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 2

Database Management System

1. What is meant by a Database?


2. What is the purpose of normalization in DBMS?
3. What is the use of DROP command and what are the differences
between DROP, TRUNCATE and DELETE commands?
4. What is the main difference between UNION and UNION ALL?
5. Explain the concept of ACID properties in DBMS?
6. What is BCNF in the DBMS?
7. What are different types of joins in SQL?
8. What is RDBMS?
9. What is Indexing and Clustering in RDBMS? Why we used?
10. What are the main differences between Primary key and Unique
Key?

Operating System

1. Explain the main purpose of an operating system?


2. What are the advantages of a multiprocessor system?
3. What is a virtual memory?
4. Describe the objective of multiprogramming.
5. Give some benefits of multithreaded programming.
6. Briefly explain FCFS.
7. What is the basic function of paging?
8. Give an example of a Process State.
9. What is the purpose of an I/O status information?
10. What is caching?

OOPS

1. What is a class?
2. What is an Object?
3. What is Polymorphism?
4. What is Inheritance?
5. Explain the term constructor?
6. What is function overloading?
7. What is the use of finalize method?
8. What is the main difference between overloading and overriding?
9. What are the various types of constructors?
10. What is dynamic or run time polymorphism?

Miscllaneous

1. Introduce Yourself
2. What is static and dynamic Binding?
3. Write code to check a String is palindrome or not?
4. What is the use of a span tag? Give one example.
5. What is the difference between new and override?
6. What is a primary key?
7. What are the types of join and explain each?
8. What is the difference between DELETE and TRUNCATE commands?
9. What is HTML?
10. What is Cloud computing?
11. What is IOT?
12. What is big data?

You might also like