D427 • Data Management Applications advanced questions with complete solved solutions 100%

D427 • Data Management Applications advanced questions
with complete solved solutions 100% accurate

1.database system instance: A blank is a single executing copy of a
database system. Personal computers usually run just one instance of a
database system. Shared computers, such as computers used for cloud
services, usually run multiple instances of a database system.
2.Data structures: that prescribe how data is organized.
3.Operations: that manipulate data structures.
4.Rules: that govern valid data.
5.database model: A blank is a conceptual framework for database
systems, with three parts:
Data structures that prescribe how data is organized.
Operations that manipulate data structures.
Rules that govern valid data.
6.relational model: The blank is a database model based on a tabular
data structure. The model was published in 1970 by E. F. Codd of IBM
and released in commercial products around 1980. The data
structure, operations, and rules are standardized in SQL, the universal
query language of relational databases.
7.big data: The rise of the internet in the 1990s generated big data,
characterized by unprecedented data volumes and rapidly changing
data structures.
8.set: A blank is an unordered collection of elements enclosed in braces.
9.tuple: A blank is an ordered collection of elements enclosed in
parentheses.
10.table: A blank has a name, a fixed tuple of columns, and a varying set
of rows.
11.column: A blank has a name and a data type.
12.row: A blank is an unnamed tuple of values. Each value corresponds
to a column and belongs to the column's data type.
13.data type: A blank is a named set of values, from which column
values are drawn.
14.relational algebra: These operations are collectively called relational
algebra and are the theoretical foundation of the SQL language.
15.Relational rules: Relational rules are part of the relational model and
govern data in every relational database.
16.Business rules: Business rules are based on business policy and
specific to a particular database.
17.constraints: Relational rules are implemented as SQL constraints and
enforced by the database system.


, D427 • Data Management Applications advanced questions
with complete solved solutions 100% accurate
18.Structured Query Language / SQL: Structured Query Language (SQL)
is a high-level computer language for storing, manipulating, and
retrieving data.
19.statement: An SQL statement is a complete command composed
of one or more clauses.






, D427 • Data Management Applications advanced questions
with complete solved solutions 100% accurate
20.clause: A clause groups SQL keywords like SELECT, FROM, and
WHERE with table names like City, column names like Name, and
conditions like Population > 100000.
21.Data Definition Language: Data Definition Language (DDL) defines the
struc- ture of the database.
22.Data Query Language: Data Query Language (DQL) retrieves data
from the database.
23.Data Manipulation Language: Data Manipulation Language (DML)
manipu- lates data stored in a database.
24.Data Control Language: Data Control Language (DCL) controls
database user access.
25. Data Transaction Language: Data Transaction Language (DTL)
manages data- base transactions.
26.CREATE DATABASE DatabaseName: CREATE DATABASE
DatabaseName creates a new database.
27.DROP DATABASE DatabaseName: DROP DATABASE
DatabaseName deletes a database, including all tables in the
database.
28.USE DatabaseName: USE DatabaseName selects a default database
for use in subsequent SQL statements.
29.SHOW DATABASES: SHOW DATABASES lists all databases in the
database system instance.
30.SHOW TABLES: SHOW TABLES lists all tables in the default database.
31.SHOW COLUMNS FROM TableName: SHOW COLUMNS FROM TableNam
lists all columns in the TableName table of the default database.
32.SHOW CREATE TABLE TableName: SHOW CREATE TABLE TableName
shows the CREATE TABLE statement for the TableName table of the
default data- base.
33.table: A table has a name, a fixed sequence of columns, and a
varying set of rows.
34.column: A column has a name and a data type.
35.row: A row is an unnamed sequence of values. Each value
corresponds to a column and belongs to the column's data type.
36.cell: A cell is a single column of a single row.
37.empty table: A table without rows is called an empty table.
38.data independence: Rule 4 is called data independence.
39.CREATE TABLE: The CREATE TABLE statement creates a new table
by spec- ifying the table name, column names, and column data types.
40.DROP TABLE: The DROP TABLE statement deletes a table, along


, D427 • Data Management Applications advanced questions
with complete solved solutions 100% accurate
with all the table's rows, from a database.