Advanced Aggregation Features Quiz with Answers PDF Download – Test 129

MCQ 641: Trend analysis can be thought of an example of:

1. Recursion
2. Transitive closure
3. Ranking
4. Windowing

MCQ 642: A relation, say r1, may include among its attributes the primary key of another relation, say r2. the r1 is also known as:

1. Parent relation
2. Referenced relation
3. Referencing relation
4. Node relation

MCQ 643: The query languages are terse and formal, but they illustrate the fundamental techniques for:

1. Storing data to database
2. Extracting data from database
3. Updating data of database
4. Deleting data from database

MCQ 644: A restarted form of the transaction is considered to be a/an:

1. Old transaction
2. Prior transaction
3. New transaction
4. Version transaction

MCQ 645: The join preserves tuples only in the relation named before the left outer join operation, is to be:

1. Left outer join
2. Left inner join
3. Right inner join
4. Right outer join