The relation schemas R1 and R2 form a Lossless join decomposition of R if and only if :
(a) R1⌒ R2 ⇒ (R1- R2)
(b) R1→ R2
(c) R1⌒ R2 ⇒ (R1- R2)
(d) R2→ R1⌒R2
Codes:
| A. | (a) and (b) happens |
| B. | (a) and (d) happens |
| C. | (a) and (c) happens |
| D. | (b) and (c) happens |
|
Option: C Explanation :
A decomposition of R into R1 and R2 is lossless join if and only if at least one of the following dependencies is in F+: Click on Discuss to view users comments. |
In the indexed scheme of blocks to a file, the maximum possible size of the file depends on :
| A. | The number of blocks used for index and the size of index |
| B. | Size of Blocks and size of Address |
| C. | Size of index |
| D. | Size of Block |
|
Option: A Explanation : When indexes are created, the maximum no. of blocks given to a file are totally dependent upon size of the index which tells how many blocks can be there, & size of each block. Click on Discuss to view users comments. |
Give the number of principal vanishing point(s) along with their direction for the standard perspective transformation :
| A. | Only one in the direction K |
| B. | Two in the directions I and J |
| C. | Three in the directions I, J and K |
| D. | Only two in the directions J and K |
|
Option: A Explanation : In this case the view plane normal N is vector K. since N.I =0 and N.J=0, so there are no vanishing points in the direction I and J. on the other hand N.K = K.K = 1. thus there is only one principal vanishing point and it is in K direction Click on Discuss to view users comments. |
Consider a triangle A (0, 0), B (1, 1) and C (5, 2). The triangle has to be rotated by an angle of 45° about the point P (-l, -l). What shall be the coordinates of the new triangle?
| A. |
|
| B. |
|
| C. |
|
| D. |
|
|
Option: C Explanation : Click on Discuss to view users comments. |
The process of dividing an analog signal into a string of discrete outputs, each of constant amplitude, is called :
| A. | Strobing |
| B. | Amplification |
| C. | Conditioning |
| D. | Quantization |
|
Option: D Explanation : Quantization is the process of converting a continuous range of values into a finite range of discreet values. This is a function of analog-to-digital converters Click on Discuss to view users comments. |
