DATABASE MYPHPADMIN

----------------

Which clause is used to select a concrete table in MySQL? Select one: a. Frome b. SELECT c. ALTER d. WHERE

-------------------------------

In the following command "person_id" can be ___________

Select one: a. Primary Key or any other attribute b. Primary Key Only c. None of the alternatives d. Attribute only but not Primary Key

------------

What is the default value (by default) of a column?

Select one: a. Undefined b. 0 c. -1 d. NULL

---------------------------

Which of the following keywords is used to specify foreign key after the table is created Select one: a. SETUP b. SET c. ALTER TABLE d. SPECIFY

-------------------------

"Numeric" datatype is used to add _______ Select one: a. Natural numbers b. Whole numbers c. Natural and rational numbers d. Rational numbers

SELECT person_id, fname, 1 name, Birth_data FROM person WHERE person_id-1