D426 Data Management - r r r r r r
Foundation Objective Assessment Practice Exa
r r r r r r r r r r
1.Database Application: Software that helps business users interact with rr rr rr rr rr rr rr rr rr
data- base systems. rr rr
2.Database Administrator: The individual who is responsible for safeguardin rr rr rr rr rr rr rr rr
g the database system against unauthorized access and enforcing proced
rr rr rr rr rr rr rr rr rr
ures for user access and system availability.
rr rr rr rr rr rr
3.Database Designer: Determines the format of each data element and the rr rr rr rr rr rr rr rr rr rr rr
overall database structure. rr rr
4.Authorization: Many database users should have limited access to speci rr rr rr rr rr rr rr rr rr
fic tables, columns, or rows of a database. Database systems use this to gra
rr rr rr rr rr rr rr rr rr rr rr rr rr
nt individual users access to specific data.
rr rr rr rr rr rr
5.Query Processor: Interprets queries, creates a plan to modify the datab
rr rr rr rr rr rr rr rr rr rr
ase or retrieve data, and returns query results to the application
rr rr rr rr rr rr rr rr rr rr
6.Rules: Database systems ensure data is consistent with structural and b
rr rr rr rr rr rr rr rr rr rr
usiness rules. rr
7.What does the query processor perform?: Query optimization to ensure t
rr rr rr rr rr rr rr rr rr rr
he most efficient instructions are executed on the data.
rr rr rr rr rr rr rr rr
8.Storage Manager: Translates the query processor instructions into low-rr rr rr rr rr rr rr rr
level file system commands that modify or retrieve data.
rr rr rr rr rr rr rr rr
9.Indexes: Database sizes range from megabytes to many terabytes, so th rr rr rr rr rr rr rr rr rr rr
e stor- age manager uses indexes to quickly locate data.
rr rr rr rr rr rr rr rr rr
10.Transaction Manager: The transaction manager ensures efficient trans rr rr rr rr rr rr rr
action execution, prevents conflicts between concurrent transactions, an
rr rr rr rr rr rr rr
d restores the database to a consistent state in case of a transaction or sy
rr rr rr rr rr rr rr rr rr rr rr rr rr rr
stem failure. rr
11.Metadata: Is data about the database, such as column names and the n rr rr rr rr rr rr rr rr rr rr rr rr
umber of rows in each table. rr rr rr rr rr
12.Relational Database: Stores data in tables, columns, and rows, similar rr rr rr rr rr rr rr rr rr
to a spreadsheet.
rr rr rr
13.SQL Query Language: All relational database systems support this.
rr rr rr rr rr rr rr rr
14.Relational systems are ideal for databases that require....: An accurate rr rr rr rr rr rr rr rr rr rr
record of every transaction, such as banking, airline reservation syste
rr rr rr rr rr rr rr rr rr
ms, and student records.
rr rr rr
15.NoSQL: A nonrelational database. rr rr rr
16.INSERT: Inserts rows into a table. rr rr rr rr rr
17.SELECT: Retrieves data from a table. rr rr rr rr rr
18.UPDATE: Modifies data in a table. rr rr rr rr rr
19.DELETE: Deletes rows from a table. rr rr rr rr rr
20.CREATE TABLE: Statement creates a new table by specifying the tabl rr rr rr rr rr rr rr rr rr rr
e and column names.
rr rr rr
1rr/rr17
, D426 Data Management - r r r r r r
Foundation Objective Assessment Practice Exa
r r r r r r r r r r
21.Data Type: Indicates the format column names. These can be numerical,
rr rr rr rr rr rr rr rr rr rr
textual or complex.
r rr rr
22.INT: Stores integer values. rr rr rr
23.DECIMAL: Stores fractional numeric values. rr rr rr rr
24.VARCHAR: Stores textual values. rr rr rr
25.DATE: Stores year, month, and day. rr rr rr rr rr
26.The Analysis Phase: Specifies database requirements without regard to
rr rr rr rr rr rr rr rr
a specific database system. Requirements are represented as entities, rel
r rr rr rr rr rr rr rr rr rr
ationships, and attributes. rr rr
27.Analysis: Has many alternative names, conceptual design, entity- rr rr rr rr rr rr rr
relationship modeling, and requirements definition. rr rr rr rr
28.What shape represents an Entitiy?: Rectanglerr rr rr rr rr
29.Logical Design Phase: Implements database requirements in a specific
rr rr rr rr rr rr rr rr rr
data-
base system. For relational database systems, it converts entities, relation
rr rr rr rr rr rr rr rr rr rr
ships, and attributes into tables, keys, and columns.
rr rr rr rr rr rr rr
30.Physical Design Phase: Adds indexes and specifies how tables are organ rr rr rr rr rr rr rr rr rr rr
ized on storage media with SQL statements such as CREATE INDEX and is s
rr rr rr rr rr rr rr rr rr rr rr rr rr
pecific to a database system. rr rr rr rr
31.Data Independence: The principle that physical design never affects
rr rr rr rr rr rr rr rr rr
query results rr
32.MySQL Command- rr
Line Client: A text interface that is included in the MySQL Server download.
rr rr rr rr rr rr rr rr rr rr rr rr
33.Error Code: Generated when a SQL statement is syntactically incorrect
rr rr rr rr rr rr rr rr rr rr
or the database cannot execute the statement.
rr rr rr rr rr rr
34.Data Structures: Prescribes how data is organized.
rr rr rr rr rr rr
35.Table, Column, Row, & Data Type: Data structures that organizes data in ta
rr rr rr rr rr rr rr rr rr rr rr rr
le.
36.Tuple: An ordered collection of elements is enclosed in parentheses suc
rr rr rr rr rr rr rr rr rr rr
h as (a, b, c) and (a, b, c).
rr rr rr rr rr rr rr rr
37.Rules: Governs valid data. rr rr rr
38.Table: Has a name, a fixed tuple of columns, and a varying set of rows.
rr rr rr rr rr rr rr rr rr rr rr rr rr rr
39.Column: Has a name and a data type. rr rr rr rr rr rr rr
40.Row: An unnamed tuple of values. Each value corresponds to a colum
rr rr rr rr rr rr rr rr rr rr rr
n and belongs to the column's data type.
rr rr rr rr rr rr rr
41.Data Type: A named set of values, from which column values are drawn.
rr rr rr rr rr rr rr rr rr rr rr rr
42.Select: Selects a subset of rows of a table. rr rr rr rr rr rr rr rr
43.Join: Combines two tables by comparing related columns.
rr rr rr rr rr rr rr
44.Union: Selects all rows of two tables. rr rr rr rr rr rr
2rr/rr17
, D426 Data Management - r r r r r r
Foundation Objective Assessment Practice Exa
r r r r r r r r r r
45.Aggregate: Performs a calculation on a set of values and returns a single rr rr rr rr rr rr rr rr rr rr rr rr rr
result. They are commonly used to summarize or analyze data, such as cal
rr rr rr rr rr rr rr rr rr rr rr rr
culating sums, averages, counts, or finding maximum or minimum values
rr rr rr rr rr rr rr rr rr rr
within a dataset. rr rr
46.Logical Constraints: Rules that ensure data is valid. rr rr rr rr rr rr rr
47.Business Rules: Based on policies that are specific to a particular databa rr rr rr rr rr rr rr rr rr rr rr
e.
Ex: PassportNumber values may not repeat in different Employee rows.
rr rr rr rr rr rr rr rr rr
48.Structured Query Language: The standard language for relational datab rr rr rr rr rr rr rr rr
ases, and is commonly supported in non-relational databases.
rr rr rr rr rr rr rr
49.Literals: Explicit values that are string (surrounded by single or double q
rr rr rr rr rr rr rr rr rr rr rr
uotes), numeric, or binary (represented with x'0', where '0' is any hex valu
rr rr rr rr rr rr rr rr rr rr rr rr
e).
50.Keywords: Words with special meaning such as SELECT, FROM, and WHER rr rr rr rr rr rr rr rr rr rr
E.
51.Identifiers: Objects from the database like tables, columns, etc. rr rr rr rr rr rr rr rr
Ex. City, Name, Population
rr rr rr
52.Data Definition Language (DDL): Defines the structure of the database.
rr rr rr rr rr rr rr rr rr
53.Data Query Language (DQL): Retrieves data from the database.
rr rr rr rr rr rr rr rr
54.Data Manipulation Language (DML): Manipulates data stored in a databas
rr rr rr rr rr rr rr rr rr
.
55.Data Control Language (DCL): Controls database user access.
rr rr rr rr rr rr rr
56.Data Transaction Language (DTL): Manages database transactions.
rr rr rr rr rr rr
57.Table: Has a name, a fixed sequence of columns, and a varying set of row
rr rr rr rr rr rr rr rr rr rr rr rr rr rr
s.
58.Row: An unnamed sequence of values. Each value corresponds to a c
rr rr rr rr rr rr rr rr rr rr rr
olumn and belongs to the column's data type.
rr rr rr rr rr rr rr
59.Cell: A single column of a single row. rr rr rr rr rr rr rr
60.No row order: Rows are not ordered. The organization of rows on a sto
rr rr rr rr rr rr rr rr rr rr rr rr rr
rage device, such as a disk drive, never affects query results.
rr rr rr rr rr rr rr rr rr rr
61.INT or INTEGER: Integer values rr rr rr rr
62.VARCHAR(N): Values with 0 to N characters. rr rr rr rr rr rr
63.DATE: Date values in YYYY-MM-DD rr rr rr rr
64.DECIMAL(M, D): Numeric values with M digits, of which D digits follo rr rr rr rr rr rr rr rr rr rr rr
w the decimal point.
rr rr rr
65.ALTER TABLE: Adds, deletes, or modifies columns on an existing table.
rr rr rr rr rr rr rr rr rr rr
66.Data Type: Is a named set of values from which column values are drawn
rr rr rr rr rr rr rr rr rr rr rr rr rr
3rr/rr17
Foundation Objective Assessment Practice Exa
r r r r r r r r r r
1.Database Application: Software that helps business users interact with rr rr rr rr rr rr rr rr rr
data- base systems. rr rr
2.Database Administrator: The individual who is responsible for safeguardin rr rr rr rr rr rr rr rr
g the database system against unauthorized access and enforcing proced
rr rr rr rr rr rr rr rr rr
ures for user access and system availability.
rr rr rr rr rr rr
3.Database Designer: Determines the format of each data element and the rr rr rr rr rr rr rr rr rr rr rr
overall database structure. rr rr
4.Authorization: Many database users should have limited access to speci rr rr rr rr rr rr rr rr rr
fic tables, columns, or rows of a database. Database systems use this to gra
rr rr rr rr rr rr rr rr rr rr rr rr rr
nt individual users access to specific data.
rr rr rr rr rr rr
5.Query Processor: Interprets queries, creates a plan to modify the datab
rr rr rr rr rr rr rr rr rr rr
ase or retrieve data, and returns query results to the application
rr rr rr rr rr rr rr rr rr rr
6.Rules: Database systems ensure data is consistent with structural and b
rr rr rr rr rr rr rr rr rr rr
usiness rules. rr
7.What does the query processor perform?: Query optimization to ensure t
rr rr rr rr rr rr rr rr rr rr
he most efficient instructions are executed on the data.
rr rr rr rr rr rr rr rr
8.Storage Manager: Translates the query processor instructions into low-rr rr rr rr rr rr rr rr
level file system commands that modify or retrieve data.
rr rr rr rr rr rr rr rr
9.Indexes: Database sizes range from megabytes to many terabytes, so th rr rr rr rr rr rr rr rr rr rr
e stor- age manager uses indexes to quickly locate data.
rr rr rr rr rr rr rr rr rr
10.Transaction Manager: The transaction manager ensures efficient trans rr rr rr rr rr rr rr
action execution, prevents conflicts between concurrent transactions, an
rr rr rr rr rr rr rr
d restores the database to a consistent state in case of a transaction or sy
rr rr rr rr rr rr rr rr rr rr rr rr rr rr
stem failure. rr
11.Metadata: Is data about the database, such as column names and the n rr rr rr rr rr rr rr rr rr rr rr rr
umber of rows in each table. rr rr rr rr rr
12.Relational Database: Stores data in tables, columns, and rows, similar rr rr rr rr rr rr rr rr rr
to a spreadsheet.
rr rr rr
13.SQL Query Language: All relational database systems support this.
rr rr rr rr rr rr rr rr
14.Relational systems are ideal for databases that require....: An accurate rr rr rr rr rr rr rr rr rr rr
record of every transaction, such as banking, airline reservation syste
rr rr rr rr rr rr rr rr rr
ms, and student records.
rr rr rr
15.NoSQL: A nonrelational database. rr rr rr
16.INSERT: Inserts rows into a table. rr rr rr rr rr
17.SELECT: Retrieves data from a table. rr rr rr rr rr
18.UPDATE: Modifies data in a table. rr rr rr rr rr
19.DELETE: Deletes rows from a table. rr rr rr rr rr
20.CREATE TABLE: Statement creates a new table by specifying the tabl rr rr rr rr rr rr rr rr rr rr
e and column names.
rr rr rr
1rr/rr17
, D426 Data Management - r r r r r r
Foundation Objective Assessment Practice Exa
r r r r r r r r r r
21.Data Type: Indicates the format column names. These can be numerical,
rr rr rr rr rr rr rr rr rr rr
textual or complex.
r rr rr
22.INT: Stores integer values. rr rr rr
23.DECIMAL: Stores fractional numeric values. rr rr rr rr
24.VARCHAR: Stores textual values. rr rr rr
25.DATE: Stores year, month, and day. rr rr rr rr rr
26.The Analysis Phase: Specifies database requirements without regard to
rr rr rr rr rr rr rr rr
a specific database system. Requirements are represented as entities, rel
r rr rr rr rr rr rr rr rr rr
ationships, and attributes. rr rr
27.Analysis: Has many alternative names, conceptual design, entity- rr rr rr rr rr rr rr
relationship modeling, and requirements definition. rr rr rr rr
28.What shape represents an Entitiy?: Rectanglerr rr rr rr rr
29.Logical Design Phase: Implements database requirements in a specific
rr rr rr rr rr rr rr rr rr
data-
base system. For relational database systems, it converts entities, relation
rr rr rr rr rr rr rr rr rr rr
ships, and attributes into tables, keys, and columns.
rr rr rr rr rr rr rr
30.Physical Design Phase: Adds indexes and specifies how tables are organ rr rr rr rr rr rr rr rr rr rr
ized on storage media with SQL statements such as CREATE INDEX and is s
rr rr rr rr rr rr rr rr rr rr rr rr rr
pecific to a database system. rr rr rr rr
31.Data Independence: The principle that physical design never affects
rr rr rr rr rr rr rr rr rr
query results rr
32.MySQL Command- rr
Line Client: A text interface that is included in the MySQL Server download.
rr rr rr rr rr rr rr rr rr rr rr rr
33.Error Code: Generated when a SQL statement is syntactically incorrect
rr rr rr rr rr rr rr rr rr rr
or the database cannot execute the statement.
rr rr rr rr rr rr
34.Data Structures: Prescribes how data is organized.
rr rr rr rr rr rr
35.Table, Column, Row, & Data Type: Data structures that organizes data in ta
rr rr rr rr rr rr rr rr rr rr rr rr
le.
36.Tuple: An ordered collection of elements is enclosed in parentheses suc
rr rr rr rr rr rr rr rr rr rr
h as (a, b, c) and (a, b, c).
rr rr rr rr rr rr rr rr
37.Rules: Governs valid data. rr rr rr
38.Table: Has a name, a fixed tuple of columns, and a varying set of rows.
rr rr rr rr rr rr rr rr rr rr rr rr rr rr
39.Column: Has a name and a data type. rr rr rr rr rr rr rr
40.Row: An unnamed tuple of values. Each value corresponds to a colum
rr rr rr rr rr rr rr rr rr rr rr
n and belongs to the column's data type.
rr rr rr rr rr rr rr
41.Data Type: A named set of values, from which column values are drawn.
rr rr rr rr rr rr rr rr rr rr rr rr
42.Select: Selects a subset of rows of a table. rr rr rr rr rr rr rr rr
43.Join: Combines two tables by comparing related columns.
rr rr rr rr rr rr rr
44.Union: Selects all rows of two tables. rr rr rr rr rr rr
2rr/rr17
, D426 Data Management - r r r r r r
Foundation Objective Assessment Practice Exa
r r r r r r r r r r
45.Aggregate: Performs a calculation on a set of values and returns a single rr rr rr rr rr rr rr rr rr rr rr rr rr
result. They are commonly used to summarize or analyze data, such as cal
rr rr rr rr rr rr rr rr rr rr rr rr
culating sums, averages, counts, or finding maximum or minimum values
rr rr rr rr rr rr rr rr rr rr
within a dataset. rr rr
46.Logical Constraints: Rules that ensure data is valid. rr rr rr rr rr rr rr
47.Business Rules: Based on policies that are specific to a particular databa rr rr rr rr rr rr rr rr rr rr rr
e.
Ex: PassportNumber values may not repeat in different Employee rows.
rr rr rr rr rr rr rr rr rr
48.Structured Query Language: The standard language for relational datab rr rr rr rr rr rr rr rr
ases, and is commonly supported in non-relational databases.
rr rr rr rr rr rr rr
49.Literals: Explicit values that are string (surrounded by single or double q
rr rr rr rr rr rr rr rr rr rr rr
uotes), numeric, or binary (represented with x'0', where '0' is any hex valu
rr rr rr rr rr rr rr rr rr rr rr rr
e).
50.Keywords: Words with special meaning such as SELECT, FROM, and WHER rr rr rr rr rr rr rr rr rr rr
E.
51.Identifiers: Objects from the database like tables, columns, etc. rr rr rr rr rr rr rr rr
Ex. City, Name, Population
rr rr rr
52.Data Definition Language (DDL): Defines the structure of the database.
rr rr rr rr rr rr rr rr rr
53.Data Query Language (DQL): Retrieves data from the database.
rr rr rr rr rr rr rr rr
54.Data Manipulation Language (DML): Manipulates data stored in a databas
rr rr rr rr rr rr rr rr rr
.
55.Data Control Language (DCL): Controls database user access.
rr rr rr rr rr rr rr
56.Data Transaction Language (DTL): Manages database transactions.
rr rr rr rr rr rr
57.Table: Has a name, a fixed sequence of columns, and a varying set of row
rr rr rr rr rr rr rr rr rr rr rr rr rr rr
s.
58.Row: An unnamed sequence of values. Each value corresponds to a c
rr rr rr rr rr rr rr rr rr rr rr
olumn and belongs to the column's data type.
rr rr rr rr rr rr rr
59.Cell: A single column of a single row. rr rr rr rr rr rr rr
60.No row order: Rows are not ordered. The organization of rows on a sto
rr rr rr rr rr rr rr rr rr rr rr rr rr
rage device, such as a disk drive, never affects query results.
rr rr rr rr rr rr rr rr rr rr
61.INT or INTEGER: Integer values rr rr rr rr
62.VARCHAR(N): Values with 0 to N characters. rr rr rr rr rr rr
63.DATE: Date values in YYYY-MM-DD rr rr rr rr
64.DECIMAL(M, D): Numeric values with M digits, of which D digits follo rr rr rr rr rr rr rr rr rr rr rr
w the decimal point.
rr rr rr
65.ALTER TABLE: Adds, deletes, or modifies columns on an existing table.
rr rr rr rr rr rr rr rr rr rr
66.Data Type: Is a named set of values from which column values are drawn
rr rr rr rr rr rr rr rr rr rr rr rr rr
3rr/rr17
