SQL

Question 1

DDL

Answer 1

Data Definition Language

Includes create database objects (table, index, view) and commands to define access rights

Question 2

DML

Answer 2

Data Manipulation Language

Includes insert, update, delete, and retrieve.

Question 3

Query

Answer 3

A SQL statement that must be executed (question or action)

Question 4

Authentication

Answer 4

Process DBMS uses to verify that only registered users access the database

Question 5

Schema

Answer 5

Logical group of database objects (tables and indexes) that are related to each other, usually belonging to a single user / application. Multiple schemas can be associated with a single database.

Question 6

Reserved Words

Answer 6

Words by SQL to perform specific functions. They should not be used in column or table names.

Question 7

Wildcard Character

Answer 7

Symbol used as a substitute for other characters or commands.

Question 8

Subquery

Answer 8

Query embedded in another query. The innermost query is always executed first.
aka Nested Query / Inner Query

Question 9

CRUD

Answer 9

Create Read Update Delete

Question 10

Alias

Answer 10

Alternate name given to a table or column

Question 11

Cascading Order Sequence

Answer 11

Multilevel ordered sequence

Question 12

View

Answer 12

Virtual table based on a SELECT query

Question 13

Base Table

Answer 13

Table that a view is based on

Question 14

Batch Update Routine

Answer 14

Multiple transactions pooled into a single batch to update a master table

Question 15

Updatable View

Answer 15

Can be used to update attributes in any base table(s) used in the view