Database Management System Concepts

16 Questions

Match the following database concepts with their descriptions:

Data Definition Language = Used for defining database schema Data Manipulation Language = Used for querying and modifying database data Data Model = Represents the structure of the database Data Warehouse = Central repository for data

Match the following database components with their functions:

Attribute = A column in a database table Entity = A thing or concept represented in the database Entity Set = A collection of entities Relationship Set = A connection between entities

Match the following join types with their descriptions:

Inner Join = Returns only matching rows from both tables Equi Join = A type of inner join using a common column Semi Join = Returns rows from one table where joined rows exist Anti Join = Returns rows from one table where joined rows do not exist

Match the following database normalization forms with their descriptions:

First Normal Form = Each row has a unique combination of values Third Normal Form = Each non-key column depends on the entire primary key Atomicity = Ensures that database transactions are treated as a single unit Isolation = Each transaction operates independently

Match the following database constraints with their descriptions:

Foreign Key = A field in a table that refers to the primary key of another table Referential Integrity Constraint = Ensures that a foreign key value exists in another table Value-Based Constraint = Restricts the values that can be entered in a field Prime Attribute = A key attribute in a functional dependency

Match the following database query concepts with their descriptions:

Subquery = A query nested inside another query Algebraic Query = A query expressed using algebraic operators Single-Tuple Subquery = A subquery that returns a single value Nested Loop = An algorithm for evaluating queries

Match the following database design concepts with their descriptions:

Entity-Relationship Diagram = A visual representation of database design Entity-Relationship Model = A conceptual representation of database design Schema = The overall structure of a database Data Graph = A graph representing data relationships

Match the following database administration concepts with their descriptions:

Authorization = Granting privileges to users Privilege = A specific right to perform a database operation Recovery Manager = A component that manages database recovery Tuning Advisor = A tool that provides performance optimization advice

Match the database concept with its description:

Normal form = Type of database organization Relational model = Method of organizing data into tables Query language = Language used to perform database operations Tuple = Single entry in a database table

Match the database term with its definition:

Join = Operation combining two or more tables Selection = Operation filtering data based on conditions Closure = Property of an operation that produces a result in the same domain Commutativity = Property of an operation that produces the same result regardless of the order of the operands

Match the database concept with its purpose:

Constraint = Rule that limits the data that can be inserted into a table Index = Data structure that improves query performance View = Virtual table based on a query Key = Column or set of columns that uniquely identifies a row

Match the database operation with its description:

Inner join = Combining two tables based on a common column Outer join = Combining two tables with missing values Intersection = Finding common elements between two tables Union = Combining two tables into a single result

Match the database term with its definition:

Redundancy = Duplication of data in a database Reflexivity = Property of a relation that is always true for a given element Transitivity = Property of a relation that is always true for a given order Predicate = Boolean expression that evaluates to true or false

Match the database concept with its application:

Quantifier = Used in query languages to specify the scope of a variable Expression tree = Data structure used to represent a query Materialized view = Physical representation of a view SQL query = Query written in Structured Query Language

Match the database term with its definition:

Serialization = Process of converting data into a format for storage Aggregation = Operation combining multiple values into a single value Dangling tuple = Row in a table that does not have a matching row in another table

Match the database concept with its characteristic:

Multivalued dependency = Dependency between multiple attributes Multi-attribute key = Key that consists of multiple columns Bag semantics = Method of treating duplicate rows in a table Non-trivial = Property of a relation that is not always true

Study Notes