Which of the following function will return a value of 8?
Options: ROUNDUP(8.4999, 0)
B. ROUNDDOWN(8.4999, 0)
C. ROUND(8.4999, 0)
D. Only B and C
Ans:– D ,
Which of the following is not true about indexes?
Options: Indexes are created to enforce uniqueness on columns., Indexes are created to enable fast retrieval by column values., Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes., Indexes are created with the ALTER TABLE command.
Options: Two SCSI devices connected to a computer can have the same ID if they are both hard drives., Each SCSI device must have its own ID, All SCSI devices must have the same ID, SCSI ID's are irrelevant
Options: a. Checks the value entered when user leaves the field
b. Displays the value in specified format when user leaves the field
c. Defines the appearance for the text
d. There is no option of Validation Rule
Options: Buffering is the process of temporarily storing the data to allow for small variation in device speeds, Buffering is a method to reduce cross-talks, Buffering is a method to reduce the routing overhead, Buffering is storage of data within the transmitting medium until the receiver is ready to receive