Protocol of Department Meeting №9 from 09.04.2013

Discipline: CSS214 Introducion to iOS

Programming

NAME:

SURNAME:

GROUP:

TEST:

1. The maximum row size in PostgreSQL is

A. 32TB B. Unlimited C. 1.6 TB D. 1GB

2. If A ……………… in one table points to a PRIMARY KEY in another table.

A. Primary Key B. Foreign Key C. Unique D. Not NULL

3. In a table a column may contain many duplicate values and sometimes you only want to list the different values using

A. SUM B. DISTINCT C. ALIASES D.DEFAULT

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

A. Remove B. Alter C. Delete D. Collapse

5. Which SQL statement is used to insert new data in a database?

A. Add new B. Add record C. Insert new D. Insert record

(5 points)

TRUE/FALSE:

1. “Min” function works only with numeric database T / F

2. Decreasing the size of a numeric column, the column must be empty T / F

3. The maximum field size in PostgreSQL is 1 GB T / F

The most common type of Join is “Full Outer Join” T / F

5. The GROUP BY statement is used in conjunction with the aggregate

functions to group the result-set by one or more columns. T / F

(5 points)

THEORY:

1. Describe ER diagram, what do we need in order to draw an ER diagram.

2. Describe the difference between ALTER and UPDATE.

3. What is “Aliases” and when do we use it?

4. What do we need in order to make UNION?

5. What do you know about Joins(types, differences and etc)

(10 points)

PROBLEM: 10 points

Solve the problem:

1. You should create a table. Give it your own name. You should have at least six columns like (age, city, university and etc)

2. Make “inner join” with your group mates’ table (a similar table like yours)

3. Make “left join” with your group mates’ table (a similar table like yours)

4. Make “full join” with your group mates’ table (a similar table like yours)

5. Make UNION with your group mates’ table (a similar table like yours)

(10 points)

Instructor _________________________________ MSc. Sayassatov D.Zh.

Head of Department _________________________________ Dr. Ivanov A.I.

Protocol of Department Meeting №9 from 09.04.2013

Approved at a meeting of EMB 28.08.2012, Protocol № 1

Faculty: Engineering & Natural Sciences

Department: Computer Engineering