Database Management System Practice Test 1

1. A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.

Referencing

Primary

Referential

Specific

2. For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.

Domain

Set

Relation

Schema

Select dept_name, ID, avg (salary)
from instructor
group by dept_name;
This statement is erroneous because

Misplaced group by clause

Avg(salary) should not be selected

Group by clause is not valid in this query

Dept_id should not be used in group by clause

Select emp_name
from department
where dept_name like ’ _____ Computer Science’;

Which one of the following has to be added into the blank to select the dept_name which has Computer Science as its ending string?

Name

Annie

Bob

Callie

Derek

Which of these query will display the the table given above ?

Select employee from name

Select name from employee

Select employee

Select name

6. If the attribute phone number is included in the relation all the values need not be entered into the phone number column. This type of entry is given as

Null

Empty space

7. Course(course_id,sec_id,semester)
Here the course_id,sec_id and semester are __________ and course is a _________

Attributes, Relation

Tuple, Attributes

Tuple, Relation

Relations, Attribute

8. The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called ______________

Referred relation

Referenced relation

Referential relation

Referencing relation

9. Which of the following statements contains an error?

Select empid from emp where empid = 10006;

Select * from emp where empid = 10003;

Select empid from emp;

Select empid where empid = 1009 and lastname = 'GELLER';

10.

Employee_id	Name	Salary
1001	Annie	6000
1009	Ross	4500
1018	Zeith	7000

This is Employee table.
Which of the following employee_id will be displayed for the given query?

Select * from employee where employee_id>1009;

1009, 1018

1001

1018

1009, 1001, 1018