CS403P Graded Quiz 3 January 2026

Quiz 1 - CS403

Question:

2nd Normal Form is based on which of the following dependency?

1. Partial dependency
2. Reflexive dependency
3. Transitive dependency
4. Full functional dependency

Correct answer: Partial dependency

Copied: 1/1/2026, 11:56:12 AM

Quiz 2 - CS403

Question:

�S�u�p�p�o�s�e� �A� !’� �B�,� �t�h�e�n� �w�h�i�c�h� �o�f� �t�h�e� �f�o�l�l�o�w�i�n�g� �i�s� �v�a�l�i�d� �F�u�n�c�t�i�o�n�a�l� �d�e�p�e�n�d�e�n�c�y� �f�o�r

�A�.� �A�D� !’� �B

�B�.� �A� !’� �C �C�.� �A�C� !’� �B�C �D�.� �A�B� !’� �C Copied: 1/1/2026, 11:56:23 AM

Quiz 3 - CS403

Question:

If a relation CLASS (crId, stId, stName, fId, room, grade) has following Functional Dependencies:

�c�r�I�d�,� �s�t�I�d� !’� �s�t�N�a�m�e�,� �f�I�d�,� �r�o�o�m�,� �g�r�a�d�e

which of the following functional dependency is in above functional dependency?

1. Reflexive dependency
2. Transitive dependency
3. Squencial dependency
4. Partial dependency

Correct answer: Partial dependency

Copied: 1/1/2026, 11:56:32 AM

Quiz 4 - CS403

Question:

In projection operation, any duplicate values are_________.

A. Grouped

B. Eliminated

C. Selected D. Copied Copied: 1/1/2026, 11:56:43 AM

Quiz 5 - CS403

Question:

Suppose a relation named STUDENT contains attributes St_name, St_cgpa, cur_semester and st_roll. Which of the following query will be used to SELECT all those student records having cgpa greater than 3.0?

�A�.� �c�g�p�a�>�3�.�0� �(�S�T�U�D�E�N�T�)

�B�.� �c�g�p�a�>�3�.�0� �(�S�T�U�D�E�N�T�)

�C�.� !&�c�g�p�a�>�3�.�0� �(�S�T�U�D�E�N�T�) Quiz's Gdb

D. €cgpa>3.0 (STUDENT)

Copied: 1/1/2026, 11:56:53 AM

Quiz 6 - CS403

Question:

A relation is in second normal form if and only if ______________ and all the non key attributes are fully functionally dependent on the key.

A. It is not in first normal form B. It has inconsistent data

C. It is in first normal form

D. It has multivalued attributes Copied: 1/1/2026, 11:57:36 AM

Quiz 7 - CS403

Question:

Suppose a relation named EMPLOYEE contains attributes Emp_name, Emp_designation, Emp_address and Emp_salary. Which of the following query will be used to SELECT all those employees whose designation is Admin officer?

�A�.� Õ� �d�e�s�i�g�n�a�t�i�o�n� �=� �‘�A�d�m�i�n� �o�f�f�i�c�e�r�’�(�E�M�P�L�O�Y�E�E�) �B�.� ±� �d�e�s�i�g�n�a�t�i�o�n� �=� �‘�A�d�m�i�n� �o�f�f�i�c�e�r�’� �(�E�M�P�L�O�Y�E�E�) �C�.� |� �d�e�s�i�g�n�a�t�i�o�n� �=� �‘�A�d�m�i�n� �o�f�f�i�c�e�r�’� �(�E�M�P�L�O�Y�E�E�) �D�.� Ã� �d�e�s�i�g�n�a�t�i�o�n� �=� �‘�A�d�m�i�n� �o�f�f�i�c�e�r�’� �(�E�M�P�L�O�Y�E�E�) Copied: 1/1/2026, 11:57:53 AM