Databases Flashcards

1
Q

Индексы

A

Индексы

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Ключи

A

Ключи

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Joins

A

Joins

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Grouping

A

Grouping

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Where

A

Where

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Subquery

A

Subquery

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

In

A

In

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

FK

A

FK

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Transactions

A

Transactions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Tasks with *

A

Tasks with *

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

No sql

A

No sql

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Сортировка

A

Сортировка

17
Q

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

A

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

18
Q

Collections & Oracle constraints

A

Collections & Oracle constraints

19
Q

Constraints

A

Constraints

20
Q

Репликация

A

Репликация

21
Q

Sequences

A

Sequences

22
Q

Views

A

Views

23
Q

Triggers

A

Triggers

24
Q

Stored procedures

A

Stored procedures

25
Q

Calling stored procedures from code. Pros and cons

A

Calling stored procedures from code. Pros and cons

26
Q

Oracle gates

A

Oracle gates

27
Q

Connection pool

A

Connection pool

28
Q

User rights

A

User rights

29
Q

Schema, namespace, etc

A

Schema, namespace, etc

30
Q

Big data types

A

Big data types

31
Q

Concurrent users. Oracle to mssql comparison

A

Concurrent users. Oracle to mssql comparison

32
Q

Expanded transactions

A

Expanded transactions