Databases

___________ is a form of normalization in which each field has a single value so that data can be sorted in any way possible.

• 3NF

• 1NF

• Alter

• Alias

__________ is a form of normalization in which a value change in a non-key column in one table does not necessitate a change in another non-key column within an entity.

• 3NF

• 1NF

• Byte

• Column

_________ is a replacement name for a column or table.

• Alternate

• Constraint

• Alias

• Backup

_________ is a SQL keyword used to change the definition of a database object.

• Alias

• ALTER

• Between

• Backup

___________ is a SQL keyword used to display records within a query if all records within that query match related records in a subquery.

• ALTER

• Alias

• Between

• All

_________ is a SQL keyword used to find matching records from a query to a subquery.

• AVG

• ANY

• ALTER

• BYTE

________ is A SQL keyword used to get the average amounts for one or more fields within a query.

• ALL

• ANY

• BETWEEN

• AVG

________ is a copy of data stored elsewhere to be restored if original data is lost or damaged.

• Backup

• Between

• Bit

• Boolean

________ is a SQL keyword used to define a range of values used for a filter within a query.

• Backup

• ALL

• Between

• Any

_________ is a data type that is either a zero or a one.

• Byte

• Bit

• Boolean

• String