Bissoy.com
Doctors Medicines MCQs Q&A

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 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
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
Will the following SQL command produce any error?
INSERT INTO person(person_id, fname,lname)VALUES (1,’S’,’U’),VALUES (1,’T’,’U’);/* where person_id is a primary key */
In the following SQL command "person_id" can be . . . . . . . .
SELECT person_id, fname, lname, Birth_data FROM person WHERE person_id=1;
Will the following SQL command produce any error?
INSERT INTO person(person_id, fname,lname)VALUES (1,’S’,’U’),VALUES (2,’T’,’U’);/* where person_id is a primary key */
In the following SQL command "person" stands for?
SELECT person_id, fname, lname, Birth_date FROM person;
In the following SQL query, what does "person_id" stands for?
CREATE TABLE person(person_ id SMALLINT UNSIGNED,fname VARCHAR(20),lname VARCHAR(20),CONSTRAINT pk_person PRIMARY KEY (person_id));
In the following SQL query, what does "person" stands for?
INSERT INTO person(person_id, fname, lname) VALUES (1,’S’,’P’);
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 */