Definition
Databases storing data in related tables with keys and relationships.
Relational databases
SQL function to return number of occurrences in a query.
What is Count?
The result set is known as a Cartesian Product.
What is a CROSS JOIN?
This lock is similar to an exclusive lock but is designed to be more flexible in a way. An __ __ can be imposed on a record that already has a shared lock. In such a case, the __ __ will impose another shared lock on the target row. Once the transaction that holds the update lock is ready to change the data, the update lock (U) will be transformed to an exclusive lock (X).
What is Update Lock?
SQL Union Operator Question
True or False
SQL Union Operator can have multiple tables where the column names and datatypes of the multiple tables does not have to be similar.
(Answer does not have to be in question.)
False
SQL Union Operator combines the result of two or more tables where the column names and datatypes of the multiple tables needs to be similar.
Logical structure of a database defining tables, columns, relationships
Database Schema
SQL function to return maximum value in a query.
What is Max?
D in ACID
What is Durability?
Used for operations that do not change or update data (read-only operations), such as a SELECT statement.
What is Shared Lock?
SQL JOIN
True or False
LEFT OUTER JOIN in SQL is a type of join that returns all the rows from the left table (table1), and the matching rows from the right table (table2), along with NULL values for the non-matching rows from the right table.
(Answer does not have to be in question.)
True
Data structure with columns and rows for organizing information
Tables
SQL keyword to return unique values in a query.
What is Distinct?
Will ensure that a page or row will be reserved exclusively for the transaction that imposed the exclusive lock, as long as the transaction holds the lock.
AKA Creates a queue.
What is Exclusive lock?
I in ACID
What is Isolation?
SQL Wildcard
True or False
A wildcard character is used to substitute one or more characters in a string.
(Answer does not have to be in question.)
True
Instructions to retrieve data from database tables.
Queries
SQL function to return minimum value in a query
What is Min?
C in ACID
What is Consistency?
A ___ constraint is used to limit the values that can be placed in a column. For Example negative values in a salary column or alphabets in an SSN column.
What is a CHECK Constraint?
SQL Comments
True or False
Any text between -- and the end of the line will not be ignored (will be executed).
(Answer does not have to be in question.)
False
Any text between -- and the end of the line will be ignored (will not be executed).
Ensuring accuracy, completeness, and consistency of data in the database.
Data Integrity
SQL keyword to assign an alias name to a column or table.
What is As?
A in ACID.
What is Atomicity?
Is a tool located in SQL Server Management Studio That allows you to take what is called a trace. A trace basically traces what is goin on while an application is running. It tells you things such as which Stored Procedures are called and how long they each take to run.
What is a SQL Profiler?
SQL FOREIGN KEY
True or false
The FOREIGN KEY constraint is used to prevent actions that would destroy links between tables.
(Answer does not have to be in question.)
True