MySQL mcq questions and answers | MySQL MCQs

Home / MySQL / MySQL Miscellaneous

26.
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));

Answer & Solution Discuss in Board Save for Later

28.
Consider a database name "db_name" whose attributes are intern_id (primary key), subject.
Intern_id = {1, 2, 3, 4, 5, 6}
Subject = {sql, oop, sql, oop, c, c++}
If these are one to one relation then what will be the output of the following MySQL statement?
SELECT intern_id
FROM db_name
WHERE subject IN (c, c++);

Answer & Solution Discuss in Board Save for Later

Read More Section(MySQL Miscellaneous)

Each Section contains maximum 100 MCQs question on MySQL Miscellaneous. To get more questions visit other sections.