Content text Untitled document - 2024-08-30T113924.967.pdf
4. Write the SQL commands to create the DEPT table with the following structure: • deptno as a number with up to 2 digits • dname as a variable character datatype up to 10 characters • loc as a variable character up to 20 characters Answer: CREATE TABLE DEPT ( deptno INT(2) NOT NULL, dname VARCHAR(10), loc VARCHAR(20), PRIMARY KEY (deptno) ); Practicalkida.com