75 Multiple choice questions
- An application, such as Microsoft Access, that is object-oriented and drag-and-drop driven.
- Removing subsets of data that apply to multiple rows of a table and place them in separate tables.
- Used to insert a new row in a table when a sub-select is used instead of the VALUES clause.
specify the possible range of values of the set, the operations that
can be performed on the values, and the way in which the values are
stored in memory.
- Used to query data from two or more tables.
- Only files that have been changed since the last FULL backup are copied.
relationship between nodes in a tree data structure in which the parent
is one step closer to the root (that is, one level higher) than the
- Shows the relationships between boolean logical operators.
- If all statements are correct within a single transaction, it records the changes in the database.
- Provides users with access to the database.
data structure that is a collection of fields (elements), each with its
own name and type that appear in a table as a group of fields across
- Compact segments of user-written SQL code that can accept parameters and return either a value or a table.
- A set of two or more statements grouped into a single unit.
result of structuring information to avoid redundancy and inconsistency
and to promote efficient maintenance, storage, and updating.
- Combines two or more SELECT statements with an OR function.
- Displays a record if both the first condition AND the second condition are true.
- One-word commands that return a single value written in the command set of SQL.
- Data type that stores whole numbers.
keywords and associated data that point to the location of more
comprehensive information, such as files and records on a disk or record
keys in a database.
- Used to update existing records in a table.
- Reverses changes.
- A model for modern database management systems in which data is organized in relations (tables).
complex association between two sets of parameters in which many
parameters of each set can relate to many others in the second set.
- Serves as a unique identifier of a specific row and uniquely defines a relationship within a database.
- Precompiled groups of SQL statements saved to the database.
- Relational Data Base Management System
- Recreate a full or incremental reproduction of the database.
- Returns a single value, based on the input value of a single field.
- removing columns that are not dependent upon the primary key.
- The data structure usually consisting of a list of entries.
- An identifier for a record in a data file that is unique and found in only one record.
- Adds databases or objects.
- Queries nested inside another query.
- Returns a single value, calculated from values in a column.
- Changes databases or objects.
- Used to insert a new row in a table.
- A specific set of instructions for extracting/selecting particular data.
- Returns only distinct(unique) values.
- An attribute for a row or record.
- Identifies which users can do what actions to data in a database.
- Deletes rows in a table.
- Grants permissions to the database. Defined roles give all users within a group the same permissions.
- Arranged similarly to the index of a book, where the index value points to the actual information.
- Ensures that data is consistent, correct, and usable throughout the database.
- Specifies an order in which to return the rows.
- Involves applying a body of techniques to a relational database to minimize the inclusion of duplicate information.
- A description of a database to a database management system (DBMS) in the language provided by the DMBS.
- Addresses the safety of the actual location of the database?
- A record within a table.
- The grammar and rules governing the structure and contents of statements.
- A process of saving all critical data to re-create the database in useful form in a relatively short time.
relational database language used in querying, updating, and managing
relational databases and is the de facto standard for database products.
- A unique data identifier.
- Specifies which rows to retrieve.
- Displays a record if either the first OR the second conditions are true.
- Used to insert, update, and delete data and to query a database.
- Creates when-then-else functionality.
- A data type that stores any real numbers.
association between two tables in which the primary key value of each
record in the primary table corresponds to the value in the matching
field of one, and only one, record in the related table.
- A data type that stores 1 or 0, true or false.
- Ensures and restricts who can connect and what they can do.
- Eliminate duplicate columns from the same table.
- A location in a record in which a particular type of data is stored.
- All files are copied for possible future retrieval.
- Used to create, modify, or drop relational databases, entities, attributes, and other objects (e.g. views).
- Selects data from the database.
- Only files that have been changed since the last backup are copied.
- A sophisticated query language with additional features beyond what is defined in the ANSI SQL.
- References the primary key in another table.
- Arranged in a special order to make retrieval of information faster with direct access to the information.
- A data type that stores A-Z or 0-9, any digit or letter that math functions will not be applied to.
- Combines two ore more SELECT statements with an AND function.
- A saved query that creates a virtual table from the result set of the query.
node in the tree contains a sorted list of key values and links that
correspond to ranges of key values between the listed values.
- Removes databases or objects.