MY SQL

Question 1

A database sublanguage used in querying,
updating, and managing relational
databases

Answer 1

Structured Query Language

Question 2

Structured Query Language Derived from an IBM research group that
created __ ___ ___ __ in the 1970s

Answer 2

Structured English Query
Language (SEQUEL)

Question 3

in 1986, the __ __ __ __ published an SQL standard.

Answer 3

American National Standards
Institute

Question 4

What Can SQL do?

Answer 4

● SQL can execute queries against a
database
● SQL can retrieve data from a database
● SQL can insert records in a database
● SQL can update records in a database
● SQL can delete records from a database
● SQL can create new databases
● SQL can create new tables in a database
● SQL can create stored procedures in a
database
● SQL can create views in a database
● SQL can set permissions on tables,
procedures, and views

Question 5

● Free
● Open-source
● Uses various proprietary licenses, including
GNU General Public License (GPL)

Answer 5

MySQL Workbench

Question 6

• As an RDBMS, ____ uses SQL to manage
  data inside a database
• It organizes correlated data into one or
  more data tables, and this correlation
  helps structure the data

Answer 6

MySQL

Question 6

Advantages of Using MySQL

Answer 6

● Open Source
● Data Security
● Scalability On Demand
● Higher Efficiency
● 24×7 Server Uptime
● Complete Transactional Support
● Comprehensive Workflow Control
● Lower Total Cost Of Ownership (TCO)

Question 7

Three Major Components of SQL

Answer 7

Data Manipulation Language (DML)
Data Definition Language (DDL)
Data Control Language (DCL)

Question 8

A module of the SQL language which
allows you to retrieve, update, add, or
delete data in a database

Answer 8

Data Manipulation Language (DML)

Question 9

Enables you to create and modify the
database itself

Answer 9

Data Definition Language (DDL)

Question 10

Maintains the proper security for the
database

Answer 10

● Data Control Language (DCL)

Question 11

Creates a
table with specified columns

Answer 11

CREATE TABLE [table_name]

Question 11

Creates a
new database

Answer 11

CREATE DATABASE [db_name]

Question 12

Deletes a
database

Answer 12

DROP DATABASE [db_name]:

Question 13

Modifies
existing tables (add/drop columns)

Answer 13

ALTER TABLE [table_name]:

Question 14

Basic Data Retrieval

Answer 14

SELECT clause
FROM clause
WHERE clause

Question 15

Specifies the attributes to
be retrieved

Answer 15

SELECT clause:

Question 16

Lists the tables to scan

Answer 16

FROM clause

Question 17

Filters results based on
conditions

Answer 17

● WHERE clause