WGU - C175 - Flash Cards

3 Vs correct answers Three basic characteristics of Big Data databases: volume, velocity, and variety. abstract data type (ADT) correct answers Data type that describes a set of similar objects with shared and encapsulated data representation and methods. A(n)___ is generally used to describe complex objects. See also class. ad hoc query correct answers A "spur-of-the-moment" question. alias correct answers An alternative name for a column or table in a SQL statement. ALTER TABLE correct answers The SQL command used to make changes to table structure. When the command is followed by a keyword (ADD or MODIFY), it adds a column or changes column characteristics. American National Standards Institute (ANSI) correct answers The group that accepted the DBTG recommendations and augmented database standards in 1975 through its SPARC committee. analytical database correct answers A database focused primarily on storing historical data and business metrics used for tactical or strategic decision making. AND correct answers The SQL logical operator used to link multiple conditional expressions in a WHERE or HAVING clause. It requires that all conditional expressions evaluate to true. application programming interface (API) correct answers Software through which programmers interact with middleware. A(n)___ allows the use of generic SQL code, thereby allowing client processes to be database server-independent. atomic attribute correct answers An attribute that cannot be further subdivided to produce meaningful components. For example, a person's last name attribute cannot be meaningfully subdivided. atomicity correct answers The transaction property that requires all parts of a transaction to be treated as a single, indivisible, logical unit of work. All parts of a transaction must be completed or the entire transaction is aborted. attribute correct answers A characteristic of an entity or object. A(n)___ has a name and a data type. availability correct answers In the context of data security, it refers to the accessibility of data whenever required by authorized users and for authorized purposes. AVG correct answers A SQL aggregate function th