Unit 4: Introduction to Database Management System - Practice Quiz

1 What is a database?

2 In a relational database, what does a table usually represent?

3 What is a record in a database table?

4 Which system commonly uses a DBMS to store account and transaction information?

5 How can a DBMS be used in a school?

6 Which DBMS application helps a hospital organize patient information?

7 Which DBMS component interprets and executes database queries?

8 Which DBMS component manages how data is stored and retrieved?

9 What does the data dictionary contain?

10 Who is primarily responsible for controlling access to a database?

11 Which DBMS actor writes programs that interact with a database?

12 Who uses a database application to perform routine tasks such as entering or viewing data?

13 How many levels are present in the traditional three-schema DBMS architecture?

14 Which level of the three-schema architecture describes how data is physically stored?

15 Which level presents different database views to individual users?

16 What does the conceptual level describe?

17 What is data independence?

18 What is a major benefit of data independence?

19 Which type of data independence allows physical storage changes without changing the conceptual schema?

20 Which type of data independence allows changes to the conceptual schema without changing user views or application programs?

21 A college stores student addresses separately in admissions, library, and examination files. The address may therefore differ across departments. Which database concept most directly addresses this problem?

22 In a relational database, a foreign key in an Orders table refers to a primary key in a Customers table. What is the main purpose of this relationship?

23 Two employees try to reserve the last available conference room for the same time slot. What database capability is most important for preventing both reservations from being accepted?

24 A bank transfers money by debiting one account and crediting another. If the credit operation fails, the debit must also be undone. Which DBMS feature supports this requirement?

25 A hospital permits doctors to view medical histories but allows billing staff to view only payment details. Which DBMS application capability enables this arrangement?

26 An online store must reduce product stock immediately after a successful purchase while supporting many simultaneous customers. Which type of workload best describes this application?

27 A SQL statement is checked, converted into an execution plan, and optimized before accessing data. Which DBMS component performs these tasks?

28 Frequently accessed disk pages are retained temporarily in main memory to reduce input/output operations. Which component manages this activity?

29 After a power failure, a DBMS uses recorded changes to restore committed transactions and undo incomplete ones. Which component supplies the required records?

30 A developer needs to find the data type, constraints, and owner of a table without reading its rows. Which DBMS component should be consulted?

31 Who is primarily responsible for creating user accounts, granting privileges, planning backups, and monitoring database performance?

32 A specialist decides which entities, relationships, attributes, and constraints should represent a university's information requirements. Which role is being performed?

33 A bank teller repeatedly uses predefined forms to deposit and withdraw funds without writing SQL. How is this user best classified?

34 In the three-schema architecture, which level describes the complete logical structure of the database while hiding physical storage details?

35 A reporting employee sees only EmployeeName and Department, although the database also stores salary and tax details. Which architectural level defines this restricted representation?

36 In a three-tier application, where is validation of business rules normally placed so that multiple client interfaces can reuse it?

37 A DBMS is said to provide data independence when developers can do what?

38 An administrator adds an index to CustomerID to improve search speed, but application queries remain unchanged. Which type of data independence does this demonstrate?

39 A database designer adds DateOfBirth to the conceptual schema while existing user views and programs continue to work. Which type of data independence is demonstrated?

40 Which change is most likely to require logical data independence rather than physical data independence?

41 A university changes every student's stored GPA after grades are finalized, but it does not alter any relation definitions, domains, or constraints. Which description is most accurate?

42 A relation records (EmployeeID, ProjectID, Hours). An employee may work on several projects, but each employee-project pair must occur at most once. Which constraint best captures the required identity?

43 Two applications separately store a customer's address. Both files are internally valid, but one contains an old address. Which database concept is most directly violated?

44 A banking application debits one account and credits another. A failure occurs after the debit but before the credit. Which DBMS capability is essential to prevent a permanently incomplete transfer?

45 An airline reservation system allows two agents to read the final available seat and then both confirm it. Which DBMS function should primarily prevent this outcome?

46 A hospital must let physicians see full clinical records while billing staff see only treatment codes and charges. Which DBMS feature most directly supports this requirement?

47 A SQL query is syntactically valid and produces the correct result, but its selected execution strategy performs repeated full-table scans despite available indexes. Which DBMS component is chiefly responsible?

48 After a committed update, the system crashes before the modified data page reaches permanent storage. Which mechanism enables the DBMS to restore the committed value?

49 The optimizer needs table cardinalities, available indexes, attribute domains, and access privileges. Which DBMS component centrally stores this metadata?

50 A requested page is already present in main memory, but the DBMS reads it from disk again because it fails to recognize the cached copy. Which component has malfunctioned most directly?

51 An organization must decide entity structures, relationship cardinalities, and integrity constraints before application programs are implemented. Who is primarily responsible?

52 A bank teller repeatedly executes predefined deposit and withdrawal forms without writing SQL or modifying schemas. Which DBMS user category best fits this role?

53 A production database requires privilege revocation, storage allocation, backup scheduling, and performance monitoring. Which actor should hold primary operational responsibility?

54 A specialist identifies business workflows and determines what transactions a new inventory system must support, but does not define storage structures or write the final programs. Which role is the closest match?

55 In the three-schema architecture, a user view continues exposing FullName after the conceptual schema replaces it with GivenName and FamilyName. Where should the reconstruction rule primarily be represented?

56 A desktop client sends requests to an application server, which enforces business rules and accesses the database server. The client has no direct database connection. Which architecture is described?

57 Which statement correctly distinguishes the conceptual schema from the internal schema in the three-schema architecture?

58 A DBA replaces a table scan with a B-tree index and reorganizes records into different disk pages. No conceptual definitions or application queries change. What property is demonstrated?

59 A conceptual relation Employee(EmpID, Name, DeptName) is replaced by Employee(EmpID, Name, DeptID) and Department(DeptID, DeptName). Existing user views still present the original columns. Which type of independence is being exercised?

60 Why is logical data independence generally harder to achieve than physical data independence?