. Which of the following is a correct order of precedence in a formula calculation?
Options: a. Multiplication and division, exponential positive and negative value b. Multiplication and division, positive and negative values, addition and subtraction c. Addition and subtraction, positive and negative values, exponentiation d. None of above
Options: a. Reports can be used to retrieve data from tables and calculate
b. Queries can be printed in well formatted manner and presented as the information
c. Queries can include calculated fields that do not exist in table
d. Reports and forms are similar but forms are use to print but reports to display on screen only
Why does the data communication industry use the layered OSI reference model? It divides the network communication process into smaller and simpler components, thus aiding component development, design, and troubleshooting. It enables equipment from different vendors to use the same electronic components, thus saving research and development funds. It supports the evolution of multiple competing standards and thus provides business opportunities for equipment manufacturers. It encourages industry standardization by defining what functions occur at each layer of the model.
Options: to provide complete file naming freedom to the users and to permit controlled sharing of files, to provide for long and short term storage of files with appropriate economic tradeoffs., to provide security against loss of information due to system failure, all of the above
In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
Options: The line numbers reported match the line numbers you see in your text editor., SQL*Plus will automatically show the errors to you., To see the errors, enter SHOW ERRORS in SQL*Plus., If there are no syntax errors, you will receive the message "NO ERRORS."
The CPU of a computer transfers print output to a temporary disk memory at high speed and then gets back to processing another job without waiting for the output to got to the printer. In this way, the CPU does not remain idle due to its own high speed as compared to the low speed of the printer. What is the name of this memory?
When you connect to an online information service, you are asked to provide some kind of identification such as your name, an account number and a password. What is the name given to this brief dialogue between you and the information system?
Which of the following is true concerning a global transaction?
Options: The required data are at one local site and the distributed DBMS routes requests as necessary., The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary., The required data are at one local site and the distributed DBMS passes the request to only the local DBMS., The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS.