82. Which of the normal form is based on multi-valued dependencies
A) First
B) Second
C) Third
D) Fourth
83. Which forms has a relation that possesses data about an individual entity
A) 2NF
B) 3NF
C) 4NF
D) 5NF
84. Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set
A) A many-to-many relationship set
B) A multi-valued attribute of an entity set
C) A one-to-many relationship set
D) Both A & B
85. In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set
A) A many-to-many relationship set
B) A multi-valued attribute of an entity set
C) A one-to-many relationship set
D) Both A & B
86. In 2NF
A) No functional dependencies (FDs) exist
B) No multivalued dependencies (MVDs) exist
C) No partial FDs exist
D) No partial MVDs exist
87. ……. can help us detect poor E-R design
A) Database Design Process
B) E-R Design Process
C) Relational scheme
D) Functional dependencies
88. What is the best way to represent the attributes in a large databas
A) Relational-and
B) Concatenation
C) Dot representation
D) All of the mentioned
89. Designers use which of the following to tune the performance of systems to support time-critical operations
A) Denormalization
B) Redundant optimization
C) Optimization
D) Realization
90. RAD stands for
A)Rapid Application Development
B) Relative Application Development
C) Rapid Application Document
D) Rational Application Document
91. Which one of the following model is not suitable for accommodating any change
A) Build & Fix Model
B) Prototyping Model
C) RAD Model
D) Waterfall Model
92. Which one of the following is not a phase of Prototyping Model
A) Quick Design
B) Coding
C) Prototype Refinement
D) Engineer Product
93. RAD Model has …….
A) 2 phases
B) 3 phase
C) 5 phases
D) 6 phases
94. What is the major drawback of using RAD Model
A) Highly specialized & skilled developers/designers are required
B) Increases reusability of components
C) Encourages customer/client feedback
D) Increases reusability of components, Highly specialized & skilled developers/designers are required
95. SDLC stands for ……
A) Software Development Life Cycle
B) System Development Life cycle
C) Software Design Life Cycle
D) System Design Life Cycle
96. Which model can be selected if user is involved in all the phases of SDLC
A) Waterfall Model
B) Prototyping Model
C) RAD Model
D) both Prototyping Model & RAD Model
97. Two devices are in network if
A) A process in one device is able to exchange information with a process in another device
B) A process is running on both devices
C) PIDs of the processes running of different devices are same
D) None of these
98. Build and fix model is suitable for Programming exercises of ……. LOC (Line of Code)
A) 100-200
B) 200-400
C) 400-1000
D) Above 1000
99. ترکی تمام ہونا‘‘ محاورہ ہے۔ اس کا مفہوم کیا ہے؟”
A) غیرملکی سفر پر روانہ ہونا
B) بجٹ ختم ہونا
C) کوشش ترک کرنا
D) ان میں سے کوئی نہیں
100. امیرخسروکس شہر میں مد فون ہیں؟
A) عمر کوٹ
B) ملتان
C) دہلی
D) رائے بریلی
