Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

314 DATA > MIDTERM > Flashcards

MIDTERM Flashcards

1
Q

 American National Standards Institute (ANSI)

A

One of two industry-accepted committees that sets standards for SQL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

 Attribute

A

A data field, or column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

 Bridging table

A

A table created to eliminate a many-to-many relationship between two tables.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

 Character

A

The basic unit of data. It can be a letter, number, or special symbol

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

 Candidate key

A

Any column that could be used as the primary key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

 Common column

A

A column that exists in two or more tables and contains equivalent data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

 Common field

A

A column that exists in two tables and is used to “join” two tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

 Composite key

A

A unique key that you create by combining two or more columns

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

 Data redundancy

A

Refers to having the same data in different places within a database, which wastes spaces and complicates database updates and changes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

 Database

A

Stores all organizational data in a central location

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

 Database administrator (DBA)

A

The person who is responsible for installing, administering, and maintaining the database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

 Database applications

A

Provide the interface that allows users to interact with the database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

 Database management system (DBMS)

A

An application that performs all routine data-handling operations.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

 Entity

A

An object about which you want to store data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

 Entity-Relationship (E-R) Model

A

A diagram that identifies the entities and data relationships in a database. The model is a logical representation of the physical system to be built.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

 Field

A

One attribute or characteristic of a database entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

 File

A

A group of records about the same type of entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

 First normal form (1NF

A

Data has primary key and no repeating groups

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Foreign key

A

A column in a table that is a primary key in another table; creates a relationship between the two tables.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

 Instance

A

A row, or record

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

 Key fields

A

Establish relationships among records in different tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

 Many-to-many (N:M) relationship

A

A relationship in which an instance can occur multiple times in each entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

 Normalization

A

Takes the raw data of an entity and evolves the data into a form that will reduce a database’s data redundancy.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

 One-to-many (1:M) relationship

A

A relationship in which an instance can only appear once in one entity, but one or more times in the other entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

 One-to-one (1:1) relationship

A

A relationship in which each occurrence of a specific entity is found only once in each set of data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

 Primary key

A

A column in a relational database table whose value must be unique for each row.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

 Record

A

A collection of fields describing the attributes of one database element. In PL/SQL, a record is a composite datatype that can assume the same structure as the row being retrieved.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

 Relational database

A

A database that stores data in a tabular format.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

 Relationships

A

Links that show how different records are related

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

 Row

A

A group of column values for a specific occurrence of an entity. In a database, records are commonly represented as rows.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

 Second normal form (2NF)

A

Data that is in 1NF and contains no partial dependencies.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

 Surrogate key

A

A column that you create to be the record’s primary key identifier.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

 SQL*Plus

A

A tool enabling users to interact with the database. Through SQL*Plus, users can enter SQL commands, set or alter environmental variables, display the structure of tables, and execute interactive scripts

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

 Structured query language (SQL)

A

The industry standard for interacting with a relational database. It is a data sublanguage, and unlike a programming language, it processes sets of data as groups and can navigate data stored within various tables.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

 Third normal form (3NF)

A

Data that is in 2NF and contains no transitive dependencies

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

 Unnormalized data

A

Data that does not have a primary key identified and/or contains repeating groups.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

 Character field

A

A field composed of nonnumeric data. This field will not display a heading longer than the width of the data stored in the field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

 Clause

A

Each section of a statement that begins with a keyword (SELECT clause, FROM clause, WHERE clause, etc.).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

 Column alias

A

Another name substituted for a column name. A column alias is created in a query and displayed in the results.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

 Concatenation

A

The combining the contents of two or more columns or character strings. Two vertical bars, or pipes (||), instruct Oracle 11g to concatenate the output of a query

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

 Keywords

A

Words used in a SQL query that have a predefined meaning to Oracle9i. Common keywords include SELECT, FROM, and WHERE.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

 Numeric column

A

A column composed of only numeric data. In output, the column will display the entire column heading, regardless of the width of the field. (Also known as a numeric field.)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

 Projection

A

Choosing specific column(s) in a SELECT statement.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
44
Q

 Query

A

A question posed to the database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
45
Q

 Relational database management system (RDBMS)

A

A software program used to create a relational database. It has functions that allow users to enter, manipulate, and retrieve data.

46
Q

 String literal

A

Alphanumeric data, enclosed within single quotation marks, that instructs the software to interpret “literally” exactly what has been entered and to show it in the resulting display

47
Q

 Syntax

A

The basic structure, pattern, or rules, for an SQL statement. For an SQL statement to execute properly, the correct syntax must be used.

48
Q

 Data definition language (DDL)

A

Commands, basically SQL commands, that create or modify database tables or other objects.

49
Q

 Database object

A

A defined, self-contained structure in Oracle 11g. Database objects include tables, sequences, indexes, and synonyms.

50
Q

 Datatype

A

Identifies the type of data Oracle9i will be expected to store in a column.

51
Q

 Schema

A

A collection of database objects owned by one user. By grouping objects according to the owner, multiple objects can exist in the same database that have the same object name.

52
Q

 Virtual column

A

A column value that is automatically generated based on the expression used to define the column.

53
Q

 Child table

A

A table having data that reference data within a parent table. Considered the “many” side in a one-to-many relationship.

54
Q

 Constraints

A

Rules that ensure the accuracy and integrity of data. Constraints prevent data that violate these rules from being added to tables. Constraints include PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, NOT NULL

55
Q

 Data dictionary

A

Oracle 11g stores all information about database objects in this “dictionary.” Stored information includes objects’ names, types, structures, owners, and the identity of users who have access to each object.

56
Q

 Referential integrity

A

When a user refers to something that exists in another table, the REFERENCES keyword is used to identify the table and column that must already contain the data being entered

57
Q

 Data manipulation language (DML)

A

Commands used to modify data. Changes to data made by DML commands are not accessible to other users until the data is committed.

58
Q

 Exclusive lock

A

When DDL operations are performed, Oracle 11g places this lock on a table so that no other user can alter the table or place a lock on it. See table locks.

59
Q

 Shared lock

A

A table lock that lets other users access portions of a table but not alter the structure of table. See table locks

60
Q

 Substitution variable

A

Instructs Oracle 11g to use a substituted value in place of a specific variable at the time a command is executed. Used to make SQL statements or PL/SQL blocks interactive.

61
Q

 Table locks

A

When DML commands are issued, Oracle 11g implicitly “locks” the row or rows being affected so that no other user can change the same data.

62
Q

 Transaction

A

A series of DML statements is considered to be one transaction. In Oracle 11g, a transaction is simply a series of statements that have been issued and not committed. The duration of a transaction is defined by when a COMMIT implicitly or explicitly occurs

63
Q

 Transaction control

A

Data control statements that either save modified data or undo uncommitted changes made in error.

64
Q

 Application cluster environment

A

A high-volume work environment in which multiple users simultaneously request data from a database.

65
Q

 Data dictionary

A

Oracle 11g stores all information about database objects in this “dictionary.” Stored information includes objects’ names, types, structures, owners, and the identity of users who have access to each object.

66
Q

 Database object

A

A defined, self-contained structure in Oracle 11g. Database objects include tables, sequences, indexes, and synonyms.

67
Q

 Dynamic view

A

Used to access statistics relating to the database’s performance. See view.

68
Q

 Function-based index

A

Can be used when a query is based on a calculated value or a function. See index.

69
Q

Index —

A

A separate database object that stores frequently referenced values so they can be quickly located. An index can either be created implicitly by Oracle 11g or explicitly by a user.

70
Q

 Private synonym

A

An alias used by an individual to reference objects owned by that individual. See synonym.

71
Q

 Public synonym

A

An alias that can be used by others to access an individual’s database objects. See synonym.

72
Q

 Sequence

A

A database object that generates sequential integers that can be used for an organization’s internal controls. A sequence can also serve as a primary key for a table.

73
Q

 Synonym

A

An alternative name given to a database object with a complex name. Synonyms can be either private or public.

74
Q

 Comparison operator

A

A search condition that indicates how data should relate to a given search value (equal to, greater than, less than, etc.). Common comparison operators include >, <, >=, and <= .

75
Q

 Condition

A

A portion of an SQL statement that identifies what must exist, or a requirement that must be met. When a query is executed, any record meeting the given condition will be returned in query results.

76
Q

 Equality operator

A

A search condition that evaluates data for exact, or equal, values. The equality operator symbol is the equal sign (=).

77
Q

 Logical operators

A

Used to combine two or more search conditions. The logical operators include AND and OR. The NOT operator reverses the meaning of search conditions.

78
Q

 NULL value

A

Means no value has been stored in that particular field. A NULL value indicates the absence of data, not a blank space.

79
Q

 Primary sort

A

When only one column is specified in the ORDER BY clause, data is ordered, or sorted, based on the data organization within the specified column.

80
Q

 Secondary sort

A

When two or more columns are specified in the ORDER BY clause, data in the second column (or additional columns) provide an alternative field on which to order data if an exact match occurs between two or more rows in the first, or primary, sort.

81
Q

 Wildcard characters

A

Symbols used to represent one or more alphanumeric characters. The wildcard characters in Oracle 11g are the percent sign (%) and the underscore symbol ( _ ). The percent sign is used to represent any number of characters; the underscore represents one character.

82
Q

 Cartesian join

A

Links table data so each record in the first table is matched with each individual record in the second table. Also called a Cartesian product or cross join.

83
Q

 Column alias

A

Another name substituted for a column name. A column alias is created in a query and displayed in the results.

84
Q

 Column qualifier

A

Indicates the table containing a referenced column.

85
Q

 Equality joins

A

Links table data in two (or more) tables having equivalent data stored in a common column. These joins might also be called equijoins, inner joins, or simple joins.

86
Q

 Inner joins

A

Joins that display data if there were a corresponding record in each table queried. Equality joins, non-equality joins, and self-joins are all classified as inner joins.

87
Q

 Non-equality join

A

Links data in two tables that do not have equivalent rows of data.

88
Q

 Outer join

A

Links data in tables that do not have equivalent rows. An outer join can be created in either the WHERE clause with an outer join operator (+) or by using the OUTER JOIN keywords.

89
Q

 Outer join operator

A

The plus (+) symbol enclosed in parentheses, used in an outer join operation.

90
Q

 Self-join

A

Links data within a table to other data within the same table. A self-join can be created with a WHERE clause or by using the JOIN keyword with the ON clause.

91
Q

 Set operators

A

Combine the results of two (or more) SELECT statements. Valid set operators in Oracle 11g are UNION, UNION ALL, INTERSECT, and MINUS.

92
Q

 Table alias

A

A temporary name for a table, given in the FROM clause. Table aliases are used to reduce memory requirements or the number of keystrokes needed when specifying a table throughout the SQL statement.

93
Q

 Argument

A

Values listed within parentheses in a function

94
Q

 Case conversion functions

A

Allow a user to temporarily alter the case of data stored in a column or character string.

95
Q

 Character functions

A

Used to change the case of characters or manipulate characters.

96
Q

 Function

A

A named PL/SQL block or predefined block of code that accepts zero or more input parameters and returns one value.

97
Q

 Julian date

A

Represents the number of days that have passed between a specified date and January 1, 4712, B.C.

98
Q

 Manipulation functions

A

Allow the user to control data (e.g., determine the length of a string, extract portions of a string) to yield a desired query output.

99
Q

 Single-row functions

A

Return one row of results for each record processed.

100
Q

 Dimension

A

Term used to describe any category used in analyzing data, such as time, geography, and product line.

101
Q

 Group functions

A

Process groups of rows, returning only one result per group of rows processed. Also called multiple-row functions and aggregate functions.

102
Q

 Normal distribution

A

When a large number of data values are obtained for statistical analysis, they tend to cluster around some “average” value. This dispersion of values is called normal distribution.

103
Q

 Standard deviation

A

A calculation used to determine how closely individual values are to the mean, or average, of a group of numbers.

104
Q

 Statistical group functions

A

Perform basic statistical calculations for data analysis. Oracle 11g’s functions include standard deviation and variance.

105
Q

 Correlated subquery

A

A subquery that references a column in the outer query. The outer query executes the subquery once for every row in the outer query.

106
Q

 Multiple-column subquery

A

A nested query that returns more than one column of results to the outer query. It can be listed in the FROM, WHERE, or HAVING clause.

107
Q

 Multiple-row subquery

A

Nested queries that return more than one row of results to the parent query. They are most commonly used in WHERE and HAVING clauses and require multiple-row operators.

108
Q

 Single value

A

The output of a single-row subquery

109
Q

 Single-row subquery

A

A nested subquery that can return to the outer query only one row of results that consists of only one column. The output of a single-row subquery is a single value.

110
Q

 Uncorrelated subquery

A

A subquery that follows this method of processing: the subquery is executed, then the results of the subquery are passed to the outer query, and finally the outer query is executed.

314 DATA (2 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions