Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
MySQL Chapter 1

MySQL Chapter 1

memorize.aimemorize.ai (lvl 286)
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%
(0)
(0)
(0)
49 cards
()
Section 1

Preview this deck

Q) Retrieves data (SQL Statement)

Front

1 / 49

SQL
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

0

Favorites

0

Last updated

7 years ago

Date created

Mar 1, 2020

Cards (49)

Section 1

(49 cards)

Q) Retrieves data (SQL Statement)

Front

SELECT

Back

Q) How to edit the data for a table?

Front

*View Data *Buttons at Top of Results page * Click Apply

Back

Q) Unique Key

Front

One or more Non-Primary keys

Back

Q) The three hardware components of a Client / Server System

Front

* Clients * Server * Network

Back

Q) What is the difference between the Client/Server and File-handling systems?

Front

* Process is Divided * All processing done by the clients

Back

Q) One-to-Many Relationship

Front

* Each row related to one or more rows in another table * Most Common

Back

Q) One-To-One Relationship

Front

* info could just be on one table * Not common

Back

Q) Default Value

Front

A value that will be used if another value isn't provided

Back

Q) What does API stand for?

Front

Application Programming Interface

Back

Q) Each SEVER requires?

Front

DataBase Management System (DBMS)

Back

Q) How to view the data for a table?

Front

*Right click on table in Schemas section of Navigator Window *Select the Select Rows- limit 1000 command to display it in a Result grid

Back

Q) Adds a new row (SQL Statement)

Front

INSERT

Back

Q) Statement for creating a new database?

Front

CREATE DATABASE (name)

Back

Q) Calculated Value

Front

A column in a Result set that is formed by calculation from other columns

Back

Q) Relational Database

Front

* Data stored in Tables * Reduces dat redundancy * Saves disk space

Back

Q) Auto Increment Column

Front

A Value is generated automatically when a row is added

Back

Q) Base Table

Front

Original Table

Back

Q) JOIN

Front

A select statement that retrieves data from two tables

Back

Q) Null Value

Front

When a value is Unknown in a column

Back

Q) Deletes existing row (SQL Statement)

Front

DELETE

Back

Q) EER (Enhanced Entity-Relationship)

Front

A diagram used to show how table are defined and related

Back

Q) How does SQL work?

Front

*Application sends SQL queries to DBMS using the data access API

Back

Q) The Client Software does what?

Front

* Does the work of the user *Provides the interface between application and DBMS *Front-End Processing

Back

Q) DBMS does what?

Front

*Back-End Processing *Stores and manages the Database

Back

Q) How to Stop/Start Database Server on Workbench?

Front

*On Home tab, click on Local MySQL56 * In Navigator window, select Startup/Shutdown option.

Back

Q) How to connect as the root user on Workbench?

Front

* Click on "Local Instance MySQL56"

Back

Q) The three types of software found in a Client / Server System?

Front

*Server Software *Client Software *SQL interface

Back

Q) How to view the column definitions?

Front

* Right click on the table in Navigator window, select Alter Table *Select the Columns tab at bottom of window.

Back

Q) Index

Front

Provides Efficient ways to access data from a table

Back

Q) How to specify your own connection parameters Workbench

Front

* Right click on the connection, select Edit Connection item. *Enter Connection parameters

Back

Q) Primary Key?

Front

Uniquely Identifies each row

Back

Q) Composite Primary Key?

Front

Uses tow or more columns for Identify

Back

Q) Referential Integrity

Front

Makes sure that any changes to the date in Database don't create invalid relationships between tables

Back

Q) How to enter SQL statement?

Front

* Click New SQL tab in SQL Editor STOP HERE!!!!!!!!!!!!!!!!!!!!! slide 15

Back

Q) OUTER Join

Front

Returns rows from one table even if the other table doesn't contain a matching row

Back

Q) SQL is what?

Front

The Link between Application software and the DBMS

Back

Q) Statement that selects the current database

Front

USE (name)

Back

Q) Change Existing Row(SQL Statement)

Front

UPDATE

Back

Q) INNER Join

Front

Returns rows from both tables only if their related columns match

Back

Q) How does the Application Server get Results from the Database Server?

Front

Sends SQL Queries

Back

Q) Query

Front

*Request for Information * "Select"

Back

Q) How to edit the column definitions?

Front

* View Column definitions *Use resulting window to add new columns and modify existing columns

Back

Q) SQL stands for?

Front

Structured Query Language

Back

Q) Results Table / Set

Front

The results of a SELECT statement

Back

Q) How to create a new connection on Workbench?

Front

* Right click the connection, select New Connection item. * Enter Connection parameters.

Back

Q) Column, Rows, Cell each represent...

Front

* Attribute of Entry * Values for a single instance of Entry * Store a Single Value

Back

Q) A SEVER is a computer with enough _____ to store files / data for the system

Front

* RAM * Disk Storage * Processor speed

Back

Q) How do you Save a Password on Workbench?

Front

* Check "Save password in Vault"

Back

Q) Foreign Key

Front

Identifies a related row in another table

Back