MC	Which data type can be used to store image data?	None of these types	incorrect	CLOB	incorrect	BLOB	correct	DBCLOB	incorrect	
MC	Which statement is CORRECT?	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	In the relational model, the set constructor allows to define multivalued attribute types.	incorrect	
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 data type can be used to store image data?	CLOB	incorrect	DBCLOB	incorrect	BLOB	correct	None of these types	incorrect	
MC	An ORDBMS will typically support inheritance...	both at data type and table type level	correct	only at a tuple level	incorrect	only at table type level	incorrect	only at data type level	incorrect	
MC	Which of the following is not an advantage of triggers?	Triggers allow to model extra semantics and/or integrity rules without changing the user front-end or application code.	incorrect	Triggers support automatic monitoring and verification in case of specific events or situations.	incorrect	Triggers allows to perform synchronic updates in case of data replication.	incorrect	Triggers allow to avoid deadlock situations.  	correct	
MC	An ORDBMS will typically support inheritance...	only at a tuple level	incorrect	only at data type level	incorrect	only at table type level	incorrect	both at data type and table type level	correct	
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	Recursive queries are a powerful SQL extension which allow to formulate complex queries such as...	queries that need to combine data from multiple tables.	incorrect	queries that need to navigate through a hierarchy of tuples.	correct	queries that have multiple subqueries.	incorrect	queries that need to get access to multimedia data.	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 explicitly invoked whereas triggers are implicitly invoked.	correct	Stored procedures are stored in the data catalog, whereas triggers are not.  	incorrect	Stored procedures are more difficult to debug than triggers.  	incorrect