Bissoy.com
Doctors Medicines MCQs Q&A

Related Questions

Assuming Z and Y are the two control variables, the following are the constraints laid out for maximizing the profit: Maximize profit (P) = 8X – 5Y Subject to Constraint-1: 2X + Y ≤ 1000 Constraint-2: 3X + 4Y ≤ 2400 Constraint-3: X + Y ≤ 800 Constraint-4: X – Y ≤ 350 Constraint-5: X ≥ 0 Constraint-6: Y ≥ 0 Which of the above constraints is a redundant one and does not have any effect on the solution?
Match the following with respect to RDBMS: A. Entity integrity 1. enforces some specific business rule that do not fall into entity or domain B. Domain integrity 2. Rows can’t be deleted which are used by other records C. Referential integrity 3. enforces valid entries for a column D. User defined integrity 4. No duplicate rows in a table
Consider two relations R1(A, B) with the tuples (1, 5), (3, 7) and R2(A, C) = (1, 7), (4, 9). Assume that R(A, B, C) is the full natural outer join of R1 and R2. Consider the following tuples of the form (A, B, C): a = (1, 5, null), b = (1, null, 7), c = (3, null, 9), d = (4, 7, null), e = (1, 5, 7), f = (3, 7, null), g = (4, null, 9). Which one of the following statements is correct?
Let relation R2 has a Foreign Key that refers to Primary Key of relation R1. Which of the following operations may cause violation of referential integrity constraints? I: insert into R1 II: insert into R2 III: delete from R1 IV: delete from R2
Consider the following statements in connection with deflection-type and null-type instruments: 1. Null-type instruments are more accurate than the deflection-type ones. 2. Null-type of instrument can be highly sensitive compared to a deflection-type instrument. 3. Under dynamic conditions, null-type instruments are less preferred to deflection-type instruments. 4. Response is faster in null-type instruments as compared to deflection-type instruments. Which of the above statements are correct?
Compare the following sentences: (1) He is a man of high professional integrity. (2) Our defense forces are determined to preserve our national Integrity. (3) His personal integrity is beyond question. Identify sentence (s) in which the word integrity implies the quality of honesty and strong moral principles.
What is the distance covered by boat N upstream in 5 hours? Which of the following option is sufficient alone to find the answer? A) Boat M is travelling downstream with 20% more downstream speed of boat N. Speed of boat M in still water is 10% more than the speed of boat N in still water. B) Boat M and Boat N are travelling downstream with speed 33 km/hr and 40 km/hr respectively and speed of boat M is still water is 2 times the speed of stream. C) Speed of boat M in still water is 6 km/hr less then speed of boat N in still water and speed of stream is 10 km/hr. D) Speed of stream is ½ times the speed of boat N in still water and downstream speed of boat M is 44 km/hr. E) Speed of stream is 10 km/hr and ratio of upstream speed of boat M and boat N is 3 : 2 respectively.
Let R(a, b, c) and S(d, e, f) be two relations in which d is the foreign key of S that refers to the primary key of R Consider the following four operations in R and S I. Insert into R II. Insert into S III. Deletion from R IV. Deletion from S Which of the following can cause violation of the relational integrity constraint above?
Suppose R1(A, B) and R2(C, D) are two relation schemas. Let r1 and r2 be the corresponding relation instances. B is a foreign key that refers to C in R2. If data in r1 and r2 satisfy referential integrity constraints, which of the following is ALWAYS TRUE?
A One-To-Many relationship that is not enforcing referential integrity, displays what symbol next to the foreign key field?