WGU C170 Terms With Complete Solution
Associative Entity Ans- All relationships for the (...) entity should be many.
Attribute Ans- An (...) is a property or characteristic of an entity.
Binary relationship Ans- A (..
...
WGU C170 Terms With Complete Solution
Associative Entity Ans- All relationships for the (...) entity should be many.
Attribute Ans- An (...) is a property or characteristic of an entity.
Binary relationship Ans- A (...) is a relationship between two entity types.
Cardinality Ans- (...) represents the maximum number of entities that can be involved in a particular
relationship.
Cascade Delete Ans- Will delete all records that reference the primary key
Database Ans- A (...) is a collection of information that is organized so that it can easily be accessed,
managed, and updated.
E-R model Ans- An (...) is a data model for describing a database in an abstract way.
Entity Ans- An (...) is an object or event in our environment that we want to keep track of.
Intersection Data Ans- Associated with the concatenation of two segments
Modality Ans- (...) represents the minimum number of entity occurrences that can be involved in a
relationship.
Ternary Relationship Ans- A (...) relationship is when three entities participate in the relationship.
Unary Relationships Ans- (...) relationships associate occurrences of an entity type with other
occurrences of the same entity type.Unique Identifier Ans- A (...) is any identifier which is guaranteed to be unique among all identifiers used
for those objects and for a specific purpose.
Data encryption Ans- When data is (...), it is changed, bit by bit or character by character, into a form
that looks totally garbled. It can and must be reconverted, or decrypted, back to its original form to be
of use.
Data normalization Ans- Is a methodology for organizing attributes into tables so that redundancy
among the non-key attributes is eliminated.
Data volatility Ans- Describes how often stored data is updated.
Data Volume Assessment Ans- Understanding of how much data will be in a database or a table within a
database
Denormalization Ans- The act of duplicating data in a database for performance or the preservation of
historical information
Disaster recovery Ans- Involves rebuilding an entire information system or significant parts of one after a
catastrophic natural disaster such as a hurricane, tornado, earthquake, building collapse, or even a
major fire
Index Ans- Used to help a DBMS find data quickly
Logical view Ans- Is a mapping onto a physical table or tables that allows an end user to access only a
specified portion of data.
Response time Ans- Is the delay from the time that the Enter Key is pressed to execute a query until the
result appears on screen.
Throughput Ans- Is the measure of how many queries from simultaneous users must be satisfied in a
given period of time by the application set and the database that it supports.Client/server architecture Ans- (...) architecture is a network architecture in which the server manages
services consumed by the client. It is also known as two-tier architecture.
Database directory Ans- (...) is an organized repository of databases that stores attributes such as the
database character set and collation.
GUI (graphical user interface) Ans- (...) is a computer program that enables a user to communicate with
a computer through the use of graphical icons.
MySQL Ans- (...) is an open source RDBMS based on SQL (structure query language) and used for adding,
removing, and modifying information in the database.
Option file Ans- (...) is an appropriate way of specifying commonly used options on the command line
while executing a program.
RDBMS (relational database management system) Ans- (...) is a program that lets you create, update,
and administer a relational database.
Schema Ans- In a relational database, a (...) defines tables, fields in each table, and relationships
between fields and tables.
DB2 Ans- (...) is a relational database management system product from IBM that serves a number of
operating system platforms.
DCL Ans- (...) is used to control access to data stored in a database.
DDL Ans- (...) - involves instructing the DBMS software on what tables will be in the database, what
attributes will be in the tables, which attributes will be indexed, and so forth.
DML Ans- (...) refers to the four basic operations that can and must be performed on data stored in any
DBMS: data retrieval, data update, insertion of new records, and deletion of existing records.EER (enhanced entity-relationship) diagram Ans- (...) is a conceptual data model incorporating
extensions to the original entity-relationship model used in the design of databases.
SQL Ans- Is a comprehensive database management language which incorporates DML and DDL
BLOB (binary large objects) Ans- (...) is a collection of binary data stored as a single entity in a database
management system. It holds up to 65,535 bytes of data.
ENUM Ans- (...) is a special data type that enables for a variable to be a set of predefined constants.
REAL Ans- (...) is a numerical data which contains decimal numbers. MySQL treats ... as a synonym for
DOUBLE, unless the REAL_AS_FLOAT SQL mode is enabled.
SET Ans- (...) is a string object that can have zero or more values (up to 64 items).
TEXT Ans- (...) data type holds a string with a maximum length of 65,535 characters.
TIMESTAMP Ans- (...) is a special data type provided by MYSQL that enables you to track when changes
were last made to a row.
VARCHAR Ans- (...) data type holds a variable length string (up to 255 characters) that contains letters,
numbers, and special characters.
Definer Ans- (...) is a MySQL term where AuthID is the same for another DBMS
Event Ans- (...) is an entity that executes on a time-activated basis according
[Show More]
