MC Which of the following is not a limitation of the relational model? The relational model does not support behavior or functions. incorrect The relational model does not support N:M relationship types. correct Because of only two types of constructors, no composite or multivalued attribute types are supported. incorrect The relational offers very poor support for specific data like audio, video or text files. incorrect MC Which statement is CORRECT? User Defined Functions (UDFs) must be stored in the application, and not in the catalog. incorrect User Defined Functions (UDFs) can only work on user-defined data types. incorrect A sourced function is a UDF which is based on an existing, built-in function. correct User Defined Functions (UDFs) can only be defined in SQL. incorrect MC Which statement is NOT CORRECT? Stored procedures may help to reduce network traffic. incorrect A disadvantage in using triggers is that they may cause cascade effects. incorrect Triggers always help to enhance maintainability and performance. correct Using triggers may lead to deadlock situations. incorrect MC Given the following SQL code for the wine database.

CREATE TRIGGER ODEREDQUANTITY
AFTER INSERT ON po_line
FOR EACH ROW
WHEN (NEW.PRODNR IS NOT NULL)
UPDATE product
SET AVAILABLE_QUANTITY = AVAILABLE_QUANTITY - NEW.QUANTITY
WHERE PRODNR=NEW.PRODNR

Which statement is CORRECT? This code has to be explicitly invoked by a user or application program. incorrect This is an example of a stored procedure. incorrect This code will always be executed before a new tuple is inserted in the po_line table. incorrect This code will update the available quantity of a certain product by subtracting its ordered quantity. correct 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 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 NOT CORRECT? A disadvantage in using triggers is that they may cause cascade effects. incorrect Using triggers may lead to deadlock situations. incorrect Stored procedures may help to reduce network traffic. incorrect Triggers always help to enhance maintainability and performance. correct MC Given the following two statements:

i. Polymorphism is not supported in ORDBMSs.
ii. When implementing behavior via triggers and/or stored procedures, only the interface or signature of the method is exposed to the outside world (e.g., applications). This is according to the principle of encapsulation.

Which statement is CORRECT? Statement ii is correct but statement i is not correct. correct Both statements are correct. incorrect Statement i is correct, but statement ii is not correct. incorrect Both statements are not correct. incorrect MC Which statement is CORRECT? A set is an ordered collection with no 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 list is an ordered collection which cannot contain duplicates. incorrect MC Suppose we have the following type definitions

CREATE TYPE STUDENTTYPE AS
(SNR SMALLINT NOT NULL,
SNAME CHAR(25) NOT NULL
MARK SMALLINT NOT NULL)
CREATE TYPE PHD-STUDENTTYPE AS (SCHOLARSHIP BOOLEAN NOT NULL)
UNDER STUDENTTYPE

We can now create the following two tables:

CREATE TABLE STUDENT OF TYPE STUDENTTYPE PRIMARY KEY (SNR)
CREATE TABLE PHD-STUDENT OF TYPE PHD-STUDENTTYPE UNDER STUDENT

What will the following query return?

SELECT * FROM STUDENT Only information about PhD students. incorrect All information about students, including the PhD students. correct All information about students who are not PhD students. incorrect An error. incorrect