Bissoy.com
Doctors Medicines MCQs Q&A

Related Questions

Consider the following statements regarding database normal forms: 1. Any relation with two attributes is BCNF. 2. Lossless, dependency - preserving decomposition into BCNF is always possible. 3. Lossless, dependency - preserving decomposition into 3NF is always possible. 4. BCNF is stricter than 3NF. Which of the above statements are correct?
Which of the following statements is/are FALSE? (i) By definition a relation schema is in first normal form. (ii) A relation schema which is in third normal form is definitely in BCNF.
A table is in BCNF if it is in 3NF and if every determinant is a ___________ key.
Let the set of functional dependencies F = {QR → S, R → P, S → Q} hold on a relation schema X = (PQRS). X is not in BCNF. Suppose X is decomposed into two schemas Y and Z, where Y = (PR) and Z = (QRS). Consider the two statements given below. I. Both Y and Z are in BCNF II. Decomposition of X into Y and Z is dependency preserving and lossless Which of the above statements is/are correct?
Let A be an m × n matrix and Ban n × m matrix. It is given that determinant ($$I$$m + AB) = determinant ($$I$$n + BA), where $$I$$k is the k × k identity matrix. Using the above property, the determinant of the matrix given below is
\[\left[ {\begin{array}{*{20}{c}} 2&1&1&1 \\ 1&2&1&1 \\ 1&1&2&1 \\ 1&1&1&2 \end{array}} \right
Consider the following statements related to composite mortar: 1. Addition of lime to cement mortar improves its workability 2. Composite mortar is obtained by adding 10% by weight of cement and mixing with water. 3. Composite mortar is not preferred in tall buildings 4. Mechanical grinding is essential for developing composite mortar. Which of the above statements are true in this case?
Public key encryption uses multiple keys.ne key is used to encrypt data, while another is used to decrypt data.he key used to encrypt data is called the _______ key, while the key used to decrypt data is called the ________ key.
A relation is in ____________ if an attribute of a composite key is dependent on an attribute of other composite key.
If an attribute of a composite key is dependent on an attribute of the other composite key, a normalization called _____ is needed.
An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.