In The Following Sql Query What Does Personid Stands Forp Pre #214
In the following SQL query, what does “person_id” stands for?</p> <pre><code class="language-sql"> CREATE TABLE person (person_ id SMALLINT UNSIGNED, fname VARCHAR(20), lname VARCHAR(20), CONSTRAINT pk_person PRIMARY KEY (person_id)); </code></pre>
This multiple choice question (MCQ) is related to the book/course
gs gs113 MySQL.
It can also be found in
gs gs113 Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.1.
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));
Normal attribute of the table
Super key
Composite key
Primary key
Similar question(s) are as followings:
Online Quizzes of gs113 MySQL
MySQL Programs Using C - Using the Embedded Server Library - Quiz No.1
gs gs113 MySQL
Online Quizzes
System, Status and User Variables - User-Defined Variables - Quiz No.1
gs gs113 MySQL
Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.1
gs gs113 MySQL
Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.2
gs gs113 MySQL
Online Quizzes
