SQL

Question 1

SQL

Answer 1

Structured Query Language

Question 2

DDL

Answer 2

Data Definition Language

-AutoCommit-

Question 3

CRUD

Answer 3

Create
Read
Update
Delete

Question 4

DDL Commands

Answer 4

Create
Alter
Drop
Truncate

Question 5

DML

Answer 5

Data Manipulation Language

-NotAutoCommit-

Question 6

DML Commands

Answer 6

Insert
Update
Delete

Question 7

DQL

Answer 7

Data Query Language

Question 8

DQL Commands

Answer 8

Select

Question 9

DCL

Answer 9

Data Control Language

-Controls who can see data-

Question 10

DCL Commands

Answer 10

Grant

Revoke

Question 11

TCL

Answer 11

Transaction Control Language

Question 12

TCL Commands

Answer 12

Commit
Savepoint
Rollback

Question 13

Functions (Built-in)

Answer 13

Scalar

Aggregate

Question 14

Scalar Function

Answer 14

returns a single row for every row queried in a table or row

Question 15

Aggregate Function

Answer 15

returns a single result or set for a group of rows/tables

Question 16

Query Makeup

Answer 16

SELECT (column list) FROM (table list) WHERE (condition1) AND (condition2) GROUP BY (column list) HAVING (condition) ORDER BY (default(ie assending) or DESC)

Question 17

ResultSet

Answer 17

Table of results returned by execution of a SQL Query

Question 18

Sub-queries types

Answer 18

Correlated

non-correlated

Question 19

Correlated Sub-Query

Answer 19

Inner Query is not independent

Question 20

Non-Correlated Sub-Query

Answer 20

Inner Query is independent

Question 21

Sub-Query

Answer 21

Nested query in a query

Question 22

Joins

Answer 22

Returns a resultset of two or more combined tables

Question 23

Classifications of Joins

Answer 23

equi (=)

theta (,!=)

Question 24

Types of Joins

Answer 24

Inner
Right/Left
Full Outer
Cross
Self

Question 25

Inner Join

Answer 25

Return only rows that match

Question 26

Right/Left Join

Answer 26

All from the directions side, only matches from the other side

Question 27

Full Outer Join

Answer 27

Returns rows from all tables

Question 28

Cross Join

Answer 28

Cartesian product

Question 29

Self Join

Answer 29

Joins a table with itself

Question 30

Set-Ops

Answer 30

Used for comparing result sets, NOT tables

Question 31

Properties of a Database (ACID)

Answer 31

Atomicity Consistency Isolation Durability

Question 32

Set-Op Commands

Answer 32

UNION ALL UNION INTERSECT MINUS

Question 33

Dirty read

Answer 33

Returns something from a table/column that has not been committed

Question 34

Non-Repeatable Read

Answer 34

Row is edited after being viewed

Question 35

Phantom Read

Answer 35

Query that does not yield the same result when viewed again

Question 36

Sequences

Answer 36

Stores and tracks a number that can be incremented/decremented

Question 37

View

Answer 37

Essentially a saved SELECT query

Question 38

Index

Answer 38

Speeds up searches by enforcing an in-memory order of rows

Question 39

Trigger

Answer 39

Event listener in database

Question 40

Function

Answer 40

Block of Code we can execute

Question 41

Stored Procedure

Answer 41

Cannot produce a resultset | Used in java

Question 42

Cursor

Answer 42

View stored in local variable

Question 43

Prepared Statement

Answer 43

Pre-compiled statement

Question 44

Callable Statement

Answer 44

Used to call a stored procedure