Aggregate Functions Quiz PDF: Questions and Answers - 103

MCQ 511: If we do want to eliminate duplicates in the aggregate function, we use the keyword

1. No Duplicates
2. Distinct
3. Select distinct
4. Count

MCQ 512: A query can usually be translated into a\an

1. 1 evaluation plan
2. No evaluation plan
3. A number of evaluation plan
4. A number of execution plan

MCQ 513: Data type that is a machine-dependent subset of the integer type, is said to be

1. int
2. smallint
3. real
4. double

MCQ 514: If a user wishes to access a relation that exists in a different schema than the default schema for that user, than they must specify

1. Index of the schema
2. Location of the schema
3. Name of the schema
4. Extension of the schema

MCQ 515: The type of blocks that resides temporarily in the main memory are known as

1. Buffer blocks
2. Logical blocks
3. Physical blocks
4. Disk blocks