Advanced Aggregation Features Quiz Questions and Answers PDF - 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