DDL

Question 1

ALTER Syntax to Add Column

Answer 1

ALTER TABLE table_1

ADD COLUMN column_1 INT

Question 2

ALTER Syntax to Drop column

Answer 2

ALTER TABLE table_1

DROP COLUMN column_1

Question 3

SAFE UPDATES

Answer 3

SET SQL_SAFE_UPDATES = 0;

Question 4

Steps to Alter

Answer 4

1. Alter table

2. Update table

Question 5

ALTER command

Answer 5

Add and Remove table Columns

Question 6

CHANGE command

Answer 6

Modify table columns

Question 7

CHANGE Syntax

Answer 7

ALTER TABLE table_1

CHANGE COLUMN old_column_name New_column_name INT;

Question 8

CHANGE syntax structure

Answer 8

1. Old Column name
2. New Column name
3. New Data Type

Question 9

ALTER and Change

Answer 9

1. Alter table

2. Change column

Question 10

FLOAT vs INT

Answer 10

Float includes decimals. Useful for Cost/Price.

Question 11

CREATE Command

Answer 11

Generate New tables

Question 12

DROP command

Answer 12

removes table from a database

Question 13

CREATE TABLE syntax

Answer 13

CREATE TABLE table_name_(
column_1 data_type,
column_2 data_type, 
column_3 data_type
);

Question 14

CHAR vs VARCHAR

Answer 14

1. Char=fixed length string(can contain letters, numbers, and special characters)
2. VARCHAR=variable length string (can contain letters, numbers, and special characters)

Question 15

CREATE DATABASE Syntax

Answer 15

CREATE DATABASE database_name;

Question 16

DROP Statement

Answer 16

Used to delete databases, tables, and columns.

Question 17

DROP Syntax

Answer 17

DROP TABLE table_1;

DROP DATABASE database_name;

Question 18

TRUNCATE command

Answer 18

remove all data from a table

Question 19

To convert a column to a new data type, you only need to list the new data type, not the old one.

Answer 19

True