Font size
WorksheetsISA245 Exam 1 Review (AI Generated)
Total questions: 110
Worksheet time: 2hrs 50mins
Anika is working on a project and needs to quickly find some data in the database. What type of query is she likely to use?
A pre-planned database query
A "spur-of-the-moment" question
A query that requires user authentication
A query that updates database schema
Aria and Kai are working on a project using a shared database. What does data inconsistency refer to?
Consistent data across all databases
A condition where different versions of the same data yield different results
Data that is always accurate
Data that is stored in multiple locations
Priya is working on a project where she needs to organize and manage a large amount of data efficiently. What tool should she use?
A collection of raw data
A program that manages database structure and access
A type of metadata
A data anomaly
Abigail is organizing her digital photo collection. She wants to add information about each photo, such as the date it was taken, the location, and the people in it. What is this type of information called?
Raw data that has not been processed
Data that describes other data
A type of database query
A database management system
Ethan is working on a project that involves data management. What is data management?
A process focusing on data collection, storage, and retrieval
A type of data inconsistency
A database query language
A form of data anomaly
Charlotte is working on a database project. What is data dependence?
Data that is independent of storage characteristics
A condition where data representation depends on physical storage
A type of data anomaly
A form of metadata
Kai is learning about databases and wants to know which DBMS component stores metadata and contains data definitions and their characteristics. Can you help Kai identify it?
Data independence
Data dictionary
Data redundancy
Query language
Arjun is working on a database system and wants to ensure that data access remains unaffected even if the physical storage characteristics change. What term describes this condition?
Data integrity
Data redundancy
Data independence
Structural dependence
Michael is managing a database for a library. What ensures that the data in the library's database complies with all entity and referential integrity constraints?
Data redundancy
Data integrity
Logical data format
Physical data format
In a university database, what is the term for when the same student information is stored unnecessarily in multiple departments?
Data dictionary
Data independence
Data redundancy
Structural independence
Ava is working on a project to create a new database for her company's inventory system. What is the process that yields the description of the database structure and determines the database components?
Database design
Query language
Data dictionary
Logical data format
Lily is working on a project where she needs to understand the way data is viewed within the context of her problem domain. What describes this perspective?
Physical data format
Logical data format
Structural dependence
Data integrity
Emma is working on a database project. What is a data characteristic where a change in the database schema affects data access?
Structural independence
Data redundancy
Structural dependence
Data dictionary
Ava is working on a project where she needs to ensure that changes in the database schema do not affect data access. What is this data characteristic called?
Structural independence
Data integrity
Logical data format
Data redundancy
Ethan is learning about how computers store data. What describes the way a computer 'sees' or stores data?
Logical data format
Physical data format
Data dictionary
Database design
In a university's database system, what defines and regulates the collection, storage, management, and use of student data?
Data dictionary
Database system
Query language
Data integrity
Rohan is working on a database project and needs to use a nonprocedural language to manipulate the data. Which language should he use?
Java
Python
SQL
C++
Liam is working on a project where he needs to create database and table structures, perform data manipulation, and query the database. Which database language should he use?
HTML
SQL
XML
CSS
Elijah is working on a project that requires a database stored in multiple locations. What type of database is he using?
A database stored on a single site
A database stored in two or more physically independent sites
A database that supports only one user
A database used for testing purposes
Arjun and Maya are working on a project that requires a database to support multiple concurrent users. What type of database should they use?
Single-user database
Multi-user database
Distributed database
Operational database
Mia is working on a project that requires her to manage real-time transaction data. What is an operational database also known as?
Analytical database
OLAP database
OLTP database
Historical database
Charlotte is designing a new app and needs to organize the data efficiently. What is a data model?
A simple list of data
A representation of a complex "real-world" data structure
A type of database
A programming language
Rohan is designing a database for a library. What is an entity in this database context?
A type of database
A characteristic of an object
A person, place, thing, concept, or event for which data can be stored
A database query
Anika is designing a database for her school project. She needs to define a characteristic of each student, such as their age or grade level. What is this characteristic called in a database?
A type of database
A characteristic of an entity or object
A database query
A programming language
In a school database, what is a relationship?
A type of database
An association between entities
A database query
A programming language
In a classroom, what does a one-to-many (1:M or 1..*) relationship represent between a teacher and students?
One teacher is associated with one student
One teacher is associated with many students
Many teachers are associated with one student
Many teachers are associated with many students
In a school, what is a many-to-many (M:N or *..*) relationship between students and clubs?
Association where one student is related to only one club.
Association where one student is related to many clubs, and vice versa.
Association where students and clubs are unrelated.
Association where students and clubs are hierarchically structured.
Grace has a library card that can be used by only one person. What type of relationship does this represent?
Association where one entity instance is associated with only one instance of the related entity.
Association where one entity is related to many occurrences of another entity.
Association where entities are unrelated.
Association where entities are hierarchically structured.
Scarlett is designing a database for her school project. What is a constraint in the context of data?
A logical construct perceived as a two-dimensional structure.
A restriction placed on data, usually expressed in the form of rules.
A description of a policy within an organization.
A collection of programs that manages a database.
During a meeting, Jackson mentioned a business rule. What is a business rule?
A logical construct perceived as a two-dimensional structure.
A restriction placed on data, usually expressed in the form of rules.
A description of a policy, procedure, or principle within an organization.
An early database model with an upside-down tree structure.
Aria is studying different types of database models. What is a hierarchical model?
A logical construct perceived as a two-dimensional structure.
A collection of programs that manages a relational database.
An early database model with an upside-down tree structure.
A description of a policy within an organization.
Samuel is working on a project that involves managing a large amount of data. What tool should he use to efficiently manage and organize this data?
A logical construct perceived as a two-dimensional structure.
A collection of programs that manages a relational database.
An early database model with an upside-down tree structure.
A description of a policy within an organization.
Isla is organizing her book collection. What is a table (relation) in the context of a relational model?
A graphical representation of a database
A collection of like entities
A two-dimensional structure of intersecting rows and columns
A diagram depicting entity relationships
Arjun is designing a database for a library. What does an Entity Relationship Diagram (ERD) depict in his model?
A row in a relational table
A collection of like entities
Entities, attributes, and relationships in a model
The 'many' side of a relationship
Lily is designing a database for her school's library system. What is the definition of connectivity in a relational model?
A row in a relational table
A collection of like entities
The type of relationship between entities
A graphical representation of a database
In a university database, what does Crow's Foot notation represent in an ER diagram when modeling the relationship between students and courses?
A row in a relational table
A collection of like entities
The 'many' side of a relationship
A two-dimensional structure of intersecting rows and columns
In a software development team, what is the basic modeling structure used by Aria to define the blueprint of objects in an object-oriented data model?
Class
Object
Method
Attribute
In a school, Luna is creating a digital model of a library book. What is an abstract representation of this book with a unique identity and embedded properties?
Class
Object
Method
Attribute
In a software development company, Ethan is tasked with managing a database that stores complex data types like multimedia files and user-defined data types. What type of database management system should he use?
Data in a relational database model
Data in a hierarchical database model
Data in an object-oriented database model
Data in a network database model
Abigail is designing a database for a library system. What is a semantic data model known for?
Modeling data in a hierarchical structure
Modeling data and their relationships in a single structure known as an object
Modeling data in a network structure
Modeling data in a tabular format
In a school, what is a class in object-oriented data modeling?
A single object with unique properties
A collection of similar objects with shared structure and behavior
A method for data processing
A data storage unit
Michael is organizing his book collection. What does a class hierarchy represent in this context?
A flat list of books
A network of interconnected books
A hierarchical tree where each parent category is a genre and each child category is a specific book
A random assortment of books
Arjun is learning about object-oriented programming. What is inheritance in the object-oriented data model?
The ability to create new classes
The ability of an object to inherit data structure and methods from classes above it
The ability to delete classes
The ability to modify data directly
Rohan is designing a new database for his company's inventory system. What does a conceptual model provide?
A detailed view of specific data objects
A global view of an entire database, describing main data objects
A view of data processing methods
A view of data storage techniques
Maya is working on a project to design a new database system for her company. She needs to create a conceptual schema. What is a conceptual schema?
A detailed list of data objects
A representation of the conceptual model, usually expressed graphically
A method for data processing
A data storage technique
Olivia is developing a new software application. What does software independence mean in this context?
A model that depends on specific software
A property of a model that does not depend on the software used to implement it
A model that requires constant software updates
A model that is software-specific
Priya is developing a software application. What is hardware independence in this context?
A condition where a model depends on specific hardware
A condition where a model does not depend on the hardware used
A model that requires specific hardware updates
A model that is hardware-specific
Sophia is designing a database for a new application. What is hardware independence in her database design?
Changes in hardware affect the database design at the conceptual level.
Changes in hardware do not affect the database design at the conceptual level.
Hardware changes require a complete redesign of the database.
Hardware independence means the database is software-dependent.
Abigail is working on a database project for her class. What is the purpose of logical design in database management?
To match the conceptual design to the requirements of the selected DBMS.
To create a physical model of the database.
To ensure hardware independence.
To develop user interfaces for the database.
In a university database system, what does the internal model represent?
The physical storage of data.
The database as 'seen' by the DBMS.
The user interface of the database.
The hardware configuration of the database.
What is logical independence in database systems?
The ability to change the internal model without affecting the conceptual model.
The ability to change the hardware without affecting the software.
The ability to change the user interface without affecting the database.
The ability to change the physical model without affecting the internal model.
What does the physical model describe in a database?
The logical structure of the database.
The software requirements for the database.
The physical characteristics such as location, path, and format for the data.
The conceptual design of the database.
What is physical independence in a database model?
A condition in which the physical model can be changed without affecting the internal model.
The application programmer's view of the data environment.
A data model that describes relationships among entities.
A named collection of related records.
What does an external model represent in a database environment?
The application programmer's view of the data environment.
The specific representation of an external view.
A row in a relational table.
A named collection of related fields.
What is an entity relationship model?
A data model that describes relationships (1:1, 1:M, and M:N) among entities at the conceptual level.
A condition in which the physical model can be changed without affecting the internal model.
An alphabetic or numeric character or group of characters that defines a characteristic.
A named collection of related records.
What is the SQL file extension?
.sql
.txt
.doc
.csv
What is a field in a database?
An alphabetic or numeric character or group of characters that defines a characteristic of a person, place, or thing.
A named collection of related records.
A row in a relational table.
A data model that describes relationships among entities.
What is a logical construct perceived to be a two-dimensional structure composed of intersecting rows and columns in the relational model?
Domain
Relation
Key
Entity Integrity
What is the construct used to organize and describe an attribute's set of possible values?
Primary Key
Domain
Foreign Key
Null
In the relational model, what is an identifier composed of one or more attributes that uniquely identifies a row?
Composite Key
Super Key
Primary Key
Null
What is the role of a key in the context of a database table, where "A determines B" indicates that knowing the value of attribute A means that the value of attribute B can be looked up?
Determination
Entity Integrity
Null
Foreign Key
What is an attribute, or set of attributes, that uniquely identify each entity in a table?
Composite Key
Super Key
Candidate Key
Domain
What is a multiple-attribute key called?
Primary Key
Composite Key
Foreign Key
Null
What are the attributes that form a primary key?
Key Attributes
Domain
Null
Foreign Key
What is a minimal super key that does not contain a subset of attributes that is itself a super key?
Composite Key
Candidate Key
Primary Key
Foreign Key
What is the property of a relational table that guarantees each entity has a unique value in a primary key and that the key has no null values?
Entity Integrity
Determination
Domain
Super Key
What is the absence of an attribute value, NOT blank?
Null
Domain
Foreign Key
Composite Key
What is an attribute or attributes in one table whose values must match the primary key in another table?
Foreign Key
Super Key
Composite Key
Null
What is Referential Integrity?
A condition where a foreign key must have a null entry or a matching entry in the related table.
A key used strictly for data retrieval purposes.
A detailed system data dictionary that describes all objects in a database.
An entity designed to transform an M:N relationship into two M:N relationships.
What is the purpose of a secondary key?
To trigger a required response or alert end users to specified conditions.
To be used strictly for data retrieval purposes.
To describe all objects in a database.
To implement an M:M relationship in a table.
What is a system catalog?
A set of allowable values for one or more attributes.
A detailed system data dictionary that describes all objects in a database.
An ordered array of index key values and row ID values.
A relationship found within a single entity type.
What is a linking table used for in the relational model?
To describe an association within an entity.
To implement an M:M relationship.
To transform an M:N relationship into two M:N relationships.
To lead to data location identified by the key.
What is a composite entity?
An entity designed to transform an M:N relationship into two M:N relationships.
A relationship found within a single entity type.
A set of allowable values for one or more attributes.
An ordered array of index key values and row ID values.
What is an index in a database?
A relationship found within a single entity type.
An ordered array of index key values and row ID values.
A set of allowable values for one or more attributes.
A key used strictly for data retrieval purposes.
What is a binary relationship in ER terms?
An association within an entity.
A relationship found within a single entity type.
An association between two entities, such as PROFESSOR teaches CLASS.
A set of allowable values for one or more attributes.
What is a ternary relationship in ER terms?
An association between two entities
An association between three entities
An association between four entities
An association between one entity
What does the relationship degree indicate?
The number of attributes in an entity
The number of entities or participants associated with a relationship
The number of relationships in a database
The number of keys in an entity
What is optional participation in a relationship?
One entity occurrence requires a corresponding entity occurrence
One entity occurrence does not require a corresponding entity occurrence
All entities must participate in the relationship
No entities can participate in the relationship
What defines a weak entity?
An entity that is independent and has its own primary key
An entity that displays existence dependence and inherits the primary key of its parent entity
An entity that has no attributes
An entity that is not part of any relationship
What is a strong (identifying) relationship?
A relationship where entities are independent
A relationship where the primary key of the related entity contains the primary key of the parent entity
A relationship with no primary keys
A relationship that does not involve any entities
What does cardinality classify?
The number of attributes in an entity
The classification of the relationship between entities
The number of tables in a database
The number of keys in a relationship
What is a derived attribute?
An attribute that can have many values for a single entity occurrence
An attribute that can be further subdivided to yield additional attributes
An attribute that can have only one value
An attribute derived by an algorithm, such as Age from birth date
Which attribute can have many values for a single entity occurrence?
Single-valued attribute
Multivalued attribute
Composite attribute
Derived attribute
What is a composite attribute?
An attribute that can have only one value
An attribute that is dependent on only a portion of the primary key
An attribute that can be further subdivided to yield additional attributes
An attribute derived by an algorithm
What is a partial diagram?
A representation of all data dependencies within a table
An attribute that is dependent on only a portion of the primary key
A condition in which an attribute is dependent on another attribute
A characteristic describing a group of multiple entries of the same type
What is a transitive dependency?
A condition in which an attribute is dependent on another attribute not part of the primary key
A representation of all data dependencies within a table
An attribute that can be further subdivided to yield additional attributes
An attribute that can have many values for a single entity occurrence
What is a repeating group in a relation?
A representation of all data dependencies within a table
A characteristic describing a group of multiple entries of the same type for a single key attribute occurrence
An attribute that can have only one value
An attribute derived by an algorithm
What does a dependency diagram represent?
A condition in which an attribute is dependent on another attribute
A representation of all data dependencies (primary key, partial, or transitive) within a table
An attribute that can be further subdivided to yield additional attributes
An attribute that can have many values for a single entity occurrence
What is the First Normal Form (1NF)?
The second stage in the normalization of a relational database
A representation of all data dependencies within a table
The first stage in the normalization process, with no repeating groups and a primary key identified
An attribute that can have many values for a single entity occurrence
What is the Second Normal Form (2NF)?
The first stage in the normalization process
The second stage in the normalization of a relational database in which all non-key attributes are dependent on the primary key
A representation of all data dependencies within a table
An attribute that can be further subdivided to yield additional attributes
What is a determinant in a database?
An attribute that forms a primary key
An attribute that is not part of a key
Any attribute in a specific row whose value directly determines other values in that row
A process that assigns attributes to entities
What is Third Normal Form (3NF) in database normalization?
A table is in 3NF when it is in 2NF and no nonkey attribute is functionally dependent on another nonkey attribute
A table is in 3NF when it has a primary key
A table is in 3NF when it has no attributes
A table is in 3NF when it is in 1NF
What is a key attribute?
An attribute that is not part of a key
The attributes that form a primary key
Any attribute in a specific row
A process that assigns attributes to entities
What is normalization in databases?
A process that assigns attributes to entities so that data redundancies are reduced or eliminated
A process that increases data redundancy
A process that creates more tables
A process that removes all keys
What is the minimum number of relationships needed to connect tables?
Equal to the number of tables
One less than the number of tables
Twice the number of tables
Half the number of tables
What is a field?
A collection of information
A single item of information
A list of information
A group of records
A collection of fields and records in a specific category
Record
Table
Field
What is a record in a database?
A unique ID that identifies an entry
A column in a database table
A collection of related data about a particular item or entity
A row in a database table
What is the primary purpose of a query in a database?
To input data
To retrieve data
To delete data
To backup data
Which concept highlights the importance of maintaining consistent and valid data in a Database System?
(A) Data redundancy
(B) Data normalization
(C) Data Integrity
(D) Data replication
Database forms structure data input to ensure data ________.
language
integrity
information
control
An organized collection of structured information, or data, typically stored electronically in a computer system.
database
record
primary key
foreign key
Repetition of data is called data ..............
dependance
redundancy
inconsistency
isolation
Data about data is ______________
Data Description
Metadata
Data redundancy
Data inconsistency
Which of the following is NOT a benefit of metadata?
It can be changed without impacting the primary data
Used for sorting and filtering information
Increases effective use of data by providing extra information
Increases search speeds of the database
