Suppose Person is a table consisting of 8 rows and Employee is a table – McqOptions

MCQOPTIONS

1.	Suppose Person is a table consisting of 8 rows and Employee is a table consisting of 6 rows, the number of combinations through which the search is performed is __________. SELECT Person.i1, Employee.i2 FROM Person INNER JOIN Employee WHERE Person.i1 = Employee.i2;
A.	1
B.	14
C.	48
D.	84
E.	None of these
Answer» D. 84

Discussion

No Comment Found

Related MCQs

In a single table (with 10 columns) join query the number of values needed to examine per column is __________.<br>
Suppose Person is a table consisting of 8 rows and Employee is a table consisting of 6 rows, the number of combinations through which the search is performed is __________.<br><pre class="prettyprint lang-c">SELECT Person.i1, Employee.i2<br> FROM Person INNER JOIN Employee<br> WHERE Person.i1 = Employee.i2;<br></pre>
How many of the following shared tablespaces is bound by the OS file size limit?<br>MyISAM, InnoDB, TRANSACTION
In a single table (with 10 columns) join query the number of values needed to examine per column is __________.
The data rows of a MyISAM table are stored in __________.
The maximum number of indexes on MyISAM table is __________.
Suppose Person is a table consisting of 8 rows and Employee is a table consisting of 6 rows, the number of combinations through which the search is performed is __________.
The slow query log is written as __________.
For a table having 4 columns, the number of columns to which hash function is applied when using hash indexes is __________.
If a column contains 7 values and 6 distinct values, the cardinality is __________.