Admin • 833.24K Points
Coach

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

(A) Normal attribute of the table
(B) DELAY_WRITE_KEY
(C) Composite key
(D) Primary key

Correct Answer - Option(B)
Views: 27
Filed under category MySQL
Hashtags:

Explanation by: Admin

This question is asking you to identify what "person_id" represents within the given SQL code. The code creates a table named "person" with several columns:

You must be Logged in to update hint/solution

Discusssion

Be the first to start discuss.

Mapped Tags:

Tag	Mapped By	Action

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

Explanation by: Admin

Discusssion

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