Chapters 1/2
Used to create and maintain a database.
What is a Database Management System (DBMS)?
Command used to create a table.
What is CREATE TABLE?
Rules to enforce business rules, practices and policies to ensure the accuracy and integrity of data.
What is a constraint?
Identifies the data values to be inserted in the table.
What is the VALUES clause?
A database object you can use to generate a series of integers.
What is a sequence?
A common field that exists between two tables.
What is a foreign key?
Command the lists all defined columns
What is the DESCRIBE key word?
Used to enforce the primary key requirements for a table.
What is the PRIMARY Key constraint?
The command used to change the contents of existing rows.
What is the UPDATE command?
A database object that stores a map of column values.
What is an index?
A group of related fields about one specific entity.
What is a record?
A SELECT statement used in another SQL command.
What is a subquery?
A constraint that is unlike any other constraints.
What is the FOREIGN KEY constraint?
A term used to describe DML statements representing data actions that should logically be performed together.
What is a transaction?
An alternative name or alias for a database object.
What is a synonym?
A collection of objects the DBMS managed to maintain information about the database.
What is the data dictionary?
The command used to make structural changes to a table.
What is the ALTER TABLE command?
Requires that a specific condition be met before adding a record to a table.
What is the CHECK constraint?
the command used to permanently save the DML statements.
What is the COMMIT command?
The process of identifying a user attempting to connect to a system.
What is authentication?
The basic structure, or rules, required to execute a statement.
What is a syntax?
Removing all rows of a table but leaving the table in tact.
What is truncating a table?
Prevents users from adding a row that contains a NULL value in the specified column.
What is the NOT NULL constraint?
Used to prevent users from mistakenly overwriting changes made by other users.
What is a table lock?
Granting object privileges to users based on their identities.
What is authorization?