Crowdly

What is SQL?

Sequential Query Language

Simple Query Language

Structured Query Language

Standard Query Language

What is normalization?

The process of manipulating with data to a database

The process of archiving data in a database

The process of removing duplicate data from a database

The process of organizing data in a database

What is true about a foreign key in a relational database?

A field that cannot contain null values.

A field in a table that refers to the primary key of another table.

A field that can store duplicate values.

A field that can store multiple values.

What is a primary key?

A field that can store atomic values

A not null unique column in a table

Any key in a table

A unique identifier for a record in a table

Which of these columns can be defined as a Primary Key?

VIN (Vehicle Identification Number)

RegistrationDate

OrderNumber

FirstName

ProductID

A relationship is ...

the degree to which a database has to be normalized

a column in a table that refers to the primary key in another table

a list of keys or keywords which identify a unique record and can be used to search and sort records more quickly

the way in which two columns in two different tables are related

Define the appropriate type of relationships.

Tables hold data about employees and the projects to which they are assigned. Each project can involve more than one employee and each employee is able to be occupied on more than one project

Record in Table A can relate to zero, one, or many records in Table B. Many records in Table B can relate to one record in Table A.

Each record in Table A relates to one, and only one, record in Table B, and each record in Table B relates to one, and only one, record in Table A.

Match the appropriate definition and description

A value of this column will uniquely identify the record in the table

A column whose values match a Primary Key in another table

A key that consists of two or more table columns that together uniquely identify a table row.

Primary Key is defined

to identify any row of data in the table in unique way