Practice Midterm

Question 1

True or False? The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.

Answer 1

True

Question 2

True or False? To establish a range of values, < and > can be used.

Answer 2

True

Question 3

True or False? If you are going to use a combination of three or more AND and OR conditions, it is often easier to
use the NOT and NOT IN operators.

Answer 3

True

Question 4

True or False? The keyword LIKE can be used in a WHERE clause to refer to a range of values.

Answer 4

False

Question 5

True or False? The format SELECT-FROM-WHERE is the fundamental framework of SQL SELECT statements.

Answer 5

True

Question 6

True or False? The SQL statement: SELECT Number1 + Number2 AS Total FROM NUMBER_TABLE; adds two
numbers from each row together and lists the results in a column named Total.

Answer 6

True

Question 7

True or False? Data Manipulation Language (DML) commands are used to define a database, including creating,
altering, and dropping tables and establishing constraints.

Answer 7

False

Question 8

True or False? The result of every SQL query is a table.

Answer 8

True

Question 9

True or False? The wildcard asterisk (*) is the Oracle SQL standard for indicating “any sequence of characters”.

Answer 9

False

Question 10

True or False? The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same
value in a column.

Answer 10

True

Question 11

Which statement is wrong about PRIMARY KEY constraint in SQL?
The Primary key…
a) uniquely identifies each record in a SQL database table.
b) can be made based on multiple columns
c) must be made of any single columns.
d) must contain UNIQUE values.

Answer 11

c) Primary key must be made of any single columns.

Question 12

In existing table, ALTER TABLE statement is used to:

Answer 12

a) Add columns.
b) Add constraints.
c) Delete columns.

Question 13

What is the SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes).

Answer 13

DELETE FROM table_name;

Question 14

In a table, a column contains duplicate value, if you want to list all different value only, then which SQL
clause is used?

Answer 14

DISTINCT

Question 15

To give a temporary name to a table, or a column in a table for more readability, what is used?

Answer 15

aliases

Question 16

Logical operators used in SQL are

Answer 16

AND, OR , NOT

Question 17

To search for a specified pattern in a column, use

Answer 17

LIKE

Question 18

Wrong statement about ORDER BY keyword is:

a) Used to sort the result-set in ascending or descending order
b) The ORDER BY keyword sorts the records in ascending order by default
c) To sort the records in ascending order, use the ASC keyword
d) To sort the records in descending order, use the DECENDING keyword.

Answer 18

d) To sort the records in descending order, use the DECENDING keyword.

Question 19

Which SQL statement is used to extract data from a database?.

Answer 19

SELECT

Question 20

If you want to allow age of a person > 18 in the column Age of table Person, then which constraint will be
applied to AGE column.

Answer 20

Check

Question 21

What are the two rules of a relational database?

Answer 21

Entity and Referential Integrity

Question 22

What is Entity Integrity?

Answer 22

1. Entity Integrity is when no column within a primary key is null. This is necessary since the primary key is necessary to uniquely identify a row or an entity.

Question 23

What is Referential Integrity?

Answer 23

2. Referential Integrity is whenever a foreign key value is used it must refer to a existing and valid primary key within the primary table. A lack of this type of integrity will return us with incomplete or missing data.

Question 24

Describe different types of relationships with examples.

Answer 24

1. A PERSON is linked to an ID NUMBER, and a ID NUMBER has is linked to a PERSON. (One to One)
2. A MUSEUM contains many ART WORKS, but ART WORKS are in only one MUSEUM at a time. (One to Many)
3. Many TEXTBOOKS contains many AUTHORS and AUTHORS can be in more than one TEXTBOOK. (Many to Many)