Bissoy.com
Doctors Medicines MCQs Q&A

What is the meaning of "EMPTY SET" in the following MySQL command?
SELECT fname, lname, person_idFROM personWHERE lname=’s’;/* after Execution*/ Mysql tool RETURN EMPTY SET 0:00sec

What is the meaning of "EMPTY SET" in the following MySQL command?

SELECT fname, lname, person_idFROM personWHERE lname=’s’;/* after Execution*/ Mysql tool RETURN EMPTY SET 0:00sec
Correct Answer No values

Related Questions

In the following MySQL query, "person_1" belongs to which category of table in MySQL?
CREATE VIEW person_1 ASSELECT fname, lname, person_id FROM person;
Which of the following forces are measured directly by strain gauges or force dynamometers during metal cutting? 1. Force exerted by the tool on the chip acting normally to the tool face 2. Horizontal cutting force exerted by the tool on the workpiece 3. Frictional resistance of the tool against the chip flow acting along the tool face 4. Vertical force which helps in holding the tool in position Select the correct answer using the codes given below.
In the following MySQL command how many rows will be updated?
UPDATE personSET lname=’s’,Fname=’p’,WHERE person_id<10;/* person_id is a primary key */
Is there any error in the following MySQL statement?
SELECT e.emp_id, e.fname,e.lname,d.nameFROM employee e INNER JOIN department dON e.dept_id=e.dept_id;
In the following MySQL command how many rows will be updated?
UPDATE personSET lname=’s’,Fname = ’p’,WHERE person_id = 1;/* person_id is a primary key */
Is there any error in the following MySQL statement?
SELECT e.emp_id, e.fname,e.lname,d.nameFROM employee AS e INNER JOIN department AS dON e.dept_id=e.dept_id;
Processes P1 and P2 have a producer-consumer relationship, communicating by the use of a set of shared buffers. P1: repeat                 Obtain a full buffer                 Empty it                 Return an empty buffer forever P2 P2P2: repeat             Obtain a full buffer             Empty it             Return an empty buffer          forever Increasing the number of buffers is likely to do which of the following? I. Increase the rate at which requests are satisfied (throughput) II. Decrease the likelihood of deadlock III. Increase the ease of achieving a correct implementation 
In the given Program: class Dialog1 { public static void main(String args[]) { Frame f1 = new Frame("INDIA"); f1.setSize(300,300); f1.setVisible(true); FileDialog d = new FileDialog(f1, "MyDialog"); d.setVisible(true); String fname = d.getDirectory() + d.getFile(); System.out.println("The Selection is" + fname); } } To make the Frame visible, which of the following statements are true?
In choosing a research tool which of the following are important considerations? A. The validity of the research tool B. The reliability of the research tool C. cost involved in terms of time and resources for use of research tool. D. Face validity of the research tool E. Opinion of the research supervisor Select the correct answer from the following options:
Two stock options are available for buying. Each offers a variable rate of return of profit over a period of 10 years. For first 4 years one has an incremental rate of return which increases by 2% per year starting from 3% of the investment and stays constant at 8% for the rest of the period. The second one has a constant annual rate of return throughout and give 10% more return after 10 years. What is the annual rate of return on second option?