1. A function that has no partial functional dependencies isin:
a. 3NF
b. 2NF
c. 1NF
d. BCNF

2. How many Primary keys can have in a table?
a. Only 2
b. Depends on no of Columns
c. Only 1
d. Depends on DBA

3. Which of the following is not a valid aggregate function?
a. COUNT
b. COMPUTE
c. SUM
d. MAX

4. To eliminate duplicates from a query result we use:

a. Unique
b. Distinct
c. *
d. where

5. Which order of clauses in a select statement is correct:

a. Select , from , having , group by, order by
b. Select , from , having , order by
c. Select , from , where , order by, group by
d. Select , from , where
6. The hidden function dependency is removed in which normalform:
a. 3NF
b. 4NF
c. BCNF
d. 2NF
7. Which of the following value will match the condition LIKE‘%A%B’ :
a. WXAYZB
b. XAABBY
c. XYBA
d. All the above
8. Consider the relation R(A1:int, A2:char(9), A3:varchar(5),A4:int) which of the following queries
doesn’t have an error:

a. SELECT MAX(A1) FROM R GROUP BY A1
b. SELECT A1, AVG(A2) FROM R GROUP BY A1
c. SELECT A1, A2, A3, COUNT(A4) FROM R GROUP BY A1 , A2
d. SELECT A1, SUM(A2) FROM R GROUP BY A1
9. Which of the following statements contains an error?
a. Select * from emp where empid = 10003;
b. Select empid from emp where empid = 10006;
c. Select empid from emp;
d. Select empid where empid = 1009 and lastname = ‘GELLER’;

10. What does DML stand for?.
a. Different Mode Level
b. Data Model Language
c. Data Mode Lane
d. Data Manipulation language

Answer rating: 100% (QA)

ANSWERS AND EXPLANATIONS 1 C 1NF A function that has no partial functional dependencies is in first ... View the full answer