D427 • Data Management – Applications UPDATED ACTUAL Questions and CORRECT Answers

D427 • Data Management – Applications UPDATED ACTUAL Questions and
CORRECT Answers

a single executing copy of a database system. Personal
computers usually run just one instance of a database
database system instance system. Shared computers, such as computers used for
cloud services, usually run multiple instances of a data-
base system.
Data structures that prescribe how data is organized.
Operations that manipulate data structures.
Rules that govern valid data.
a conceptual framework for database systems, with three
parts:
database model Data structures that prescribe how data is organized.
Operations that manipulate data structures.
Rules that govern valid data.
a database model based on a tabular data structure. The
model was published in 1970 by E. F. Codd of IBM and
relational model released in commercial products around 1980. The data
structure, operations, and rules are standardized in SQL,
the universal query language of relational databases.
The rise of the internet in the 1990s generated this, char-
big data acterized by unprecedented data volumes and rapidly
changing data structures.
set an unordered collection of elements enclosed in braces.
an ordered collection of elements enclosed in parenthe-
tuple
ses.
has a name, a fixed tuple of columns, and a varying set of
table
rows.
column has a name and a data type.

, an unnamed tuple of values. Each value corresponds to a
row
column and belongs to the column's data type.
a named set of values, from which column values are
data type
drawn.
These operations are collectively called this and are the
relational algebra
theoretical foundation of the SQL language.
are part of the relational model and govern data in every
Relational rules
relational database.
are based on business policy and specific to a particular
Business rules
database.
Relational rules are implemented as these and enforced
constraints
by the database system.
a high-level computer language for storing, manipulating,
Structured Query Language / SQL
and retrieving data.
is a complete command composed of one or more claus-
statement
es.
groups SQL keywords like SELECT, FROM, and WHERE
clause with table names like City, column names like Name, and
conditions like Population > 100000.
defines the structure of the database.
Data Definition Language
CREATE, ALTER, DROP
Data Query Language Retrieves data from the database. SELECT
Data Manipulation Language Manipulates data stored in a database. UPDATE
controls database user access.
Data Control Language
GRANT, REVOKE
manages database transactions.
Data Transaction Language
SAVEPOINT, ROLLBACK, COMMIT



, CREATE DATABASE DatabaseName SQL clause that creates a new database DatabaseName.
SQL clause that deletes a database DatabaseName, in-
DROP DATABASE DatabaseName
cluding all tables in the database.
selects a default database DatabaseName for use in sub-
USE DatabaseName
sequent SQL statements.
SHOW DATABASES lists all databases in the database system instance.
SHOW TABLES lists all tables in the default database.
lists all columns in the TableName table of the default
SHOW COLUMNS FROM TableName
database.
shows the CREATE TABLE statement for the TableName
SHOW CREATE TABLE TableName
table of the default database.
cell a single column of a single row.
empty table A table without rows is called this.
The principle that physical design never affects query re-
data independence
sults
statement that deletes a table, along with all the table's
DROP TABLE
rows, from a database.
statement that adds, deletes, or modifies columns on an
ALTER TABLE
existing table.
Integer data types that represent positive and negative integers.
Decimal data types represent numbers with fractional values.
Character data types represent textual characters.
data types represent date, time, or both. Some include a
Date and time
time zone or specify a time interval.
data types store data exactly as the data appears in mem-
Binary
ory or computer files, bit for bit.