TAW_10_2 chapter 8, views and maintenance views Flashcards

1
Q

Which is more efficient, a join declared in a program or a view declared in the database?

A

The view declared in the database is faster

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

What tcode is used for maintenance views?

A

SE54

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

What is one requirement of creating a maintenance view?

A

All tables must be linked by foreign keys

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

What is a maintenance cluster?

A

A collection of maintenance views put together in a sequence

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

What is the maximum number of maintenance views that can be in a cluster?

A

14

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