SQL Server Multiple Choice Questions and Answers PDF Download - 33

MCQ 161: Aggregate functions are said to take a set or multiset of values as input and return

1. Single value
2. Multiple sets
3. Multiple attributes
4. Multiple values

MCQ 162: A SQL view is updatable providing the clause has

1. Only one database relation
2. Two database relations
3. Multiple database relations
4. No database relations

MCQ 163: The check option clause defined by the SQL views, is expressed at the end of the

1. View definition
2. View schema
3. From clause
4. Where clause

MCQ 164: Match on specified attributes can be generated through a form of natural join known to be

1. Join.. In
2. Join.. Using
3. Join.. Upon
4. Join.. Across

MCQ 165: User defined data types in SQL standard can be expressed as

1. List datatype
2. Create type
3. Describe type
4. Define datatype