Basic DB
Intro to SQL
Queries
PL/SQL
Wild Card
100
Two-dimensional structure with rows and columns.
What is a table?
100
The SQL statements that define the database.
What is DDL?
100
Specifies how data is sorted in a results set.
What is the ORDER BY clause?
100

data structure that allows you to access rows in a result set. It acts as a pointer to a specific row in a query result set

What is a cursor?

100

This operator searches for a pattern of letters

What is like?

200
This uniquely identifies a row in a table.
What is a primary key?
200
Define what data looks like and how it can be used.
What is a data type?
200
In a SQL query, specifies the table that data is selected from.
What is the FROM clause?
200

PL/SQL program unit that responds to specific events in a database table

What is a trigger?

200
'Invented' the relational database.
Who is E.F. Codd?
300
A type of database that 'relates' tables to each other.
What is a relational database
300
a virtual table
What is a view.
300
Selects everything from the Personnel table.
What does the following query do? SELECT * FROM Personnel;
300

encapsulated collections of related procedures, functions, variables, and data types

What are packages?

300
NOT AND OR
What is the order of operations for compound WHERE statements?
400
Contains the smallest unit of meaningful information in a row/record.
What is a field?
400
The subset of SQL used to select and update the data in a database.
What is DML?
400
Allows you to specify pattern matches for data retrieval values.
What does IN allow you to do in SQL?
400

They allow you to group related functionality together and call it from different parts of your application

What are procedures?

400
Use the syntax /* */ or --
How do you add comments to SQL?
500

It involves dividing a large table into smaller, related tables and ensuring that each table follows specific rules (normal forms) to eliminate data anomalies

What is normalization?

500

keyword, which selects records that have matching values in both tables.

What is INNER JOIN?

500
WHERE Weight is between 2000 and 3000 OR Where Weight is > 1999 and < 3001 OR WHERE Weight is >= to 2000 and <=3000
What WHERE clause will select weight values between 2000 and 3000?
500

custom exceptions defined by the developer to handle specific scenarios

What are User-Defined Exceptions?

500
* % _
What are wild card characters in SQL?
M
e
n
u