Crowdly

to provide a unique interface for any format of data

to define, manipulate, and manage data in a database

to provide control of access to the data

to store data in a cloud storage

Choose the appropriate terms

Represented

using a tree-diagram

Data

elements are stored in different tables

made up of rows and columns

Can

represent one-to-one and many-to-many as

well

Which of the following is not a data model?

Hierarchical data model

Network data model

Linear data model

Relational data model

What is a relational database?

A database that stores data in a hierarchical structure

A database that stores data in a single table

A database that stores data in tables consisting of rows and columns

A database that stores data in a network structure

What is SQL?

Sequential Query Language

Simple Query Language

Structured Query Language

Standard Query Language

Select the most appropriate SQL data type to store the specified values

358.67

'SQL comes in different dialects, and each dialect shares common data types, as well as including some that are unique.'

'28/04/2023'

0.234e+02

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