CS403P Final Term Quiz 3 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. INSERT INTO statement is used to enter values into__________. Options:

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

Correct option: c) All columns

Q2. From the following options, choose the correct statement for the third normal form. Options:

1. Non-key attribute is dependent on another non-key attribute.
2. There is partial dependency in the relation.
3. There is redundant data in the relation.
4. No non-key attribute is dependent on another non-key attribute.

Correct option: d) No non-key attribute is dependent on another non-key attribute.

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

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

Correct option: b) Transitive dependency

Q4. Which of the following is a correct syntax for creating a Database named employee? Options:

1. CREATE TABLE employee;
2. CREATE TABLE employee;
3. CREATE SQL DATABASE employee;
4. CREATE DATABASE employee;

e) CREATE MYSQL Database employee

Correct option: d) CREATE DATABASE employee;

Q5. ___________ SQL statement is used to enter values into columns. Options:

1. ENTER INTO
2. INSERT TOP
3. PUT INTO
4. INSERT INTO

Correct option: d) INSERT INTO

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

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

Correct option: d) It has a transitive dependency.

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

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

Correct option: d) NOT NULL

Q8. A transitive dependency occurs when _________.

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

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

Q9. Which of the following is the correct syntax for creating a database table? Options:

1. CREATE MYSQL TABLE name;
2. CREATE TABLE name;