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

Related MCQs

• What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 7 columns respectively?
• Which of the following operations need the participating relations to be union compatible?
• In the SQL Cursor, which attribute is TRUE when a cursor has some remaining rows to fetch, and FALSE when a cursor has no rows left to fetch?
• 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?
• In                                index instead of storing all the columns for a record together, each column is stored separately with all other rows in an index.
• Which of the following is a structure that provides faster access to the rows of a table based on the values of one or more columns?
• The ............ operator preserves unmatched rows of the relations being joined.
• 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.