PRELIM Quiz 1 Lab

Question 1

Provide the SQL command that will create a database named dbexam.

Answer 1

CREATE DATABASE dbexam;

Question 2

Provide the command that lists all existing databases.

Answer 2

SHOW DATABASES;

Question 3

Command that list all existing tables.

Answer 3

show tables;

Question 4

The command that deletes a table named tblEmployee.

Answer 4

DROP TABLE tblEmployee;

Question 5

The command that selects all the records in the “tblEmployee” table.

Answer 5

SELECT * FROM tblEmployee;

Question 6

The command that creates a table named tblEmployee with the following details:

lname - varchar(50)

fname - varchar(50)

city - varchar(50)

Answer 6

CREATE TABLE tblEmployee(lname varchar(50), fname varchar(50), city varchar(50));

Question 7

The ______ parameter specifies the type of data the column can hold (e.g. varchar, integer, date, etc.).

Answer 7

datatype

Question 8

The following command inserts a value in a table called “tblPersons” that contains five columns: PersonID, LastName, FirstName, Address, and City.

The PersonID column is of type int and will hold an integer and the value is 1.

The LastName, FirstName, Address, and City columns are of type varchar and will hold characters, and the maximum length for these fields is 255 characters. and the values are Manaloto, Mieko, Barcelona, City of San Fernando respectively.

Answer 8

INSERT INTO tblPersons (PersonID, LastName, FirstName, Address, City) VALUES (1, ‘Manaloto’, ‘Mieko’, ‘Barcelona’, ‘City of San Fernando’);

Question 9

The following command inserts a value in a table called “tblPersons” that contains five columns: PersonID, LastName, FirstName, Address, and City.

The PersonID column is of type int and will hold an integer and the value is 2.

The LastName, FirstName, Address, and City columns are of type varchar and will hold characters, and the maximum length for these fields is 255 characters. and the values are Lastname - Dizon and City - Angeles.

Answer 9

INSERT INTO tblPersons (PersonID, LastName, City) VALUES (2, ‘Dizon’, ‘Angeles’);

Question 10

(T ot F) If you are adding values for all the columns of the table, you do not need to specify the column names in the SQL query.

Answer 10

T

Question 11

(T ot F) SQL keywords are NOT case sensitive

Answer 11

T

Question 12

(T ot F) The INSERT RECORD statement is used to insert new records in a table.

Answer 12

F
INSERT INTO

Question 13

A field with a ___ value is a field with no value.

Answer 13

NULL