What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 7 columns respectively?

Related MCQs

• What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 20 rows respectively?
• Which of the following operations need the participating relations to be union compatible?
• Suppose now that R(A,B:) and S(A,B:) are two relations with r and s tuples, respectively (again, not necessarily distinct). If m is the number of (not necessarily distinct) tuples in the result of the SQL query: R intersect S; Then which of the following is the most restrictive, correct condition on the value of m?
• Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary) Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.
• Department (dept name, building, budget) and Employee (employee_id , name, deptname,salary) Here the dept_name attribute appears in both the relations .Here using common attributes in relation schema is one way of relating ___________ relations.
•              is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
• A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called
• ………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
• ………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations.
• A relational database system needs to maintain data about the relations, such as the schema of the relations. This is called