Question
SELECT tbl_1.i1, tbl_2.i2
FROM tbl_1 INNER JOIN tbl_2
WHERE tbl_1.i1 = tbl_2.i2;a.
14
b.
2
c.
1
d.
48
Posted under Query Optimization MySQL Database
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Suppose tbl_1 is a table consisting of 8 rows and tbl_2 is a table consisting of 6 rows, the number of combinations through which the search is performed is __________
Similar Questions
Discover Related MCQs
Q. How many of the following shared tablespaces is bound by the OS file size limit?
MyISAM, InnoDB, TRANSACTION
View solution
Q. If a column contains 7 values and 6 distinct values, the cardinality is __________
View solution
Q. For a table having 4 columns, the number of columns to which hash function is applied when using hash indexes is __________
View solution
Q. The slow query log can be used to identify queries that may be performing badly.
View solution
Q. The slow query log is written as __________
View solution
Q. To check how MySQL would execute a SELECT query, which statement is used?
View solution
Q. To perform analysis of key values by the server, the statement used is __________
View solution
Q. Which statement is used to verify optimizer operation?
View solution
Q. Which statement is used to force the optimizer to use tables in a particular order?
View solution
Q. Which of these comparisons is slowest?
View solution
Q. Which system variable tells the optimizer to skip certain plans based on estimates of the number of rows accessed for each table?
View solution
Q. Which system variable tells how far into the rest of each incomplete plan the optimizer should look to evaluate whether it should be expanded further?
View solution
Q. The optimizer_prune_level is set by default.
View solution
Q. Calculations involving numbers are faster than those involving string.
View solution
Q. To convert an int to string, the function is _________________
View solution
Q. To convert a string to an int, the function is _________________
View solution
Q. To maintain performance of tables having variable length rows, which statement is used?
View solution
Q. Which of these columns are faster?
Variable length, Fixed length
View solution
Q. Which of these take more space?
Variable length columns, Fixed length columns
View solution
Q. To minimize disk I/O, which of these should be chosen?
CHAR, VARCHAR
View solution
Suggested Topics
Are you eager to expand your knowledge beyond MySQL Database? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
