Basic Structure of SQL Queries Practice Test PDF Download eBook p. 93

MCQ: The operands of the logical connectives can be expressions involving

1. Arithmetic operators
2. Comparison operators
3. Numeric operators
4. Bound operators

MCQ: Providing monitoring and evaluation is the responsibility of

1. Database declaration
2. Database definition
3. Database operation
4. Database security

MCQ: A calendar date containing a four-digit year, month, and day of the month, is defined in the data type

1. Date
2. Time
3. Timestamp
4. Calendar

MCQ: The second extended relational-algebra operation is the

1. Aggregate operation
2. Embedded operations
3. Generalized operation
4. Extended operation

MCQ: If a correlation name is defined both locally in a subquery and globally in a containing query

1. Local definition is applied
2. Global definition is applied
3. No definition applied
4. Global and local definitions applied