MC Which statement is NOT CORRECT? The BLOB data type can be used to store image data. incorrect Recursive queries are a powerful SQL extension which allow to formulate complex queries such as queries that have multiple subqueries. correct Triggers allows to perform synchronic updates in case of data replication. incorrect A distinct data type in ORDBMSs is a user-defined data type that specializes a standard, built-in SQL data type. incorrect MC Recursive queries are a powerful SQL extension which allow to formulate complex queries such as... 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 queries that need to combine data from multiple tables. incorrect MC Which data type can be used to store image data? CLOB incorrect BLOB correct None of these types incorrect DBCLOB incorrect MC An ORDBMS will typically support inheritance... only at a tuple level incorrect only at data type level incorrect both at data type and table type level correct only at table type level incorrect MC Which statement is CORRECT? The key difference between stored procedures and triggers is that stored procedures cannot have input variables whereas triggers can. incorrect Triggers always help to enhance maintainability and performance. incorrect The key difference between stored procedures and triggers is that stored procedures are stored in the data catalog, whereas triggers are not. incorrect Triggers allows to perform synchronic updates in case of data replication. correct MC Which data type can be used to store image data? BLOB correct None of these types incorrect CLOB incorrect DBCLOB incorrect MC Which of the following is not an advantage of triggers? Triggers allow to avoid deadlock situations. correct Triggers support automatic monitoring and verification in case of specific events or situations. incorrect Triggers allow to model extra semantics and/or integrity rules without changing the user front-end or application code. incorrect Triggers allows to perform synchronic updates in case of data replication. incorrect MC Which data type can be used to store image data? CLOB incorrect None of these types incorrect BLOB correct DBCLOB incorrect MC An ORDBMS will typically support inheritance... both at data type and table type level correct only at table type level incorrect only at a tuple level incorrect only at data type level incorrect MC An ORDBMS will typically support inheritance... both at data type and table type level correct only at data type level incorrect only at table type level incorrect only at a tuple level incorrect