Statements
Constraints, Keywords, & Clauses
MVC
Reserved Words
General SQL/MVC
100
In SQL, this statement is used to get data from a database.
What is a SELECT statement?
100
In SQL, this constraint uniquely identifies each record in a database table.
What is the PRIMARY KEY constraint?
100
This word describes the V in MVC.
What is View?
100
In java, this word refers to the primitive type that allows for up to a 32 bit number.
What is 'int'?
100
This is a set of data organized by tables, columns, and rows.
What is a 'relational database'?
200
In SQL, this statement is used to add new records in a table.
What is an INSERT statement?
200
In SQL, this constraint requires the column to point to an existing primary key in another table.
What is the FOREIGN KEY constraint?
200
This word describes the M in MVC.
What is Model?
200
In java, this word refers to the primitive type that allows for true/false statements.
What is 'boolean'?
200
This table allows for a Many to Many relationship.
What is a 'join', or 'link table'?
300
In SQL, the statement is used to remove existing records in a table.
What is an DELETE statement?
300
In SQL, this clause is used to filter records.
What is the WHERE clause?
300
This word describes the C in MVC.
What is Controller?
300
In SQL, this word combines records from two or more tables in a database.
What is 'join'?
300
In databases, this is the process of organizing fields and tables to minimize redundancy.
What is a 'normalization'?
400
In SQL, this statement is used to change existing records in a table.
What is the UPDATE statement?
400
In SQL, these keywords allow for a join to return a null.
What is are the IS NOT, or IS NOT NULL keywords?
400
In an MVC project, this refers to the class that acts as an abstract interface to the database, or some other persistence mechanism.
What is the DAO?
400
In SQL, this word is an operator that matches a character pattern when performing a search.
What is 'LIKE'?
400
In databases, this relationship is where each row in one table can be related to many rows in another table.
What is a 'One to Many Relationship'?
500
In SQL, this statement is used to remove indexes, tables, and databases.
What is a DROP statement?
500
In SQL, this keyword is used to sort the result-set by one or more columns.
What is the ORDER BY keyword?
500
This statement describes MVC as a re-usable solution for a commonly occurring problem.
What is a design pattern?
500
In java, this word refers to the object type that allows for the concatenation of individual characters to form text.
What is 'String'?
500
In programming, this term commonly refers to a set of libraries that provide generic functionality, like Spring for java, that aid in development.
What is a 'framework'?
M
e
n
u