Infojobnews

PPSC PAST PAPER LECTURER COMPUTER SCIENCE (BS-17) (MALE & FEMALE) -2017

(31) . For each attribute of a relation. there is a set of permitted values, called the ________ of that attribute

  1. Domain

  2. Relation

  3. Set

  4. Schema

(32) . Which of the following is a tuple-generating dependency?

  1. Functional dependency

  2. Equality-generating dependencies

  3. Multi-valued dependencies

  4. Non-functional dependency

(33) . The main task carried out in the _____ is to remove repeating attributes to separate tables :

  1. First Normal Form

  2. Second Normal Form

  3. Third Normal Form

  4. Fourth Normal Form

(34) . Which of the normal form is based on multi-valued dependencies?

  1. First

  2. Second

  3. Third

  4. Fourth

(35) . Which form has a relation that possesses data about an individual entity?

  1. 2NF

  2. 3NF

  3. 4NF

  4. 5NF

(36) . Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set?

  1. A many-to-many relationship set

  2. A multi-valued attribute of an entity set

  3. A one.to-many relationship set

  4. Both A and B

(37) . ln which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set?

  1. A many-to-many relationship set

  2. A multi-valued attribute of an entity set

  3. A one-to-many relationship set

  4. Both A and B

(38) . In 2NF:

  1. No functional dependencies (FDs) exist.

  2. No multi-valued dependencies (MVOs) exist.

  3. No Partial FDs exist.

  4. No Partial MVOs exist.

(39) . ________ can help us detect Poor E-R design.

  1. Database Design Process

  2. E-R Design Process

  3. Relational scheme

  4. Functional dependences

(40) . Build & Fix Model is suitable for programming exercises of _______ LOC (Line of code)

  1. 100-200

  2. 200-400

  3. 400-1000

  4. Above 1000

LATEST PAST PAPER

RECENT JOB POST

RECENT EDUCATION POST

RECENT SCHOLARSHIP POST