DBMS Flashcards (95 cards)

All cards

1Question

What is a database?

Answer

An organized collection of related data.

2Question

What software defines, creates, stores, retrieves, updates, and controls access to a database?

Answer

A Database Management System (DBMS).

3Question

What does a DBMS do to reduce data problems?

Answer

It reduces unnecessary data redundancy and inconsistency.

4Question

How does a DBMS protect data access?

Answer

It provides security and authorization.

5Question

How do DBMSs differ from file systems in managing data?

Answer

DBMSs provide integrated data management with controlled redundancy, authorization, data independence, and transaction, concurrency, and recovery facilities.

6Question

What does data abstraction do?

Answer

It hides unnecessary storage details and presents data at different levels.

7Question

What schemas make up the three-schema architecture?

Answer

External schemas, one conceptual schema, and an internal schema.

8Question

How does the relational data model represent data?

Answer

As tables with rows and columns.

9Question

What is a business rule?

Answer

A statement defining or restricting how an organization operates.

10Question

What is a transaction?

Answer

A logical unit of work containing one or more database operations.

11Question

What does the database design process collect before creating an ER design?

Answer

Requirements and business rules.

12Question

What is an entity?

Answer

A distinguishable real-world object.

13Question

What does an attribute describe?

Answer

An entity.

14Question

What does a relationship represent in an ER model?

Answer

An association between entities.

15Question

What does a 1:1 relationship allow each entity to relate to on the other side?

Answer

At most one entity.

16Question

What does an M:N relationship allow entities on both sides to do?

Answer

Relate to many entities on the other side.

17Question

What does total participation require of every entity in an entity set?

Answer

It must participate in the relationship.

18Question

What is the primary key of ENROLLMENT(StudentID, CourseID, EnrollDate)?

Answer

(StudentID, CourseID).

19Question

How is STUDENT ENROLLS_IN COURSE represented in the example?

Answer

As M:N relationship table ENROLLMENT(StudentID, CourseID, EnrollDate).

20Question

What is a weak entity?

Answer

An entity that cannot be uniquely identified by its own attributes and depends on an owner strong entity.

21Question

In a relation, what does each row represent?

Answer

A tuple.

22Question

What makes a candidate key different from a super key?

Answer

A candidate key is a minimal super key.

23Question

What does entity integrity prohibit for primary keys?

Answer

NULL values.

24Question

What does an insertion anomaly prevent?

Answer

Adding one fact without another unrelated fact.

25Question

What does a functional dependency X→YX \to Y mean?

Answer

Each value of XX determines exactly one value of YY.

26Question

When is a relation in 1NF?

Answer

When every cell contains one atomic value, with no repeating groups or multivalued fields.

27Question

What dependency must every non-prime attribute have on each candidate key for 2NF?

Answer

Full dependency on every candidate key.

28Question

What formal condition defines 3NF for every non-trivial X→AX \to A?

Answer

XX is a superkey or AA is a prime attribute.

29Question

Who proposed rules for relational DBMSs?

Answer

Codd.

30Question

What does Codd’s Rule 0 require a relational DBMS to do?

Answer

Manage the database entirely through its relational capabilities.

31Question

What does Codd’s dynamic online catalog rule require?

Answer

Relational metadata must be queryable.

32Question

What does Codd’s view-updatability rule require?

Answer

Theoretically updatable views must be updatable.

33Question

What operations must Codd’s set-level rule support?

Answer

Set-level insert, update, and delete.

34Question

What kind of query language is relational algebra?

Answer

A procedural query language specifying operations to obtain a required relation.

35Question

What does relational algebra’s selection operator choose?

Answer

Rows satisfying a condition.

36Question

What does relational algebra’s projection operator choose?

Answer

Columns.

37Question

What condition does a theta join use?

Answer

A general condition.

38Question

What rows does an inner join return?

Answer

Only matching rows.

39Question

What does division R÷SR \div S return from R(A,B)R(A,B)?

Answer

The AA values associated with every required BB value in S(B)S(B).

40Question

What kind of query language is relational calculus?

Answer

A non-procedural query language based on predicate logic.

41Question

What does the TRC expression {t∣P(t)}\{t \mid P(t)\} represent?

Answer

Tuples tt for which predicate P(t)P(t) is true.

42Question

What do variables represent in Domain Relational Calculus?

Answer

Individual attribute values rather than whole tuples.

43Question

What does a database constraint do to stored data?

Answer

It restricts stored data to help maintain validity and consistency.

44Question

What must be true of a primary key under entity integrity?

Answer

It must never be NULL.

45Question

What must a foreign key reference under referential integrity?

Answer

An existing key value, or NULL if permitted.

46Question

What is a view in a database?

Answer

A named query that behaves like a virtual table.

47Question

What must happen to materialized view results when underlying data changes?

Answer

The results must be refreshed.

48Question

What components make up a database system?

Answer

The database, DBMS software, applications, users, and hardware.

49Question

Which software are examples of DBMSs?

Answer

MySQL, Oracle Database, PostgreSQL, Microsoft SQL Server, and SQLite.

50Question

What is one staffing limitation of a DBMS?

Answer

It requires trained staff.

51Question

What can happen when a DBMS fails?

Answer

The failure can affect many users.

52Question

What does the internal or physical level describe?

Answer

How data is stored, including files, indexes, and storage blocks.

53Question

What does the conceptual or logical level describe?

Answer

Stored data, its attributes, relationships, and constraints.

54Question

What does the external or view level present?

Answer

The database portion required by a particular user or application.

55Question

What does a query processor do with SQL?

Answer

It parses, validates, and optimizes SQL, then executes the query plan.

56Question

What metadata does a data dictionary or catalog store?

Answer

Metadata such as table definitions, columns, constraints, and users.

57Question

How does the hierarchical data model organize data?

Answer

As a tree of parent-child relationships.

58Question

What does the ER model represent for conceptual design?

Answer

Entities, attributes, and relationships.

59Question

What structures do semi-structured data models commonly use?

Answer

Flexible structures such as JSON or XML documents.

60Question

What are basic building blocks used by data models?

Answer

Entities or objects, attributes or properties, relationships, constraints, and operations.

61Question

Which database constraints can implement business rules?

Answer

PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL, and CHECK constraints.

62Question

What is an entity set?

Answer

A collection of similar entities.

63Question

What does a key attribute do in an ER model?

Answer

It uniquely identifies an entity.

64Question

What does a rectangle denote in common ER notation?

Answer

An entity.

65Question

What does an underlined attribute denote in common ER notation?

Answer

A key.

66Question

Where is InstructorID stored when each course has one instructor?

Answer

As a foreign key in COURSE.

67Question

Which attributes identify a DEPENDENT weak entity in the example?

Answer

EmployeeID and DependentName.

68Question

What does a relation’s degree measure?

Answer

Its number of attributes.

69Question

What does a relational database schema collect?

Answer

Relation definitions and their constraints.

70Question

In STUDENT(StudentID, Email, Name), what is Email if StudentID is primary?

Answer

An alternate key.

71Question

What does a CHECK constraint require?

Answer

A specified condition must be satisfied.

72Question

What does a DEFAULT constraint provide when no value is supplied?

Answer

A default value.

73Question

What does good relational design minimize?

Answer

Duplicated facts.

74Question

Why does a Student table storing PhoneNumbers as “111, 222” violate 1NF?

Answer

The PhoneNumbers field contains multiple values.

75Question

Which attributes have partial dependencies in the stated ENROLLMENT example?

Answer

StudentName depends on StudentID; CourseName depends on CourseID.

76Question

Which Codd rule represents all information as table values?

Answer

The Information rule.

77Question

Which Codd rule guarantees access to every atomic value by table, primary key, and column?

Answer

The Guaranteed access rule.

78Question

What does Codd’s NULL rule require for missing or inapplicable information?

Answer

Consistent handling.

79Question

What does relational algebra’s closure property guarantee about its operators?

Answer

They take relations as input and produce a relation as output.

80Question

What does relational algebra’s set difference R−SR - S return?

Answer

Rows in RR but not in SS.

81Question

What must be compatible for relational algebra’s union, intersection, and difference?

Answer

The relations must have the same number of attributes and compatible corresponding domains.

82Question

What does a join combine from two relations?

Answer

Related tuples.

83Question

Which rows does a right outer join retain?

Answer

All right rows and matching left rows.

84Question

What does a cross join pair with every left row?

Answer

Every right row.

85Question

Which students does ENROLLED÷REQUIRED\text{ENROLLED} \div \text{REQUIRED} return?

Answer

Students enrolled in every course listed in REQUIRED.

86Question

What does grouping do to tuples with identical grouping-attribute values?

Answer

It collects them into groups.

87Question

Which student tuples does {t∣STUDENT(t)∧t.Marks>70}\{t \mid STUDENT(t) \land t.Marks > 70\} return?

Answer

Student tuples with marks greater than 70.

88Question

What does the given DRC expression return for students scoring above 70?

Answer

The names of students scoring more than 70.

89Question

What does relational calculus use to express queries?

Answer

Predicates, variables, quantifiers, and logical conditions.

90Question

What does relational algebra make explicit that relational calculus does not?

Answer

The operational sequence of query operations.

91Question

What must a safe relational-calculus query produce?

Answer

A finite result based on values in the database.

92Question

What do domain constraints require of data values?

Answer

Values must have the correct type or range.

93Question

What range can a business-defined constraint require for Marks?

Answer

Marks can be required to be between 0 and 100.

94Question

What does the relational algebra operator ρ do?

Answer

It renames a relation or its attributes.

95Question

What tuples does relational algebra intersection R ∩ S return?

Answer

The tuples common to both relations.

Test yourself with the quiz

Answer 37 questions on DBMS.

1. Which statements accurately distinguish a database from a DBMS?

2. A database architect is assigning responsibilities across the three-schema architecture. Which statements are correct?

Take the quiz →

Read the study guide

Go over the full study guide for DBMS.

Read the study guide →

Related classes

Make your own flashcards

Upload your class notes and Revizly writes your flashcards in about a minute.

Flashcard maker