Prelim

Question 1

It is the standard language for dealing with Relational Databases.

Answer 1

SQL

Question 2

______ is used to insert, search, update, and
delete database records.

Answer 2

SQL

Question 3

TRUE OR FALSE:
SQL keyword are NOT case sensitive select is the same as SELECT

Answer 3

TRUE

Question 4

TRUE OR FALSE:
Some database systems require a semicolon at the end of each SQL statement.

Answer 4

TRUE

Question 5

_________ is the standard way to separate each SQL statement in database systems that allow more than one SQL statement to be executed in the same call to the server.

Answer 5

Semicolon

Question 6

SQL COMMAND:
Extracts data from a database

Answer 6

SELECT

Question 7

SQL COMMAND:
Updates data in a database

Answer 7

UPDATE

Question 8

SQL COMMAND:
Deletes data from a database

Answer 8

DELETE

Question 9

SQL COMMAND:
Inserts new data into a database.

Answer 9

INSERT INTO

Question 10

SQL COMMAND:
Creates a new database.

Answer 10

CREATE DATABASE

Question 11

SQL COMMAND:
Modifies a database.

Answer 11

ALTER DATABASE

Question 12

SQL COMMAND:
Creates a new table.

Answer 12

CREATE TABLE

Question 13

SQL COMMAND:
Modifies a table.

Answer 13

ALTER TABLE

Question 14

SQL COMMAND:
Deletes a table.

Answer 14

DROP TABLE

Question 15

SQL COMMAND:
Creates an index (search key).

Answer 15

CREATE INDEX

Question 16

SQL COMMAND:
Deletes an index.

Answer 16

DROP INDEX

Question 17

What is the syntax of SELECT statement?

Answer 17

SELECT * FROM table name;

If only specific fields:
SELECT Lname, Fname, MI FROM Students (tablename);

Question 18

The __________ statement is used to return only distinct (different) values.

Answer 18

SELECT DISTINCT

Question 19

Syntax for SELECT Example Without DISTINCT

Answer 19

SELECT age FROM student;

Question 20

Syntax for SELECT Example With DISTINCT

Answer 20

SELECT DISTINCT age FROM student;

Question 21

Syntax for SELECT Example With COUNT DISTINCT

Answer 21

SELECT COUNT(DISTINCT age) FROM student;

Question 22

The WHERE clause is used to ____ records.

Answer 22

filter

Question 23

TRUE OR FALSE:
The WHERE clause is not only used in SELECT statements, it is also used in UPDATE, DELETE, etc.!

Answer 23

TRUE

Question 24

What is the syntax of WHERE clause?

Answer 24

SELECT * FROM students
WHERE age = ‘20’;

SELECT * FROM student
WHERE userID = 1;

Question 25

SQL requires ______ quotes around text values (most database systems will also allow double quotes).

Answer 25

single

Question 26

TRUE OR FALSE: In SELECT clause, numeric fields should not be enclosed in quotes.

Answer 26

TRUE

Question 27

=

Answer 27

Equal

Question 28

>

Answer 28

Greater than

Question 29

<

Answer 29

Less than

Question 30

Operator: Between a certain range

Answer 30

BETWEEN

Question 31

Operator: Search for a pattern.

Answer 31

LIKE

Question 32

Operator: To specify multiple possible values for a column.

Answer 32

IN

Question 33

Syntax for creating database

Answer 33

CREATE DATABASE CREATE DATABASE `student`;

Question 34

Syntax for dropping database

Answer 34

DROP DATABASE `student`;

Question 35

Syntax for creating table

Answer 35

CREATE TABLE `studinfo`

Question 36

Syntax for dropping table

Answer 36

DROP TABLE `studinfo`

Question 37

Syntax for adding a column

Answer 37

ALTER TABLE studinfo ADD Remarks varchar(100);

Question 38

Syntax for deleting a column

Answer 38

ALTER TABLE studinfo DROP COLUMN Remarks;

Question 39

AUTO_INCREMENT PRIMARY KEY, FOREIGN KEY (SanIcoconnect) REFERENCE tablename(SanIcoconnect)