Bissoy.com
Doctors Medicines MCQs Q&A

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.i2FROM tbl_1 INNER JOIN tbl_2WHERE tbl_1.i1 = tbl_2.i2;

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.i2FROM tbl_1 INNER JOIN tbl_2WHERE tbl_1.i1 = tbl_2.i2;
Correct Answer 48

Related Questions

Which type of join returns all the rows of the table on the right side of the join and matching rows for the table on the left side of join?
Consider the following two tables and four queries in SQL. Book (isbn, bname), Stock (isbn, copies) Query 1: SELECT B.isbn, S.copies FROM Book B INNER JOIN Stock S ON B.isbn = S.isbn;   Query 2: SELECT B.isbn, S.copies FROM Book B LEFT OUTER JOIN Stock S ON B.isbn = S.isbn; Query 3: SELECT B.isbn, S.copies FROM Book B RIGHT OUTER JOIN Stock S ON B.isbn = S.isbn;   Query 4: SELECT B.isbn, S.copies FROM Book B FULL OUTER JOIN Stock S ON B.isbn = S.isbn;   Which one of the queries above is certain to have an output that is a superset of the outputs of the other three queries?
In inner join, result is produced by matching rows in one table with rows in another table.
In the following passage, some of the words have been left out. Read the passage carefully and select the correct answer for the given blank out of thefour alternatives. The rising sun has great inner ______. Not just to ______ the new morning right after the dark night, but also the new rhythms and vibrations within existence. Theentire universe – including the trees, birds and flowers – wake up to the rising sun. When we listen to the birds chirping and see the flower petals open, rememberthat the sunrise is not just a great happening on the outside. If we are alert and aware, then the sunrise is also happening deep within us. Something within ourselvesis also ______ with the first rays of the sun. We just need to be sensitive and available; we just need to be ______. Like the outside world, we need to open the inner doorto let the new dawn enter within. Just open the window of our inner world and allow the beautiful experience of sunrise to ______ within ourselves – this experience isbeyond anything earthly. sun has great inner ______.
There are two rows, each containing 3 numbers. Below are some rules to be used to get the resultant number for each row separately. Use the rule from left to right for each row and find the answer to the question. Rule: 1. If an even number is followed by an even number, then the first number will be subtracted from the second. 2. If an odd number is followed by an odd number, then both will be added. 3. If an odd number is followed by an even number, then the even number will be subtracted from the square of the odd number. 4. If an even number is followed by an odd number, then the odd number will be subtracted from the even number. Row I: 9,11, 34 Row II: 16, 9, 8 What is the difference between the resultant numbers in the first row and the second row
In a group of 50 students who either want to join defence forces or paramilitary forces, out of which 40 students want to join defence forces and 30 want to join paramilitary forces. Find the number of students who want to join only defence forces.
There are two rows, each containing 3 numbers. Some rules are given below to be used for obtaining the resultant number for each row separately. Apply the rules for each row from left to right and answer the question. Rules: i. If an even number is followed by an even number, the first is to be subtracted from the second. ii. If an odd number is followed by an odd number, both are to be added. iii. If an odd number is followed by an even number, the even number is to be subtracted from the square of the odd number. iv. If an even number is followed by an odd number, the odd number is to be subtracted from the even number. Row I: 28, 19, 12 Row II: 13, 7, 32 What is the average of the resultant numbers of the first row and the second row?
Under section 95 of Criminal Procedure Code certain publications can be forfeited and search warrant can be issued for the same. In this context, the propositions are
1. A newspaper cannot be forfeited and search warrant cannot be issued for the same as it would be violative of the fundamental right of speech and expression and involves the fourth estate.
2. A book can be forfeited and search warrant can be issued for the same.
3. A document can be forfeited and search warrant can be issued for the same.
Which of the following is correct
In class, students want to join sports. 15 people will join football, 24 people will join basketball, and 7 people will join both. How many people are there in the class?
Under Section 95 of the Code of Criminal Procedure, 1973, certain publications can be forfeited and search warrant can be issued for the same. In this context, which of the following is/are the correct legal proposition?
1. A news paper cannot be forfeited and search warrant cannot be issued for the same as it would be violative of the fundamental right of speech and expression
2. A book can be forfeited and search warrant can be issued for the same
3. A document can be forfeited and search warrant can be issued for the same
Select the correct answer: