Coaching & Educational Academy (Chiniot) : Objective Type
Coaching & Educational Academy (Chiniot) : Objective Type
Coaching & Educational Academy (Chiniot) : Objective Type
1. A rule that states that each foreign key value must match a primary key value in the other relation is called:
a Referential integrity b Key match rule c Entity key group d Foreign/primary
constraint rule match rule
2. Two or more attributes with different names but same meanings create a problem:
a Homonyms b Aliases c Synonyms d Alternate attributes
3. A constraint between two attributes is called:
a Functional relation b Attribute dependency c Functional d Functional relation
dependency constraint
4. The attribute on the left side of the arrow in a functional dependency is called:
a Candidate key b Determinant c Foreign key d Primary key
5. The goal of normalization is to:
a Get stable data b Increase number of c Increase d Remove constraints
structure relation redundancy
Mail ID: [email protected]
Bismillah Pak Forces
Coaching & Educational
ش تAcademy (Chiniot) ٹ
ے کم از کم ی ن ب ار درود ریف پڑھ لی ںہ
سٹ سے پ ل ی
6. A relation is in 2NF if it is in 1 NF and all its non key attributes are:
a Dependent on part of b Dependent on the entire c Independent of the d Independent of any
the primary key primary key primary key other relation
7. Which form of dependency is removed in 2NF?
a Functional b Transitive c Associative d Partial
8. Which of the following are anomalies that can be caused by redundancy in tables?
a Insertion b Deletion c Modification d All
9. A functional dependency between two or more non key attributes is called:
a Partial functional b Partial non-key c Transitive d None
dependency dependency dependency
10. Which of the following anomalies result from a transitive dependency?
a Insertion b Modification c Deletion d All
1. The operators to compare operands and decide if the relation is true or false are:
a Arithmetic operators b Logical operators c Syntax operator d Relational operator
2. When a relational expression is false it has the value _____:
a 0 b 1 c <0 d 5
3. Which of the following statement is the simplest form of a decision structure?
a Select…case b If statement c Try…catch…finally d Nested if
4. ______ is used to specify two different choices with “if” statement :
a Switch b Else c If d If else
5. In if statement false is represented by:
a 0 b 1 c 2 d 3
6. In if statement true is represented by:
a 0 b 1 c 2 d 3
7. ______ refers to group of statement enclosed in opening and closing braces.
a Control structure b Compound statement c Sequencestructure d Instruction
8. The conditional portion of the if statement can contain:
a Any valid constant b Any expression that can c Any valid variable d Any valid constant or
be evaluated to a variable
Boolean value
9. Which of the following is not part of an if statement?
a A condition that b A condition that c A true block d All of are part of an if
evaluates as a Boolean evaluates as true or statement
false
10. An if statement inside the true block of another if statement is called:
a Nested if statement b Branched if statement c conditional operator d Relational operator