Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Murach MySQL Section 1- Chapter 1

memorize.ai (lvl 286)

(0)

88 cards

()

Section 1

Preview this deck

data access API

Front

1 / 88

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (88)

Section 1

(50 cards)

data access API

Front

provides the interface between the application program and the DBMS

Back

base table

Front

the table referred to in the FROM column for a query

Back

web server

Front

server that stores web applications and web services

Back

calculated values

Front

A result set can include that are calculated from columns in the table

Back

query

Front

what a SELECT statement is commonly referred to as being

Back

default value

Front

value used if another value isn't provided when a row Is added to a table

Back

scalability

Front

the capability of a system, network, or process to handle a growing amount of work, or its potential to be enlarged to accommodate that growth

Back

SELECT

Front

SQL DML statement; retrieves data from one or more tables

Back

relational database

Front

collection of data items with pre-defined relationships between them, every table shares at least one field with another table

Back

foreign key

Front

one or more columns in a table that refer to a primary key in another table

Back

null value

Front

represents a value that's unknown, unavailable, or not applicable.

Back

Connector/J and Connector/Net

Front

two commonly used MySQL drivers

Back

vertical

Front

______ database scalability is adding more capacity to a single machine

Back

row

Front

also called a record or tuple

Back

DBMS

Front

database management system

Back

join

Front

operation whereby the data from two tables are brought into a single result set

Back

CREATE

Front

SQL DDL statement that creates a new database, table or index

Back

data manipulation language (DML)

Front

language that lets you work with the data in the database and the data definition language

Back

referential integrity

Front

makes sure that any changes to the data in the database don't create invalid relationships between tables

Back

PHP, Java, C# or VB.NET

Front

common options for accessing MySQL data

Back

JDBC (Java Database Connectivity).

Front

for Java applications, the most common data access API for MySQL is

Back

UPDATE

Front

SQL DML statement; changes the values in one or more rows of a table based on the condition you specify

Back

horizontal

Front

______ database scalability is adding more capacity by adding more machines

Back

SQL

Front

standard language for working with a relationship database

Back

column

Front

also called a field, and it represents some attribute of the entity represented by the table

Back

composite key

Front

a primary key that consists of two or more columns

Back

clients

Front

the ______ are usually the PCs that are already available on the desktops throughout a company

Back

INSERT

Front

SQL DML statement; adds new rows to a table

Back

database driver

Front

software used by an API used to communicate with the database

Back

DML & DDL

Front

SQL statements can be divided into two categories:

Back

The clients, The network, and The server.

Front

three hardware components of a client/server system

Back

table

Front

where data is stored within a relational database

Back

USE

Front

statement that selects the current database

Back

DELETE

Front

SQL DML statement; deletes one or more rows from a table based on the condition you specify.

Back

database server

Front

a , is a computer that stores the files and databases of the system and provide services to the clients of the system

Back

SQL

Front

Structured Query Language

Back

DROP

Front

SQL DDL statement; deletes an existing database, table, or index

Back

index

Front

provides an efficient way to access data from a table based on the values in specific columns

Back

cell

Front

the intersection of each row and column, representing a value

Back

data type

Front

determines the type of information that can be stored in the column.

Back

auto increment column

Front

numeric column whose value is generated automatically when a row is added to a table

Back

DBA

Front

Database Administrator

Back

API

Front

application programming interface

Back

application server

Front

server that stores the business components

Back

ALTER

Front

SQL DDL statement; changes the definition of an existing table or changes the structure of an existing index

Back

primary key

Front

column that uniquely identifies that record in the table

Back

mysqli or PDO

Front

used by PHP to access MySQL data

Back

network

Front

the ______ consists of the cabling, communication lines, and other components that connect the clients and the servers of the system

Back

unique key

Front

also called a non-primary key, it isn't the primary key but also uniquely identifies each row in a table

Back

result table/set

Front

a logical table returned by the SELECT statement that's created temporarily within the database.

Back

Section 2

(38 cards)

client/server

Front

in a / system, the processing done by an application is typically divided between the client and the server.

Back

inner

Front

the most common type of join returns rows from both tables only if their related columns match

Back

single-line comment

Front

--followed by text is an example of a _- ___

Back

MySQL

Front

is a popular open-source database that runs on all major operating systems and is commonly used for web applications.

Back

Java

Front

To execute a SQL statement from a ______ application, you can use JDBC objects such as the Connection, Statement, and ResultSet objects

Back

constraint

Front

referential integrity ______ state happens where relation refers to a key attribute of a different or same relation. However, that key element must exist in the table.

Back

true

Front

True or False: a file-handling system isn't a client/server system

Back

Java

Front

before you can use ______ to work with MySQL, you must install a database driver.

Back

DDL (Data Definition Language)

Front

database administrators (DBAs) typically work with the ______ statements.

Back

block comment

Front

Back

entity-relationship (ER) or entity-enhanced-relationship (EER)

Front

an - diagram can be used to show how the tables in a database are defined and related.

Back

referential integrity

Front

when you define a foreign key for a table in MySQL, you can have that foreign key enforce

Back

file-handling

Front

in a - system, all of the processing is done on the clients

Back

enterprise

Front

a system consisting of networks, mid-range systems, & mainframe systems, often spread throughout the country or world, it is commonly referred to as an ______ system

Back

local area network

Front

in a simple client/server system, the clients and the server are part of a __ (LAN)

Back

true

Front

True or False: line breaks, white space, indentation, and capitalization have no effect on the operation of a statement

Back

Microsoft (MS) SQL Server

Front

is typically used for small-to-medium-sized systems that run on one or more Windows servers.

Back

front

Front

the client is typically referred to as the ______ end

Back

one-to-many relationship

Front

a relationship where one record in a table may have links to many records in another table.

Back

link or join

Front

you should ______ tables when the data in the tables has a one-to-one or a many-to-one relationship.

Back

one-to-one relationship

Front

instance of one entity can be related to only one instance of a related entity

Back

Oracle

Front

is typically used for large, mission-critical systems that run on one or more Unix servers

Back

front-end

Front

the processing done by the client software is typically referred to as - processing

Back

many-to-many relationship

Front

example of what relationship

Back

many-to-many relationship

Front

occurs when multiple records in a table are associated with multiple records in another table, usually not implemented in a relational database

Back

DML (Data Manipulation Language)

Front

MySQL programmers typically work with the ______ statements

Back

attribute

Front

each record is identified by a field referred to as an ______ containing a unique value.

Back

data definition language (DDL)

Front

language that lets you work with the objects in the database.

Back

DML (Data Manipulation Language)

Front

select, insert, update and delete statements fall under DML or DDL language

Back

DB2

Front

is typically used for large, mission-critical systems that run on legacy IBM mainframe systems.

Back

back

Front

the database server is referred to as the______ end

Back

database management system

Front

to store and manage the databases of the client/server system, each server requires a __ like MySQL

Back

back-end

Front

the processing that's done by the DBMS is typically referred to as - processing

Back

tuples

Front

each table is composed of records referred to as

Back

wide area network

Front

two or more LANs that reside at separate geographical locations can be connected as part of a larger network such as a __ (WAN)

Back

DDL (Data Definition Language)

Front

create, alter and drop statements fall under DML or DDL language

Back

queries

Front

application software communicates with the DBMS by sending SQL ______ through the data access API

Back

outer

Front

this type of join returns rows from one table in the join even if the other table doesn't contain a matching row.

Back

Murach MySQL Section 1- Chapter 1

Preview this deck

data access API

0.0

Cards (88)

data access API

provides the interface between the application program and the DBMS

base table

the table referred to in the FROM column for a query

web server

server that stores web applications and web services

calculated values

A result set can include ______ ______ that are calculated from columns in the table

query

what a SELECT statement is commonly referred to as being

default value

value used if another value isn't provided when a row Is added to a table

scalability

the capability of a system, network, or process to handle a growing amount of work, or its potential to be enlarged to accommodate that growth

SELECT

SQL DML statement; retrieves data from one or more tables

relational database

collection of data items with pre-defined relationships between them, every table shares at least one field with another table

foreign key

one or more columns in a table that refer to a primary key in another table

null value

represents a value that's unknown, unavailable, or not applicable.

Connector/J and Connector/Net

two commonly used MySQL drivers

vertical

______ database scalability is adding more capacity to a single machine

row

also called a record or tuple

DBMS

database management system

join

operation whereby the data from two tables are brought into a single result set

CREATE

SQL DDL statement that creates a new database, table or index

data manipulation language (DML)

language that lets you work with the data in the database and the data definition language

referential integrity

makes sure that any changes to the data in the database don't create invalid relationships between tables

PHP, Java, C# or VB.NET

common options for accessing MySQL data

JDBC (Java Database Connectivity).

for Java applications, the most common data access API for MySQL is

UPDATE

SQL DML statement; changes the values in one or more rows of a table based on the condition you specify

horizontal

______ database scalability is adding more capacity by adding more machines

SQL

standard language for working with a relationship database

column

also called a field, and it represents some attribute of the entity represented by the table

composite key

a primary key that consists of two or more columns

clients

the ______ are usually the PCs that are already available on the desktops throughout a company

INSERT

SQL DML statement; adds new rows to a table

database driver

software used by an API used to communicate with the database

DML & DDL

SQL statements can be divided into two categories:

The clients, The network, and The server.

three hardware components of a client/server system

table

where data is stored within a relational database

USE

statement that selects the current database

DELETE

SQL DML statement; deletes one or more rows from a table based on the condition you specify.

database server

a ______ ______, is a computer that stores the files and databases of the system and provide services to the clients of the system

SQL

Structured Query Language

DROP

SQL DDL statement; deletes an existing database, table, or index

index

A result set can include that are calculated from columns in the table

a , is a computer that stores the files and databases of the system and provide services to the clients of the system

in a / system, the processing done by an application is typically divided between the client and the server.

--followed by text is an example of a _- ___

an - diagram can be used to show how the tables in a database are defined and related.

when you define a foreign key for a table in MySQL, you can have that foreign key enforce

in a - system, all of the processing is done on the clients

in a simple client/server system, the clients and the server are part of a __ (LAN)