Question

1. Create a table that is named test_table. This table should have two columns named test_id and test_description. These columns should be defined to store the following type of data, respectively: test_id stores numeric data that is a maximum of 3 characters in size; test_description stores variable character data that is a maximum of 25 characters in size.(Hint: Refer to SQL Example 2.1)

2. Insert two rows into the test_table as follows:

INSERT INTO test_table VALUES (1, 'Test1');

INSERT INTO test_table VALUES (2, 'Test2');

3. Use the DESCRIBE command to describe the test_table

Answer 1

Query 1:

CREATE TABLE test_table(test_id NUMBER(3), test_description VARCHAR2(25));

Query 2:

INSERT INTO test_table(test_id,test_description) VALUES(1,"Test1");

INSERT INTO test_table(test_id,test_description) VALUES(2,"Test2");

Query 3:

DESC test_table;