Question

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 __________

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 MySQL Database

Answer: (d).48

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 __________

Add Comment

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

View All MCQs on MySQL Database

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!

Management Information Systems

Discover how businesses leverage technology with our Management Information Systems...

Computer Hardware

Explore the tangible components of computers with our Computer Hardware MCQs. Learn...

Human Computer Interaction

Enhance your knowledge of Human-Computer Interaction with our specialized MCQs....

MS Office

Master the suite of productivity tools with our MS Office MCQs. From Word and Excel...

PHP

Venture into server-side scripting with our PHP MCQs. Cover everything from syntax...

CSS

Polish your web design skills with our CSS MCQs. Learn about selectors, properties,...

Systems Analysis and Design Methods

Get familiar with the process of designing and improving business systems with our...

Digital Communication

Master the basics of electronic communication with our Digital Communication MCQs....

Python

Dive into one of the most popular languages with our Python MCQs. Understand...