What is an advantage of placing computations in SQL views?
Options: To save users from having to write an expression., To ensure that the results are consistent., To accomplish both of the above., None of the above is correct - computations cannot be placed in a view.
Options: Return an entire collection of elements including duplicates., Return a collection of elements without duplicates., Return a specific subset of elements using a given criteria., All of the above.
. When a row of data is to be converted into columns
Options: a. Â Copy the cells in row, select the same number of cells in row and paste
b. Â Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK
c. Â Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK
d. Â Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK.
You can use the format painter multiple times before you turn it off by
Options: a. You can use the format painter button on ly one time when you click it b. Double clicking the format painter button c. Pressing the Ctrl key and clicking the format painter button d. Pressing the Alt key and clicking the format painter button
A lock that allows concurrent transactions to access different rows of the same table is known as a
Options: Field-level lock
B. Row-level lock
C. Table-level lock
D. Database-level lock
Ans:– A ,
What is a negative ion?
Options: An atom that contains more electrons than neutrons, An atom that contains more protons than neutrons, An atom that contains more electrons than protons, An atom that contains more protons than electrons
Which of the following describes the operation of a positive edge-triggered D-type flip-flop?
Options: If both inputs are HIGH, the output will toggle., The output will follow the input on the leading edge of the clock., When both inputs are LOW, an invalid state exists., The input is toggled into the flip-flop on the leading edge of the clock and is passed to the output on the trailing edge of the clock.
In laser technology, what happens during the transfer stage?
Options: Residual toner is transferred to the waste receptacle, The laser transfers the image from the drum to the paper, The image is transferred from the drum to the paper, A negative charge is transferred to the surface of the drum
The CPU, after receiving an interrupt from an I/O device
Options: halts for a predetermined time, hands over control of address bus and data bus to the interrupting device, branches off to the interrupt service routine immediately, branches off to the interrupt service routine after completion of the current instruction