Bissoy.com
Doctors Medicines MCQs Q&A

Related Questions

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));
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 */
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;
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
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;
Find the missing clause from the following SQL statement?
CREATE VIEW person_1 ASSELECT fname, lname, person_id_________ person;
In the following SQL command "person_id" can be . . . . . . . .
SELECT person_id, fname, lname, Birth_data FROM person WHERE person_id=1;
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