Crowdly

Додати до Chrome

Questions Bank (1248785 total)

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

Переглянути це питання

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

to identify any table in the database

to define the specific value in the column

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

Переглянути це питання

Попередня
1
124776
124777
124778
124779
124780
124879
Наступна

Telegram Instagram TikTok Question Bank

Умови використання Зв'яжіться з нами

Додати до Chrome