Unit 8: Data Base Management Systems - Practice Quiz

1 What is a database?

2 In a database table, a row is also commonly called a:

3 In a database table, a column is also known as a:

4 Which field uniquely identifies each record in a table?

5 A collection of related records in a database is called a:

6 What does the abbreviation DBMS stand for?

7 What is the main purpose of a DBMS?

8 The most widely used type of database model organizes data into:

9 A DBMS that stores data in related tables is called a:

10 Which benefit does a DBMS provide compared to storing data in separate files?

11 A query in a database is used to:

12 Which language is commonly used to work with relational databases?

13 What is a database form mainly used for?

14 A database report is used to:

15 Sorting data in a database means:

16 Filtering data allows a user to:

17 Which is a common everyday use of a database?

18 A bank uses a database mainly to:

19 Which of the following is a well-known corporate DBMS?

20 Which product is a database management system developed by Microsoft?

21 A retail company stores customer records where each customer can place many orders, but each order belongs to exactly one customer. Which type of relationship best describes this design?

22 In a relational table, a column is chosen to uniquely identify every row and is never left blank. What is this column called?

23 A database designer wants to link an Orders table to a Customers table. The CustomerID column in Orders refers to the primary key of Customers. What is CustomerID in the Orders table?

24 In database terminology, a single row of a table that groups related fields about one entity is best described as a:

25 A hospital needs many staff members to read and update patient data at the same time without corrupting records. Which core DBMS capability directly addresses this need?

26 A DBMS allows a payroll clerk to see salary fields while blocking a receptionist from viewing them. Which DBMS function makes this possible?

27 Which statement best explains why a DBMS reduces data redundancy compared with separate flat files?

28 A power failure interrupts a bank transfer after money left one account but before it reached another. Which DBMS feature ensures the whole transaction is undone rather than left half-done?

29 The part of a DBMS that provides a layer between the physical data storage and the user's view, so users need not know how data is physically stored, is achieved through:

30 A user runs the SQL statement SELECT name FROM Employees WHERE dept = 'Sales';. What does this statement do?

31 Which SQL command would you use to permanently remove specific rows from a table while keeping the table structure intact?

32 A manager wants a screen where staff can type data into labeled boxes without seeing the raw table. Which database object is designed for this input task?

33 To combine matching rows from a Students table and an Enrollments table based on a common StudentID, which SQL operation is used?

34 A librarian wants a printable, formatted summary of overdue books grouped by member. Which database object best produces this output?

35 When you define that the Age field may only accept values greater than 0, you are applying a:

36 An online store analyzes years of sales history to discover that customers who buy printers often buy ink within two weeks. This process of finding hidden patterns in large data is called:

37 A company keeps a large, integrated store of historical data from many systems specifically for analysis and reporting rather than daily transactions. This is known as a:

38 When you search an airline website for flights and it instantly returns matching options from a live database, this best illustrates:

39 A small business needs a free, widely used open-source relational DBMS that pairs well with web applications. Which option best fits?

40 A large enterprise runs a very high-volume mission-critical system and chooses a commercial DBMS known for scalability and robust enterprise features. Which of these is such a corporate DBMS?

41 A retail company stores customer orders where a single customer can place many orders, but each order belongs to exactly one customer. In a relational schema, which design correctly enforces this relationship while avoiding data redundancy?

42 A table has attributes {StudentID, CourseID, StudentName, Grade} with the composite primary key (StudentID, CourseID). StudentName depends only on StudentID. This design most directly violates which normal form?

43 Two banking transactions execute concurrently. reads a balance, and before commits, updates and commits a change to that same balance. When reads the balance again it sees a different value. Which concurrency anomaly is this?

44 Which set of properties must a DBMS transaction guarantee, and what does the 'D' specifically ensure?

45 Consider the SQL query: SELECT dept, COUNT(*) FROM employees WHERE salary > 50000 GROUP BY dept HAVING COUNT(*) > 3;. Which statement correctly describes the logical order of evaluation?

46 Table A has 5 rows and Table B has 3 rows. If you perform SELECT * FROM A CROSS JOIN B;, how many rows result, and what does this operation compute?

47 A query joins two tables where some rows in the left table have no match in the right table. The result should include all left-table rows, filling NULL for unmatched right-table columns. Which join accomplishes this?

48 A database index dramatically speeds up SELECT queries on a column but is known to slow down another category of operations. Which operations are negatively affected and why?

49 Two transactions each hold a lock the other needs, and neither can proceed. A DBMS resolves this by aborting one transaction and rolling it back. What condition occurred and what is the resolution called?

50 A designer wants to guarantee that the Email column in a Users table never contains duplicate values but may be left empty (NULL) for some users. Which constraint best satisfies both requirements?

51 In an entity-relationship model, a Booking entity exists only when linked to both a Flight and a Passenger, and cannot exist independently. What kind of entity is Booking?

52 Given a table Sales(region, amount), which query correctly returns only regions whose total sales exceed 10000?

53 A DBMS view is defined by a stored query. Which statement most accurately captures a key characteristic of a standard (non-materialized) view?

54 An organization needs to store historical data from multiple operational systems, optimized for complex analytical queries and reporting rather than day-to-day transactions. Which system is most appropriate?

55 A rapidly scaling web application must store semi-structured product catalogs with varying attributes per item and requires horizontal scalability across many servers. Which database type best fits, and why is a rigid relational schema less ideal here?

56 A corporation needs an open-source relational DBMS known for strong standards compliance, advanced features like complex queries and extensibility, often preferred for data integrity in analytical workloads. Which system best matches?

57 A team must choose a DBMS for a small departmental application built primarily as a Windows desktop tool with an integrated forms/report designer, expecting only a handful of concurrent users. Which is the most fitting choice?

58 A query must find customers who have placed at least one order. Which construct is generally the most efficient and semantically correct when you only need existence, not the matched data?

59 In a client/server database architecture, why does placing the DBMS engine on the server rather than on each client generally improve integrity and consistency in a multi-user environment?

60 A table Employee(EmpID, DeptID, DeptName) where EmpID is the primary key, EmpID → DeptID, and DeptID → DeptName. This chain of dependencies violates which normal form, and what is the fix?