MC	An ORDBMS will typically support inheritance...	both at data type and table type level	correct	only at a tuple level	incorrect	only at data type level	incorrect	only at table type level	incorrect	
MC	Which statement is CORRECT?	Triggers are a piece of SQL code, stored in the catalog, that is automatically activated and run by the RDBMS when a specific event occurs and a specific condition is evaluated as true.	correct	In the industry, ORDBMSs have been very successful since they replaced RDBMSs as the mainstream database technology.	incorrect	In the industry, ORDBMSs have never gained any traction at all.	incorrect	In the relational model, the set constructor allows to define multivalued attribute types.	incorrect	
MC	Which statement is CORRECT?	User Defined Functions (UDFs) must be stored in the application, and not in the catalog.  	incorrect	A sourced function is a UDF which is based on an existing, built-in function.	correct	User Defined Functions (UDFs) can only work on user-defined data types.	incorrect	User Defined Functions (UDFs) can only be defined in SQL.	incorrect	
MC	Which statement is CORRECT?	An array is an unordered collection which can contain duplicates.	incorrect	A bag is an unordered collection which may contain duplicates.	correct	A list is an ordered collection which cannot contain duplicates.	incorrect	A set is an ordered collection with no duplicates.	incorrect	
MC	Which data type can be used to store image data?	DBCLOB	incorrect	BLOB	correct	None of these types	incorrect	CLOB	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	Which statement is CORRECT?	Opaque data types in an ORDBMS are always based on existing SQL data types. 	incorrect	In the industry, ORDBMSs have never gained any traction at all.	incorrect	A bag is an unordered collection which may contain duplicates.	correct	In an ORDBMS, inheritance can be only be implemented on data type level and not on table type level. 	incorrect	
MC	Which statement is CORRECT?	A bag is an unordered collection which may contain duplicates.	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	
MC	In the industry, ORDBMSs have...	have had modest success with most companies only implementing a carefully selected set of extensions.  	correct	been very successful since they replaced RDBMSs as the mainstream database technology.	incorrect	have not been successful at all.	incorrect	
MC	The key difference between stored procedures and triggers is that:	Stored procedures cannot have input variables whereas triggers can.	incorrect	Stored procedures are stored in the data catalog, whereas triggers are not.  	incorrect	Stored procedures are more difficult to debug than triggers.  	incorrect	Stored procedures are explicitly invoked whereas triggers are implicitly invoked.	correct