MC	Which statement is CORRECT?	In the relational model, the tuple constructor can only be used on atomic values and the set constructor can only be used on tuples.	correct	In the relational model, the tuple constructor allows to define composite attribute types.	incorrect	In the relational model, the tuple and set constructor can be used in a nested way.	incorrect	In the relational model, the set constructor allows to define multivalued attribute types.	incorrect	
MC	Which statement is CORRECT?	In the relational model, the tuple and set constructor can be used in a nested way.	incorrect	In the relational model, the tuple constructor allows to define composite attribute types.	incorrect	In the relational model, the tuple constructor can only be used on atomic values and the set constructor can only be used on tuples.	correct	In the relational model, the set constructor allows to define multivalued attribute types.	incorrect	
MC	Which statement is CORRECT?	A distinct data type is a user-defined data type which specializes a standard, built-in SQL data type.	incorrect	An opaque data type is an entirely new, user-defined data type, which is not based upon any existing SQL data type.	incorrect	An unnamed row type allows to include a composite data type in a table by using the keyword ROW.	incorrect	A named row type is a user-defined data type which groups a coherent set of data types into a new composite data type and assigns a meaningful name to it.  	incorrect	All statements are correct	correct	
MC	An ORDBMS will typically support inheritance...	only at data type level	incorrect	both at data type and table type level	correct	only at a tuple level	incorrect	only at table type level	incorrect	
MC	Which statement is CORRECT?	In the relational model, the tuple and set constructor can be used in a nested way.	incorrect	In the relational model, the tuple constructor allows to define composite attribute types.	incorrect	In the relational model, the set constructor allows to define multivalued attribute types.	incorrect	In the relational model, the tuple constructor can only be used on atomic values and the set constructor can only be used on tuples.	correct	
MC	Which statement is CORRECT?	In the relational model, the set constructor allows to define multivalued attribute types.	incorrect	In the relational model, the tuple constructor allows to define composite attribute types.	incorrect	In the relational model, the tuple constructor can only be used on atomic values and the set constructor can only be used on tuples.	correct	In the relational model, the tuple and set constructor can be used in a nested way.	incorrect	
MC	Which statement is CORRECT?	An array is an unordered collection which can contain duplicates.	incorrect	A list is an ordered collection which cannot contain duplicates.	incorrect	A set is an ordered collection with no duplicates.	incorrect	A bag is an unordered collection which may contain duplicates.	correct	
MC	Which statement is CORRECT?	User Defined Functions (UDFs) can only work on user-defined data types.	incorrect	User Defined Functions (UDFs) must be stored in the application, and not in the catalog.  	incorrect	User Defined Functions (UDFs) can only be defined in SQL.	incorrect	A sourced function is a UDF which is based on an existing, built-in function.	correct	
MC	Recursive queries are a powerful SQL extension which allow to formulate complex queries such as...	queries that need to get access to multimedia data.	incorrect	queries that need to combine data from multiple tables.	incorrect	queries that have multiple subqueries.	incorrect	queries that need to navigate through a hierarchy of tuples.	correct	
MC	Which statement is CORRECT?	A list is an ordered collection which cannot contain duplicates.	incorrect	A bag is an unordered collection which may contain duplicates.	correct	An array is an unordered collection which can contain duplicates.	incorrect	A set is an ordered collection with no duplicates.	incorrect