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

Сортировка

Study These Flashcards

A

Сортировка

Q

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

Study These Flashcards

A

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

Q

Collections & Oracle constraints

Study These Flashcards

A

Collections & Oracle constraints

Q

Constraints

Study These Flashcards

A

Constraints

Q

Репликация

Study These Flashcards

A

Репликация

Q

Sequences

Study These Flashcards

A

Sequences

Q

Views

Study These Flashcards

A

Views

Q

Triggers

Study These Flashcards

A

Triggers

Q

Stored procedures

Study These Flashcards

A

Stored procedures

Calling stored procedures from code. Pros and cons

Calling stored procedures from code. Pros and cons

Oracle gates

Oracle gates

Connection pool

Connection pool

User rights

User rights

Schema, namespace, etc

Schema, namespace, etc

Big data types

Big data types

Concurrent users. Oracle to mssql comparison

Concurrent users. Oracle to mssql comparison

Expanded transactions

Expanded transactions