Database Management System Mock Test 1

1.

Select * from employee where salary>10000 and dept_id=101;

Which of the following fields are displayed as output?

2. For like predicate which of the following is true.

i) % matches zero of more characters.
ii) _ matches exactly one character.

3. In SQL the spaces at the end of the string are removed by _______ function.

4. The subset of a super key is a candidate key under what condition?

5. In an employee table to include the attributes whose value always have some value which of the following constraint must be used?

6. 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.

7. The term attribute refers to a ___________ of a table.

8. Aggregate functions are functions that take a ___________ as input and return a single value.

9. _____ operator is used for appending two strings.

10. A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.