Bissoy.com
Doctors Medicines MCQs Q&A

What does the following query do? select name, ID, branch from student, department where student.branch = department.branch;

What does the following query do? select name, ID, branch from student, department where student.branch = department.branch; Correct Answer It gives the values of name, ID, branch from their respective relations where the values in the branch attribute are same

student.branch = department.branch verifies whether both the values of the attributes are same in both the relations and returns the value.

Related Questions

In a group of 450 Teachers, 22% of the total Teachers take the English department, 34% of the total Teachers take the quant. department, and 26% of the total Teachers take the LR department. 8% of the total Teachers have taken both English and quant department only. Out of the total Teachers in the English department, 1 / 3 have taken both English and LR department only. Out of the total Teachers in the quant department, 1 / 3 have taken both quant and LR department only. Only 20 Teachers take all the three departments. Find the number of Teachers who have not taken any department. 
Study the given pie chart and answer the question given below. Percentage breakup of employees working in different departments of a company Department the ratio of men and women male female Information technology (IT) 11 12 Account 5 4 Marketing 8 9 Production 4 3 Human Resource (HR) 9 5 Total number of employees = 1800 If 10% of the men working in the Accounts department are transferred to the HR department, and one-fourth of the female employees working in the Production department is transferred to the Marketing department, then the number of male employees working in the HR department is what percent less than the number of female employees working in the Marketing department? (correct to one decimal place)
The Chairman of a big company visits one department on Monday of every week except for the Monday of third week of every month. When did he visit the Purchase department ? Statements : I. He visited Accounts department in the second week of September after having visited Purchase department on the earlier occasion. II. He had visited Purchase department immediately after visiting Stores department but before visiting Accounts department.
The Chairman of a big company visits one department on Monday of every week except for the Monday of third week of every month. When did he visit the Purchase department ? I. He visited Accounts department in the second week of September after having visited Purchase department on the earlier occasion. II. He had visited Purchase department immediately after visiting Stores department but before visiting Accounts department.
Question : The Chairman of a big company visits one department on Monday of every week except for the Monday of third week of every month. When did he visit the Purchase department ?

Statements :
I. He visited Accounts department in the second week of September after having visited Purchase department on the earlier occasion.
II. He had visited Purchase department immediately after visiting Stores department but before visiting Accounts department.
With respect to Arabian Sea Branch and Bay of Bengal branch of the monsoon entering the Indian landmass, consider the following statements: 1. Arabian Sea Branch is much more powerful than the Bay of Bengal branch. 2. Arabian Sea Branch is divided into three distinct streams while Bay of Bengal branch is divided into two distinct streams. Which of the statements given above is/are correct ?
The relation scheme given below is used to store information about the employees of a company, where empId is the key and deptId indicates the department to which the employee is assigned. Each employee is assigned to exactly one department. emp(empId, name, gender, salary, deptId) Consider the following SQL query: select deptId, count(⋆) from emp where gender = "female" and salary > (select avg(salary) from emp) group by deptId; The above query gives, for each department in the company, the number of female employees whose salary is greater than the average salary of
In a class text, to the question, find out 23% of 200, two students answered in following ways:  Student A: 23% of 200 = 23% of (100 + 100) = 23 + 23 = (20 + 20) + (3 + 3) = 46  Student B: 23% of 200 = 200 × \(\frac{23}{100}\) = 2 × 23 = 46 Which of the following statements is the most appropriate in the given context? 1. Since student B has used the standard algorithm, teacher gives full marks to student B and zero to student A 2. Teacher gives full marks to both the students as they have attempted the question using their own algorithms. Both formal and informal algorithms are integral to solving problems in mathematics. 3. Teacher gives zero marks to student A and directs him to redo the question using the algorithm taught in the Class 4. Teacher accepts both the responses but directed student A to refrain from using informal algorithm 
Point out the correct statement. * executes a Hive query and prints results to standard output b) executes a Hive query and prints results to standard output c) executes a Hive query and prints results to standard output d) All of the mentioned
Which of the following pairs is not matched correctly?   Important Scheme Related Department (i) Sanskar Abhiyan Health Department (ii) Mukhyamantri Swavalamban  Yojana Panchayat and Rural Development Yojana Department (iii) Mukhyamantri Suposhan Abhiyan Women and Child Development Department (iv) Tirath Barat Yojana Urban Administration Department (v) Samarthya Vikas Yojana Agriculture Department