July 7, 2021 in C and CPP
1.8 Maximum number of relationship instances that an entity can participate in a relationship is
called
A) Degree
B) Cardinality ratio
C) Min-max constraints
D) None of the aboveJuly 7, 2021 in C and CPP
1.7 Single entity having more than one role in the same relationship is an example of
A) Binary relationship
B) Identifying relationship
C) Recursive relationship
D) Ternary relationshipJuly 7, 2021 in C and CPP
1.6 Create table is a
A) DDL Command
B) DML command
C) Both A) and B)
D) None of the aboveJuly 7, 2021 in C and CPP
1.5 In ER modeling weak entity is identified for an owner entity using
A) Primary key
B) Super key
C) Candidate key
D) Partial keyJuly 7, 2021 in C and CPP
1.4 Following operation is used to update the structure of the database table
A) Alter
B) Update
C) Change
D) None of the aboveJuly 7, 2021 in C and CPP
1.3 Which one of the following is an example of 1:N relationship
A) Course-has-Student
B) Teacher-teaches-students
C) Teacher-heads-Department
D) None of the aboveJuly 7, 2021 in C and CPP
1.2 The result of the operation RUS includes all tuples that are
A) Either in R or S
B) Both in R and S
C) Both A) and B)
D) None of the aboveJuly 7, 2021 in C and CPP
1.1 Which of the following is NOT a basic element of the E-R model?
A) Entities
B) Attributes
C) Relationship
D) Primary keysJuly 7, 2021 in C and CPP
b) Give an example of
i) Switch statement
ii) Conditional expression
iii) Nesting of loops
iv) Dynamic memory allocationJuly 7, 2021 in C and CPP
a) What are preprocessor directions? Why do we need them? Explain various preprocessor
directives.
