CS403P Final Term Quiz 7 July 2023 by Miss Mehwish

We also provide Past papers for Mids. and Finals

Cross Check your answers before submitting directly from the file. We are not responsible for 100% correction as human error exists

ِِبِسْم · ِِالل · ِِالرَّحْمٰن · ِِالرَّحِيْم

Q1. ___________ in SQL table is used to uniquely identify individual rows of a given table. Options:

1. NOT NULL constraints
2. Primary key column
3. Foreign key column
4. Secondary key column

Correct option: b) Primary key column

Q2. ___________ is not a DML command.

1. UPDATE
2. INSERT
3. SELECT
4. CREATE

Correct option: d) CREATE

Q3. Which of the following is the correct syntax for inserting some values into the employee table? Options:

1. INSERT into employee COLUMN (col1, col2, col3) VALUES (val1, val2, val3)
2. INSERT into (col1, col2, col3) VALUES (val1, val2, val3)
3. INSERT into employee (col1, col2, col3), (val1, val2, val3)
4. INSERT into employee (col1, col2, col3) VALUES (val1, val2, val3)

Correct option: d) INSERT into employee (col1, col2, col3) VALUES (val1, val2, val3)

Q4. A relation is in third normal form if ________.

1. It is already in second normal form
2. It has a transitive dependency
3. It has a partial dependency
4. It has multivalued attributes

Correct option: a) It is already in second normal form

Q5. Which of the following is NOT related to the basic SELECT statement? Options:

1. SELECT
2. NOT NULL
3. WHERE
4. FROM

Correct option: b) NOT NULL

Q6. A transitive dependency occurs when __________.

1. Part of the key is dependent on key attribute
2. Non-key attribute is dependent on another non-key attribute
3. Primary key attribute is dependent on non-key attribute
4. Non-key attribute is not dependent on another non-key attribute

Correct option: b) Non-key attribute is dependent on another non-key attribute

Q7. INSERT INTO statement is used to enter values into __________. Options:

1. Only particular column
2. All columns
3. Not null columns only
4. Key value columns only

Correct option: b) All columns

Q8. If a relation is not in third normal form, then anomalies are due to ________. Options:

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

Correct option: d) Partial dependency