Databases Flashcards by Евгений Костюк

Q

Индексы

A

Индексы

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Ключи

A

Ключи

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Joins

A

Joins

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Grouping

A

Grouping

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Where

A

Where

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Subquery

A

Subquery

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

In

A

In

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

FK

A

FK

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Transactions

A

Transactions

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Tasks with *

A

Tasks with *

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Различия между разными бд

A

Различия между разными бд

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Нормализация нужна или нет

A

Нормализация нужна или нет

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

No sql

A

No sql

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Сложность выполнения, мастер запросов

A

Сложность выполнения, мастер запросов

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Строка как ключ? + и -

A

Строка как ключ? + и -

How well did you know this?

1

Not at all

2

3

4

5

Perfectly

Q

Сортировка

A

Сортировка

Q

Поиск по строке

A

Поиск по строке

Q

Collections & Oracle constraints

A

Collections & Oracle constraints

Q

Constraints

A

Constraints

Q

Репликация

A

Репликация

Q

Sequences

A

Sequences

Q

Views

A

Views

Q

Triggers

A

Triggers

Q

Stored procedures

A

Stored procedures

Q

Calling stored procedures from code. Pros and cons

A

Calling stored procedures from code. Pros and cons

Q

Oracle gates

A

Oracle gates

Q

Connection pool

A

Connection pool

Q

User rights

A

User rights

Q

Schema, namespace, etc

A

Schema, namespace, etc

Q

Big data types

A

Big data types

Q

Concurrent users. Oracle to mssql comparison

A

Concurrent users. Oracle to mssql comparison

Q

Expanded transactions

A

Expanded transactions