TAW_10_2 chapter 3, Database tables Flashcards

1
Q

Can a database table be included in the definition of another database table?

A

No, but you can use an include

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

Technical settings of a transparent table include;

A

Data class
Logging
Table buffer
Size Category

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

what are the 4 data classes in the transparent table technical settings?

A

System Data
Master Data
Transaction data
Organization data

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

What are the size categories of the technical settings?

A

0-9 and they determine the size of the extents

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

All that is needed to turn on loging of table changes i to check the box in technical settings?

A

No, system parameter rec/client must also be set

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

If logging is turned on in parameters and checked in technical settings of the table, what tcode is used to view the log?

A

SCU3

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

What is the data field of a cluster table?

A

VARDATA

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

What two fields make up the key of a pooled table?

A

TABNAME and VARKEY

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