Database Management System

 VERY SHORT ANSWER (KEYWORDS ONLY):

DBMS

1.       What is DBMS?

Software for managing databases

2.       What is a database?

Collection of organized data

3.       Give two examples of DBMS.

MySQL, Oracle

4.       What is a relational database?

Data stored in tables

5.       What is SQL?

Structured Query Language

6.       What is a primary key?

Unique identifier for records

7.       What is a foreign key?

Link between two tables

8.       What is normalization?

Process of organizing data

9.       What is denormalization?

Combining tables for speed

10.   What is a table in DBMS?

Rows and columns storage

11.   What are data types in DBMS?

Integer, String, Date

12.   What is a constraint?

Rule on database fields

13.   What is a composite key?

Multiple columns as key

14.   What is an alternate key?

Candidate key not chosen

15.   What is an index in DBMS?

Speeds up search queries

16.   What is a view in DBMS?

Virtual table in SQL

17.   What is a transaction in DBMS?

Sequence of database operations

18.   What is atomicity in DBMS?

All or nothing execution

19.   What is database backup?

Copy of database for recovery

20.   What is database replication?

Copying data to multiple locations

21.   What is database encryption?

Securing database data

22.   What is MS Access?

Database Management System (DBMS)

23.   Which type of database is MS Access?

Relational Database Management System (RDBMS)

24.   What is a table in MS Access?

Stores data in rows and columns

25.   What is a field in MS Access?

Column in a table

26.   What is a record in MS Access?

Row in a table

27.   What is a primary key in MS Access?

Unique identifier for records

28.   What is a foreign key in MS Access?

Links two tables together

29.   What is a query in MS Access?

Retrieves specific data

30.   What is a form in MS Access?

User-friendly data entry interface

31.   What is a report in MS Access?

Used for formatted data presentation

32.   What are the main data types in MS Access?

Text, Number, Date/Time, Currency

33.   What is a calculated field in MS Access?

Stores the result of a calculation

34.   What is the use of Yes/No data type?

Stores True/False values

35.   What is a lookup field in MS Access?

Provides dropdown list values

36.   What is an action query?

Performs actions like delete, update

37.   What is a parameter query?

Asks for input before execution

38.   What is a wildcard in MS Access?

Used in queries for pattern matching

39.   What is the purpose of relationships in MS Access?

Defines links between tables

40.   What are the types of relationships in MS Access?

One-to-One, One-to-Many, Many-to-Many

41.   Which view is used to design a table in MS Access?

Design View

42.   What is the use of a macro in MS Access?

Automates database tasks

43.   What is an index in MS Access?

Speeds up searches

44.   What is Referential Integrity?

Ensures valid relationships between tables

45.   Which file extension is used for MS Access databases?

.ACCDB (new), .MDB (older)

46.   What is the function of the "Compact and Repair" tool in MS Access?

Optimizes and fixes database errors