NEW
Font size
WorksheetsDH20x Week 5 (textbook-glossary)
Total questions: 20
Worksheet time: 12mins
Database - is an organized collection of ____________, or data, typically stored electronically in a computer system.
structured information
unstructured information
structured facts and opinions
columns and rows
Relational Database - a relational database is a type of database that stores and provides access to ______________________.
user accounts and administration tools
metadata related to culture artifacts
data points that depended on facts
data points that are related to one another
A column (or set of columns) whose values uniquely identify each row in a table.
Primary key
Foreign key
Surrogate key
Composite key
This key is formed when more than one column in a table is merged to constitute the primary key.
Complex key
Foreign key
Surrogate key
Composite key
When multiple copies of the same data have conflicting values because not all copies have been updated correctly.
Data Redundancy
Data Inconsistency
Data Integrity
Data Accuracy
Unnecessary duplication of data across multiple locations, leading to errors and wasted storage.
Data Redundancy
Data Inconsistency
Data Integrity
Data Accuracy
The accuracy, consistency, and reliability of data over its entire life cycle.
Data Completeness
Data Cyclicity
Data Integrity
Data Accuracy
The reliability and correctness of data.
Data Completeness
Data Cyclicity
Data Fairness
Data Accuracy
Which is the example of Camel Case naming?
correct_answer_is_here
CorrectAnswerIsHere
correctAnstwerIsHere
correct ANSWER is HERE
Which is the example of Pascal Case naming?
correct_answer_is_here
CorrectAnswerIsHere
correctAnstwerIsHere
correct ANSWER is HERE
They ensure the physical database is working properly by monitoring performance and managing security access and other standards. They also perform routine maintenance activities regarding the database.
System Administrator
Database Administrator
Customer
Information Architect
Database Security - the practice of ensuring that every user in the database system cannot access all the data, requiring delegation and specific ____________, often with a password.
access denial
access preferences
access level
access permissions
Indexed file organization is designed to provide __________ to records based on key values.
secure access
reliable access
quick random access
simultaneous access
The ______________ is a structure that describes in a formal language the association of data as a blueprint of how the database can be constructed.
database type
DBMS
SQL query
database schema
Which of the following are NOT properties of relations in a database?
Each table in a database has a unique identity (name).
Any entry at the connection of each row and column has a single value. There can be only one value that is related with each attribute on a specific row of a table; no multivalued attributes are allowed in a relation.
Each row is unique; no two rows or tables in the same relation can be identical.
Each attribute (or column) within a table has a unique name.
The sequence of columns (left to right) is significant.
The sequence of rows (top to bottom) is significant.
A technique in database design used to organize tables in a way that reduces redundancy and dependency of data.
ER Mapping
Normalization
Attribute Definition
Key validation
In a sequential file organization,
the records in the file are stored in sequence according to a primary key value
records are stored either sequentially or nonsequentially, and an index is created that allows the application software to locate individual records
hashing and indexing are used
several rows of related tables to be joined together and store the same amount of units of storage (data block)
What are the column/columns in the following SQL query?
SELECT StudentName, Grade FROM Student
SELECT, FROM
StudentName, Grade, Student
StudentName, Grade
Student
A data dictionary in database is a file or a set of files that contains a database's _____.
keys
entities
records
metadata
What are data types here?
integer, real, character
pdf, docx, rtf
image, video, audio, hypertext
graph, document, wide column, key-value
