Bissoy.com
Doctors Medicines MCQs Q&A

Related Questions

Which of the following statements are TRUE about an SQL query? P: An SQL query can contain a HAVING clause even if it does not have a GROUP BY clause Q: An SQL query can contain a HAVING clause only if it has a GROUP BY clause R: All attributes used in the GROUP BY clause must appear in the SELECT clause S: Not all attributes used in the GROUP BY clause need to appear in the SELECT clause
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
Consider the following code. int count = 0; void *thfun () { int ctr=0; for (ctr=0; ctr<100; ctr++)      count++; } If thfun is executed by two threads concurrently in a uniprocessor system, what will be the MINIMUM value of count when both threads complete their execution? Assume that count++ is performed using three instructions: (i) read value of count from memory to a CPU register R, (ii) increment R, and (iii) store the value of R in memory. 
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?
The SQL COUNT function is used to count the number of rows returned in which of the following statement?
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
Each of a set of n processes executes the following code using two semaphores a and b initialized to 1 and 0, respectively. Assume that count is a shared variable initialized to 0 and not used in CODE SECTION P. CODE SECTION P wait (a); count=count+1 ; if (count==n) signal (b) ; signal (a) ; wait (b) ; signal (b) ; CODE SECTION Q What does the code achieve?
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
Quantity I: Mc Donald farm has only Emus and Lions, the total count of legs was 14 less than 4 times the total count of heads. How many legs are counted in total? Quantity II: Mc Donald Farm has only Emus and Lions, the total count of legs was 15 less than 5 times the total count of the head. How many legs are counted in total?
Consider the following code snippet : var c = counter(), d = counter(); c.count() d.count() c.reset() c.count() d.count() The state stored in d is :